Development — entry 034 of 100

Google Sheets

Verified Jul 2026

The Google Sheets API is a REST interface for reading and writing spreadsheet data, formatting cells, and managing Connected Sheets, addressing ranges with either A1 (`Sheet1!A1:B2`) or R1C1 notation. It authenticates via OAuth 2.0 (or a service account for server-to-server access) and is widely used to drive spreadsheets as a lightweight database or reporting backend from external apps and scripts. Standard use is free under per-project and per-user Google Cloud quotas.

google-workspacespreadsheetsoauth

Visit developers.google.com ↗Read the docs ↗More Development

AuthenticationOAuthRequires an OAuth flow; expect app registration.

HTTPSSupportedTraffic is encrypted in transit.

CORSEnabledCallable directly from browser JavaScript.

PricingFreeNo paid tier — free for the documented use case.

FormatsJSONResponses can be requested as JSON.

GreatAPIs Score

Score77out of 100

Authentication8/25OAuth flow required

Pricing20/20Free to use

Docs20/20Machine-readable spec file bundled

Formats9/15Single response format

Freshness20/20Verified within 6 months

Embed this badge

<a href="https://greatapis.com/api/google-sheets/"><img src="https://greatapis.com/badge/google-sheets.svg" alt="Scored 77 on greatapis.com"></a>

Auth quickstart

Register an app / run the OAuth flow to obtain a bearer token.
Send it as an Authorization headerAuthorization: Bearer <token>

Stored keyNo key stored

Your key is stored only in this browser (localStorage) and sent directly to the API — never to greatapis.

Endpoints

Servers

https://sheets.googleapis.com/

Auth

Oauth2Oauth2c

spreadsheets17

POST/v4/spreadsheets

Request body

application/json — Spreadsheet

Responses

Status	Description	Schema
`200`	Successful response	`Spreadsheet`

GET/v4/spreadsheets/{spreadsheetId}

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string
`includeGridData`	query	no	boolean
`ranges`	query	no	array

Responses

Status	Description	Schema
`200`	Successful response	`Spreadsheet`

GET/v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string
`metadataId`	path	yes	integer

Responses

Status	Description	Schema
`200`	Successful response	`DeveloperMetadata`

POST/v4/spreadsheets/{spreadsheetId}/developerMetadata:search

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string

Request body

application/json — SearchDeveloperMetadataRequest

Responses

Status	Description	Schema
`200`	Successful response	`SearchDeveloperMetadataResponse`

POST/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string
`sheetId`	path	yes	integer

Request body

application/json — CopySheetToAnotherSpreadsheetRequest

Responses

Status	Description	Schema
`200`	Successful response	`SheetProperties`

GET/v4/spreadsheets/{spreadsheetId}/values/{range}

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string
`range`	path	yes	string
`dateTimeRenderOption`	query	no	string
`majorDimension`	query	no	string
`valueRenderOption`	query	no	string

Responses

Status	Description	Schema
`200`	Successful response	`ValueRange`

PUT/v4/spreadsheets/{spreadsheetId}/values/{range}

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string
`range`	path	yes	string
`includeValuesInResponse`	query	no	boolean
`responseDateTimeRenderOption`	query	no	string
`responseValueRenderOption`	query	no	string
`valueInputOption`	query	no	string

Request body

application/json — ValueRange

Responses

Status	Description	Schema
`200`	Successful response	`UpdateValuesResponse`

POST/v4/spreadsheets/{spreadsheetId}/values/{range}:append

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string
`range`	path	yes	string
`includeValuesInResponse`	query	no	boolean
`insertDataOption`	query	no	string
`responseDateTimeRenderOption`	query	no	string
`responseValueRenderOption`	query	no	string
`valueInputOption`	query	no	string

Request body

application/json — ValueRange

Responses

Status	Description	Schema
`200`	Successful response	`AppendValuesResponse`

POST/v4/spreadsheets/{spreadsheetId}/values/{range}:clear

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string
`range`	path	yes	string

Request body

application/json — ClearValuesRequest

Responses

Status	Description	Schema
`200`	Successful response	`ClearValuesResponse`

POST/v4/spreadsheets/{spreadsheetId}/values:batchClear

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string

Request body

application/json — BatchClearValuesRequest

Responses

Status	Description	Schema
`200`	Successful response	`BatchClearValuesResponse`

POST/v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string

Request body

application/json — BatchClearValuesByDataFilterRequest

Responses

Status	Description	Schema
`200`	Successful response	`BatchClearValuesByDataFilterResponse`

GET/v4/spreadsheets/{spreadsheetId}/values:batchGet

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string
`dateTimeRenderOption`	query	no	string
`majorDimension`	query	no	string
`ranges`	query	no	array
`valueRenderOption`	query	no	string

Responses

Status	Description	Schema
`200`	Successful response	`BatchGetValuesResponse`

POST/v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string

Request body

application/json — BatchGetValuesByDataFilterRequest

Responses

Status	Description	Schema
`200`	Successful response	`BatchGetValuesByDataFilterResponse`

POST/v4/spreadsheets/{spreadsheetId}/values:batchUpdate

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string

Request body

application/json — BatchUpdateValuesRequest

Responses

Status	Description	Schema
`200`	Successful response	`BatchUpdateValuesResponse`

POST/v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string

Request body

application/json — BatchUpdateValuesByDataFilterRequest

Responses

Status	Description	Schema
`200`	Successful response	`BatchUpdateValuesByDataFilterResponse`

POST/v4/spreadsheets/{spreadsheetId}:batchUpdate

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string

Request body

application/json — BatchUpdateSpreadsheetRequest

Responses

Status	Description	Schema
`200`	Successful response	`BatchUpdateSpreadsheetResponse`

POST/v4/spreadsheets/{spreadsheetId}:getByDataFilter

Parameters

Name	In	Required	Type
`spreadsheetId`	path	yes	string

Request body

application/json — GetSpreadsheetByDataFilterRequest

Responses

Status	Description	Schema
`200`	Successful response	`Spreadsheet`

Try it

Operation

API key

Developer reference

Base URLhttps://sheets.googleapis.com

Rate limit

Google's Sheets API limits docs (developers.google.com/workspace/sheets/api/limits) publish flat per-minute quotas rather than a quota-unit system: Read requests are capped at 300/minute/project and 60/minute/user/project, and Write requests at 300/minute/project and 60/minute/user/project. Exceeding a limit returns a 429 (Too many requests) HTTP status; Google recommends an exponential backoff before retrying. There's no daily cap as long as the per-minute quotas are respected, and standard use is free under these Google Cloud project quotas.

Key endpoints

POST/v4/spreadsheets
GET/v4/spreadsheets/{spreadsheetId}
GET/v4/spreadsheets/{spreadsheetId}/values/{range}
PUT/v4/spreadsheets/{spreadsheetId}/values/{range}
POST/v4/spreadsheets/{spreadsheetId}/values/{range}:append

GreatAPIs Score

Embed this badge

Auth quickstart

Endpoints

Try it

Developer reference

People comparing Google Sheets also look at…

Kroki

QR code

Statically

Wandbox

APIs.guru

Beeceptor