Connect Google Sheets to VS Code

How do you add a Google Sheet to VS Code?

Register a Google Sheets MCP server in VS Code's mcp.json and Copilot's agent mode can query the sheet while you code. PasteSheet turns any Google Sheet into that server from a pasted URL, so there is no Google Cloud project and nothing running locally.

It is the same trick as Cursor and Windsurf — the editors differ, the protocol does not.

Add the server

Create .vscode/mcp.json in your workspace (or add to your user config) and paste the MCP URL:

{
  "servers": {
    "pastesheet": {
      "type": "http",
      "url": "https://pastesheet.com/mcp/sheets/your-endpoint-id"
    }
  }
}

Then use it in agent mode

Open Copilot Chat, switch to Agent mode, and ask a question about your data. The agent discovers the sheet's tools, reads the schema, and queries only the rows it needs — you never name a tool yourself.

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.

Frequently asked questions

Sources

• Use MCP servers in VS Code — Microsoft
• Model Context Protocol specification — Model Context Protocol

Related guides