mcp-google-sheets
This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets.
Decision gist · record as of 2026-08-14
Yes, if you need AI-driven Google Sheets automation. The package is actively maintained, has low install friction, and integrates cleanly with MCP clients. However, verify the license terms on GitHub first, and ensure your Google Cloud setup (Service Account or OAuth) is complete before deployment. Not suitable if you need a traditional Python library for direct Sheets access—this is specifically an MCP server for AI assistants.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later.
- Must configure Google Cloud Platform credentials (Service Account recommended) and enable the Google Sheets and Drive APIs before the server can function.
- Low friction: pure Python wheel with four runtime dependencies (google-api-python-client, google-auth-oauthlib, google-auth, mcp).
License · maintenance · safety
(unclear) — License status is unclear—no SPDX identifier or raw license text is available in the package metadata. Verify the actual license terms on the GitHub repository before adopting in production or proprietary contexts.
last release 2026-05-14 (92 days) · last repo commit 2026-05-14 · 980 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 110,440 downloads/mo, #12,462 on PyPI
Alternatives
Verify before relying
# Install and run the MCP server
uvx mcp-google-sheets@latest
# In your MCP client config, set environment variables:
export SERVICE_ACCOUNT_PATH="/path/to/service-account-key.json"
export DRIVE_FOLDER_ID="YOUR_DRIVE_FOLDER_ID"
# Then connect your MCP client (e.g., Claude Desktop) to the running server- Exact scope and limitations of the 19 available tools beyond the names listed in the description.
- Whether OAuth 2.0 authentication is fully supported or if Service Account is the recommended path.
- Performance characteristics when handling large spreadsheets or batch operations.
- Whether the package is actively maintained beyond the latest commit date shown.
What it is and what it does
mcp-google-sheets is a Python-based MCP (Model Context Protocol) server that acts as a gateway between AI-compatible clients and the Google Sheets API. It exposes 19 tools for spreadsheet operations—including reading, writing, creating sheets, batch updates, searching, and sharing—allowing natural language commands from an AI assistant to manipulate Google Drive spreadsheets. The server runs as a standalone process that your MCP client (such as Claude Desktop) connects to, translating high-level requests into Sheets API calls.
The package depends on google-api-python-client, google-auth-oauthlib, and google-auth for API communication, and mcp for the protocol layer. It supports both Service Account (recommended) and OAuth 2.0 authentication via environment variables. Tool filtering is available to reduce token consumption by enabling only the tools you need, and the server can be launched instantly using uvx without manual installation.
Use it for
- Automate spreadsheet creation and population from AI-driven workflows without writing custom API code.
- Enable Claude or another MCP client to read, analyze, and update Google Sheets through natural language prompts.
- Batch-update multiple cells or sheets in a single operation, triggered by AI reasoning.
- Search and retrieve data from existing spreadsheets, then feed results back into an AI conversation.
- Share spreadsheets and manage permissions programmatically as part of an automated data pipeline.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need AI-driven Google Sheets automation.
The package is actively maintained, has low install friction, and integrates cleanly with MCP clients. However, verify the license terms on GitHub first, and ensure your Google Cloud setup (Service Account or OAuth) is complete before deployment. Not suitable if you need a traditional Python library for direct Sheets access—this is specifically an MCP server for AI assistants.
Install
mcp-google-sheets on PyPI
Before you install
Low friction: pure Python wheel with four runtime dependencies (google-api-python-client, google-auth-oauthlib, google-auth, mcp). Active maintenance with recent commits and 980 repository stars. Requires Python 3.10 or later.
Requires Python 3.10 or later. Must configure Google Cloud Platform credentials (Service Account recommended) and enable the Google Sheets and Drive APIs before the server can function.
License in practice
License status is unclear—no SPDX identifier or raw license text is available in the package metadata. Verify the actual license terms on the GitHub repository before adopting in production or proprietary contexts.
Quickstart
# Install and run the MCP server
uvx mcp-google-sheets@latest
# In your MCP client config, set environment variables:
export SERVICE_ACCOUNT_PATH="/path/to/service-account-key.json"
export DRIVE_FOLDER_ID="YOUR_DRIVE_FOLDER_ID"
# Then connect your MCP client (e.g., Claude Desktop) to the running serverVerify before relying
- Exact scope and limitations of the 19 available tools beyond the names listed in the description.
- Whether OAuth 2.0 authentication is fully supported or if Service Account is the recommended path.
- Performance characteristics when handling large spreadsheets or batch operations.
- Whether the package is actively maintained beyond the latest commit date shown.
Package facts
| License | Not declared unclear |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagesgoogle-api-python-clientgoogle-auth-oauthlibgoogle-authmcp |
| Maintenance | Actively maintained 92 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 110,440 / month, #12,462 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
Evidence: mcp_google_sheets-0.6.3-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “mcp server google sheets”
- mcp-google-sheetsAn MCP server that bridges AI clients like Claude Desktop to Google…
- workspace-mcpWorkspace MCP is an MCP server that exposes Google Workspace services…
- analytics-mcpRuns an MCP server that exposes Google Analytics Admin and Data APIs…
Give your agent the search over MCP, or paste the wish link into any chat.
More Dynamic Content packages
MarkupSafe provides a text object that escapes special characters so untrusted strings can be safely embedded in HTML and XML without injection attacks.
Jinja2 is a templating engine that renders dynamic content by combining templates with Python-like syntax and data, supporting template inheritance, macros, autoescaping, and sandboxed execution.
Soupsieve is a CSS selector library designed to work with Beautiful Soup 4 to select, match, and filter HTML and XML elements using modern CSS selectors from CSS level 1 through CSS level 4 specifications.
Install it if you use Beautiful Soup for HTML or XML parsing and want modern CSS selector support.
Werkzeug is a WSGI utility library providing request/response objects, URL routing, an interactive debugger, HTTP utilities, and a development server for building web applications.
Flask is a lightweight WSGI web application framework for building web applications in Python, from simple single-page sites to complex multi-route applications.
Mako compiles Python-embedded templates into Python modules for fast rendering, supporting layout inheritance, custom functions, and direct Python expressions within template syntax.
See also workspace-mcp · mcp-server-odoo · blender-mcp · pygsheets · aiogoogle · smartsheet-python-sdk · gspread · gsheets · gspread-pandas · ha-mcp