Google Forms MCP

🚀 Google Forms MCP Server

This MCP server utilizes the Google Forms API to offer functions such as creating, editing, and retrieving form responses.

🚀 Quick Start

✨ Features

This MCP server provides the following tools:

1. create_form - Create a new Google Form
2. add_text_question - Add a text question to the form
3. add_multiple_choice_question - Add a multiple-choice question to the form
4. get_form - Get form details
5. get_form_responses - Get form responses

📦 Installation

Initial Setup

After cloning the repository, install the dependencies:

cd google-forms-mcp

Build the Server

# Build the main MCP server
npm run build

Build the Refresh Token Retrieval Script

# Build the refresh token retrieval script
npm run build:token

Execution in the Development Environment

# Run the server directly
node build/index.js

# Or use the npm script
npm run start

📚 Documentation

Setup Method

1. Create a project in the Google Cloud Console and enable the Google Forms API.

   • https://console.cloud.google.com/
   • Search for "Google Forms API" from APIs & Services > Library and enable it.

2. Obtain the OAuth 2.0 client ID and secret.

   • APIs & Services > Credentials > Create Credentials > OAuth Client ID
   • Select the application type: "Desktop App"

3. Set the environment variables and obtain the refresh token.

   export GOOGLE_CLIENT_ID="YOUR_CLIENT_ID"
   export GOOGLE_CLIENT_SECRET="YOUR_CLIENT_SECRET"
   cd google-forms-mcp
   npm run build
   node build/get-refresh-token.js
   

   ⚠️ Important Note

   If an error occurs when running get-refresh-token.js, execute the following command:

   cd google-forms-mcp
   npm run build:token
   node build/get-refresh-token.js
   

4. Copy the displayed refresh token.

5. Update the configuration file of the Claude desktop application.

   • Open ~/Library/Application Support/Claude/claude_desktop_config.json.
   • Add the environment variables to google-forms-mcp in the mcpServers section:

   "google-forms-mcp": {
     "command": "node",
     "args": [
       "/path/to/your/google-forms-mcp/build/index.js" # Update this path
     ],
     "env": {
       "GOOGLE_CLIENT_ID": "YOUR_CLIENT_ID",
       "GOOGLE_CLIENT_SECRET": "YOUR_CLIENT_SECRET",
       "GOOGLE_REFRESH_TOKEN": "YOUR_REFRESH_TOKEN"
     }
   }
   

6. Restart the Claude desktop application.