PasteSheet

PasteSheet turns any public Google Sheet into a live, cached JSON REST API and an MCP server for AI agents — in seconds, with no backend, no database, and no code.

Paste a Google Sheets share URL and instantly get a working JSON endpoint you can query with filters, sorting, search, and pagination. The same sheet is also queryable by AI agents (Claude, Cursor, ChatGPT) through a built-in MCP server, using the exact same query engine.

Who it's for:

• Indie devs & makers — skip the backend. Paste a sheet, get an API, ship your app.
• No-code & non-technical builders — your spreadsheet already is your database. Get an API or an embeddable search widget without writing a single line of code.
• AI & agent builders — wire live spreadsheet data into LLMs via MCP so your agent can read and query the sheet at runtime.

Key features:

• Instant JSON REST API from any Google Sheet
• MCP server support for Claude, Cursor, ChatGPT, and Claude Code
• Filtering, sorting, full-text search, and aggregation (group by, count, sum, avg)
• Private endpoints with API key auth
• Configurable caching (30s–1hr on paid plans)
• Schema lock & drift alerts — get notified when columns change
• Embeddable search widget for any website
• Usage dashboard tracking API vs. MCP requests
• Free tier: 3 endpoints, 2,000 requests/month — no credit card, no expiry