mcp-google-sheets

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

An MCP server that bridges AI clients like Claude Desktop to Google Sheets, enabling spreadsheet creation, reading, writing, and manipulation through natural language commands.

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

pip install mcp-google-sheets

uv add mcp-google-sheets

poetry add mcp-google-sheets

Installing mcp-google-sheets

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.

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 server

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.

Verify 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

Evidence: mcp_google_sheets-0.6.3-py3-none-any.whl

Tags

More Dynamic Content packages