query public
1
Node
JavaScript
Python beta
Ruby beta
Shell
curl
Hey! Want to build awesome, scalable APIs like this one?
Sign up with Standard Library today and build your own API or connect to others in seconds.
We hope you enjoy documentation for the Google Sheets query API on Standard Library! This API can be used via the command line (shell), Node, Ruby, Python or as a generic HTTP call in any language. Check the code examples on the right associated with each API method for how to use this API in your language of choice.
API Description
Query Google Sheets like a Database
# API Documentation This file should contain documentation introducing your API to **end-users**. It will display on your service's [Standard Library](https://stdlib.com/) documentation page if you choose to publish it. Usage examples and additional information around calling your API belong here.
Count Rows in a Spreadsheet by querying it like a Database
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
spreadsheetId
string
The id of the Spreadsheet. By default this is the spreadsheet linked to the active library token
optional, default value is
null
optional, current value set to
enter a test value
range
required
string
The A1 notation of the values to use as a table. The first row will be used as column names.
current value set to
enter a test value
bounds
enum
Specify the ending bounds of the table. FIRST_EMPTY_ROW will end the table when an empty row is encountered.
optional, default value is
"FIRST_EMPTY_ROW"
optional, current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
Delete Rows from a Spreadsheet by querying it like a Database
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
spreadsheetId
string
The id of the Spreadsheet. By default this is the spreadsheet linked to the active library token
optional, default value is
null
optional, current value set to
enter a test value
range
required
string
The A1 notation of the values to use as a table. The first row will be used as column names.
current value set to
enter a test value
bounds
enum
Specify the ending bounds of the table. FIRST_EMPTY_ROW will end the table when an empty row is encountered.
optional, default value is
"FIRST_EMPTY_ROW"
optional, current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
Retrieve Distinct Values from a Spreadsheet by querying it like a Database
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
spreadsheetId
string
The id of the Spreadsheet. By default this is the spreadsheet linked to the active library token
optional, default value is
null
optional, current value set to
enter a test value
range
required
string
The A1 notation of the values to use as a table. The first row will be used as column names.
current value set to
enter a test value
bounds
enum
Specify the ending bounds of the table. FIRST_EMPTY_ROW will end the table when an empty row is encountered.
optional, default value is
"FIRST_EMPTY_ROW"
optional, current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
field
required
string
The field (column name) to grab distinct values for
current value set to
enter a test value
Insert a Row into a Spreadsheet
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
spreadsheetId
string
The id of the Spreadsheet. By default this is the spreadsheet linked to the active library token
optional, default value is
null
optional, current value set to
enter a test value
range
required
string
The A1 notation of the values to use as a table. The first row will be used as column names.
current value set to
enter a test value
bounds
enum
Specify the ending bounds of the table. FIRST_EMPTY_ROW will end the table when an empty row is encountered.
optional, default value is
"FIRST_EMPTY_ROW"
optional, current value set to
enter a test value
fields
required
object
An object with key-value pairs representing column-cell updates
current value set to
enter a test value
Replace Rows in a Spreadsheet by querying it like a Database
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
spreadsheetId
string
The id of the Spreadsheet. By default this is the spreadsheet linked to the active library token
optional, default value is
null
optional, current value set to
enter a test value
range
required
string
The A1 notation of the values to use as a table. The first row will be used as column names.
current value set to
enter a test value
bounds
enum
Specify the ending bounds of the table. FIRST_EMPTY_ROW will end the table when an empty row is encountered.
optional, default value is
"FIRST_EMPTY_ROW"
optional, current value set to
enter a test value
replaceRows
required
array
An array of rows to replace
current value set to
enter a test value
Select Rows from a Spreadsheet by querying it like a Database
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
spreadsheetId
string
The id of the Spreadsheet. By default this is the spreadsheet linked to the active library token
optional, default value is
null
optional, current value set to
enter a test value
range
required
string
The A1 notation of the values to use as a table. The first row will be used as column names.
current value set to
enter a test value
bounds
enum
Specify the ending bounds of the table. FIRST_EMPTY_ROW will end the table when an empty row is encountered.
optional, default value is
"FIRST_EMPTY_ROW"
optional, current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
Update Rows in a Spreadsheet by querying it like a Database
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
spreadsheetId
string
The id of the Spreadsheet. By default this is the spreadsheet linked to the active library token
optional, default value is
null
optional, current value set to
enter a test value
range
required
string
The A1 notation of the values to use as a table. The first row will be used as column names.
current value set to
enter a test value
bounds
enum
Specify the ending bounds of the table. FIRST_EMPTY_ROW will end the table when an empty row is encountered.
optional, default value is
"FIRST_EMPTY_ROW"
optional, current value set to
enter a test value
A list of column values to filter by. By default, the exact value will be filtered for.
optional, default value is
{}
optional, current value set to
enter a test value
A limit representing the number of results to return
optional, default value is
{"count":0,"offset":0}
optional, current value set to
enter a test value
fields
object
An object with key-value pairs representing column-cell updates
optional, default value is
{}
optional, current value set to
enter a test value
Made with by the Google Sheets team with the help of Standard Library.