At my day job we kept our FAQ in a Google Sheet so non-technical teammates could edit it without touching code. A third-party service turned that sheet into an API the website could read. It worked until the FAQ page started showing up blank. No error, no warning, just an empty page. The service's free tier had a low monthly request cap, and ordinary traffic had quietly used it up.
My fix was not a good one. I made three more accounts on the same service and rotated them by hand, so we never leaned on any one account long enough to hit its limit. Two simple sheets now needed four juggled logins just to stay online.
That is the problem PasteSheet exists to solve. You paste a Google Sheet URL and it gives you a reliable, cached API for that sheet. This post is about a newer part of it: the MCP server, which lets an AI agent like Claude read your sheet directly. If you have ever wanted Claude or Cursor to answer questions straight from your own spreadsheet, this is how you do it.
What an MCP server actually is
MCP, the Model Context Protocol, is the standard way AI clients like Claude and Cursor connect to outside data. An MCP server hands the AI a set of tools it can call. The AI decides when to use them and what to do with the results.
A "Google Sheets MCP server" is simply a server that gives the AI tools for reading one spreadsheet. PasteSheet builds and hosts that server for you. You paste a share URL, and any MCP-compatible client can connect to it. There is no Google Cloud project, no OAuth consent screen, and no service-account file to set up.
Publish a sheet, don't connect your account
Most tools solve this by connecting your entire Google account to the agent, behind OAuth and a Cloud project you have to configure yourself. That hands the agent far more than the one sheet you actually care about. Google's own tooling works this way, and so does Zapier.
PasteSheet does the opposite. You publish a single sheet as its own endpoint, and the agent can read that sheet and nothing else in your Drive. There is also no write path anywhere in the product, so the connection is walks through Desktop, web, Code, and Cursor step by step. Public endpoints need no key. For a private one you pass ?api_key=... in the URL, or send an Authorization: Bearer header.
After that you just ask questions in plain English. Here is a real exchange against a products sheet:
Me: Which rows in my catalog are out of stock and under $50?
Claude: [calls get_schema, sees columns: name, price, stock, category]
[calls query_rows filter stock=0, price<50, sort by price]
4 items: Ceramic Mug ($12), Sticker Pack ($6), Notebook ($18), Cable ($24).
I never told Claude the column names. It read the schema, wrote the query, and answered.
Why it caches, and where that stops
AI agents ask a lot of small questions. To answer one prompt, Claude might list the tabs, read the schema, and then run several filtered queries in a row. If each of those hit Google directly, you would run into Google's limits fast. The Sheets API allows 300 reads per minute per project and only 60 per minute per user, and it returns a 429 error once you cross that line. It is the same kind of silent cap that broke my FAQ page in the first place.
So PasteSheet reads your sheet once and caches the rows. Every tool call after that is served from the cache, which means the agent's tenth query costs Google nothing.
That cache comes with a cost worth being honest about. You choose how long it lasts, from 30 seconds to an hour, and within that window the agent sees the cached copy rather than an edit you made a moment ago. And because everything is read-only, the agent can analyze your sheet but never change it. If you need an agent that writes back to a spreadsheet, this is the wrong tool. If you want a source of truth that agents can read safely, that read-only limit is exactly the , and it is listed in the official MCP Registry as com.pastesheet/google-sheets, so any client that browses the registry can find and connect to it.
I build PasteSheet. Paste a Google Sheet URL and get a cached JSON API plus a read-only MCP server your AI agent can query. Free tier, no credit card, no Google Cloud project.
SOCIAL SHARE CARD GENERATOR