Overview
mcp-google-sheets is a Python-based MCP server that acts as a bridge between MCP-compatible clients (such as Claude Desktop) and the Google Sheets API. It exposes a curated set of tools that let you list, create, read, update, batch update, share, and manage spreadsheets and sheets, enabling AI-powered automation and data manipulation inside Google Sheets. The server connects to Google Drive as needed and supports running with a Service Account (recommended for servers), OAuth 2.0, or direct credential injection via environment variables. It can be deployed instantly with uvx or developed locally by cloning the repository. Authentication can be provided via SERVICE_ACCOUNT_PATH, DRIVE_FOLDER_ID, CREDENTIALS_PATH, TOKEN_PATH, CREDENTIALS_CONFIG, or via Google Application Default Credentials with fallback behavior. It includes MCP resources such as spreadsheet://{spreadsheet_id}/info for basic metadata and a suite of tools like list_spreadsheets, create_spreadsheet, get_sheet_data, get_sheet_formulas, update_cells, batch_update_cells, add_rows, list_sheets, create_sheet, and more. The README also covers usage patterns with Claude Desktop and Docker deployments, making it easy to integrate Google Sheets workflows into AI-assisted pipelines.
Features
Seamless Google Drive & Sheets integration
Directly interfaces with Google Drive and Google Sheets APIs to access and manipulate spreadsheets and folders.
Comprehensive toolset for spreadsheets
Provides CRUD, listing, batching, sharing, formatting and other spreadsheet operations exposed as MCP tools.
Flexible authentication
Supports Service Accounts (recommended), OAuth 2.0, and direct credential injection via environment variables (CREDENTIALS_CONFIG, SERVICE_ACCOUNT_PATH, etc.).
Zero-install deployment with uvx
Run instantly with uvx to fetch and run the latest server or clone for local development with uv.
AI-ready MCP client compatibility
Designed for MCP-compatible clients, enabling natural language interactions with Google Sheets.
Who Is This For?
- MCP developers:Build AI-powered workflows that read, write, and manage Google Sheets via MCP-compatible clients (e.g., Claude Desktop).
