Google Sheets API for AI Agents and Apps - PasteSheet

docs.google.com → /api

Your Google Sheet is now a<br>live API

Paste a Google Sheet URL and get clean, cached JSON in seconds — for your app, your no-code tool, or your AI agent. No login, no code, no Google Cloud project.

Generate API<br>Fetching…

Free forever tier · no credit card · live in under a minute

team.xlsx

name<br>role<br>status

Ada Lovelace<br>Engineer<br>active

Grace Hopper<br>Admiral<br>active

Alan Turing<br>Researcher<br>active

GET

https://pastesheet.com/api/your-endpoint-id

table<br>json

copied = false, 1500)" aria-label="Copy JSON">

name<br>role<br>status

Ada Lovelace<br>Engineer<br>active

Grace Hopper<br>Admiral<br>active

Alan Turing<br>Researcher<br>active

"data": [<br>"name": "Ada Lovelace",<br>"role": "Engineer",<br>"status": "active"<br>},<br>"name": "Grace Hopper",<br>"role": "Admiral",<br>"status": "active"<br>},<br>"name": "Alan Turing",<br>"role": "Researcher",<br>"status": "active"<br>],<br>"total": 3,<br>"limit": 10,<br>"offset": 0

200 OK<br>3 rows

One endpoint, every workflow

One URL, however you build — terminal, no-code, or agent.

developers

no-code

ai-builders

terminal

curl<br>js<br>py

copied = false, 1500)" aria-label="Copy snippet">

curl 'https://pastesheet.com/api/your-endpoint-id?limit=10'

copied = false, 1500)" aria-label="Copy snippet">

const res = await fetch('https://pastesheet.com/api/your-endpoint-id?limit=10');<br>const { data } = await res.json();

copied = false, 1500)" aria-label="Copy snippet">

import requests<br>res = requests.get('https://pastesheet.com/api/your-endpoint-id', params={'limit': 10})<br>data = res.json()['data']

Paste this endpoint into Softr, Framer, Webflow, Zapier, Make — anything that reads JSON.

https://pastesheet.com/api/your-endpoint-id

copied = false, 1500)" aria-label="Copy endpoint URL">

~/.cursor/mcp.json

copied = false, 1500)" aria-label="Copy MCP config">

"mcpServers": {<br>"pastesheet": {<br>"url": "https://pastesheet.com/mcp/sheets/your-endpoint-id"

Drop into Claude, Cursor, or any MCP client.

People build:<br>a Next.js data source<br>a Webflow site<br>an AI agent data source<br>a headless CMS

All use cases

Private endpoints

Keys hashed · SHA-256

Edge-cached responses

Reads anywhere JSON does —<br>Next.js · React · Vue · Notion · Zapier · iOS

A spreadsheet in.<br>A real API out.

Everything you’d stand up a backend for — without standing up a backend.

Filter, sort & paginate

Query any column with plain URL params — no query language to learn.

?status=active<br>→ 128

Edge cached

Configurable TTL, served fast.

12ms

MCP for AI agents

Every endpoint is also a tool your agent can call.

How many users are active?

query_rows<br>→ 128 active

See all features

Three steps to a live endpoint

01

Paste your sheet URL

Any public Google Sheet. We read tabs, headers, and rows instantly.

docs.google.com/…/edit

02

Get a cached endpoint

We mint a permanent API URL backed by an edge cache you control.

GET /api/your-endpoint-id

03

Query from anywhere

Your app, a no-code tool, or an AI agent — filtered and paginated.

?status=active&limit=10

Google Sheet

PasteSheet cache

Your app / Claude

Your spreadsheet, ready for agents

Connect an endpoint and it becomes a Model Context Protocol server — no Google Cloud project, no OAuth to configure. Claude, Cursor, and ChatGPT query your sheet as a native, read-only tool: safe to hand over, it reads every row but can change none.

list_tabs<br>get_schema<br>query_rows

Read the Google Sheets MCP guide

this.copied = false, 2000);<br>} catch {<br>this.failed = true;<br>setTimeout(() => this.failed = false, 2000);<br>},<br>}"<br>class="flex flex-wrap items-center gap-2 -ml-2"

Copy as Markdown

Copied

Copy failed

View as .md

claude · pastesheet

Which engineers are active this quarter?

called query_rows

{ "role": "Engineer", "status": "active" }

3 engineers are active: Ada, Grace, and Alan.

Publish a sheet — don’t wire up an account

Google’s own MCP and tools like Zapier connect your account to your agent. PasteSheet publishes a sheet so anyone’s app, site, or agent can read it — no Google Cloud project, read-only by design.

Connect

Google · Zapier · Composio

Wires your Google account to your own assistant

Needs a Google Cloud project, OAuth client, or service account

Read-write — an agent can overwrite your source of truth

Cell/range access in A1 notation, not a query API

Publish

PasteSheet

Turns a sheet into an endpoint any app, site, or agent can read

Just paste a share URL — no Google Cloud, no OAuth to configure

Read-only by design — safe to embed publicly or hand to an agent

A typed query engine — filter, search, sort, aggregate

PasteSheet vs Google’s official MCP

Switching from something else?<br>SheetDB,<br>Composio,<br>and<br>Airtable<br>alternatives.

Start free. Scale when you need to.

A free tier with real headroom, and paid plans that grow with your traffic. No contracts.

Free

For side projects and trying things out.

$0<br>/mo

Endpoints

Requests / mo<br>2,000

Row cap<br>500

Private endpoints & keys

AI column mapping

Full-text...