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.
Free, no paid tierVisit WebsiteFreeVisit Website
Tracked since2026
The Bottom Line
- Price
- Free, no paid tier. Compare plans
Key facts
- 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
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
What is Google Sheets MCP?
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.
Key Features
- Full CRUD operations on spreadsheets, create, read, update, and delete cells, rows, and sheets
- Cell formatting, text styles, background colors, borders, and number formats
- Column-level aggregation, sum, average, min, max, count with filter-based grouping
- SQL-like queries against spreadsheet data for structured data retrieval
- Chart creation and spreadsheet property management (title, locale, recalculation)
- Configurable tool selection to reduce context window usage, enable only what you need
- Service Account, OAuth 2.0, and environment variable authentication options
- Zero-install deployment via uvx or standard Python clone for local development
Pricing Plans
Pricing checked Sep 28, 2026
| Plan | Price | Details |
|---|---|---|
| Open Source | Free |
|
Is Google Sheets MCP worth the price?
Great value
The Google Sheets MCP pricing is exceptionally generous, as it is entirely free and open-source.
This makes it an outstanding value, especially for those who can self-host and leverage community support. It's best for developers, small businesses, and individuals comfortable with open-source solutions and self-management.
Reviews
$99Free with your review
Write a reviewReview Google Sheets MCP, get a free AI guide
Share your experience and we will send you Improve Your Thinking Patterns Using ChatGPT, free.
Best Google Sheets MCP Alternatives
Top alternatives based on features, pricing, and user needs.
Still deciding?
Most buyers shortlist 2 or 3 tools before committing. Pull a side-by-side comparison or browse the full alternatives shortlist below.
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