Google Sheets
Wire Claude Code or Cursor to Google Sheets so agents can manage spreadsheets, run batch updates, and apply formatting with OAuth or a service account.
Overview
Google Sheets MCP is a MCP server for the Build phase that connects agents to Google Sheets via OAuth or service accounts for spreadsheet management and batch updates.
What is this MCP server?
- Google Sheets read/write with spreadsheet lifecycle management
- Two auth modes: loopback OAuth and service-account JSON key file
- Optional --headless OAuth (URL returned instead of browser auto-open)
- Batch operations and cell/range formatting support
- stdio transport via npx @mcp-z/mcp-sheets (package version 1.0.7)
- Package version 1.0.7 (@mcp-z/mcp-sheets)
- stdio transport via npx runtimeHint
- 2 authentication choices: loopback-oauth and service-account
What problem does it solve?
Agents cannot safely read or update live spreadsheet data without a dedicated Google API integration and auth flow.
Who is it for?
Indie builders who already run ops or lead lists in Google Sheets and want Claude Code or Cursor to automate tab updates and batch edits.
Skip if: Teams that need a full database, real-time collaboration outside Sheets, or zero Google Cloud setup.
What do I get? / Deliverables
After registration, your agent can create and manage spreadsheets, run batch reads/writes, and apply formatting using your chosen auth mode.
- Agent-callable tools for spreadsheet management and formatted range updates
- Authenticated Google Sheets sessions via loopback OAuth or service account
- Batch read/write workflows against live workbooks
Recommended MCP Servers
Journey fit
Sheets MCP is installed while wiring product and ops integrations during the build phase, not during early idea research. It is a third-party API bridge (Google Sheets) that belongs on the integrations shelf alongside other agent-facing connectors.
How it compares
MCP integration to Google Sheets, not an in-repo agent skill or a standalone spreadsheet UI.
Common Questions / FAQ
Who is Google Sheets MCP for?
Solo and small-team builders using AI coding agents who rely on Google Sheets for data capture, reporting, or lightweight backends.
When should I use Google Sheets MCP?
Use it during build when you are connecting your agent workflow to existing spreadsheets, automating range updates, or prototyping integrations before a full database.
How do I add Google Sheets MCP to my agent?
Register the server with stdio transport and run npx @mcp-z/mcp-sheets, passing --auth loopback-oauth or service-account plus --service-account-key-file when needed; complete OAuth unless --headless is set.