Google Sheets

Name: Google Sheets MCP Server
Author: Google Sheets

stdio

Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting

Getting Started

npx @getmcp/cli add io.github.mcp-z/mcp-sheets

Requires Node.js 18+. Community-contributed server. Review source before installing.

Claude Desktop guide →Vscode guide →Cursor guide →Windsurf guide →

Required Environment Variables

GOOGLE_CLIENT_ID
Google OAuth client ID (required for OAuth authentication modes)

Configuration

Config file: ~/Library/Application Support/Claude/claude_desktop_config.json

JSON

{
  "mcpServers": {
    "io.github.mcp-z/mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "",
        "GOOGLE_CLIENT_SECRET": "",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "",
        "AUTH_MODE": "loopback-oauth",
        "HEADLESS": "false",
        "REDIRECT_URI": "",
        "RESOURCE_STORE_URI": "file://~/.mcp-z/mcp-sheets/files",
        "PORT": "",
        "BASE_URL": "",
        "LOG_LEVEL": "info"
      }
    }
  }
}

Claude Desktop MCP documentation