convez.ai
MCP ServerIntegração & APIsIntermediário
jowtron

Sheets MCP — Servidor Google Sheets Minimalista

jowtron/sheets-mcp

Google Sheets no Claude via gcloud ADC — sem OAuth complexo

Ver no GitHub
InicialPluginScore · de 0 a 100

Servidor 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-mcp

1 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

Estrelas
0
Forks
0
Acompanhando
0
Saúde
42%
Último commit
há 5 meses
Versão
v0.1.0
Issues abertas
0
Contribuidores
1

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.json juggling in the app — gcloud owns 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 just gcloud auth application-default login.

Tools

ToolDescription
list_sheetsList your spreadsheets (id + name), optionally filtered by name
read_rangeRead a range's displayed values (A1 notation)
read_formulasRead the underlying formulas — see what's a formula vs a typed value
write_rangeWrite values or formulas to a range (USER_ENTERED, so =SUM(...) goes live)
append_rowsAppend 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.js instead of using claude mcp add.

Security

  • No secrets live in this repo. ADC credentials are stored by gcloud in ~/.config/gcloud/, never here.
  • The spreadsheets scope grants write access to your sheets. Revoke anytime with gcloud auth application-default revoke or at https://myaccount.google.com/permissions.

License

MIT

Ver o original no GitHub

Bom para

Relacionados