Google Sheets
API for reading, writing, and formatting data in Google Sheets.
Reference-quality API operations across every facet — a rich contract, published governance, transparent operations, and machine-readable commercial terms.
API Evangelist profiles Google Sheets the way a machine reads it — 309 machine-readable artifacts across 5 APIs, pulled from the provider's own public surface and indexed so a developer, an analyst, or an AI agent can evaluate it against every other provider on the network.
Every provider in the network is reduced to the same set of machine-readable artifacts — OpenAPI contracts, event specifications, GraphQL schemas, runnable collections, pricing and rate-limit signals, security posture, OAuth scopes, and the agent surfaces (MCP servers and skills) that let software drive the API on its own. We profile them because the interface is the part of a company you can actually inspect: it is a truer signal of what a provider does than any marketing page. From those artifacts we compute the Kin Score — Google Sheets scores 71.9/100 (exemplar), with a separate agent-readiness read of 71/100 (agent native). The full breakdown is below, followed by every artifact we hold — each card links through to its machine-readable definition on apis.io.
Kin Score
This is the API Evangelist rating — a single, repeatable read computed from the artifacts on this page. Green fill is points earned; the red track is points possible, so every bar shows earned-versus-possible at a glance.
Kin Score
How this is scored →scored 2026-07-27 · rubric v0.5
How we profile Google Sheets
Each block below is one kind of artifact we hold for Google Sheets. For each we say what it is and why it earns a place in the profile, then list every one we've indexed — capped at two rows, scroll within the panel for the rest.
APIs 5
Each API is captured as its own OpenAPI definition — every operation, parameter, and response. This is the single most useful machine-readable description of what an API does, and it's what lets us score, lint, mock, and generate against it without asking the provider for anything.
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
A runnable collection turns the contract into something a developer can execute in seconds. We profile them because the fastest way to trust an API is to make a real call against it.
Ready-to-run Postman collections for exercising this provider's APIs.
Google Sheets API
POSTMANOpen Collections 1
Open, tool-agnostic collections carry the same runnable value as Postman without locking you to one client — the portable, forkable form of the same exercise.
Open, tool-agnostic API collections (OpenAPI-derived and Bruno).
Google Sheets API
OPEN COLLECTIONArazzo Workflows 12
Real integrations are rarely a single call. Arazzo describes the multi-step sequences — auth, then create, then confirm — so both a human and an agent can follow the choreography, not just the endpoints.
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.
ARAZZOGoogle 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.
ARAZZOGoogle Sheets Bulk Load Multiple Ranges
Create a spreadsheet, write several ranges in one batch, then read them all back in one batch.
ARAZZOGoogle Sheets Copy a Sheet Between Spreadsheets
Read a source spreadsheet, copy one of its sheets into a destination spreadsheet, then confirm the destination.
ARAZZOGoogle Sheets Create and Seed a Spreadsheet
Create a new spreadsheet, append seed rows to it, then read them back.
ARAZZOGoogle Sheets Create With an Extra Sheet and Write
Create a spreadsheet, add a second named sheet to it, then write values into that sheet.
ARAZZOGoogle Sheets Create, Write, and Verify
Create a spreadsheet, write values into a range, then read the range back to verify the write.
ARAZZOGoogle Sheets Overwrite or Append Rows
Inspect a range and branch — overwrite it in place when it already has data, otherwise append fresh rows.
ARAZZOGoogle Sheets Refresh a Range
Read the current values of a range, clear it, then write a fresh set of values into it.
ARAZZOGoogle Sheets Seed a Range Only If Empty
Read a range and branch — write seed values only when the range has no existing data.
ARAZZOGoogle 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.
ARAZZOGoogle 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.
ARAZZOScroll within the panel for all 12 ·
MCP Servers 1
Model Context Protocol servers expose these APIs directly to AI agents. We profile them because agent-native access is the fastest-growing way this provider's capabilities actually get used.
Model Context Protocol servers that expose these APIs to AI agents.
google-sheets-mcp.yml
MCP SERVERPricing Plans 1
Pricing is part of the interface. Machine-readable plans tell you what a tier costs and includes before you commit — one of the six things the Kin Score reads for commercial clarity.
Published pricing tiers and plan structures.
Rate Limits 1
Rate limits are the difference between a demo that works and a production integration that doesn't fall over. Publishing them is an operational-transparency signal — and a hard requirement for any agent that plans its own throughput.
Documented rate limits and quota policies.
Google Sheets Rate Limits
RATE LIMITSFinOps 1
Cost, billing, and metering signals let a buyer model the financial operations of an API before it's live. We profile them for the same reason we profile pricing: the money is part of the contract.
Cost, billing, and metering signals for API financial operations.
Google Sheets Finops
FINOPSFeatures 10
The notable capabilities this provider advertises, captured as structured features so they can be searched and compared instead of read one landing page at a time.
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 within the panel for all 10 ·
Semantic Vocabularies 1
JSON-LD contexts give the data shared meaning across APIs. We profile them because semantics are what let a machine reconcile 'customer' here with 'customer' somewhere else.
JSON-LD contexts and semantic vocabularies used across these APIs.
Google Sheets Context
JSON-LDSpectral Rules 2
Governance rulesets we run against this provider's specs — the automated checks behind parts of the score. Profiling them makes the quality bar explicit and re-runnable, not a matter of opinion.
Google Sheets API Rules
SPECTRALGoogle Sheets API Rules
SPECTRALJSON Schema 86
Standalone JSON Schema definitions describe the data models behind the API. We profile them so the shapes are validatable on their own — useful long after a single request is forgotten.
Standalone JSON Schema definitions for this provider's data models.
AppendValuesResponse
JSON SCHEMABandedRange
JSON SCHEMABandingProperties
JSON SCHEMABasicFilter
JSON SCHEMABatchClearValuesByDataFilterResponse
JSON SCHEMABatchClearValuesResponse
JSON SCHEMABatchGetValuesByDataFilterResponse
JSON SCHEMABatchGetValuesResponse
JSON SCHEMABatchUpdateSpreadsheetRequest
JSON SCHEMABatchUpdateSpreadsheetResponse
JSON SCHEMABatchUpdateValuesByDataFilterResponse
JSON SCHEMABatchUpdateValuesRequest
JSON SCHEMABatchUpdateValuesResponse
JSON SCHEMABigQueryDataSourceSpec
JSON SCHEMABooleanCondition
JSON SCHEMABorder
JSON SCHEMABorders
JSON SCHEMACellData
JSON SCHEMACellFormat
JSON SCHEMAClearValuesResponse
JSON SCHEMAColor
JSON SCHEMAColorStyle
JSON SCHEMAConditionValue
JSON SCHEMAConditionalFormatRule
JSON SCHEMADataExecutionStatus
JSON SCHEMADataFilter
JSON SCHEMADataFilterValueRange
JSON SCHEMADataSourceColumnReference
JSON SCHEMADataSourceColumn
JSON SCHEMADataSourceFormula
JSON SCHEMADataSourceParameter
JSON SCHEMADataSourceRefreshSchedule
JSON SCHEMADataSource
JSON SCHEMADataSourceSheetProperties
JSON SCHEMADataSourceSpec
JSON SCHEMADataSourceTable
JSON SCHEMADataValidationRule
JSON SCHEMADateTimeRenderOption
JSON SCHEMADeveloperMetadataLocation
JSON SCHEMADeveloperMetadataLookup
JSON SCHEMADeveloperMetadata
JSON SCHEMADimensionProperties
JSON SCHEMADimensionRange
JSON SCHEMADimension
JSON SCHEMAEmbeddedChart
JSON SCHEMAEmbeddedObjectPosition
JSON SCHEMAErrorResponse
JSON SCHEMAErrorValue
JSON SCHEMAExtendedValue
JSON SCHEMAFilterCriteria
JSON SCHEMAFilterSpec
JSON SCHEMAFilterView
JSON SCHEMAGridCoordinate
JSON SCHEMAGridData
JSON SCHEMAGridProperties
JSON SCHEMAGridRange
JSON SCHEMAInterpolationPoint
JSON SCHEMAIterativeCalculationSettings
JSON SCHEMALink
JSON SCHEMANamedRange
JSON SCHEMANumberFormat
JSON SCHEMAPadding
JSON SCHEMAPivotFilterCriteria
JSON SCHEMAPivotFilterSpec
JSON SCHEMAPivotGroupLimit
JSON SCHEMAPivotGroupRule
JSON SCHEMAPivotGroup
JSON SCHEMAPivotGroupSortValueBucket
JSON SCHEMAPivotTable
JSON SCHEMAPivotValue
JSON SCHEMAProtectedRange
JSON SCHEMARowData
JSON SCHEMASheetProperties
JSON SCHEMASheet
JSON SCHEMASlicer
JSON SCHEMASortSpec
JSON SCHEMASpreadsheetProperties
JSON SCHEMASpreadsheet
JSON SCHEMASpreadsheetTheme
JSON SCHEMATextFormatRun
JSON SCHEMATextFormat
JSON SCHEMATextRotation
JSON SCHEMAUpdateValuesResponse
JSON SCHEMAValueInputOption
JSON SCHEMAValueRange
JSON SCHEMAValueRenderOption
JSON SCHEMAScroll within the panel for all 86 ·
JSON Structure 86
JSON Structure captures the data shapes in a form built for tooling — a complement to JSON Schema that keeps the model machine-legible.
JSON Structure definitions describing this provider's data shapes.
Google Sheets Append Values Response Structure
JSON STRUCTUREGoogle Sheets Banded Range Structure
JSON STRUCTUREGoogle Sheets Banding Properties Structure
JSON STRUCTUREGoogle Sheets Basic Filter Structure
JSON STRUCTUREGoogle Sheets Batch Clear Values Response Structure
JSON STRUCTUREGoogle Sheets Batch Get Values Response Structure
JSON STRUCTUREGoogle Sheets Batch Update Spreadsheet Request Structure
JSON STRUCTUREGoogle Sheets Batch Update Values Request Structure
JSON STRUCTUREGoogle Sheets Batch Update Values Response Structure
JSON STRUCTUREGoogle Sheets Big Query Data Source Spec Structure
JSON STRUCTUREGoogle Sheets Boolean Condition Structure
JSON STRUCTUREGoogle Sheets Border Structure
JSON STRUCTUREGoogle Sheets Borders Structure
JSON STRUCTUREGoogle Sheets Cell Data Structure
JSON STRUCTUREGoogle Sheets Cell Format Structure
JSON STRUCTUREGoogle Sheets Clear Values Response Structure
JSON STRUCTUREGoogle Sheets Color Structure
JSON STRUCTUREGoogle Sheets Color Style Structure
JSON STRUCTUREGoogle Sheets Condition Value Structure
JSON STRUCTUREGoogle Sheets Conditional Format Rule Structure
JSON STRUCTUREGoogle Sheets Data Execution Status Structure
JSON STRUCTUREGoogle Sheets Data Filter Structure
JSON STRUCTUREGoogle Sheets Data Filter Value Range Structure
JSON STRUCTUREGoogle Sheets Data Source Column Reference Structure
JSON STRUCTUREGoogle Sheets Data Source Column Structure
JSON STRUCTUREGoogle Sheets Data Source Formula Structure
JSON STRUCTUREGoogle Sheets Data Source Parameter Structure
JSON STRUCTUREGoogle Sheets Data Source Refresh Schedule Structure
JSON STRUCTUREGoogle Sheets Data Source Sheet Properties Structure
JSON STRUCTUREGoogle Sheets Data Source Spec Structure
JSON STRUCTUREGoogle Sheets Data Source Structure
JSON STRUCTUREGoogle Sheets Data Source Table Structure
JSON STRUCTUREGoogle Sheets Data Validation Rule Structure
JSON STRUCTUREGoogle Sheets Date Time Render Option Structure
JSON STRUCTUREGoogle Sheets Developer Metadata Location Structure
JSON STRUCTUREGoogle Sheets Developer Metadata Lookup Structure
JSON STRUCTUREGoogle Sheets Developer Metadata Structure
JSON STRUCTUREGoogle Sheets Dimension Properties Structure
JSON STRUCTUREGoogle Sheets Dimension Range Structure
JSON STRUCTUREGoogle Sheets Dimension Structure
JSON STRUCTUREGoogle Sheets Embedded Chart Structure
JSON STRUCTUREGoogle Sheets Embedded Object Position Structure
JSON STRUCTUREGoogle Sheets Error Response Structure
JSON STRUCTUREGoogle Sheets Error Value Structure
JSON STRUCTUREGoogle Sheets Extended Value Structure
JSON STRUCTUREGoogle Sheets Filter Criteria Structure
JSON STRUCTUREGoogle Sheets Filter Spec Structure
JSON STRUCTUREGoogle Sheets Filter View Structure
JSON STRUCTUREGoogle Sheets Grid Coordinate Structure
JSON STRUCTUREGoogle Sheets Grid Data Structure
JSON STRUCTUREGoogle Sheets Grid Properties Structure
JSON STRUCTUREGoogle Sheets Grid Range Structure
JSON STRUCTUREGoogle Sheets Interpolation Point Structure
JSON STRUCTUREGoogle Sheets Iterative Calculation Settings Structure
JSON STRUCTUREGoogle Sheets Link Structure
JSON STRUCTUREGoogle Sheets Named Range Structure
JSON STRUCTUREGoogle Sheets Number Format Structure
JSON STRUCTUREGoogle Sheets Padding Structure
JSON STRUCTUREGoogle Sheets Pivot Filter Criteria Structure
JSON STRUCTUREGoogle Sheets Pivot Filter Spec Structure
JSON STRUCTUREGoogle Sheets Pivot Group Limit Structure
JSON STRUCTUREGoogle Sheets Pivot Group Rule Structure
JSON STRUCTUREGoogle Sheets Pivot Group Sort Value Bucket Structure
JSON STRUCTUREGoogle Sheets Pivot Group Structure
JSON STRUCTUREGoogle Sheets Pivot Table Structure
JSON STRUCTUREGoogle Sheets Pivot Value Structure
JSON STRUCTUREGoogle Sheets Protected Range Structure
JSON STRUCTUREGoogle Sheets Row Data Structure
JSON STRUCTUREGoogle Sheets Sheet Properties Structure
JSON STRUCTUREGoogle Sheets Sheet Structure
JSON STRUCTUREGoogle Sheets Slicer Structure
JSON STRUCTUREGoogle Sheets Sort Spec Structure
JSON STRUCTUREGoogle Sheets Spreadsheet Properties Structure
JSON STRUCTUREGoogle Sheets Spreadsheet Structure
JSON STRUCTUREGoogle Sheets Spreadsheet Theme Structure
JSON STRUCTUREGoogle Sheets Text Format Run Structure
JSON STRUCTUREGoogle Sheets Text Format Structure
JSON STRUCTUREGoogle Sheets Text Rotation Structure
JSON STRUCTUREGoogle Sheets Update Values Response Structure
JSON STRUCTUREGoogle Sheets Value Input Option Structure
JSON STRUCTUREGoogle Sheets Value Range Structure
JSON STRUCTUREGoogle Sheets Value Render Option Structure
JSON STRUCTUREScroll within the panel for all 86 ·
Examples 86
Real request and response payloads are what turn a spec from abstract into obvious — and they're one of the twelve things an agent needs to call an API correctly on the first try.
Example request and response payloads for these APIs.
Google Sheets Border Example
EXAMPLEGoogle Sheets Color Example
EXAMPLEGoogle Sheets Link Example
EXAMPLEGoogle Sheets Sheet Example
EXAMPLEGoogle Sheets Slicer Example
EXAMPLEScroll within the panel for all 86 ·
Security Posture 3
Authentication, domain security, vulnerability disclosure, and trust-center signals — the evidence that a provider takes security seriously enough to document it. We profile it because you can't govern what you can't see.
Authentication, domain security, vulnerability disclosure, and trust-center signals.
Scopes 1
OAuth scopes are the vocabulary of least-privilege access. Profiling them shows exactly what an integration — or an agent acting on a user's behalf — is allowed to do.
OAuth scopes governing access to this provider's APIs.
Agentic Access 1
An x-agentic-access contract marks which operations are safe for an agent to run on its own and which need a human in the loop. It is the difference between an API an agent can use and one it can use safely.
Recommended x-agentic-access execution contracts for AI agents.
Use Cases 5
What developers actually build with this provider — captured so the catalogue answers 'what is this for', not just 'what does this expose'.
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 tell you where this provider already fits in a stack.
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
Every other property we hold for Google Sheets — documentation, portals, status pages, policies, and corporate surface — grouped by the job it does, following the integrator's arc from getting started to running in production.
Get Started 4
Portal, sign-up, and the first successful call
Documentation 1
Reference material describing how the API behaves
Agent Surfaces 4
MCP servers, agent skills, and machine-readable catalogs
Design & Contract 18
Pagination, idempotency, versioning, errors, and events
Scroll within the panel for all 18 ·
Build 4
SDKs, sample code, and the tooling you integrate with
Access & Security 5
Authentication, authorization, and security posture
Learn 1
Tutorials, courses, talks, and written guidance
Operate 6
Status, limits, changes, and where to get help
Commercial 3
Pricing, plans, and the legal terms of use
Company 1
The organization behind the API
Other 1
Properties that don't map to a standard resource type
← All providers · Data indexed from github.com/api-evangelist/google-sheets · machine-readable index on apis.io