# PasteSheet

> PasteSheet turns any public Google Sheet into a cached JSON REST API and an MCP server, so apps and AI agents can read spreadsheet data without a backend, a Google Cloud project or an API key.

Paste a Google Sheet share URL and PasteSheet infers the column schema, caches the rows and exposes them at a REST endpoint and over MCP. Reads are public by default; private endpoints are authenticated with a per-endpoint API key. It reads published/public sheets only and never writes back to them.

## Product

- [Overview](https://pastesheet.com/index.md): What PasteSheet is, how it works in three steps, and the questions people ask before signing up.
- [Features](https://pastesheet.com/features.md): What PasteSheet does: REST endpoints, MCP servers, caching, schema inference and drift alerts.
- [Pricing](https://pastesheet.com/pricing.md): Plans, limits and prices, including the free tier.
- [About](https://pastesheet.com/about.md): Who builds PasteSheet and why.

## Guides

- [Google Sheets MCP Server: Hosted, No Code](https://pastesheet.com/guides/google-sheets-mcp.md): 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.
- [How to Connect Google Sheets to Claude (MCP)](https://pastesheet.com/guides/google-sheets-mcp-claude.md): Connect a public or private Google Sheet to Claude via MCP. Step-by-step setup for Claude Desktop and Claude web to query spreadsheet rows in plain English.
- [Google Sheets MCP Server for Cursor](https://pastesheet.com/guides/google-sheets-mcp-cursor.md): Add a Google Sheet to Cursor as an MCP server so the editor's AI can query your spreadsheet while you code. No backend — copy one URL and you are connected.
- [Connect Google Sheets to ChatGPT via MCP](https://pastesheet.com/guides/google-sheets-mcp-chatgpt.md): Connect a Google Sheet to ChatGPT using PasteSheet's workspace MCP server and OAuth. Let ChatGPT query your spreadsheet data in plain English, no code required.
- [Google Sheets MCP for Claude Code](https://pastesheet.com/guides/google-sheets-mcp-claude-code.md): Add a Google Sheet to Claude Code as an MCP server with one command. Query spreadsheet data from your terminal-based agent — no backend and no code to write.
- [Connect Google Sheets to Codex via MCP](https://pastesheet.com/guides/google-sheets-mcp-codex.md): Connect a Google Sheet to Codex as a remote MCP server. Add one hosted URL, query rows from the CLI or IDE, and keep the source read-only.
- [Enable a Google Sheets MCP Server in Manus AI](https://pastesheet.com/guides/google-sheets-mcp-manus-ai.md): Enable Google Sheets MCP in Manus AI in two minutes: create a hosted endpoint, add it as a custom MCP connector, and query rows without Google Cloud setup.
- [Does Google Have an Official Sheets MCP Server?](https://pastesheet.com/guides/google-sheets-mcp-vs-google-official.md): Google now offers an official Sheets MCP server in developer preview. Compare its Cloud setup and write access with PasteSheet's read-only endpoint.
- [Google Sheets MCP Without Google Cloud](https://pastesheet.com/guides/google-sheets-mcp-without-google-cloud.md): Connect a public or restricted Google Sheet to Claude or ChatGPT over MCP without your own Cloud project, OAuth client, or service account.
- [Google Sheets MCP vs Zapier & Composio](https://pastesheet.com/guides/google-sheets-mcp-vs-zapier.md): Zapier and Composio give Google Sheets MCP for read-write automation. PasteSheet is a hosted, read-only endpoint from a pasted URL — which to pick, and when.
- [Read-Only Google Sheets MCP for Agents](https://pastesheet.com/guides/read-only-google-sheets-mcp.md): A read-only Google Sheets MCP server is safe to hand an AI agent: it can query, filter, and analyze your data but can never modify the spreadsheet.
- [Turn Google Sheets Into a REST API (No Code)](https://pastesheet.com/guides/google-sheets-rest-api.md): Turn a public or restricted Google Sheet into a live JSON REST API with filtering, sorting, and pagination — no backend, no code.
- [Convert a Google Sheet to a REST API](https://pastesheet.com/guides/convert-google-sheet-to-rest-api.md): A step-by-step guide to converting a Google Sheet into a JSON REST API: share the sheet, paste the URL, and call it with filters, sorting, and paging.
- [Is Google Sheets API Free? Quotas & Real Costs](https://pastesheet.com/guides/is-google-sheets-api-free.md): Google does not bill per request, yet the Sheets API still costs you: Cloud setup, quota walls, and planned overage fees. Here is where the money really goes.
- [Does Google Sheets Have a REST API?](https://pastesheet.com/guides/does-google-sheets-have-an-api.md): Does Google Sheets have an API? Yes — Google's cell-based Sheets API, plus simpler no-code options that expose your sheet as clean JSON in minutes.
- [Google Sheets API Rate Limits & How to Fix 429s](https://pastesheet.com/guides/google-sheets-api-rate-limits.md): Which Google Sheets API quota your app is actually hitting, what the 429 RESOURCE_EXHAUSTED error means, and five fixes ranked by payoff — caching first.
- [Google Sheets API Auth: Key vs OAuth](https://pastesheet.com/guides/google-sheets-api-authentication.md): Choose the right Google Sheets API credential for public data, user-owned sheets, or server automation. Compare API keys, OAuth, and service accounts.
- [How to Cache a Google Sheets JSON API](https://pastesheet.com/guides/google-sheets-json-cache.md): Should you cache a Google Sheets JSON API? How edge caching keeps reads fast, avoids Google's rate limits, and serves your app from a CDN-like layer.
- [How to Use Google Sheets as a Database](https://pastesheet.com/guides/google-sheets-as-a-database.md): Use Google Sheets as a database: query rows over a cached REST API with filters, sorting, and paging — no backend. When it fits, when it doesn't, and how.
- [Google Sheets Database for a Website](https://pastesheet.com/guides/google-sheets-database-for-website.md): Use Google Sheets as a database for your website: serve content, listings, and copy as JSON your pages fetch. Editable by your team, cached, and code-free.
- [Is Google Sheets Good as a Database?](https://pastesheet.com/guides/is-google-sheets-good-for-a-database.md): Is Google Sheets good for a database? An honest look at where a spreadsheet-backed API shines, where it breaks down, and how to use it without regret.
- [How to Query Google Sheets With SQL](https://pastesheet.com/guides/query-google-sheets-with-sql.md): Query Google Sheets like SQL: the built-in QUERY() function for in-sheet queries, and a REST API for SQL-style filtering, sorting, and grouping from your app.
- [Google Sheets Query: Sort & Order By](https://pastesheet.com/guides/google-sheets-query-order-by.md): Sort Google Sheets query results by any column, ascending or descending, including by date. Use the QUERY() function or sort and order URL parameters.
- [Google Sheets Query: Group By & Totals](https://pastesheet.com/guides/google-sheets-query-group-by.md): Group Google Sheets rows and compute totals: count, sum, and average by any column. Use the QUERY() function in-sheet or group_by aggregation over a REST API.
- [Google Sheets Query: Starts With Filter](https://pastesheet.com/guides/google-sheets-query-starts-with.md): Filter Google Sheets rows by a starts-with or partial text match. Use the QUERY() function's STARTS WITH, or the contains and search parameters over a REST API.
- [Build a No-Code App on Google Sheets](https://pastesheet.com/guides/google-sheets-no-code-app.md): Build a no-code app backed by Google Sheets: turn a sheet into a REST API and MCP server, then wire it to your front end, no-code tools, or an AI agent.
- [Connect Google Sheets to Zapier & Make](https://pastesheet.com/guides/google-sheets-api-zapier-make.md): Feed Google Sheets data into Zapier or Make as clean JSON. Expose your sheet as a REST API, then read it from any no-code automation — no add-on.
- [SheetDB Alternative: REST API + Free MCP](https://pastesheet.com/guides/sheetdb-alternative.md): SheetDB turns a Google Sheet into a REST API. PasteSheet does that too — plus a read-only MCP server for AI agents, with MCP included on the free plan.
- [Sheety Alternative: Sheets API + MCP](https://pastesheet.com/guides/sheety-alternative.md): Looking for a Sheety alternative? PasteSheet turns a Google Sheet into a REST API and an MCP server for Claude and ChatGPT, with a bigger free tier.
- [Sheet Best Alternative for Google Sheets](https://pastesheet.com/guides/sheet-best-alternative.md): A Sheet Best alternative that turns a Google Sheet into a REST API and a read-only MCP server for AI agents — with filtering, search, and aggregation.
- [Composio Alternative for Sheets MCP](https://pastesheet.com/guides/composio-alternative.md): A Composio alternative focused on one job: publish a Google Sheet as a read-only MCP server and REST API from a URL — no OAuth, no Google Cloud project.
- [Self-Hosted Google Sheets MCP Alternative](https://pastesheet.com/guides/self-hosted-google-sheets-mcp-alternative.md): A hosted alternative to self-hosted Google Sheets MCP servers: no service account, Docker, or uvx — paste a share URL and get a read-only endpoint.
- [Open Source Google Sheets MCP Servers](https://pastesheet.com/guides/open-source-google-sheets-mcp.md): Comparing open source Google Sheets MCP servers? See what running one really costs in setup and upkeep, and when a hosted read-only endpoint beats it.
- [Airtable Alternative for Google Sheets](https://pastesheet.com/guides/airtable-alternative.md): An Airtable alternative that keeps your data in Google Sheets: get a REST API and an MCP server for AI agents without migrating or paying per seat.
- [Airtable vs Google Sheets for Developers](https://pastesheet.com/guides/airtable-vs-google-sheets.md): Airtable vs Google Sheets, compared on API access, row limits, pricing, and cost. Which one to build on when your app needs to read the data programmatically.
- [Rows Alternative: Google Sheets + MCP](https://pastesheet.com/guides/rows-alternative.md): With Rows winding down in 2026, PasteSheet is a Sheets-first alternative: turn a Google Sheet into a REST API and an MCP server for AI agents in minutes.
- [Baserow Alternative for Google Sheets](https://pastesheet.com/guides/baserow-alternative.md): A Baserow alternative with no database migration or self-hosting: publish an existing Google Sheet as a read-only REST API and MCP server for AI agents.
- [Google Docs MCP Server: The Options](https://pastesheet.com/guides/google-docs-mcp-server.md): Is there an MCP server for Google Docs? What exists today, why Sheets is the structured one, and which tool to reach for depending on your data.
- [Google Sheets MCP Server in Python](https://pastesheet.com/guides/google-sheets-mcp-python.md): Build or connect a Google Sheets MCP server from Python. Compare the DIY route against a hosted endpoint, with working client code for both paths.
- [Google Sheets MCP Server for Windsurf](https://pastesheet.com/guides/google-sheets-mcp-windsurf.md): Add a Google Sheet to Windsurf as an MCP server so Cascade can query your spreadsheet while you code. One URL, no backend, no Google Cloud project.
- [Google Sheets MCP for VS Code & Copilot](https://pastesheet.com/guides/google-sheets-mcp-vscode.md): Connect a Google Sheet to VS Code and GitHub Copilot over MCP. Paste one URL into mcp.json and your editor's agent can query the spreadsheet live.
- [Google Sheets MCP Server for n8n](https://pastesheet.com/guides/google-sheets-mcp-n8n.md): Give an n8n AI agent live access to a Google Sheet over MCP. Read rows, filter, and aggregate inside a workflow without a Google Cloud project.
- [Fix Google Sheets API Quota Exceeded (429)](https://pastesheet.com/guides/google-sheets-api-quota-exceeded.md): Seeing RESOURCE_EXHAUSTED or a 429 from the Google Sheets API? Here is the per-minute quota, why you hit it, and how caching removes it for read-heavy apps.
- [Google Sheets API Without an API Key](https://pastesheet.com/guides/google-sheets-api-without-api-key.md): Read a Google Sheet as JSON with no API key, no OAuth client, and no service account. What is possible keyless, and where the trade-offs actually are.
- [How to Read a Google Sheet in Python](https://pastesheet.com/guides/read-google-sheet-in-python.md): Three ways to read a Google Sheet from Python: gspread, the official API, and a plain HTTP endpoint. Working code and the gotchas for each approach.
- [How to Read a Google Sheet in Laravel](https://pastesheet.com/guides/read-google-sheet-in-laravel.md): Pull Google Sheet rows into Laravel as typed JSON with Http::get and a cache. No Google client library, no service account JSON, no Cloud project.
- [How to Read a Google Sheet in React](https://pastesheet.com/guides/read-google-sheet-in-react.md): Fetch Google Sheet rows into a React app as JSON. Why you cannot safely call Google's API from the browser, and what to do instead. With working code.
- [Sheet2API Alternative With MCP Support](https://pastesheet.com/guides/sheet2api-alternative.md): Comparing Sheet2API and PasteSheet for turning a Google Sheet into an API. Where each one fits, and which adds a built-in MCP server for AI agents.
- [NoCodeAPI Alternative for Google Sheets](https://pastesheet.com/guides/nocodeapi-alternative.md): Comparing NoCodeAPI and PasteSheet for Google Sheets endpoints. One is a multi-service hub, the other is read-optimised with caching and MCP built in.
- [Stein Alternative for Google Sheets APIs](https://pastesheet.com/guides/stein-alternative.md): Comparing Stein (steinhq) and PasteSheet. Stein does read and write; PasteSheet is read-only, cached, and doubles as an MCP server for AI agents.
- [Google Apps Script API Alternative](https://pastesheet.com/guides/apps-script-alternative.md): Serve sheet JSON without an Apps Script Web App. See what breaks at scale, then swap in a hosted endpoint with caching, typed columns, and MCP built in.

## Use cases

- [Google Sheets as a Headless CMS for Websites](https://pastesheet.com/use-cases/google-sheets-cms.md): Run your website's content from a Google Sheet. PasteSheet publishes it as a live, read-only JSON API — no database, no backend, no Google Cloud setup.
- [A Google Sheets Data Source for AI Agents](https://pastesheet.com/use-cases/google-sheets-ai-agent-data-source.md): Give any AI agent read-only access to a Google Sheet over MCP. It can list tabs, read the schema, and query rows in plain English — no glue code, no backend.
- [A No-Code Backend From a Google Sheet](https://pastesheet.com/use-cases/google-sheets-app-backend.md): Skip the server. PasteSheet turns a Google Sheet into a live, read-only JSON API your web or mobile app reads from — no database, no backend, no Google setup.
- [Build a Directory Website From a Sheet](https://pastesheet.com/use-cases/google-sheets-directory-website.md): Turn a Google Sheet into a searchable directory. PasteSheet serves your listings as a filterable, read-only JSON API — no database, no admin panel, no code.
- [Run a Job Board From a Google Sheet](https://pastesheet.com/use-cases/google-sheets-job-board.md): Post jobs from a spreadsheet. PasteSheet publishes your listings as a live, read-only JSON API, filterable by role, location, and remote — no backend needed.
- [Serve a Product Catalog from Google Sheets](https://pastesheet.com/use-cases/google-sheets-product-catalog.md): Power a product catalog from a Google Sheet. PasteSheet serves products, prices, and stock as a live, read-only JSON API — no backend, no Google Cloud setup.
- [Drive a Pricing Table from Google Sheets](https://pastesheet.com/use-cases/google-sheets-pricing-table.md): Drive a website pricing table from a Google Sheet so non-devs update prices and features without a deploy — served as a live, read-only JSON API.
- [Run a Restaurant Menu on Google Sheets](https://pastesheet.com/use-cases/google-sheets-restaurant-menu.md): Run a digital restaurant menu from a Google Sheet — dishes, prices, and dietary tags as a live, read-only JSON API. Update by editing cells, no redeploy.
- [Real Estate Listings from Google Sheets](https://pastesheet.com/use-cases/google-sheets-real-estate-listings.md): Publish real-estate listings from a Google Sheet and filter by price, beds, or location over a live, read-only JSON API — no backend to build.
- [Drive a Marketing Site from Google Sheets](https://pastesheet.com/use-cases/google-sheets-content-website.md): Run your marketing site's content blocks from a Google Sheet — hero copy, feature lists, section text. PasteSheet publishes it as a live, read-only JSON API.
- [Run a Blog with Google Sheets as the CMS](https://pastesheet.com/use-cases/google-sheets-blog-cms.md): Publish a blog from a Google Sheet — posts, slugs, dates, tags, and body text. Filter to published rows and sort by date over a fast, read-only JSON API.
- [Power an FAQ Page from a Google Sheet](https://pastesheet.com/use-cases/google-sheets-faq-page.md): Build a searchable FAQ or help page from a Google Sheet — one row per question and answer. Full-text search over questions via a live, read-only JSON API.
- [Build a Testimonials Wall from a Sheet](https://pastesheet.com/use-cases/google-sheets-testimonials.md): Run a testimonials or reviews wall from a Google Sheet — names, quotes, ratings, avatars. Feature-flag which ones show over a live, read-only JSON API.
- [Build a Team Directory from a Sheet](https://pastesheet.com/use-cases/google-sheets-team-directory.md): Publish a team or staff directory from a Google Sheet — names, roles, photos, bios. Filter by department through a live, read-only JSON API. No backend.
- [Build an Event Schedule from Google Sheets](https://pastesheet.com/use-cases/google-sheets-event-schedule.md): Run your conference agenda from a Google Sheet — sessions, times, tracks, and speakers as live JSON. Filter by day or track, no backend, no Google Cloud setup.
- [Build a Course Catalog from Google Sheets](https://pastesheet.com/use-cases/google-sheets-course-catalog.md): Turn a course catalog into a live JSON API straight from a Google Sheet. Courses, modules, lessons, and prices — filtered and sorted, with no backend to build.
- [Run a Public Changelog from Google Sheets](https://pastesheet.com/use-cases/google-sheets-changelog.md): Publish a release-notes page from a Google Sheet — every version as live JSON, sorted newest first and filtered by type. No backend, no deploy to ship updates.
- [Build a Public Roadmap from Google Sheets](https://pastesheet.com/use-cases/google-sheets-roadmap.md): Ship a public product roadmap from a Google Sheet — items grouped by status: planned, in progress, shipped. Update a cell to move a card, no deploy required.
- [Google Sheets Feature Flags & Remote Config](https://pastesheet.com/use-cases/google-sheets-feature-flags.md): Ship feature flags from a Google Sheet. Toggles are served as a live, read-only JSON API your app reads on launch — no deploy, no app-store review, no backend.
- [Google Sheets for Mobile App Content](https://pastesheet.com/use-cases/google-sheets-mobile-app-content.md): Ship mobile app strings, banners, and promos from a Google Sheet. PasteSheet serves them as a live, read-only JSON API — update content without a new build.
- [Google Sheets Translations & i18n Strings](https://pastesheet.com/use-cases/google-sheets-translations.md): Manage localization from a Google Sheet with a column per locale. PasteSheet serves your i18n strings as a live, read-only JSON API — no deploy to translate.
- [Google Sheets Leaderboard & Rankings API](https://pastesheet.com/use-cases/google-sheets-leaderboard.md): Power a game leaderboard from a Google Sheet. PasteSheet serves scores as a live, read-only JSON API — sort descending and page the top N.
- [Feed a Live Dashboard From Google Sheets](https://pastesheet.com/use-cases/google-sheets-live-dashboard.md): Power a live dashboard from a Google Sheet: PasteSheet serves rows and count/sum/avg rollups as cached JSON your charts read — no backend, no database.
- [A Reporting API Backed by Google Sheets](https://pastesheet.com/use-cases/google-sheets-reporting-api.md): Expose a Google Sheet of report data as a JSON API for BI tools, scripts, and embeds — with count/sum/avg summaries and no backend to build.
- [A Chatbot Knowledge Base in Google Sheets](https://pastesheet.com/use-cases/google-sheets-chatbot-knowledge-base.md): Keep your chatbot's Q&A and product facts in a Google Sheet it queries over MCP or REST — accurate answers from live rows, with no vector store to run.
- [A RAG Data Source From Google Sheets](https://pastesheet.com/use-cases/google-sheets-rag-data-source.md): Skip the vector store for small, structured corpora: your agent retrieves rows from a Google Sheet with query_rows filters and full-text search over MCP.
- [A Support Agent Lookup in Google Sheets](https://pastesheet.com/use-cases/google-sheets-support-agent.md): Let a support agent look up orders, policies, and account tiers in a Google Sheet over MCP — read-only, so it answers tickets but never edits a record.
- [Google Sheets Webflow Integration (No Plugin)](https://pastesheet.com/use-cases/google-sheets-webflow.md): Connect Google Sheets to Webflow through a live JSON API. Fetch rows in an Embed with no plugin, database, backend, or Google Cloud setup.
- [Power a Framer Site With a Google Sheet](https://pastesheet.com/use-cases/google-sheets-framer.md): Render live data on a Framer site from a Google Sheet. PasteSheet serves cached JSON your code component fetches — no plugin, no backend, no Google Cloud.
- [Use a Google Sheet as a Bubble Backend](https://pastesheet.com/use-cases/google-sheets-bubble-backend.md): Use a Google Sheet as a read data source in Bubble. Pull lists and records through the API Connector from a live JSON endpoint — no plugin, no Google Cloud.
- [Use a Google Sheet as a Next.js Data Source](https://pastesheet.com/use-cases/google-sheets-nextjs-data.md): Fetch a Google Sheet as typed JSON in Next.js or React — from a Server Component, getStaticProps, or ISR. Cached, read-only, set up by pasting a share URL.

## Tools

- [Free Google Sheets to JSON Converter](https://pastesheet.com/tools/google-sheets-to-json.md): Paste a public Google Sheet URL and get clean, formatted JSON instantly. No signup, no API key, and no Google Cloud project. Copy it, download it, or go live.
- [Google Sheets to CSV Converter (Free)](https://pastesheet.com/tools/google-sheets-to-csv.md): Paste a Google Sheet URL and download it as clean, RFC 4180 CSV — no Google account, no sign-in, and no export menu. Works on any sheet shared with a link.
- [Google Sheets to Markdown Table Converter](https://pastesheet.com/tools/google-sheets-to-markdown.md): Paste a Google Sheet URL and get a Markdown table instantly — ready for a README, a doc, or an AI prompt. Free, no signup, and pipes in your cells are escaped.
- [Google Sheets to SQL INSERT Generator](https://pastesheet.com/tools/google-sheets-to-sql.md): Turn a Google Sheet into a CREATE TABLE plus INSERT statements you can run straight into MySQL, Postgres, or SQLite. Free, no signup, quotes escaped properly.
- [Google Sheets to TypeScript Types Generator](https://pastesheet.com/tools/google-sheets-to-typescript.md): Generate a TypeScript interface from a Google Sheet. Column names become properties, types are inferred from your actual data, and it is free with no signup.
- [Is My Google Sheet Public? Free Checker](https://pastesheet.com/tools/google-sheet-public-checker.md): Paste a Google Sheet URL to check whether it is publicly readable. See exactly what an app, script, or API sees — and get the fix if the sheet is still private.
- [Google Sheets MCP Config Generator](https://pastesheet.com/tools/google-sheets-mcp-config-generator.md): Generate the MCP server config for a Google Sheet — Claude, Cursor, VS Code, and ChatGPT. Get the exact JSON block and the file it goes in. Free, no signup.
- [Free CSV to JSON Converter Online](https://pastesheet.com/tools/csv-to-json.md): Paste CSV and get formatted JSON back — one object per row, keyed by the header row. Quoted fields, embedded commas and newlines all handled. Free, no signup.
- [Free JSON to CSV Converter Online](https://pastesheet.com/tools/json-to-csv.md): Paste a JSON array of objects and get CSV back, header row built from the keys. Values holding commas or quotes are escaped properly. Free, no signup.
- [Free JSON Formatter and Validator](https://pastesheet.com/tools/json-formatter.md): Paste JSON to pretty-print and validate it. Invalid JSON gets the exact error and where it happened, so you can find the missing comma. Free, no signup.
- [CSV to Markdown Table Converter (Free)](https://pastesheet.com/tools/csv-to-markdown-table.md): Paste CSV and get a GitHub-flavored Markdown table for a README, docs, or an AI prompt. Pipes inside your cells are escaped so the table cannot break.

## Optional

- [Privacy Policy](https://pastesheet.com/privacy): How PasteSheet handles your data.
- [Terms of Service](https://pastesheet.com/terms): The terms you agree to when using PasteSheet.