Google Sheets — Claude Code MCP server: batch editing cell ranges
Connects Google Sheets to coding agents via an HTTP endpoint. It lets tools search files, read grid data, batch edit rows, and manage comment threads.
no license 56,138 installs updated 2025-11-19
claude mcp add --transport http googlesheets https://googlesheets.run.toolsWhat Google Sheets does
This MCP server links to Google Sheets through the endpoint https://googlesheets.run.tools. It looks up Drive spreadsheets by title and metadata, verifies read permissions, and generates Drive file picker links for sharing access. Inspection separates layout checks from data fetching: structure mode inspects the sheet schema cheaply, while read mode exports grid rows into raw formats, markdown, csv, or tsv.
All sheet updates run in batches via requests[], handling operations like updateCells, addSheet, and sortRange. A dedicated scanning tool flags faulty cells by exact grid coordinates and severities using fixed rules rather than language model judgements. Edit history only tracks revision timestamps and author identities, so checking per-cell diffs or reverting versions is impossible here.
Newly created comments attach solely to the spreadsheet document, because the underlying Drive API cannot link new comments to specific cells.
What it helps with
- search Google Drive spreadsheets by title and file metadata
- inspect workbook sheets and export cell ranges to csv or markdown
- batch edit rows, sort cell ranges, and insert new sheets
- detect malformed values using deterministic rule checks
- read revision authors and manage document comment threads
Example prompts for the agent
- Search for the quarterly budget spreadsheet and inspect its structure
- Scan the active sheet for data issues and show flagged coordinates
- Read rows A1 to D20 and export them as markdown
How to install Google Sheets
Platform CLI: remote server
claude mcp add --transport http googlesheets https://googlesheets.run.toolsPlatform CLI: remote server
codex mcp add google-sheets --url https://googlesheets.run.toolsConfig file
{
"mcpServers": {
"google-sheets": {
"url": "https://googlesheets.run.tools"
}
}
}Config file
{
"servers": {
"google-sheets": {
"type": "http",
"url": "https://googlesheets.run.tools"
}
}
}Platform CLI: remote server
gemini mcp add -t http google-sheets https://googlesheets.run.toolsStep 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 Google Sheets
How do I install Google Sheets in Claude Code?
Run the command claude mcp add --transport http googlesheets https://googlesheets.run.tools in your terminal.
Can newly added comments be anchored to specific cells?
No, the Drive API creates comments at the document level only. However, existing cell-anchored comments added from the web interface remain readable.
Does the revision tool show cell-level diffs?
No, it only reports revision authors and timestamps. It cannot identify specific cell changes or revert edits.