How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Need help?

Contact us
Google Sheets

Google Sheets Values API

Operations on spreadsheet cell values

Documentation Provider Profile APIs.io OpenAPI GitHub

Google Sheets Values API is one of 5 APIs that Google Sheets publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 1 JSON Schema definition.

Tagged areas include Values. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, authentication docs, a getting-started guide, an API reference, a changelog, and 1 JSON Schema.

This API exposes 10 operations across 9 paths, and defines 22 schemas. It is described by OpenAPI 3.2.0, at version v4.

Requests are made against a single base URL, https://sheets.googleapis.com/v4.

10 operations 9 paths 22 schemas 2 GET7 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
v4
Base URL
https://sheets.googleapis.com/v4
Authentication
OAuth 2.0, API Key
Contact
Google Workspace Developer Support
License
Creative Commons Attribution 4.0
Terms of Service
View terms
Resource Areas
1

Authentication & Security 2

Google Sheets Values API declares 2 security schemes for authenticating requests. It supports OAuth 2.0 (oauth2) using the authorizationCode flow, exposing 5 scopes. An API key is passed in the query as key (apiKey). By default, every request must be authenticated.

  • oauth2 — OAuth 2.0 authentication for accessing user spreadsheets.
  • apiKey — API key for accessing public spreadsheets without user authentication.

Paths & Operations 10

Across 9 paths, the API surfaces 10 operations — 2 GET, 7 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

Values 10

Operations on spreadsheet cell values

GET
/spreadsheets/{spreadsheetId}/values/{range}
Google Sheets Get Values From a Range
getValues 5 params → 200401403404429
PUT
/spreadsheets/{spreadsheetId}/values/{range}
Google Sheets Update Values in a Range
updateValues 6 params body → 200401403404429
POST
/spreadsheets/{spreadsheetId}/values/{range}:append
Google Sheets Append Values to a Range
appendValues 7 params body → 200401403404429
POST
/spreadsheets/{spreadsheetId}/values/{range}:clear
Google Sheets Clear Values From a Range
clearValues 2 params body → 200401403404429
GET
/spreadsheets/{spreadsheetId}/values:batchGet
Google Sheets Get Values From Multiple Ranges
batchGetValues 5 params → 200401403404429
POST
/spreadsheets/{spreadsheetId}/values:batchUpdate
Google Sheets Update Values in Multiple Ranges
batchUpdateValues 1 param body → 200401403404429
POST
/spreadsheets/{spreadsheetId}/values:batchClear
Google Sheets Clear Values From Multiple Ranges
batchClearValues 1 param body → 200401403404429
POST
/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter
Google Sheets Get Values From Ranges Matching Data Filters
batchGetValuesByDataFilter 1 param body → 200401403404429
POST
/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter
Google Sheets Update Values in Ranges Matching Data Filters
batchUpdateValuesByDataFilter 1 param body → 200401403404429
POST
/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter
Google Sheets Clear Values From Ranges Matching Data Filters
batchClearValuesByDataFilter 1 param body → 200401403404429

Schemas 22

The contract defines 22 schemas that model the data the API accepts and returns. The most detailed are DeveloperMetadataLookup (7 properties), BatchUpdateValuesResponse (6 properties), UpdateValuesResponse (6 properties), BatchUpdateValuesByDataFilterResponse (6 properties). Each schema is shown below with its type and property counts.

BatchUpdateValuesResponse
object
The response when updating a range of values in a spreadsheet.
6 properties
BatchGetValuesByDataFilterResponse
object
The response when retrieving more than one range of values in a spreadsheet selected by DataFilters.
2 properties
Dimension
string
Indicates which dimension an operation should apply to.
BatchClearValuesByDataFilterResponse
object
The response when clearing a range of values selected by DataFilters in a spreadsheet.
2 properties
DeveloperMetadataLookup
object
Selects DeveloperMetadata that matches all of the specified fields.
7 properties
UpdateValuesResponse
object
The response when updating a range of values in a spreadsheet.
6 properties
ValueInputOption
string
Determines how input data should be interpreted.
BatchClearValuesResponse
object
The response when clearing a range of values in a spreadsheet.
2 properties
DataFilterValueRange
object
A range of values whose location is specified by a DataFilter.
3 properties
DeveloperMetadataLocation
object
A location where metadata may be associated in a spreadsheet.
4 properties
DimensionRange
object
A range along a single dimension on a sheet.
4 properties
BatchUpdateValuesByDataFilterResponse
object
The response when updating a range of values in a spreadsheet by data filter.
6 properties
DataFilter
object
Filter that describes what data should be selected or returned from a request.
3 properties
ClearValuesResponse
object
The response when clearing a range of values in a spreadsheet.
2 properties
GridRange
object
A range on a sheet. All indexes are zero-based.
5 properties
AppendValuesResponse
object
The response when updating a range of values by appending.
3 properties
BatchGetValuesResponse
object
The response when retrieving more than one range of values in a spreadsheet.
2 properties
ValueRenderOption
string
Determines how values should be rendered in the output.
DateTimeRenderOption
string
Determines how dates, times, and durations should be rendered in the output.
ErrorResponse
object
An error response from the API.
1 property
BatchUpdateValuesRequest
object
The request for updating more than one range of values in a spreadsheet.
5 properties
ValueRange
object
Data within a range of the spreadsheet.
3 properties

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

google-sheets-values-api-openapi.yml Raw ↑

Other APIs Google Sheets publishes across the network.

Google Apps Script Spreadsheet Service
AE Profile APIs.io
Google Sheets developerMetadata API
AE Profile APIs.io
Google Sheets Sheets API
AE Profile APIs.io
Google Sheets Spreadsheets API
AE Profile APIs.io
#Values
← Back to G APIs
API Details
ID
google-sheets:google-sheets-values-api
Base URL
https://sheets.googleapis.com/v4
Docs
https://developers.google.com/sheets/api
Provider
Google Sheets
APIs.io →  GitHub →
Explore more
All APIs Providers APIs.io Network
Work with this as data

Every API here is available over the API and to AI agents over MCP. APIs is not yet its own endpoint on the v1 API. Reach this content through network search and the tag graph, or the MCP server below.

Installs https://mcp.apievangelist.com/mcp in Claude, Cursor, VS Code and the rest — one button, every client.

MCP tools for apis
4 tools reach this content
  • search_api_evangelistSearch every content type across the network at once.
  • find_relatedThe shared-tag relevance graph — what else covers this.
  • get_tagEverything one tag labels, across all content types.
  • guide_topicPRO — a curated bundle for a topic: area, guidance, rules, papers, stories, services.
All tools & prompts
Call it yourself
curl for this page
Search the network for this 
curl "https://api.apievangelist.com/v1/search?q=google-sheets-values-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/google-sheets-values-api"

Discovery needs no key. Full bodies and the synthesis endpoints are Pro.

Get an API key

Free tier, no email required. Sign in with whichever identity you already have.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have. Your account

Where this information came from

This is an independent, third-party profile of Google Sheets Values API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.