Sheets MCP — Claude Code MCP server: what it does, how to install
Brings Google Sheets into Claude Code and desktop environments. Edits spreadsheet cells, draws charts, and catches formula errors locally.
claude mcp add sheets-mcp -- npx -y @sheetsmcp/serverWhat Sheets MCP does
The server runs on your machine and communicates directly with Google. Access is restricted strictly to spreadsheets. Claude can write values, format cells, generate pivot tables, and insert charts. Every modification triggers an automated formula-error check alongside full rollback support.
It works with multiple Google accounts simultaneously. You can pull values from personal sheets into corporate reports without juggling tokens. In Claude Desktop, a live view displays changes cell by cell, while Claude Code provides file history through /mcp__google-sheets__recent_sheets.
Running the tool requires Node.js 18 or later. The initial authorization triggers an unverified app alert in the browser, which requires proceeding past the advanced warning.
What it helps with
- build a pivot summary grouped by region
- format currency columns and auto-fit row headers
- transfer report tabs between two Google accounts
- revert unintended spreadsheet edits with undo
Example prompts for the agent
- Calculate gross margin in column D and set currency formatting
- Turn the monthly expense breakdown into a line chart: <link>
- Revert the last batch of edits in the active sheet
How to install Sheets MCP
Platform CLI
claude mcp add sheets-mcp -- npx -y @sheetsmcp/serverPlatform CLI
codex mcp add sheets-mcp -- npx -y @sheetsmcp/serverConfig file
{
"mcpServers": {
"sheets-mcp": {
"command": "npx",
"args": [
"-y",
"@sheetsmcp/server"
]
}
}
}Config file
{
"servers": {
"sheets-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@sheetsmcp/server"
]
}
}
}Platform CLI
gemini mcp add sheets-mcp npx -y @sheetsmcp/serverStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Sheets MCP
How to install Sheets MCP in Claude Code?
Run claude mcp add sheets-mcp -- npx -y @sheetsmcp/server in your terminal. Then start a new Claude Code session.
How does Sheets MCP differ from the official Google Sheets integration?
It runs locally without routing data through remote proxy servers and functions on free plans. It also enables multi-account switching and inspects formulas for errors before committing edits.
Why does Google show an unverified app screen during setup?
Google displays this screen because the OAuth client is not pre-verified yet. Click Advanced, select the link to Sheets MCP, and allow spreadsheet permissions to proceed.
