Mcp Gsheets

Overview

Mcp Gsheets is an MCP server that connects AI assistants to the Google Sheets API. It lets Claude, Cursor, VS Code, and other MCP clients read, write, format, and perform batch operations on your spreadsheets directly from conversation.

Run it locally with npx -y mcp-gsheets. You'll need a Google Project ID and API key set in your environment as GOOGLE_PROJECT_ID. The latest release is v1.10.1, published under the MIT license. Find the source code on GitHub at freema/mcp-gsheets, where the project has 95 stars.

Mcp Gsheets lives in the Development category on mcp.site and works with Claude Desktop, Claude Code, Cursor, VS Code, Windsurf, Zed, and other MCP clients. If you maintain this server, claim your listing to earn the Verified badge and keep information up to date.

Installation

// claude_desktop_config.json
{
  "mcpServers": {
    "mcp_gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "<google-project-id>"
      }
    }
  }
}

Requires GOOGLE_PROJECT_ID