MCP Gsheets MCP Server

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

claude mcp add mcp-gsheets -- npx -y mcp-gsheets

{
  "mcpServers": {
    "mcp-gsheets": {
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "command": "npx"
    }
  }
}

[mcp_servers.mcp-gsheets]
command = "npx"
args = ["-y", "mcp-gsheets"]

{
  "mcpServers": {
    "mcp-gsheets": {
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "command": "npx"
    }
  }
}

{
  "mcpServers": {
    "mcp-gsheets": {
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "command": "npx"
    }
  }
}

This one needs environment variables set before it will start: GOOGLE_PROJECT_ID (Google Cloud project ID), GOOGLE_APPLICATION_CREDENTIALS (Path to service account key JSON file (auth method 1)), GOOGLE_SERVICE_ACCOUNT_KEY (Service account key as JSON string (auth method 2)), GOOGLE_PRIVATE_KEY (Service account private key in PEM format (auth method 3)), GOOGLE_CLIENT_EMAIL (Service account email (auth method 3)). The author declared them in the registry entry; get the values from the project itself.