Google Sheets API

Reads and writes Google Sheets.

Service: sheets.googleapis.com

All URIs below are relative to https://sheets.googleapis.com

This service provides the following discovery document:

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.

Send feedback about...