Skip to main content
MCP server CX Codex

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

Install into Claude Code · Platform CLI: remote server All methods and platforms ↓
claude mcp add --transport http googlesheets https://googlesheets.run.tools
Open on GitHub

What 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.tools

Step 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.

Similar MCP servers

All MCP servers for Office documents →

More in the catalog

Project sponsors

Companies that keep this analytics open