Connect Google Sheets to Windsurf
Windsurf speaks MCP, so its Cascade agent can read a spreadsheet the same way it reads your codebase — if you hand it a server. Here is the one URL that does it.
Last updated
Key facts
-
Windsurf's Cascade agent supports MCP natively. Servers live in its MCP config, and a remote one is a single
serverUrlentry — no plugin, no local process. 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_schemaandquery_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 Windsurf?
Add a Google Sheets MCP server to Windsurf's MCP config and Cascade can query your spreadsheet while you work. Windsurf supports MCP natively, so the whole job is pasting one URL. PasteSheet produces that URL from a pasted Google Sheet link — no Google Cloud project, no local server.
This is most useful when the data you need mid-task lives in a sheet rather than the repo: seed data, copy, feature flags, a product catalog, a pricing table.
Add the server
Open Windsurf's MCP settings and add the server, or edit the config directly. Paste the MCP URL from your endpoint's Connect via MCP panel:
{
"mcpServers": {
"pastesheet": {
"serverUrl": "https://pastesheet.com/mcp/sheets/your-endpoint-id"
}
}
}Private sheets
For a private endpoint, send the key as a bearer token — Authorization: Bearer YOUR_KEY. Want one connector covering every sheet you own instead of one per sheet? Use the workspace server at https://pastesheet.com/mcp with an account key or OAuth.
What it costs
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.
Free
For side projects and trying things out.
- Endpoints
- 3
- Requests / mo
- 2,000
- Row cap
- 500
- MCP for AI agents
- Private endpoints & keys
Frequently asked questions
Does Windsurf support MCP?
Yes. Windsurf supports MCP servers natively, so its Cascade agent can call any MCP server you register — including a Google Sheets one — without a plugin or extension.
Can Cascade edit my spreadsheet?
No. PasteSheet exposes read-only tools, so Cascade can list tabs, read the schema, and query rows, but it has no way to modify the sheet.
Do I need a Google Cloud project?
No. PasteSheet reads a shared sheet through its link, so there is no Google Cloud project, OAuth client, or service account to set up.
One sheet or all of them?
Both are possible. A per-sheet URL exposes exactly one endpoint; the workspace server at /mcp exposes every sheet in your account through a single connector.
Sources
- MCP — Windsurf docs — Windsurf
- Model Context Protocol specification — Model Context Protocol
Related guides
Google Sheets MCP Server for Cursor
Add a Google Sheet to Cursor as an MCP server so the editor's AI can query your spreadsheet while you code. No backend — copy one URL and you are connected.
Google Sheets MCP for VS Code & Copilot
Connect a Google Sheet to VS Code and GitHub Copilot over MCP. Paste one URL into mcp.json and your editor's agent can query the spreadsheet live.
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.
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.