Google Sheets MCP

Google Sheets MCP server for Claude Code, Cursor, Copilot and five more AI agents. Connect Google Sheets to Claude, Copilot, Cursor, Codex, Gemini, Windsurf, Continue.dev and Cline. One extension, 8 agents, no config files to edit.

Install. Sign in with Google. Ask your AI agent to work with Google Sheets.

Install this or Google Workspace MCP, not both.

Quick Start

Install from the VS Code Marketplace or Open VSX
Authenticate: the setup wizard appears on first launch
Ask your AI agent anything about Google Sheets

"Show me the data in Sheet1!A1:D20"
"Append a row to my expense tracker"
"Create a spreadsheet called Leads November"
"Update cell B4 to 1,250"

Prerequisites

You need one of these (the wizard will guide you):

Method	Best For	What You Need
OAuth (recommended)	Personal Google accounts	A Google Cloud project with OAuth credentials
ADC	Developers with `gcloud` CLI	Run one terminal command
Service Account	Workspace admins	A JSON key file

Go to Google Cloud Console
Create a project (or select an existing one)
Enable the Google Sheets API under APIs & Services > Library
Create OAuth credentials:
- Go to APIs & Services > Credentials
- Click Create Credentials > OAuth client ID
- Application type: Desktop app
- Copy the Client ID and Client Secret
Configure the OAuth consent screen (if prompted) and add yourself as a test user
In the extension wizard, select "OAuth" and paste your Client ID and Secret
A browser window opens: sign in with your Google account and authorize

Option B: Application Default Credentials

gcloud auth application-default login \
  --scopes=https://www.googleapis.com/auth/spreadsheets.readonly

Option C: Service Account Key

Create a service account in Google Cloud Console
Share the files or calendars with the service account, or enable domain-wide delegation
Download the JSON key file
In the extension wizard, select "Service Account" and pick the file

Available Tools (3)

Sheets (1 tool)

Tool	What It Does	Example Prompt
`sheets_read`	Read cell data or sheet metadata	"Show me the data in Sheet1!A1:D10"

Sheets Admin (mega-tool)

Action	Description
`create`	Create a new spreadsheet
`append_rows`	Add rows to a sheet
`update_cells`	Update cell values
`add_sheet`	Add a new sheet tab
`delete_sheet`	Delete a sheet tab (requires confirm)
`clear_range`	Clear a cell range (requires confirm)

Safety

Destructive actions (delete, trash, clear) require confirm: true to execute. The AI agent will be warned and must explicitly confirm before proceeding.

Supported AI Agents

The extension auto-registers with every AI agent it detects:

Agent	How It Registers	Config File
VS Code Copilot	VS Code API (automatic)	--
Claude Code	`~/.claude.json`	JSON
Cursor	`~/.cursor/mcp.json`	JSON
OpenAI Codex	`~/.codex/config.toml`	TOML
Google Gemini	`~/.gemini/settings.json`	JSON
Windsurf	`~/.codeium/windsurf/mcp_config.json`	JSON
Continue.dev	`~/.continue/config.yaml`	YAML
Cline	VS Code globalStorage	JSON

You can toggle individual agents on/off in Settings > search gsheetsMcp.agents.

Settings

Setting	Default	Description
`gsheetsMcp.authMethod`	`"oauth"`	Auth method: oauth, adc, serviceAccount
`gsheetsMcp.agents.*`	`true`	Per-agent registration toggles
`gsheetsMcp.registrationScope`	`"global"`	Global or workspace registration
`gsheetsMcp.autoStart`	`true`	Auto-start server on VS Code launch
`gsheetsMcp.serverLogLevel`	`"info"`	Server log verbosity

Commands

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and search for:

Command	What It Does
`Google Sheets MCP: Setup Authentication`	Run the setup wizard
`Google Sheets MCP: Register with AI Agents`	Re-register with all detected agents
`Google Sheets MCP: Show Status`	Show auth method and server state
`Google Sheets MCP: Restart MCP Server`	Restart the background MCP server
`Google Sheets MCP: Check Authentication Status`	Verify credentials are valid
`Google Sheets MCP: View Server Logs`	Open the output channel for debugging
`Google Sheets MCP: Remove from All Agents`	Clean up all agent registrations

Troubleshooting