MCP Server MCP

io.github.freema/mcp-gsheets

By github 👁 1 views ▲ 0 votes

MCP server for Google Sheets API — read, write, format, batch operations.

Homepage Verified source GitHub

Install

npx -y [email protected]

Configuration Example

{
  "remotes": [],
  "packages": [
    {
      "registryType": "npm",
      "registryBaseUrl": "https://registry.npmjs.org",
      "identifier": "mcp-gsheets",
      "version": "1.10.1",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "Google Cloud project ID",
          "isRequired": true,
          "name": "GOOGLE_PROJECT_ID"
        },
        {
          "description": "Path to service account key JSON file (auth method 1)",
          "name": "GOOGLE_APPLICATION_CREDENTIALS"
        },
        {
          "description": "Service account key as JSON string (auth method 2)",
          "isSecret": true,
          "name": "GOOGLE_SERVICE_ACCOUNT_KEY"
        },
        {
          "description": "Service account private key in PEM format (auth method 3)",
          "isSecret": true,
          "name": "GOOGLE_PRIVATE_KEY"
        },
        {
          "description": "Service account email (auth method 3)",
          "name": "GOOGLE_CLIENT_EMAIL"
        }
      ]
    }
  ]
}

mcp model-context-protocol npm