# 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: 2026-07-07 · Source: * ## Key facts - ChatGPT connects to MCP servers as **custom connectors**, and authenticates over **OAuth** rather than a pasted API key. ([source](https://platform.openai.com/docs/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 **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](https://pastesheet.com/guides/google-sheets-mcp) overview explains how the tools work. ## Setup steps 1. In ChatGPT, open **Settings → Connectors** (Developer mode / custom connectors) and choose **Add custom connector**. 2. Enter the workspace URL `https://pastesheet.com/mcp` and start the connection. 3. Complete the OAuth prompt to authorize ChatGPT against your PasteSheet account. 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 — $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 ### 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 - [Model Context Protocol (MCP)](https://platform.openai.com/docs/mcp) — OpenAI - [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. - [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. - [Turn Google Sheets Into a REST API (No Code)](https://pastesheet.com/guides/google-sheets-rest-api) — Turn a public or restricted Google Sheet into a live JSON REST API with filtering, sorting, and pagination — no backend, no code. --- [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: