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

Connect Google Sheets to ChatGPT

ChatGPT connects to PasteSheet's workspace MCP server over OAuth, giving it one connector for every sheet you own. Ask ChatGPT to pull, filter, and summarize your spreadsheet data.

Last updated

Key facts

  • ChatGPT connects to MCP servers as custom connectors, and authenticates over OAuth rather than a pasted API key. 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 workspace server at https://pastesheet.com/mcp runs the OAuth flow for you (including dynamic client registration) and exposes every sheet in your account through one connector.
  • 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.

Can you connect Google Sheets to ChatGPT?

Yes. ChatGPT supports custom MCP connectors, so you can hand it a Google Sheet by pointing it at an MCP server that serves the sheet. PasteSheet provides one: connect the workspace server, authorize with OAuth, and ChatGPT can query any sheet in your account in plain English.

ChatGPT authenticates with OAuth rather than a pasted key, so it connects to the workspace server at https://pastesheet.com/mcp — a single connector that exposes all of your sheets. PasteSheet handles the OAuth flow (dynamic client registration) automatically, so there is nothing to configure on Google's side. New to this? The Google Sheets MCP overview explains how the tools work.

Setup steps

  1. 1 In ChatGPT, open Settings → Connectors (Developer mode / custom connectors) and choose Add custom connector.
  2. 2 Enter the workspace URL https://pastesheet.com/mcp and start the connection.
  3. 3 Complete the OAuth prompt to authorize ChatGPT against your PasteSheet account.
  4. 4 Ask ChatGPT to list_sheets, then query any of them by name in plain English.

Workspace tools

The workspace server adds a discovery tool on top of the per-sheet tools:

  • list_sheets — list every sheet in your workspace with its id, title, and tab count.
  • list_tabs, get_schema, query_rows — the same read tools, each taking a sheet id argument.

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

Why does ChatGPT use a different URL than Claude?

ChatGPT authenticates with OAuth, so it connects to the workspace server at /mcp (one connector for all your sheets) rather than a single per-sheet URL.

Do I need an API key for ChatGPT?

No — ChatGPT uses OAuth. You authorize the connector once and PasteSheet issues the token. Account keys are an alternative for non-OAuth clients.

Can ChatGPT see all my sheets?

The workspace connector exposes the sheets in your account via list_sheets. It is read-only and scoped to your own workspace.

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.

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 Google Sheets Into a REST API (No Code)

Turn a public or restricted Google Sheet into a live JSON REST API with filtering, sorting, and pagination — no backend, no code.

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