AgentIndex icon
AgentIndex
ToolsCategoriesTrendingNewCompareGuides
Submit Tool
ToolsCategoriesTrendingNewCompareGuides
Home/
API Integration/
mcp-google-sheets
mcp-google-sheets logo

mcp-google-sheets

Active·★ 1.0k·MIT·Updated 2026-05-14
★ API Integration★ Data Processing

mcp-google-sheets is a Python MCP server that connects clients such as Claude Desktop to the Google Sheets API. It exposes 19 tools covering creating and listing spreadsheets and sheets, reading and updating cells and ranges, batch updates, formatting and sharing. It runs in one line with `uvx mcp-google-sheets@latest`, which the README recommends over pinning an old version.

Authentication is the main setup cost. You must configure Google Cloud credentials and enable the necessary APIs first. The README strongly recommends a Service Account, set through `SERVICE_ACCOUNT_PATH` and a `DRIVE_FOLDER_ID` for the folder it may work in, and also describes OAuth 2.0 and direct credential injection with `CREDENTIALS_CONFIG`. With a Service Account, listing is limited to the configured Drive folder, which is a useful boundary.

© 2026 AgentIndex.app|Built by a 10-year iOS Developer.
Best by use caseAboutContactAdvertisePrivacy PolicyTerms of UseQYSGitHubBuy me a coffee ☕

Browse by Category

Code AssistantWorkflow AutomationRAG / Knowledge BaseMulti-AgentBrowser AutomationLLM InfraDev ToolingObservability

Not affiliated with Anthropic, OpenAI or Microsoft.

One practical feature is tool filtering. By default all 19 tools are enabled and use about 13K tokens of context before you say anything, so the README shows `--include-tools` or the `ENABLED_TOOLS` environment variable to enable only what you need, for example `get_sheet_data`, `update_cells`, `list_spreadsheets` and `list_sheets`. The licence is MIT and the last push was 2026-05-14, about five months before this review. This review is based on the README and repository data; we have not run it ourselves.

This write-up is based on the project's README and public repository data. We have not hand-tested the tool.

#google#mcp#mcp-server#mcp-servers#spreadsheet
$ Install
$ pip install mcp-google-sheets
↗ Visit site★ GitHub
01

Features

01Seamless Integration with Google Drive & Sheets APIs
02Comprehensive Tools for CRUD, listing, batching, sharing, formatting
03Flexible Authentication (Service Account, OAuth, ADC, Injection)
04Easy Deployment via uvx (zero-install) or cloning
05Tool Filtering to reduce context usage
02

Why choose it

+19 tools for reading, writing, batch updates, formatting and sharing Google Sheets
+Service Account auth with a `DRIVE_FOLDER_ID` boundary, plus OAuth 2.0 and credential injection
+`--include-tools` and `ENABLED_TOOLS` cut about 13K tokens of default tool definitions
+Runs with `uvx`; MIT license
03

Trade-offs

!Needs a Google Cloud project, enabled APIs and a Service Account before the first call
!Write tools can overwrite or delete real spreadsheet data, so test on copies and limit the Drive folder
!All 19 tools use about 13K tokens unless you filter them
!Last push was 2026-05-14, so check recent activity if you need fast fixes
04

Compatibility

macOS
macOS
Verified via docs
Linux
Linux
Verified via docs
Windows
Windows
Verified via docs
05

Quick start

1
$ pip install mcp-google-sheets
06

Use cases

↳AI assistant managing Google Sheets data through natural language
↳Automating data operations like batch updates, adding rows/columns
↳Integrating with Claude Desktop for interactive spreadsheet management
07

Alternatives

GitHub MCP Server logo
GitHub MCP Server★ 33.6k
GitHub's official MCP Server. Allows AI agents to interact directly with your GitHub repositories (read files, search code, issues).
python-sdk logo
python-sdk★ 24.6k
The official Python SDK for Model Context Protocol servers and clients
fastmcp logo
fastmcp★ 28.1k
🚀 The fast, Pythonic way to build MCP servers and clients.

Featured in these lists

  • Best MCP Servers for Work Apps: Jira, Slack, Google Workspace, Notion

Comments

Log in to leave a comment

No comments yet. Be the first!

On this page
01Features02Why choose it03Trade-offs04Compatibility05Quick start06Use cases
FunASR logo
FunASR★ 20.7k
Open-source speech recognition toolkit for training, inference, streaming ASR, VAD, punctuation and speaker diarization, with OpenAI-compatible and MCP serving.
semble logo
semble★ 6.2k
Fast and Accurate Code Search for Agents
csharp-sdk logo
csharp-sdk★ 4.6k
The official C# SDK for Model Context Protocol servers and clients. Maintained in collaboration with Microsoft.
fast-agent logo
fast-agent★ 3.9k
Code, Build and Evaluate agents - excellent Model and Skills/MCP/ACP Support
Godot-MCP logo
Godot-MCP★ 283
Godot-MCP — Model Context Protocol (MCP) integration for the Godot Engine. AI tools for the Godot Editor in C#, with cloud connection to ai-game.dev. Apache-2.0.
See all alternatives →
07
Alternatives
Stats
GitHub Stars★ 1.0k
Last commit5mo ago
StatusActive
LicenseMIT
CategoryAPI Integration
Trend (30d)
+0k↑ 0.9%
Links
Documentation↗Discussion↗Issues↗Releases↗

Deploy on DigitalOcean — Get $200 Free Credit

Ad