spreadsheets public
2
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 spreadsheets 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
Manage your Spreadsheets
# 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.
Create a Spreadsheet
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
properties
required
object
General properties of the spreadsheet
current value set to
enter a test value
sheets
array
The sheets that are part of the spreadsheet
optional, default value is
[]
optional, current value set to
enter a test value
namedRanges
array
The named ranges defined in the spreadsheet.
optional, default value is
[]
optional, current value set to
enter a test value
List your Spreadsheets
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
pageToken
string
The token for continuing a previous list request on the next page.
optional, default value is
null
optional, current value set to
enter a test value
Retrieve a Spreadsheet's Metadata
Authenticated   |   Pricing  ·  Free   |   Limit  ·  no rate limit
Unauthenticated   |   Limit  ·  no rate limit
Parameters
spreadsheetId
string
The id of the Spreadsheet
optional, default value is
null
optional, current value set to
enter a test value
Retrieve 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
ranges
string
The ranges to retrieve from the Spreadsheet.
optional, default value is
null
optional, current value set to
enter a test value
Made with by the Google Sheets team with the help of Standard Library.