Skip to content
mcp/harbor
Gemini CLI

Google Sheets MCP for Gemini CLI

com.renzojohnson/google-sheets-mcp

Google Sheets MCP server: read ranges, append rows, update cells and add tabs.

client:Gemini CLI transport:stdio runtime:npm

Install Google Sheets MCP in Gemini CLI

~/.gemini/settings.json · windows: %USERPROFILE%\.gemini\settings.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen. 

{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@renzo.johnson/google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
        "GOOGLE_OAUTH_CLIENT_ID": "<GOOGLE_OAUTH_CLIENT_ID>",
        "GOOGLE_OAUTH_CLIENT_SECRET": "<GOOGLE_OAUTH_CLIENT_SECRET>",
        "GOOGLE_OAUTH_REFRESH_TOKEN": "<GOOGLE_OAUTH_REFRESH_TOKEN>"
      }
    }
  }
}

Gemini expands $VAR and ${VAR} inside env values, so a secret can live in your shell rather than this file. Gemini CLI docs

Google Sheets MCP in other clients

Google Sheets MCP MCP server