Google Sheets website screenshot

Google Sheets

API for reading, writing, and formatting data in Google Sheets.

Google Sheets publishes 4 APIs on the APIs.io network, including developerMetadata API, Sheets API, Spreadsheets API, and 1 more. Tagged areas include Google Workspace, Productivity, and Spreadsheets.

The Google Sheets catalog on APIs.io includes 1 JSON-LD context and 2 Spectral governance rulesets.

Google Sheets’ developer surface includes authentication, changelog, developer portal, documentation, engineering blog, support, signup flow, and 41 more developer resources.

🌐 Visit website 📡 Source on GitHub
71.4/100 exemplar ▬ flat Agent 47/100 agent ready Full breakdown ↓
scored 2026-07-28 · rubric v0.6
AccessFreemiumSelf serve⚡ Free to try
5 APIs 1 MCP Servers 10 Features 5 Use Cases
Google WorkspaceProductivitySpreadsheets

Kin Score

Kin Score Kin Score How this is scored →
scored 2026-07-28 · rubric v0.6
Composite quality — 71.4/100 · exemplar
Contract Quality 18.4 / 25
Developer Ergonomics 11.7 / 20
Commercial Clarity 16.8 / 20
Operational Transparency 8.9 / 13
Governance 8.4 / 12
Discoverability 7.2 / 10
Agent readiness — 47/100 · agent ready
Machine-Readable Contract 18 / 18
Agentic Access Contract 10 / 10
MCP Server 12 / 12
Machine-Readable Auth 10 / 10
Idempotency 0 / 9
Stable Error Semantics 8 / 8
Request/Response Examples 7 / 7
Rate-Limit Signaling 7 / 7
Typed Event Surface 0 / 6
Agent Skills 0 / 5
Well-Known Catalog 4 / 4
Consent & Bot Identity 0 / 3
A2A Agent Card 0 / 8
Dry-Run / Simulate Mode 0 / 4
Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. This rating is computed from github.com/api-evangelist/google-sheets: open an issue to ask a question, or submit a pull request to add artifacts. Want it done for you? Prioritized profiling — $2,500 →

APIs 5

Individual APIs this provider publishes, each with its own machine-readable definition.

Google Apps Script Spreadsheet Service

The built-in Google Apps Script Spreadsheet Service allows creation, access, and modification of Google Sheets files directly from Apps Script with performance bundling and nume...

Google Sheets developerMetadata API

Operations on developer metadata

Google Sheets Sheets API

Operations on individual sheets within a spreadsheet

Google Sheets Spreadsheets API

Operations on spreadsheet resources

Google Sheets Values API

Operations on spreadsheet cell values

Postman Collections 1

Ready-to-run Postman collections for exercising this provider's APIs.

Google Sheets API

POSTMAN

Open Collections 1

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

Google Sheets API

OPEN COLLECTION

Arazzo Workflows 12

Multi-step API workflows described with the Arazzo specification.

Google Sheets Append Rows and Format the Header

Create a spreadsheet, append rows including a header, then bold the header row via batchUpdate.

ARAZZO

Google Sheets Archive and Clear Multiple Ranges

Read several ranges as an archive, clear them all in one batch, then re-read to confirm they are empty.

ARAZZO

Google Sheets Bulk Load Multiple Ranges

Create a spreadsheet, write several ranges in one batch, then read them all back in one batch.

ARAZZO

Google Sheets Copy a Sheet Between Spreadsheets

Read a source spreadsheet, copy one of its sheets into a destination spreadsheet, then confirm the destination.

ARAZZO

Google Sheets Create and Seed a Spreadsheet

Create a new spreadsheet, append seed rows to it, then read them back.

ARAZZO

Google Sheets Create With an Extra Sheet and Write

Create a spreadsheet, add a second named sheet to it, then write values into that sheet.

ARAZZO

Google Sheets Create, Write, and Verify

Create a spreadsheet, write values into a range, then read the range back to verify the write.

ARAZZO

Google Sheets Overwrite or Append Rows

Inspect a range and branch — overwrite it in place when it already has data, otherwise append fresh rows.

ARAZZO

Google Sheets Refresh a Range

Read the current values of a range, clear it, then write a fresh set of values into it.

ARAZZO

Google Sheets Seed a Range Only If Empty

Read a range and branch — write seed values only when the range has no existing data.

ARAZZO

Google Sheets Tag and Find a Spreadsheet With Developer Metadata

Create a spreadsheet, attach a developer metadata tag via batchUpdate, then search for it by key.

ARAZZO

Google Sheets Update and Read Values by Data Filter

Resolve a spreadsheet via a data filter, update matching ranges by filter, then read them back by filter.

ARAZZO

Scroll for all 12

MCP Servers 1

Model Context Protocol servers that expose these APIs to AI agents.

google-sheets-mcp.yml

MCP SERVER

Pricing Plans 1

Published pricing tiers and plan structures.

Google Sheets Plans Pricing

3 plans

PLANS

Rate Limits 1

Documented rate limits and quota policies.

Google Sheets Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Google Sheets Finops

FINOPS

Features 10

Notable capabilities this provider offers.

Spreadsheet Management

Create, read, update, and delete spreadsheets programmatically with full control over properties and metadata.

Cell Value Operations

Read and write individual cell values, ranges, and batch operations across multiple ranges.

Formatting

Apply rich formatting to cells including fonts, colors, borders, alignment, and number formats.

Sheet Management

Add, remove, copy, and configure individual sheets within a spreadsheet.

Developer Metadata

Attach custom metadata to spreadsheets, sheets, rows, and columns for application-specific data.

Data Validation

Set validation rules on cells to enforce data quality and consistency.

Conditional Formatting

Apply conditional formatting rules based on cell values and formulas.

Charts and Graphs

Create and manage embedded charts within spreadsheets.

Named Ranges

Define and manage named ranges for easier formula references.

Batch Operations

Execute multiple read and write operations in a single API call for efficiency.

Scroll for all 10

Semantic Vocabularies 1

JSON-LD contexts and semantic vocabularies used across these APIs.

Google Sheets Context

0 classes · 0 properties

JSON-LD

Spectral Rules 2

Spectral governance rulesets for linting and validating these APIs.

Google Sheets API Rules

5 rules · 3 warnings 2 info

SPECTRAL

Google Sheets API Rules

20 rules · 8 errors 11 warnings 1 info

SPECTRAL

JSON Schema 86

Standalone JSON Schema definitions for this provider's data models.

AppendValuesResponse

2 properties

JSON SCHEMA

BandedRange

1 properties

JSON SCHEMA

BandingProperties

0 properties

JSON SCHEMA

BasicFilter

3 properties

JSON SCHEMA

BatchClearValuesByDataFilterResponse

2 properties

JSON SCHEMA

BatchClearValuesResponse

2 properties

JSON SCHEMA

BatchGetValuesByDataFilterResponse

2 properties

JSON SCHEMA

BatchGetValuesResponse

2 properties

JSON SCHEMA

BatchUpdateSpreadsheetRequest

4 properties

JSON SCHEMA

BatchUpdateSpreadsheetResponse

2 properties

JSON SCHEMA

BatchUpdateValuesByDataFilterResponse

6 properties

JSON SCHEMA

BatchUpdateValuesRequest

2 properties

JSON SCHEMA

BatchUpdateValuesResponse

6 properties

JSON SCHEMA

BigQueryDataSourceSpec

3 properties

JSON SCHEMA

BooleanCondition

2 properties

JSON SCHEMA

Border

2 properties

JSON SCHEMA

Borders

0 properties

JSON SCHEMA

CellData

4 properties

JSON SCHEMA

CellFormat

5 properties

JSON SCHEMA

ClearValuesResponse

2 properties

JSON SCHEMA

Color

4 properties

JSON SCHEMA

ColorStyle

1 properties

JSON SCHEMA

ConditionValue

2 properties

JSON SCHEMA

ConditionalFormatRule

3 properties

JSON SCHEMA

DataExecutionStatus

4 properties

JSON SCHEMA

DataFilter

1 properties

JSON SCHEMA

DataFilterValueRange

1 properties

JSON SCHEMA

DataSourceColumnReference

1 properties

JSON SCHEMA

DataSourceColumn

1 properties

JSON SCHEMA

DataSourceFormula

1 properties

JSON SCHEMA

DataSourceParameter

2 properties

JSON SCHEMA

DataSourceRefreshSchedule

6 properties

JSON SCHEMA

DataSource

3 properties

JSON SCHEMA

DataSourceSheetProperties

2 properties

JSON SCHEMA

DataSourceSpec

1 properties

JSON SCHEMA

DataSourceTable

6 properties

JSON SCHEMA

DataValidationRule

3 properties

JSON SCHEMA

DateTimeRenderOption

0 properties

JSON SCHEMA

DeveloperMetadataLocation

3 properties

JSON SCHEMA

DeveloperMetadataLookup

6 properties

JSON SCHEMA

DeveloperMetadata

4 properties

JSON SCHEMA

DimensionProperties

4 properties

JSON SCHEMA

DimensionRange

3 properties

JSON SCHEMA

Dimension

0 properties

JSON SCHEMA

EmbeddedChart

2 properties

JSON SCHEMA

EmbeddedObjectPosition

3 properties

JSON SCHEMA

ErrorResponse

1 properties

JSON SCHEMA

ErrorValue

2 properties

JSON SCHEMA

ExtendedValue

4 properties

JSON SCHEMA

FilterCriteria

1 properties

JSON SCHEMA

FilterSpec

1 properties

JSON SCHEMA

FilterView

6 properties

JSON SCHEMA

GridCoordinate

3 properties

JSON SCHEMA

GridData

5 properties

JSON SCHEMA

GridProperties

7 properties

JSON SCHEMA

GridRange

5 properties

JSON SCHEMA

InterpolationPoint

2 properties

JSON SCHEMA

IterativeCalculationSettings

2 properties

JSON SCHEMA

Link

1 properties

JSON SCHEMA

NamedRange

2 properties

JSON SCHEMA

NumberFormat

2 properties

JSON SCHEMA

Padding

4 properties

JSON SCHEMA

PivotFilterCriteria

2 properties

JSON SCHEMA

PivotFilterSpec

1 properties

JSON SCHEMA

PivotGroupLimit

2 properties

JSON SCHEMA

PivotGroupRule

3 properties

JSON SCHEMA

PivotGroup

5 properties

JSON SCHEMA

PivotGroupSortValueBucket

2 properties

JSON SCHEMA

PivotTable

7 properties

JSON SCHEMA

PivotValue

5 properties

JSON SCHEMA

ProtectedRange

7 properties

JSON SCHEMA

RowData

1 properties

JSON SCHEMA

SheetProperties

6 properties

JSON SCHEMA

Sheet

8 properties

JSON SCHEMA

Slicer

2 properties

JSON SCHEMA

SortSpec

2 properties

JSON SCHEMA

SpreadsheetProperties

5 properties

JSON SCHEMA

Spreadsheet

7 properties

JSON SCHEMA

SpreadsheetTheme

2 properties

JSON SCHEMA

TextFormatRun

1 properties

JSON SCHEMA

TextFormat

6 properties

JSON SCHEMA

TextRotation

2 properties

JSON SCHEMA

UpdateValuesResponse

5 properties

JSON SCHEMA

ValueInputOption

0 properties

JSON SCHEMA

ValueRange

2 properties

JSON SCHEMA

ValueRenderOption

0 properties

JSON SCHEMA

Scroll for all 86

JSON Structure 86

JSON Structure definitions describing this provider's data shapes.

Google Sheets Append Values Response Structure

2 properties

JSON STRUCTURE

Google Sheets Banded Range Structure

1 properties

JSON STRUCTURE

Google Sheets Banding Properties Structure

0 properties

JSON STRUCTURE

Google Sheets Basic Filter Structure

3 properties

JSON STRUCTURE

Google Sheets Batch Clear Values By Data Filter Response Structure

2 properties

JSON STRUCTURE

Google Sheets Batch Clear Values Response Structure

2 properties

JSON STRUCTURE

Google Sheets Batch Get Values By Data Filter Response Structure

2 properties

JSON STRUCTURE

Google Sheets Batch Get Values Response Structure

2 properties

JSON STRUCTURE

Google Sheets Batch Update Spreadsheet Request Structure

4 properties

JSON STRUCTURE

Google Sheets Batch Update Spreadsheet Response Structure

2 properties

JSON STRUCTURE

Google Sheets Batch Update Values By Data Filter Response Structure

6 properties

JSON STRUCTURE

Google Sheets Batch Update Values Request Structure

2 properties

JSON STRUCTURE

Google Sheets Batch Update Values Response Structure

6 properties

JSON STRUCTURE

Google Sheets Big Query Data Source Spec Structure

3 properties

JSON STRUCTURE

Google Sheets Boolean Condition Structure

2 properties

JSON STRUCTURE

Google Sheets Border Structure

2 properties

JSON STRUCTURE

Google Sheets Borders Structure

0 properties

JSON STRUCTURE

Google Sheets Cell Data Structure

4 properties

JSON STRUCTURE

Google Sheets Cell Format Structure

5 properties

JSON STRUCTURE

Google Sheets Clear Values Response Structure

2 properties

JSON STRUCTURE

Google Sheets Color Structure

4 properties

JSON STRUCTURE

Google Sheets Color Style Structure

1 properties

JSON STRUCTURE

Google Sheets Condition Value Structure

2 properties

JSON STRUCTURE

Google Sheets Conditional Format Rule Structure

3 properties

JSON STRUCTURE

Google Sheets Data Execution Status Structure

4 properties

JSON STRUCTURE

Google Sheets Data Filter Structure

1 properties

JSON STRUCTURE

Google Sheets Data Filter Value Range Structure

1 properties

JSON STRUCTURE

Google Sheets Data Source Column Reference Structure

1 properties

JSON STRUCTURE

Google Sheets Data Source Column Structure

1 properties

JSON STRUCTURE

Google Sheets Data Source Formula Structure

1 properties

JSON STRUCTURE

Google Sheets Data Source Parameter Structure

2 properties

JSON STRUCTURE

Google Sheets Data Source Refresh Schedule Structure

6 properties

JSON STRUCTURE

Google Sheets Data Source Sheet Properties Structure

2 properties

JSON STRUCTURE

Google Sheets Data Source Spec Structure

1 properties

JSON STRUCTURE

Google Sheets Data Source Structure

3 properties

JSON STRUCTURE

Google Sheets Data Source Table Structure

6 properties

JSON STRUCTURE

Google Sheets Data Validation Rule Structure

3 properties

JSON STRUCTURE

Google Sheets Date Time Render Option Structure

0 properties

JSON STRUCTURE

Google Sheets Developer Metadata Location Structure

3 properties

JSON STRUCTURE

Google Sheets Developer Metadata Lookup Structure

6 properties

JSON STRUCTURE

Google Sheets Developer Metadata Structure

4 properties

JSON STRUCTURE

Google Sheets Dimension Properties Structure

4 properties

JSON STRUCTURE

Google Sheets Dimension Range Structure

3 properties

JSON STRUCTURE

Google Sheets Dimension Structure

0 properties

JSON STRUCTURE

Google Sheets Embedded Chart Structure

2 properties

JSON STRUCTURE

Google Sheets Embedded Object Position Structure

3 properties

JSON STRUCTURE

Google Sheets Error Response Structure

1 properties

JSON STRUCTURE

Google Sheets Error Value Structure

2 properties

JSON STRUCTURE

Google Sheets Extended Value Structure

4 properties

JSON STRUCTURE

Google Sheets Filter Criteria Structure

1 properties

JSON STRUCTURE

Google Sheets Filter Spec Structure

1 properties

JSON STRUCTURE

Google Sheets Filter View Structure

6 properties

JSON STRUCTURE

Google Sheets Grid Coordinate Structure

3 properties

JSON STRUCTURE

Google Sheets Grid Data Structure

5 properties

JSON STRUCTURE

Google Sheets Grid Properties Structure

7 properties

JSON STRUCTURE

Google Sheets Grid Range Structure

5 properties

JSON STRUCTURE

Google Sheets Interpolation Point Structure

2 properties

JSON STRUCTURE

Google Sheets Iterative Calculation Settings Structure

2 properties

JSON STRUCTURE

Google Sheets Link Structure

1 properties

JSON STRUCTURE

Google Sheets Named Range Structure

2 properties

JSON STRUCTURE

Google Sheets Number Format Structure

2 properties

JSON STRUCTURE

Google Sheets Padding Structure

4 properties

JSON STRUCTURE

Google Sheets Pivot Filter Criteria Structure

2 properties

JSON STRUCTURE

Google Sheets Pivot Filter Spec Structure

1 properties

JSON STRUCTURE

Google Sheets Pivot Group Limit Structure

2 properties

JSON STRUCTURE

Google Sheets Pivot Group Rule Structure

3 properties

JSON STRUCTURE

Google Sheets Pivot Group Sort Value Bucket Structure

2 properties

JSON STRUCTURE

Google Sheets Pivot Group Structure

5 properties

JSON STRUCTURE

Google Sheets Pivot Table Structure

7 properties

JSON STRUCTURE

Google Sheets Pivot Value Structure

5 properties

JSON STRUCTURE

Google Sheets Protected Range Structure

7 properties

JSON STRUCTURE

Google Sheets Row Data Structure

1 properties

JSON STRUCTURE

Google Sheets Sheet Properties Structure

6 properties

JSON STRUCTURE

Google Sheets Sheet Structure

8 properties

JSON STRUCTURE

Google Sheets Slicer Structure

2 properties

JSON STRUCTURE

Google Sheets Sort Spec Structure

2 properties

JSON STRUCTURE

Google Sheets Spreadsheet Properties Structure

5 properties

JSON STRUCTURE

Google Sheets Spreadsheet Structure

7 properties

JSON STRUCTURE

Google Sheets Spreadsheet Theme Structure

2 properties

JSON STRUCTURE

Google Sheets Text Format Run Structure

1 properties

JSON STRUCTURE

Google Sheets Text Format Structure

6 properties

JSON STRUCTURE

Google Sheets Text Rotation Structure

2 properties

JSON STRUCTURE

Google Sheets Update Values Response Structure

5 properties

JSON STRUCTURE

Google Sheets Value Input Option Structure

0 properties

JSON STRUCTURE

Google Sheets Value Range Structure

2 properties

JSON STRUCTURE

Google Sheets Value Render Option Structure

0 properties

JSON STRUCTURE

Scroll for all 86

Examples 86

Example request and response payloads for these APIs.

Google Sheets Append Values Response Example

2 fields

EXAMPLE

Google Sheets Banded Range Example

1 fields

EXAMPLE

Google Sheets Banding Properties Example

0 fields

EXAMPLE

Google Sheets Basic Filter Example

3 fields

EXAMPLE

Google Sheets Batch Clear Values By Data Filter Response Example

2 fields

EXAMPLE

Google Sheets Batch Clear Values Response Example

2 fields

EXAMPLE

Google Sheets Batch Get Values By Data Filter Response Example

2 fields

EXAMPLE

Google Sheets Batch Get Values Response Example

2 fields

EXAMPLE

Google Sheets Batch Update Spreadsheet Request Example

4 fields

EXAMPLE

Google Sheets Batch Update Spreadsheet Response Example

2 fields

EXAMPLE

Google Sheets Batch Update Values By Data Filter Response Example

6 fields

EXAMPLE

Google Sheets Batch Update Values Request Example

2 fields

EXAMPLE

Google Sheets Batch Update Values Response Example

6 fields

EXAMPLE

Google Sheets Big Query Data Source Spec Example

3 fields

EXAMPLE

Google Sheets Boolean Condition Example

2 fields

EXAMPLE

Google Sheets Border Example

2 fields

EXAMPLE

Google Sheets Borders Example

0 fields

EXAMPLE

Google Sheets Cell Data Example

4 fields

EXAMPLE

Google Sheets Cell Format Example

5 fields

EXAMPLE

Google Sheets Clear Values Response Example

2 fields

EXAMPLE

Google Sheets Color Example

4 fields

EXAMPLE

Google Sheets Color Style Example

1 fields

EXAMPLE

Google Sheets Condition Value Example

2 fields

EXAMPLE

Google Sheets Conditional Format Rule Example

3 fields

EXAMPLE

Google Sheets Data Execution Status Example

4 fields

EXAMPLE

Google Sheets Data Filter Example

1 fields

EXAMPLE

Google Sheets Data Filter Value Range Example

1 fields

EXAMPLE

Google Sheets Data Source Column Example

1 fields

EXAMPLE

Google Sheets Data Source Column Reference Example

1 fields

EXAMPLE

Google Sheets Data Source Example

3 fields

EXAMPLE

Google Sheets Data Source Formula Example

1 fields

EXAMPLE

Google Sheets Data Source Parameter Example

2 fields

EXAMPLE

Google Sheets Data Source Refresh Schedule Example

6 fields

EXAMPLE

Google Sheets Data Source Sheet Properties Example

2 fields

EXAMPLE

Google Sheets Data Source Spec Example

1 fields

EXAMPLE

Google Sheets Data Source Table Example

6 fields

EXAMPLE

Google Sheets Data Validation Rule Example

3 fields

EXAMPLE

Google Sheets Date Time Render Option Example

0 fields

EXAMPLE

Google Sheets Developer Metadata Example

4 fields

EXAMPLE

Google Sheets Developer Metadata Location Example

3 fields

EXAMPLE

Google Sheets Developer Metadata Lookup Example

6 fields

EXAMPLE

Google Sheets Dimension Example

0 fields

EXAMPLE

Google Sheets Dimension Properties Example

4 fields

EXAMPLE

Google Sheets Dimension Range Example

3 fields

EXAMPLE

Google Sheets Embedded Chart Example

2 fields

EXAMPLE

Google Sheets Embedded Object Position Example

3 fields

EXAMPLE

Google Sheets Error Response Example

1 fields

EXAMPLE

Google Sheets Error Value Example

2 fields

EXAMPLE

Google Sheets Extended Value Example

4 fields

EXAMPLE

Google Sheets Filter Criteria Example

1 fields

EXAMPLE

Google Sheets Filter Spec Example

1 fields

EXAMPLE

Google Sheets Filter View Example

6 fields

EXAMPLE

Google Sheets Grid Coordinate Example

3 fields

EXAMPLE

Google Sheets Grid Data Example

5 fields

EXAMPLE

Google Sheets Grid Properties Example

7 fields

EXAMPLE

Google Sheets Grid Range Example

5 fields

EXAMPLE

Google Sheets Interpolation Point Example

2 fields

EXAMPLE

Google Sheets Iterative Calculation Settings Example

2 fields

EXAMPLE

Google Sheets Link Example

1 fields

EXAMPLE

Google Sheets Named Range Example

2 fields

EXAMPLE

Google Sheets Number Format Example

2 fields

EXAMPLE

Google Sheets Padding Example

4 fields

EXAMPLE

Google Sheets Pivot Filter Criteria Example

2 fields

EXAMPLE

Google Sheets Pivot Filter Spec Example

1 fields

EXAMPLE

Google Sheets Pivot Group Example

5 fields

EXAMPLE

Google Sheets Pivot Group Limit Example

2 fields

EXAMPLE

Google Sheets Pivot Group Rule Example

3 fields

EXAMPLE

Google Sheets Pivot Group Sort Value Bucket Example

2 fields

EXAMPLE

Google Sheets Pivot Table Example

7 fields

EXAMPLE

Google Sheets Pivot Value Example

5 fields

EXAMPLE

Google Sheets Protected Range Example

7 fields

EXAMPLE

Google Sheets Row Data Example

1 fields

EXAMPLE

Google Sheets Sheet Example

8 fields

EXAMPLE

Google Sheets Sheet Properties Example

6 fields

EXAMPLE

Google Sheets Slicer Example

2 fields

EXAMPLE

Google Sheets Sort Spec Example

2 fields

EXAMPLE

Google Sheets Spreadsheet Example

7 fields

EXAMPLE

Google Sheets Spreadsheet Properties Example

5 fields

EXAMPLE

Google Sheets Spreadsheet Theme Example

2 fields

EXAMPLE

Google Sheets Text Format Example

6 fields

EXAMPLE

Google Sheets Text Format Run Example

1 fields

EXAMPLE

Google Sheets Text Rotation Example

2 fields

EXAMPLE

Google Sheets Update Values Response Example

5 fields

EXAMPLE

Google Sheets Value Input Option Example

0 fields

EXAMPLE

Google Sheets Value Range Example

2 fields

EXAMPLE

Google Sheets Value Render Option Example

0 fields

EXAMPLE

Scroll for all 86

Security Posture 3

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Google Sheets Authentication

apiKey/oauth2 · 2 schemes

SECURITY

Google Sheets Domain Security

TLSv1.3 · HSTS · DMARC

SECURITY

Google Sheets Vulnerability Disclosure

security.txt · contact published

SECURITY

Scopes 1

OAuth scopes governing access to this provider's APIs.

Google Sheets Scopes

5 scopes · authorizationCode

5 scopes

SCOPES

Agentic Access 1

Recommended x-agentic-access execution contracts for AI agents.

Google Sheets Agentic Access

17 operations · 13 acting

17 operations · 13 acting

AGENTIC

Use Cases 5

What developers build with this provider.

Data Collection and Reporting

Collect data from various sources and generate automated reports in Google Sheets.

Database Backend

Use Google Sheets as a lightweight database for web applications and prototypes.

Workflow Automation

Automate data entry, processing, and distribution workflows using the API.

Data Integration

Synchronize data between Google Sheets and other business applications.

Dashboard Creation

Build interactive dashboards and visualizations from spreadsheet data.

Integrations 5

Pre-built integrations with other platforms and tools.

Google Workspace

Deep integration with Google Docs, Slides, Forms, and other Workspace applications.

Google Apps Script

Extend Sheets functionality with custom functions, menus, and automation scripts.

Google Cloud Platform

Connect to BigQuery, Cloud Functions, and other GCP services for advanced data processing.

Zapier

Connect Google Sheets to thousands of apps through Zapier automation workflows.

Slack

Send notifications and updates to Slack channels based on spreadsheet changes.

Resources

Get Started 4

Portal, sign-up, and the first successful call

Portal
Portal
 Signup
Signup
 Login
Login
 GettingStarted
GettingStarted

Documentation 1

Reference material describing how the API behaves

Documentation
Documentation

Agent Surfaces 4

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess
AgenticAccess
 WellKnown
WellKnown
 MCPServer
MCPServer
 LLMsTxt
LLMsTxt

Design & Contract 18

Pagination, idempotency, versioning, errors, and events

Conformance
Conformance
 ErrorCatalog
ErrorCatalog
 Lifecycle
Lifecycle
 Conventions
Conventions
 DataModel
DataModel
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 Arazzo
Arazzo
 SpectralRules
SpectralRules

Scroll for all 18

Build 4

SDKs, sample code, and the tooling you integrate with

Packages
Packages
 PostmanWorkspace
PostmanWorkspace
 GitHubOrganization
GitHubOrganization
 SDKs
SDKs

Access & Security 5

Authentication, authorization, and security posture

VulnerabilityDisclosure
VulnerabilityDisclosure
 DomainSecurity
DomainSecurity
 Authentication
Authentication
 OAuthScopes
OAuthScopes
 Authentication
Authentication

Learn 1

Tutorials, courses, talks, and written guidance

YouTube
YouTube

Operate 6

Status, limits, changes, and where to get help

ChangeLog
ChangeLog
 Support
Support
 StatusPage
StatusPage
 StackOverflow
StackOverflow
 ReleaseNotes
ReleaseNotes
 RateLimits
RateLimits

Commercial 3

Pricing, plans, and the legal terms of use

TermsOfService
TermsOfService
 PrivacyPolicy
PrivacyPolicy
 Pricing
Pricing

Company 1

The organization behind the API

Blog
Blog

Other 1

Properties that don't map to a standard resource type

Overlay
Overlay

Source (apis.yml)

apis.yml Raw ↑ 
aid: google-sheets
name: Google Sheets
description: API for reading, writing, and formatting data in Google Sheets.
accessModel:
  pricing: freemium
  onboarding: self-serve
  trial: false
  try_now: true
  public: false
  label: Freemium · Self-serve signup
  confidence: high
  source:
  - plans
  - authentication
  generated: '2026-07-22'
  method: derived
image: https://www.google.com/images/branding/googlelogo/2x/googlelogo_color_272x92dp.png
url: https://developers.google.com/sheets/api
created: '2024-01-01'
modified: '2026-06-20'
specificationVersion: '0.19'
type: Index
apis:
- name: Google Apps Script Spreadsheet Service
  description: The built-in Google Apps Script Spreadsheet Service allows creation, access, and modification of Google Sheets
    files directly from Apps Script with performance bundling and numerous classes for formatting, data sources, structure,
    and content.
  image: https://www.gstatic.com/images/branding/product/2x/apps_script_48dp.png
  humanURL: https://developers.google.com/apps-script/reference/spreadsheet
  properties:
  - type: Documentation
    url: https://developers.google.com/apps-script/reference/spreadsheet
  - type: GettingStarted
    url: https://developers.google.com/apps-script
  - type: APIReference
    url: https://developers.google.com/apps-script/reference
  - type: ReleaseNotes
    url: https://developers.google.com/apps-script/release-notes
  contact:
  - type: StackOverflow
    url: https://stackoverflow.com/questions/tagged/google-apps-script
  tags:
  - Apps Script
  - Automation
  - Google
  - Scripting
  - Spreadsheets
- aid: google-sheets:google-sheets-developermetadata-api
  name: Google Sheets developerMetadata API
  description: Operations on developer metadata
  humanURL: https://developers.google.com/sheets/api
  baseURL: https://sheets.googleapis.com/v4
  tags:
  - developerMetadata
  properties:
  - type: OpenAPI
    url: openapi/google-sheets-developermetadata-api-openapi.yml
  - type: Documentation
    url: https://developers.google.com/sheets/api/reference/rest
  - type: Authentication
    url: https://developers.google.com/sheets/api/guides/authorizing
  - type: GettingStarted
    url: https://developers.google.com/sheets/api/quickstart/python
  - type: GettingStarted
    url: https://developers.google.com/workspace/sheets/api/guides/concepts
  - type: APIReference
    url: https://developers.google.com/workspace/sheets/api/reference/rest
  - type: SDKs
    url: https://developers.google.com/workspace/sheets/api/guides/libraries
  - type: ChangeLog
    url: https://developers.google.com/workspace/sheets/release-notes
  - type: CodeExamples
    url: https://developers.google.com/workspace/sheets/api/samples
  - type: RateLimits
    url: https://developers.google.com/workspace/sheets/api/limits
  - type: ErrorCodes
    url: https://developers.google.com/workspace/sheets/api/troubleshoot-api-errors
  - type: JSONSchema
    url: json-schema/google-sheets-spreadsheet-schema.json
  - type: JSONLD
    url: json-ld/google-sheets-context.jsonld
- aid: google-sheets:google-sheets-sheets-api
  name: Google Sheets Sheets API
  description: Operations on individual sheets within a spreadsheet
  humanURL: https://developers.google.com/sheets/api
  baseURL: https://sheets.googleapis.com/v4
  tags:
  - Sheets
  properties:
  - type: OpenAPI
    url: openapi/google-sheets-sheets-api-openapi.yml
  - type: Documentation
    url: https://developers.google.com/sheets/api/reference/rest
  - type: Authentication
    url: https://developers.google.com/sheets/api/guides/authorizing
  - type: GettingStarted
    url: https://developers.google.com/sheets/api/quickstart/python
  - type: GettingStarted
    url: https://developers.google.com/workspace/sheets/api/guides/concepts
  - type: APIReference
    url: https://developers.google.com/workspace/sheets/api/reference/rest
  - type: SDKs
    url: https://developers.google.com/workspace/sheets/api/guides/libraries
  - type: ChangeLog
    url: https://developers.google.com/workspace/sheets/release-notes
  - type: CodeExamples
    url: https://developers.google.com/workspace/sheets/api/samples
  - type: RateLimits
    url: https://developers.google.com/workspace/sheets/api/limits
  - type: ErrorCodes
    url: https://developers.google.com/workspace/sheets/api/troubleshoot-api-errors
  - type: JSONSchema
    url: json-schema/google-sheets-spreadsheet-schema.json
  - type: JSONLD
    url: json-ld/google-sheets-context.jsonld
- aid: google-sheets:google-sheets-spreadsheets-api
  name: Google Sheets Spreadsheets API
  description: Operations on spreadsheet resources
  humanURL: https://developers.google.com/sheets/api
  baseURL: https://sheets.googleapis.com/v4
  tags:
  - Spreadsheets
  properties:
  - type: OpenAPI
    url: openapi/google-sheets-spreadsheets-api-openapi.yml
  - type: Documentation
    url: https://developers.google.com/sheets/api/reference/rest
  - type: Authentication
    url: https://developers.google.com/sheets/api/guides/authorizing
  - type: GettingStarted
    url: https://developers.google.com/sheets/api/quickstart/python
  - type: GettingStarted
    url: https://developers.google.com/workspace/sheets/api/guides/concepts
  - type: APIReference
    url: https://developers.google.com/workspace/sheets/api/reference/rest
  - type: SDKs
    url: https://developers.google.com/workspace/sheets/api/guides/libraries
  - type: ChangeLog
    url: https://developers.google.com/workspace/sheets/release-notes
  - type: CodeExamples
    url: https://developers.google.com/workspace/sheets/api/samples
  - type: RateLimits
    url: https://developers.google.com/workspace/sheets/api/limits
  - type: ErrorCodes
    url: https://developers.google.com/workspace/sheets/api/troubleshoot-api-errors
  - type: JSONSchema
    url: json-schema/google-sheets-spreadsheet-schema.json
  - type: JSONLD
    url: json-ld/google-sheets-context.jsonld
- aid: google-sheets:google-sheets-values-api
  name: Google Sheets Values API
  description: Operations on spreadsheet cell values
  humanURL: https://developers.google.com/sheets/api
  baseURL: https://sheets.googleapis.com/v4
  tags:
  - Values
  properties:
  - type: OpenAPI
    url: openapi/google-sheets-values-api-openapi.yml
  - type: Documentation
    url: https://developers.google.com/sheets/api/reference/rest
  - type: Authentication
    url: https://developers.google.com/sheets/api/guides/authorizing
  - type: GettingStarted
    url: https://developers.google.com/sheets/api/quickstart/python
  - type: GettingStarted
    url: https://developers.google.com/workspace/sheets/api/guides/concepts
  - type: APIReference
    url: https://developers.google.com/workspace/sheets/api/reference/rest
  - type: SDKs
    url: https://developers.google.com/workspace/sheets/api/guides/libraries
  - type: ChangeLog
    url: https://developers.google.com/workspace/sheets/release-notes
  - type: CodeExamples
    url: https://developers.google.com/workspace/sheets/api/samples
  - type: RateLimits
    url: https://developers.google.com/workspace/sheets/api/limits
  - type: ErrorCodes
    url: https://developers.google.com/workspace/sheets/api/troubleshoot-api-errors
  - type: JSONSchema
    url: json-schema/google-sheets-spreadsheet-schema.json
  - type: JSONLD
    url: json-ld/google-sheets-context.jsonld
maintainers:
- name: Kin Lane
  email: kin@apievangelist.com
  url: https://apievangelist.com
common:
- type: AgenticAccess
  url: agentic-access/google-sheets-agentic-access.yml
- type: VulnerabilityDisclosure
  url: security/google-sheets-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/google-sheets-domain-security.yml
- type: Authentication
  url: authentication/google-sheets-authentication.yml
- type: OAuthScopes
  url: scopes/google-sheets-scopes.yml
- type: Packages
  url: packages/google-sheets-packages.yml
- type: WellKnown
  url: well-known/google-sheets-well-known.yml
- type: MCPServer
  url: mcp/google-sheets-mcp.yml
- type: LLMsTxt
  url: llms/google-sheets-llms.txt
- type: Overlay
  url: overlays/google-sheets-openapi-overlay.yaml
- type: Conformance
  url: conformance/google-sheets-conformance.yml
- type: ErrorCatalog
  url: errors/google-sheets-problem-types.yml
- type: Lifecycle
  url: lifecycle/google-sheets-lifecycle.yml
- type: Conventions
  url: conventions/google-sheets-conventions.yml
- type: ChangeLog
  url: changelog/google-sheets-changelog.yml
- type: DataModel
  url: data-model/google-sheets-data-model.yml
- type: PostmanWorkspace
  url: https://www.postman.com/kinlaneapi/google-sheets/overview
- type: Arazzo
  url: arazzo/google-sheets-append-and-format-header-workflow.yml
  name: Google Sheets Append Rows and Format the Header
- type: Arazzo
  url: arazzo/google-sheets-archive-and-clear-multiple-ranges-workflow.yml
  name: Google Sheets Archive and Clear Multiple Ranges
- type: Arazzo
  url: arazzo/google-sheets-bulk-load-multiple-ranges-workflow.yml
  name: Google Sheets Bulk Load Multiple Ranges
- type: Arazzo
  url: arazzo/google-sheets-copy-sheet-between-spreadsheets-workflow.yml
  name: Google Sheets Copy a Sheet Between Spreadsheets
- type: Arazzo
  url: arazzo/google-sheets-create-and-seed-spreadsheet-workflow.yml
  name: Google Sheets Create and Seed a Spreadsheet
- type: Arazzo
  url: arazzo/google-sheets-create-with-extra-sheet-and-write-workflow.yml
  name: Google Sheets Create With an Extra Sheet and Write
- type: Arazzo
  url: arazzo/google-sheets-create-write-and-verify-workflow.yml
  name: Google Sheets Create, Write, and Verify
- type: Arazzo
  url: arazzo/google-sheets-overwrite-or-append-rows-workflow.yml
  name: Google Sheets Overwrite or Append Rows
- type: Arazzo
  url: arazzo/google-sheets-refresh-range-workflow.yml
  name: Google Sheets Refresh a Range
- type: Arazzo
  url: arazzo/google-sheets-seed-if-empty-workflow.yml
  name: Google Sheets Seed a Range Only If Empty
- type: Arazzo
  url: arazzo/google-sheets-tag-and-find-developer-metadata-workflow.yml
  name: Google Sheets Tag and Find a Spreadsheet With Developer Metadata
- type: Arazzo
  url: arazzo/google-sheets-update-and-read-by-data-filter-workflow.yml
  name: Google Sheets Update and Read Values by Data Filter
- type: Portal
  url: https://developers.google.com/workspace/sheets/api
- type: Documentation
  url: https://developers.google.com/workspace/sheets/api/reference/rest
- type: Blog
  url: https://workspace.google.com/blog/developers-practitioners
- type: GitHubOrganization
  url: https://github.com/googleapis
- type: Support
  url: https://developers.google.com/sheets/api/support
- type: StatusPage
  url: https://www.google.com/appsstatus/dashboard/
- type: TermsOfService
  url: https://developers.google.com/terms
- type: PrivacyPolicy
  url: https://policies.google.com/privacy
- type: Signup
  url: https://console.cloud.google.com/
- type: Login
  url: https://console.cloud.google.com/
- type: StackOverflow
  url: https://stackoverflow.com/questions/tagged/google-sheets-api
- type: YouTube
  url: https://developers.google.com/workspace/sheets/api/videos
- type: GettingStarted
  url: https://developers.google.com/workspace/sheets/api/guides/concepts
- type: Authentication
  url: https://developers.google.com/sheets/api/guides/authorizing
- type: SDKs
  url: https://developers.google.com/workspace/sheets/api/guides/libraries
- type: ReleaseNotes
  url: https://developers.google.com/workspace/sheets/release-notes
- type: Pricing
  url: https://developers.google.com/workspace/sheets/api/limits
- type: RateLimits
  url: https://developers.google.com/workspace/sheets/api/limits
- type: SpectralRules
  url: rules/google-sheets-spectral-rules.yml
- type: Features
  data:
  - name: Spreadsheet Management
    description: Create, read, update, and delete spreadsheets programmatically with full control over properties and metadata.
  - name: Cell Value Operations
    description: Read and write individual cell values, ranges, and batch operations across multiple ranges.
  - name: Formatting
    description: Apply rich formatting to cells including fonts, colors, borders, alignment, and number formats.
  - name: Sheet Management
    description: Add, remove, copy, and configure individual sheets within a spreadsheet.
  - name: Developer Metadata
    description: Attach custom metadata to spreadsheets, sheets, rows, and columns for application-specific data.
  - name: Data Validation
    description: Set validation rules on cells to enforce data quality and consistency.
  - name: Conditional Formatting
    description: Apply conditional formatting rules based on cell values and formulas.
  - name: Charts and Graphs
    description: Create and manage embedded charts within spreadsheets.
  - name: Named Ranges
    description: Define and manage named ranges for easier formula references.
  - name: Batch Operations
    description: Execute multiple read and write operations in a single API call for efficiency.
- type: UseCases
  data:
  - name: Data Collection and Reporting
    description: Collect data from various sources and generate automated reports in Google Sheets.
  - name: Database Backend
    description: Use Google Sheets as a lightweight database for web applications and prototypes.
  - name: Workflow Automation
    description: Automate data entry, processing, and distribution workflows using the API.
  - name: Data Integration
    description: Synchronize data between Google Sheets and other business applications.
  - name: Dashboard Creation
    description: Build interactive dashboards and visualizations from spreadsheet data.
- type: Integrations
  data:
  - name: Google Workspace
    description: Deep integration with Google Docs, Slides, Forms, and other Workspace applications.
  - name: Google Apps Script
    description: Extend Sheets functionality with custom functions, menus, and automation scripts.
  - name: Google Cloud Platform
    description: Connect to BigQuery, Cloud Functions, and other GCP services for advanced data processing.
  - name: Zapier
    description: Connect Google Sheets to thousands of apps through Zapier automation workflows.
  - name: Slack
    description: Send notifications and updates to Slack channels based on spreadsheet changes.
tags:
- Google Workspace
- Productivity
- Spreadsheets