Sheets MCP — Servidor Google Sheets Minimalista
jowtron/sheets-mcp
Google Sheets no Claude via gcloud ADC — sem OAuth complexo
Ver no GitHubServidor MCP que fornece acesso de leitura e escrita a seus Google Sheets via Application Default Credentials (gcloud), sem necessidade de configurar OAuth callback ou contas de serviço. Suporta leitura/escrita de valores e fórmulas live.
Instalação
npx convez-ai jowtron/sheets-mcp1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.
Métricas
Casos de uso
- Automatizar leitura e atualização de planilhas diretamente do Claude
- Sincronizar dados entre Claude e Google Sheets com fórmulas vivas
- Consultar e modificar múltiplas abas sem configuração extra de credenciais
Veredito

Solução prática e bem pensada para integração Sheets-Claude que elimina fricção de OAuth/service accounts. Recomendado para quem quer automação de planilhas direto no Claude com overhead mínimo de setup.
README
A tradução para o português deste README ainda está na fila.
sheets-mcp
A tiny Model Context Protocol server that gives an MCP client (Claude Code, Claude Desktop, etc.) read/write access to your own Google Sheets — including writing live formulas, not just values.
What makes this one different
Most Google Sheets MCP servers make you run a bespoke OAuth callback server and juggle
token.json, or set up a service account and share each sheet with its robot email. This
one leans on gcloud Application Default Credentials so the credential storage/refresh
is handled for you:
- ✅ No bespoke OAuth flow or
token.jsonjuggling in the app —gcloudowns the token - ✅ No service-account key files, no sharing each sheet with a robot email
- ✅ No new Google Cloud project (reuse any existing one for quota)
- ✅ Works across every sheet your Google account can edit
Note: Google now blocks sensitive scopes (like
spreadsheets) on gcloud's built-in client ID, so you do need to create your own lightweight OAuth client (Desktop type) once and pass it via--client-id-file. It's a 5-minute, one-time step in an existing project — see setup below. After that, auth is justgcloud auth application-default login.
Tools
| Tool | Description |
|---|---|
list_sheets | List your spreadsheets (id + name), optionally filtered by name |
read_range | Read a range's displayed values (A1 notation) |
read_formulas | Read the underlying formulas — see what's a formula vs a typed value |
write_range | Write values or formulas to a range (USER_ENTERED, so =SUM(...) goes live) |
append_rows | Append rows to the end of a sheet's data |
Setup
Requires Node 18+ and the gcloud CLI.
npm install
# 1. Enable the APIs on any project you own (one-time)
gcloud services enable sheets.googleapis.com drive.googleapis.com --project=YOUR_PROJECT_ID
# 2. Create an OAuth client (one-time, in the Cloud Console GUI):
# APIs & Services > OAuth consent screen > External, add yourself as a Test user.
# APIs & Services > Credentials > Create credentials > OAuth client ID > Desktop app.
# Download the JSON (e.g. to ~/oauth-client.json).
# 3. Log in with ADC using YOUR client (one line; cloud-platform scope is required)
gcloud auth application-default login --client-id-file=$HOME/oauth-client.json --scopes=https://www.googleapis.com/auth/cloud-platform,https://www.googleapis.com/auth/spreadsheets,https://www.googleapis.com/auth/drive.readonly
# 4. Point ADC's quota project at that project
gcloud auth application-default set-quota-project YOUR_PROJECT_ID
# 5. Register with Claude Code
claude mcp add sheets-mcp -- node "$(pwd)/src/index.js"
Restart your MCP client and the tools appear.
Works with any MCP client (Claude Code, Claude Desktop, Cursor, etc.) — it's a standard stdio MCP server. For non-Claude clients, point the client at
node /path/to/src/index.jsinstead of usingclaude mcp add.
Security
- No secrets live in this repo. ADC credentials are stored by
gcloudin~/.config/gcloud/, never here. - The
spreadsheetsscope grants write access to your sheets. Revoke anytime withgcloud auth application-default revokeor at https://myaccount.google.com/permissions.
License
MIT