What is Google Forms Mcp

google-forms-mcp is an MCP server that utilizes the Google Forms API to enable functionalities such as creating, editing, and retrieving responses for Google Forms.

Use cases

Use cases include automating the creation of feedback forms for events, managing surveys for research purposes, and integrating form responses into applications for data analysis.

How to use

To use google-forms-mcp, clone the repository, install dependencies, set up a Google Cloud project with the Google Forms API enabled, obtain OAuth 2.0 credentials, and configure environment variables. Finally, build and run the server using npm commands.

Key features

Key features include seamless integration with Google Forms API, the ability to create and manage forms programmatically, and easy retrieval of form responses.

Where to use

google-forms-mcp can be used in various fields such as education for surveys and quizzes, event management for feedback forms, and any scenario requiring data collection through forms.

Google Forms MCP Server

This MCP server uses the Google Forms API to provide functions such as creating, editing, and retrieving responses for forms.

Build Method

Initial Setup

After cloning the repository, install dependencies

cd google-forms-mcp

Build the Server

# Build the main MCP server
npm run build

Build the Refresh Token Acquisition Script

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

Execution in Development Environment

# Run the server directly
node build/index.js

# Or, use npm script
npm run start

Setup Method

1. Create a project in 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 OAuth 2.0 Client ID and Secret.

   • APIs & Services > Credentials > Create Credentials > OAuth client ID
   • Select Application type: “Desktop app”

3. Set 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
   

   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 Claude desktop app’s configuration file.

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

6. Restart the Claude desktop app.

Available Tools

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

Usage Example

Create a form and add some questions.

Claude uses MCP tools like the following to create the form:

1. Use the create_form tool to create a new form
2. Use add_text_question or add_multiple_choice_question tools to add questions
3. Display the URL of the created form