PasteSheet icon PasteSheet logo mark — a spreadsheet grid with a curly brace on a green rounded square PasteSheet

Connect Google Sheets to Cursor

Wire a Google Sheet into Cursor as an MCP server and let Cursor's AI read your data — reference tables, config, or content — without leaving the editor.

Last updated

Key facts

  • Cursor speaks MCP natively and reads its servers from ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). A remote server is a single url entry — nothing to install. source
  • MCP is an open protocol built on JSON-RPC 2.0. A server exposes Resources, Prompts and Tools to any MCP client — Claude, Cursor, ChatGPT, VS Code and Windsurf all speak it. source
  • PasteSheet's MCP server exposes three tools — list_tabs, get_schema and query_rows — and is read-only by design: an agent can query your sheet but can never modify it.
  • It needs no Google Cloud project, no OAuth consent screen and no service-account JSON. You paste a share URL, and MCP is included on the Free plan.

How do you connect Google Sheets to Cursor?

Add a Google Sheets MCP server to Cursor and its AI can read your spreadsheet while you code. Cursor supports MCP natively, so the whole job is pasting one URL into ~/.cursor/mcp.json. PasteSheet gives you that URL from a pasted Google Sheet link — no Google Cloud project, no local server to run.

This is what makes a sheet useful while you are writing code: seed data, copy, config, or a product catalog that lives in a spreadsheet becomes something the editor's agent can query directly instead of you copy-pasting rows into the chat.

Add the MCP server to Cursor

Open Cursor Settings → MCP → Add new MCP server, or edit ~/.cursor/mcp.json directly. Paste your endpoint's MCP URL (copied from the Connect via MCP panel):

~/.cursor/mcp.json 
{
  "mcpServers": {
    "pastesheet": {
      "url": "https://pastesheet.com/mcp/sheets/your-endpoint-id"
    }
  }
}

Private endpoints

Cursor is a CLI-style client, so for a private endpoint send an Authorization: Bearer YOUR_KEY header instead of a query string. Public endpoints connect with just the URL.

After saving, Cursor lists the list_tabs, get_schema, and query_rows tools. Ask the agent to pull rows and it queries your sheet live.

Requirements

MCP is included on the Free plan. Connect any public endpoint over MCP with no Google Cloud project and no credit card. Private endpoints and the account-wide workspace server need a paid plan (from Starter ($9/mo)) for the keys and OAuth they authenticate with.

Pro adds full-text search and aggregation (count, sum, avg, group_by) that your AI agent can call through query_rows.

Starter

For indie makers shipping a real app.

$9 /mo
Endpoints
10
Requests / mo
50,000
Row cap
5,000
  • MCP for AI agents
Choose Starter
Compare plans Start free

Frequently asked questions

Where do I add the MCP server in Cursor?

In Cursor Settings → MCP, or by editing ~/.cursor/mcp.json. Add your PasteSheet endpoint URL under mcpServers.

How do I connect a private endpoint from Cursor?

Send an Authorization: Bearer YOUR_KEY header with the request. Public endpoints need no authentication.

Sources

Related guides

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.

Google Sheets MCP for Claude Code

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 Claude via MCP

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.

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.

Start free See pricing