Google Sheets MCP

Local · stdio

Google Sheets MCP is a community Python server (MIT, 959★) by author xing5 for Google Sheets and Google Drive. It gives an agent full CRUD: reading cells and formulas, batch updates, creating and copying sheets, charts and sharing permissions. Four auth methods are supported, from a service account to Application Default Credentials. It runs locally over stdio; Docker adds SSE on port 8000.

Why this server

959 GitHub stars — a well-known community server for Google Sheets, in Python
Four auth methods — from a service account to Application Default Credentials
Full CRUD: reading cells and formulas, batch updates, creating and copying sheets
The Docker mode adds SSE on port 8000 — deployable as a remote service

Usage examples

Prompt: Pull range A1:D50 from the Sales sheet and total column D

Result: The agent called the range-reading tool, pulled values and formulas from the Sales sheet, and summed the requested column.

Prompt: Create a new "July" sheet in this spreadsheet and copy the header row from "June"

Result: The agent created the sheet via the sheet-management tool and copied the header range across in a single call.

Local server

This MCP runs locally on the user's machine (stdio), so availability isn't tracked — rely on reviews and the rating instead.

Reviews

No reviews yet.