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-provided client 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
A Discovery 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
A service 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}:batchUpdate Applies one or more updates to the spreadsheet. |
create | POST /v4/spreadsheets Creates a spreadsheet, returning the newly created spreadsheet. |
get | GET /v4/spreadsheets/{spreadsheetId} Returns the spreadsheet at the given ID. |
getByDataFilter | POST /v4/spreadsheets/{spreadsheetId}:getByDataFilter Returns the spreadsheet at the given ID. |
Methods | |
---|---|
get | GET /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId} Returns the developer metadata with the specified ID. |
search | POST /v4/spreadsheets/{spreadsheetId}/developerMetadata:search Returns all developer metadata matching the specified DataFilter . |
REST Resource: v4.spreadsheets.sheets
Methods | |
---|---|
copyTo | POST /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo Copies a single sheet from a spreadsheet to another spreadsheet. |
REST Resource: v4.spreadsheets.values
Methods | |
---|---|
append | POST /v4/spreadsheets/{spreadsheetId}/values/{range}:append Appends values to a spreadsheet. |
batchClear | POST /v4/spreadsheets/{spreadsheetId}/values:batchClear Clears one or more ranges of values from a spreadsheet. |
batchClearByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter Clears one or more ranges of values from a spreadsheet. |
batchGet | GET /v4/spreadsheets/{spreadsheetId}/values:batchGet Returns one or more ranges of values from a spreadsheet. |
batchGetByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter Returns one or more ranges of values that match the specified data filters. |
batchUpdate | POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdate Sets values in one or more ranges of a spreadsheet. |
batchUpdateByDataFilter | POST /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter Sets values in one or more ranges of a spreadsheet. |
clear | POST /v4/spreadsheets/{spreadsheetId}/values/{range}:clear Clears 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 the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-09-03 UTC.
[{ "type": "thumb-down", "id": "missingTheInformationINeed", "label":"Missing the information I need" },{ "type": "thumb-down", "id": "tooComplicatedTooManySteps", "label":"Too complicated / too many steps" },{ "type": "thumb-down", "id": "outOfDate", "label":"Out of date" },{ "type": "thumb-down", "id": "samplesCodeIssue", "label":"Samples / code issue" },{ "type": "thumb-down", "id": "otherDown", "label":"Other" }] [{ "type": "thumb-up", "id": "easyToUnderstand", "label":"Easy to understand" },{ "type": "thumb-up", "id": "solvedMyProblem", "label":"Solved my problem" },{ "type": "thumb-up", "id": "otherUp", "label":"Other" }]