Mcp Gsheets
Read, write, format, and batch-update Google Sheets from your agent for ops dashboards, lead lists, and lightweight databases.
Overview
io.github.freema/mcp-gsheets is a Build-phase MCP server that wraps the Google Sheets API for agent-driven read, write, format, and batch updates.
What is this MCP server?
- npm mcp-gsheets v1.8.1 with stdio transport
- Read, write, format, and batch operations on Google Sheets API
- Three documented auth paths: GOOGLE_APPLICATION_CREDENTIALS file, GOOGLE_SERVICE_ACCOUNT_KEY JSON, or GOOGLE_PRIVATE_KEY
- Requires GOOGLE_PROJECT_ID for the Google Cloud project
- GitHub source freema/mcp-gsheets for service-account setup patterns
- Version 1.8.1 on npm registry
- Three documented Google service-account authentication methods
- Transport: stdio via identifier mcp-gsheets
What problem does it solve?
Copy-pasting between Google Sheets and your IDE wastes time when agents could safely read and update rows if credentials were wired once.
Who is it for?
Indie SaaS builders who already run ops or metrics in Google Sheets and want Claude Code or Cursor to automate updates with a service account.
Skip if: Teams forbidden from service-account Sheet access, or anyone needing BigQuery-scale analytics instead of spreadsheet APIs.
What do I get? / Deliverables
Your agent can perform structured Sheet reads and writes—including batch and formatting—under your service account permissions.
- Agent-executed cell reads, writes, and formatting on shared spreadsheets
- Batch sheet mutations without custom Apps Script
Recommended MCP Servers
Journey fit
Spreadsheet automation is almost always wired while building integrations, internal tools, and data-backed features. Direct Google Sheets API coverage maps cleanly to third-party SaaS integration during implementation.
How it compares
Google Sheets API MCP, not Excel desktop macros or a no-code Airtable skill.
Common Questions / FAQ
Who is io.github.freema/mcp-gsheets for?
Developers and solo operators who keep live data in Google Sheets and want MCP agents to read, write, and format cells programmatically.
When should I use io.github.freema/mcp-gsheets?
Use it while building integrations or lightweight back-office automation, and again in Grow when agents refresh metrics or content planning tabs.
How do I add io.github.freema/mcp-gsheets to my agent?
Install npm package mcp-gsheets, configure stdio MCP in your client, set GOOGLE_PROJECT_ID, and provide service account credentials via file path, JSON env, or PEM plus client email.