Google Sheets API

Reads and writes Google Sheets.

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.

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: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.