# 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: 2026-07-07 · Source: <https://pastesheet.com/guides/google-sheets-mcp-cursor>*

## 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](https://cursor.com/docs/context/mcp))
- 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](https://modelcontextprotocol.io/specification/2025-06-18))
- 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](https://pastesheet.com/guides/google-sheets-mcp) 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):

```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 — $9/month.** For indie makers shipping a real app.

- Endpoints: 10
- Requests: 50,000 / month
- Rows per endpoint: 5,000
- Tabs per endpoint: 5
- Rate limit: 300 / minute

## 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

- [Model Context Protocol — Cursor docs](https://cursor.com/docs/context/mcp) — Cursor
- [Model Context Protocol specification](https://modelcontextprotocol.io/specification/2025-06-18) — Model Context Protocol

## Related guides

- [Google Sheets MCP Server for Claude & ChatGPT](https://pastesheet.com/guides/google-sheets-mcp) — 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](https://pastesheet.com/guides/google-sheets-mcp-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](https://pastesheet.com/guides/google-sheets-mcp-claude) — 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.

---

[PasteSheet](https://pastesheet.com) turns any Google Sheet into a live REST API and MCP server for AI agents — no backend, no code. Canonical HTML version of this page: <https://pastesheet.com/guides/google-sheets-mcp-cursor>