FreeVisit Website
TL;DR - Google Sheets MCP
- MCP server bridging AI assistants to Google Sheets for CRUD, formatting, aggregation, and SQL-like queries
- Up to 37 tools with configurable selection to minimize context window token usage
- Supports Service Account, OAuth 2.0, and env var auth — deploy instantly with uvx or clone locally
Pricing: Free forever
Best for: Individuals & startups
Pros & Cons
Pros
- Aggregation and SQL-like queries turn spreadsheets into a lightweight analytics layer
- Configurable tool selection keeps context window usage lean for cost-sensitive workflows
- Multiple authentication methods support both automated pipelines and interactive use
- Broad tool coverage (up to 37 tools) handles formatting, charts, sharing, and batch operations
Cons
- Requires Google Cloud project setup with Sheets API enabled and credential configuration
- Google Sheets API rate limits (60 requests per minute per user) can throttle high-volume operations
- Community-maintained — no official Google MCP server, so long-term support depends on contributors
Key Features
Full CRUD operations on spreadsheets — create, read, update, and delete cells, rows, and sheetsCell formatting — text styles, background colors, borders, and number formatsColumn-level aggregation — sum, average, min, max, count with filter-based groupingSQL-like queries against spreadsheet data for structured data retrievalChart creation and spreadsheet property management (title, locale, recalculation)Configurable tool selection to reduce context window usage — enable only what you needService Account, OAuth 2.0, and environment variable authentication optionsZero-install deployment via uvx or standard Python clone for local development
Pricing Plans
Open Source
Free
- Full source code access
- Community support
- Self-hosted
About Google Sheets MCP
By Toolradar Team·
Google Sheets MCP is a Model Context Protocol server that bridges AI assistants and the Google Sheets API, enabling natural-language interaction with your spreadsheets. You can create, read, update, and delete cells and sheets, apply formatting, run aggregations, and even execute SQL-like queries against your spreadsheet data — all through conversational AI tools like Claude Desktop, Cursor, and other MCP clients.
The server provides up to 37 tools depending on the implementation, covering CRUD operations, batch updates, cell formatting (text styles, background colors, borders), chart creation, sharing permissions, and spreadsheet property management (title, locale, recalculation settings). A standout feature is column-level aggregation: you can search for rows matching a value in one column and perform sum, average, min, max, or count operations on data from another column — turning Google Sheets into a lightweight analytics tool accessible through natural language.
Authentication supports Service Accounts (recommended for server deployments), OAuth 2.0 (for user-facing apps), and direct credential injection via environment variables. The server is optimized for token efficiency — you can enable only the tools you need using an include list or environment variable, reducing context window usage from the full 13K tokens to just what your workflow requires. Google Sheets MCP is open source, Python-based, and can be deployed instantly with uvx for zero-install usage or cloned for local development.
Reviews
No reviews yet. Be the first to review Google Sheets MCP!
Explore More
Google Sheets MCP FAQ
What does SQL-like query support mean for Google Sheets?
The server translates structured queries into Google Sheets API calls, letting the AI filter, sort, and aggregate spreadsheet data using familiar query patterns. Instead of navigating cell references manually, you can ask "show me all rows where revenue > 10000 sorted by date" and the server handles the translation.
Can the AI create new spreadsheets or just read existing ones?
Depending on the implementation, the server supports both read and write operations — creating spreadsheets, adding sheets, writing cell ranges, formatting, and appending rows. Permissions are controlled by the Google OAuth scope you authorize during setup.
Does it support shared team spreadsheets?
Yes. The server accesses any Google Sheet that the authenticated account has permission to view or edit. This includes shared team spreadsheets, sheets in shared drives, and publicly accessible sheets. Permission levels mirror what your Google account can do in the Sheets UI.
How does it handle large spreadsheets with thousands of rows?
The server reads data in specified ranges rather than loading entire sheets. The AI can request specific cell ranges, named ranges, or filtered subsets. For very large datasets, pagination and range-based queries prevent memory issues and keep responses within LLM context limits.
Source: github.com