Connect Google Sheets to Claude Code

How do you add Google Sheets to Claude Code?

Run claude mcp add --transport http pastesheet <your-mcp-url>. Claude Code registers HTTP MCP servers from the CLI, and PasteSheet turns any Google Sheet into one of those URLs, so your terminal agent can query the spreadsheet without a Google Cloud project or a local server.

Once it is registered, Claude Code can list the sheet's tabs, read its schema, and run filtered queries against it mid-task — useful when the data you need (fixtures, config, a content table) lives in a spreadsheet rather than the repo.

Connect in three steps

From a connected endpoint to a querying agent:

1. 1 In PasteSheet, open the endpoint's Connect via MCP panel and copy its MCP URL.
2. 2 Register it with claude mcp add --transport http pastesheet <your-mcp-url> (add a --header for a private endpoint).
3. 3 Run claude, confirm the server with claude mcp list, and ask a question about your sheet — the agent calls the read tools for you.

Add the server with one command

Claude Code registers HTTP MCP servers from the CLI. Point it at your endpoint's MCP URL:

claude mcp add --transport http pastesheet \
  https://pastesheet.com/mcp/sheets/your-endpoint-id

Private endpoints

For a private endpoint, pass a bearer header when you add the server:

claude mcp add --transport http pastesheet \
  https://pastesheet.com/mcp/sheets/your-endpoint-id \
  --header "Authorization: Bearer YOUR_KEY"

Use it

Run claude and ask about your data — the agent calls list_tabs, get_schema, and query_rows as needed. Manage the connection later with claude mcp list and claude mcp remove pastesheet.

For the full picture of how the MCP connection works, see the Google Sheets MCP overview.

What Claude Code can do with your sheet

With the endpoint registered, the agent can, mid-task:

• Read a specific tab or a filtered slice of rows without leaving the terminal.
• Check whether a metric crossed a threshold before it writes code or a report.
• Cross-reference fixtures, config, or a content table that lives in a sheet rather than the repo.
• Look up a single value — an ID, a price, a feature flag — on demand.

No install, just a URL

Unlike managed connectors that make you pip-install a CLI, log into a broker, and authorize Google, PasteSheet is one claude mcp add command against a URL. There is no Google Cloud project, no OAuth consent screen, and no local server to keep running — and because the connection is read-only, the agent can query your sheet but never change it.

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.

Frequently asked questions

Sources

• Installing and using an MCP server — Anthropic
• Model Context Protocol specification — Model Context Protocol

Related guides