Google Sheets MCP: Documentation
Updated:
Connection
Repo: github.com/xing5/mcp-google-sheets (Python, MIT, 959★/229 forks). Install: uvx mcp-google-sheets or via pip; the Docker image adds an SSE mode on port 8000. Transport defaults to stdio.
Auth (pick one of four): a Google Cloud service account (recommended for server use) — a JSON key file or a base64 env var; OAuth 2.0 (interactive login for personal use); Application Default Credentials inside Google Cloud environments.
Tools
Reading: cell values, formulas, sheet and spreadsheet metadata. Writing: updating cells, batch-updating several ranges at once, adding rows and columns. Management: creating, renaming and copying sheets between spreadsheets. Extras: charts, sharing-permission management, multi-range queries.
Agent flow
"Pull range A1:D50 from the Sales sheet and total column D", "create a new July sheet and copy the header row from June", "grant read access to this spreadsheet to a user by email".
Note
A community project, not affiliated with Google. Google has a separate official Sheets MCP preview (sheetsmcp.googleapis.com, with tools like get_values and update_spreadsheet) under its Developer Preview program — these are two different servers with different toolsets.
Pricing
The MCP server is free and open source (MIT); using the Google Sheets API falls within Google Cloud's free quotas for most scenarios.