Google Sheets MCP Logo

About 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.