convez.ai
MCP ServerAutomaçãoIntermediário
MatthewWolff

Google Forms MCP Server

MatthewWolff/google-forms-mcp

Automação completa de Google Forms dentro do Claude

Ver no GitHub
InicialPluginScore · de 0 a 100

Servidor MCP completo para a API do Google Forms que permite criar, gerenciar e analisar formulários via Claude. Inclui suporte a todos os tipos de perguntas, respostas, webhooks e análises integradas de dados.

Instalação

$npx convez-ai MatthewWolff/google-forms-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
100%
Último commit
há 5 meses
Versão
v1.0.2
Issues abertas
0
Contribuidores
1

Casos de uso

  • Criar e gerenciar formulários programaticamente via IA
  • Analisar respostas e gerar gráficos (Sankey, frequência cruzada)
  • Automatizar workflows de coleta de dados com notificações em tempo real
  • Exportar respostas em CSV e criar relatórios automatizados

Veredito

MCP robusto e bem documentado para quem precisa integrar Google Forms com fluxos de IA. Cobertura API completa e ferramentas analíticas nativas eliminam chamadas repetitivas. Exige credenciais OAuth corretamente configuradas.

README

A tradução para o português deste README ainda está na fila.

Google Forms MCP Server

npm version Node.js License: MIT

A comprehensive Model Context Protocol server for the Google Forms API. Enables LLMs to create, manage, and analyze Google Forms.

Install

npx @matthewwolff/google-forms-mcp

Or install globally:

npm install -g @matthewwolff/google-forms-mcp
google-forms-mcp

Setup

1. Google Cloud project

  1. Create a project in Google Cloud Console
  2. Enable the Google Forms API and Google Drive API
  3. Configure the OAuth consent screen (External, add your email as a test user)
  4. Create an OAuth 2.0 Client ID (Application type: Desktop app)
  5. Note your Client ID and Client Secret

2. Get a refresh token

GOOGLE_CLIENT_ID="your_id" GOOGLE_CLIENT_SECRET="your_secret" npx @matthewwolff/google-forms-mcp-auth

This opens a browser for OAuth consent and prints your refresh token.

3. Add to your MCP client

Claude Code (~/.claude/settings.json):

{
  "mcpServers": {
    "google-forms": {
      "command": "npx",
      "args": ["-y", "@matthewwolff/google-forms-mcp"],
      "env": {
        "GOOGLE_CLIENT_ID": "your_client_id",
        "GOOGLE_CLIENT_SECRET": "your_client_secret",
        "GOOGLE_REFRESH_TOKEN": "your_refresh_token"
      }
    }
  }
}

Claude Desktop (~/Library/Application Support/Claude/claude_desktop_config.json):

{
  "mcpServers": {
    "google-forms": {
      "command": "npx",
      "args": ["-y", "@matthewwolff/google-forms-mcp"],
      "env": {
        "GOOGLE_CLIENT_ID": "your_client_id",
        "GOOGLE_CLIENT_SECRET": "your_client_secret",
        "GOOGLE_REFRESH_TOKEN": "your_refresh_token"
      }
    }
  }
}

Tools

CategoryToolsCapability
Formscreate_form, get_form, list_forms, delete_form, update_form_info, update_form_settingsFull form lifecycle
Itemsadd_question, add_section, add_text_item, update_item, delete_item, move_itemAll question types: radio, checkbox, dropdown, text, paragraph, scale, date, time, rating
Responseslist_responses, get_responsePaginated retrieval with timestamp filtering
Watchescreate_watch, list_watches, delete_watch, renew_watchPub/Sub notifications on submissions or schema changes
Compositebuild_form, get_form_summary, get_responses_table, clone_form, export_responses_csvHigh-level operations that would otherwise take multiple calls
Analyticsanalyze_frequency, cross_tabulate, generate_sankey_data, response_summaryIn-server data analysis

Examples

Build an entire form in one call

Use build_form to create a feedback survey with:
- Section "About You": name (text), role (dropdown: Engineer/Designer/PM)
- Section "Feedback": rating (scale 1-10), comments (paragraph)

Generate Sankey diagram data

Use generate_sankey_data on form XYZ with stages:
["How did you hear about us?", "Which plan did you choose?", "Are you still using it?"]

Returns source/target/value triples ready for SankeyMATIC or D3:

[
  { "source": "Google Search", "target": "Free", "value": 12 },
  { "source": "Google Search", "target": "Pro", "value": 8 },
  { "source": "Friend referral", "target": "Pro", "value": 6 }
]

Export responses as CSV

Use export_responses_csv on form XYZ

Troubleshooting

"Google Forms API has not been used in project..." Enable the Forms API (and Drive API) in your Google Cloud Console.

Refresh token stops working after 7 days Your OAuth app is likely in "Testing" mode. Publish it in the consent screen settings, or re-run the auth flow.

"Request had insufficient authentication scopes" Re-run npx @matthewwolff/google-forms-mcp-auth to get a new token with the correct scopes.

Development

git clone https://github.com/MatthewWolff/google-forms-mcp
cd google-forms-mcp
npm install
npm run build
cp .env.example .env  # fill in your credentials
npm run test:integration

Architecture

src/
  index.ts              # MCP server entry point (stdio transport)
  auth.ts               # OAuth2 client factory
  get-refresh-token.ts  # Token acquisition script
  tools/
    forms/              # CRUD on forms
    items/              # Questions, sections, text blocks
    responses/          # Submission retrieval
    watches/            # Pub/Sub notification management
    composite/          # High-level multi-step operations
    analytics/          # In-server data analysis

License

MIT

Ver o original no GitHub

Bom para

Relacionados