Does Google Sheets have an API?
Yes — but "the Google Sheets API" and "a REST API for my sheet" are not quite the same thing. Here is what Google provides and what you probably actually want.
Last updated
Key facts
- Yes. Google publishes the Sheets API v4. It reads and writes cells and ranges, and it requires a Google Cloud project plus OAuth or a service account. source
-
The Google Sheets API allows 300 read requests per minute per project and 60 per minute per user. Past that it returns
429 RESOURCE_EXHAUSTED. source - Google states that all standard use of the Sheets API is available at no additional cost — though it has said exceeding the quota is planned to incur Google Cloud charges later in 2026. source
Does Google Sheets have an API?
Yes. Google publishes the Google Sheets API (v4), and it is free to use. But it is low-level: it reads and writes cells and ranges rather than records, it requires a Google Cloud project plus OAuth or a service account, and you have to reassemble the response into rows yourself.
So the honest answer is "yes, but probably not the one you want." It is an excellent API for building an integration with Sheets. It is heavy for the far more common job of "just give me my rows as JSON," which is what most people are actually asking for.
Google's API also meters you: 300 read requests per minute per project, and 60 per minute per user, after which it returns a 429 (published usage limits). A cached endpoint in front of the sheet sidesteps that entirely.
What most people want
Usually the goal is simpler: a URL that returns each row as a typed JSON object, with filtering and sorting. That is exactly what PasteSheet generates — no Cloud project, no code. Paste the sheet, get an endpoint. See using Google Sheets as a REST API for the full parameter set.
The same connection also works for AI agents: your sheet becomes an MCP server that Claude, Cursor, and ChatGPT can query. For the full picture — the response shape, the query parameters, and how the three approaches compare — see using Google Sheets as a REST API.
Frequently asked questions
Does Google Sheets have an official API?
Yes, the Google Sheets API (v4) reads and writes cells and ranges, but it requires OAuth or a service account and code to use.
Is there a simpler REST API for a sheet?
Yes. PasteSheet turns a sheet into a row-oriented JSON REST API from a pasted URL, with filtering, sorting, and pagination built in.
Can AI tools use the Google Sheets API?
They can, but it is simpler to expose the sheet as an MCP server. PasteSheet does this so Claude, Cursor, and ChatGPT can query it directly.
Sources
- Usage limits — Google Sheets API — Google
Related guides
Turn Google Sheets Into a REST API (No Code)
Turn a public or restricted Google Sheet into a live JSON REST API with filtering, sorting, and pagination — no backend, no code.
Google Sheets API Pricing: Is It Free?
Google Sheets API pricing, straight: standard use costs nothing, but quotas and setup do. What is actually free, what is capped, and where the real cost lands.
Google Sheets MCP Server for Claude & ChatGPT
Turn any public or private Google Sheet into an MCP server so Claude, Cursor, and ChatGPT can read and query it in plain English. No code, no backend.
Turn your sheet into an API in minutes
Paste a Google Sheet URL and get a live REST API and MCP server — no backend, no code, free to start.