Google Sheets API
Reads and writes Google Sheets.
- REST Resource: v4.spreadsheets
- REST Resource: v4.spreadsheets.developerMetadata
- REST Resource: v4.spreadsheets.sheets
- REST Resource: v4.spreadsheets.values
Service: sheets.googleapis.com
To call this service, we recommend that you use the Google-providedclient libraries. If your application needs to use your own libraries to call this service, use the following information when you make the API requests.
Discovery document
ADiscovery Document is a machine-readable specification for describing and consuming REST APIs. It is used to build client libraries, IDE plugins, and other tools that interact with Google APIs. One service may provide multiple discovery documents. This service provides the following discovery document:
Service endpoint
Aservice endpoint is a base URL that specifies the network address of an API service. One service might have multiple service endpoints. This service has the following service endpoint and all URIs below are relative to this service endpoint:
https://sheets.googleapis.com
REST Resource:v4.spreadsheets
| Methods | |
|---|---|
batchUpdate | POST /v4/spreadsheets/{spreadsheetId}:batchUpdateApplies one or more updates to the spreadsheet. |
create | POST /v4/spreadsheetsCreates a spreadsheet, returning the newly created spreadsheet. |
get | GET /v4/spreadsheets/{spreadsheetId}Returns the spreadsheet at the given ID. |
getByDataFilter | POST /v4/spreadsheets/{spreadsheetId}:getByDataFilterReturns the spreadsheet at the given ID. |
REST Resource:v4.spreadsheets.developerMetadata
| Methods | |
|---|---|
get | GET /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}Returns the developer metadata with the specified ID. |
search | POST /v4/spreadsheets/{spreadsheetId}/developerMetadata:searchReturns all developer metadata matching the specified DataFilter. |
REST Resource:v4.spreadsheets.sheets
| Methods | |
|---|---|
copyTo | POST /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyToCopies a single sheet from a spreadsheet to another spreadsheet. |
REST Resource:v4.spreadsheets.values
| Methods | |
|---|---|
append | POST /v4/spreadsheets/{spreadsheetId}/values/{range}:appendAppends values to a spreadsheet. |
batchClear | POST /v4/spreadsheets/{spreadsheetId}/values:batchClearClears one or more ranges of values from a spreadsheet. |
batchClearByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilterClears one or more ranges of values from a spreadsheet. |
batchGet | GET /v4/spreadsheets/{spreadsheetId}/values:batchGetReturns one or more ranges of values from a spreadsheet. |
batchGetByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilterReturns one or more ranges of values that match the specified data filters. |
batchUpdate | POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateSets values in one or more ranges of a spreadsheet. |
batchUpdateByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilterSets values in one or more ranges of a spreadsheet. |
clear | POST /v4/spreadsheets/{spreadsheetId}/values/{range}:clearClears values from a spreadsheet. |
get | GET /v4/spreadsheets/{spreadsheetId}/values/{range}Returns a range of values from a spreadsheet. |
update | PUT /v4/spreadsheets/{spreadsheetId}/values/{range}Sets values in a range of a spreadsheet. |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-03-21 UTC.