Back to MCP Servers
🔌

freema/mcp-gsheets

MITAPI key required

📇 ☁️ - MCP server for Google Sheets API integration with comprehensive reading, writing, formatting, and sheet management capabilities.

TypeScriptCommunication

Install

npx -y mcp-gsheets@latest

Required environment variables

GOOGLE_SERVICE_ACCOUNT_KEYSet in your MCP config
GOOGLE_PRIVATE_KEYSet in your MCP config

claude_desktop_config.json

claude_desktop_config.json
{
  "mcpServers": {
    "freema-mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets@latest"
      ],
      "env": {
        "GOOGLE_SERVICE_ACCOUNT_KEY": "<YOUR_GOOGLE_SERVICE_ACCOUNT_KEY>",
        "GOOGLE_PRIVATE_KEY": "<YOUR_GOOGLE_PRIVATE_KEY>"
      }
    }
  }
}

Add this to your Claude Desktop config file. Find it at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS.