Skip to content
appsgit

MCP Google Sheets

MCP Google Sheets is an MCP server that adds productivity tools to AI assistants such as Claude Desktop, Claude Code and Cursor. This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets. It has 1,013 GitHub stars, is released under the MIT license and runs locally with uvx mcp-google-sheets.

github.com/xing5/mcp-google-sheets (opens in a new tab)

Data as of from the GitHub API; description from the project's repository. Report an error

View on GitHub (opens in a new tab)

Install MCP Google Sheets

Generated from the server's published package. Replace your-value with your own values.

Claude Desktop

claude_desktop_config.json
{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "CREDENTIALS_PATH": "your-value",
        "TOKEN_PATH": "your-value",
        "CREDENTIALS_CONFIG": "your-value",
        "GOOGLE_APPLICATION_CREDENTIALS": "your-value"
      }
    }
  }
}

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

Claude Code

claude mcp add --env CREDENTIALS_PATH=your-value --env TOKEN_PATH=your-value --env CREDENTIALS_CONFIG=your-value --env GOOGLE_APPLICATION_CREDENTIALS=your-value --transport stdio mcp-google-sheets -- uvx mcp-google-sheets

Cursor

.cursor/mcp.json
{
  "mcpServers": {
    "mcp-google-sheets": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "CREDENTIALS_PATH": "your-value",
        "TOKEN_PATH": "your-value",
        "CREDENTIALS_CONFIG": "your-value",
        "GOOGLE_APPLICATION_CREDENTIALS": "your-value"
      }
    }
  }
}

Project file; use ~/.cursor/mcp.json to enable it in every project.

VS Code

.vscode/mcp.json
{
  "inputs": [
    {
      "type": "promptString",
      "id": "credentials_path",
      "description": "CREDENTIALS_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "token_path",
      "description": "TOKEN_PATH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "credentials_config",
      "description": "CREDENTIALS_CONFIG",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google_application_credentials",
      "description": "GOOGLE_APPLICATION_CREDENTIALS",
      "password": true
    }
  ],
  "servers": {
    "mcp-google-sheets": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "CREDENTIALS_PATH": "${input:credentials_path}",
        "TOKEN_PATH": "${input:token_path}",
        "CREDENTIALS_CONFIG": "${input:credentials_config}",
        "GOOGLE_APPLICATION_CREDENTIALS": "${input:google_application_credentials}"
      }
    }
  }
}

Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).

Environment variables

Variables the server reads at startup.

NameRequiredDescription
SERVICE_ACCOUNT_PATHNoShown in the README's example configuration.
ENABLED_TOOLSNoShown in the README's example configuration.
DRIVE_FOLDER_IDNoShown in the README's example configuration.
CREDENTIALS_PATHsecretNoShown in the README's example configuration.
TOKEN_PATHsecretNoShown in the README's example configuration.
CREDENTIALS_CONFIGsecretNoShown in the README's example configuration.
GOOGLE_APPLICATION_CREDENTIALSsecretNoShown in the README's example configuration.

About MCP Google Sheets

Your AI Assistant's Gateway to Google Sheets! 📊 mcp-google-sheets is a Python-based MCP server that acts as a bridge between any MCP-compatible client (like Claude Desktop) and the Google Sheets API. It allows you to interact with your Google Spreadsheets using a defined set of tools, enabling powerful automation and data manipulation workflows driven by AI.

  • google
  • mcp
  • mcp-server
  • spreadsheet

Similar MCP servers

More productivity MCP servers

All Productivity

FAQ

MCP Google Sheets FAQ

Still curious? Email info@appsgit.com.

How do I install the MCP Google Sheets MCP server?

Add the command uvx mcp-google-sheets to your MCP client: put it in claude_desktop_config.json for Claude Desktop, run claude mcp add for Claude Code, or add it to .cursor/mcp.json (Cursor) or .vscode/mcp.json (VS Code). The snippets on this page are ready to paste.

Is MCP Google Sheets free?

The server is open source under the MIT license, so running it is free. It needs credentials (CREDENTIALS_PATH, TOKEN_PATH, CREDENTIALS_CONFIG and GOOGLE_APPLICATION_CREDENTIALS) for the service it connects to, which may require a paid account.

Is MCP Google Sheets actively maintained?

The most recent commit was on May 14, 2026. The latest release is v0.6.3, published May 14, 2026. appsgit only lists MCP servers with a commit in the last six months.