# Google Forms MCP

> Google Forms MCP lets your AI client analyze data directly from Google Forms. List every active survey instance under your account, check the exact structure of any form, and pull all raw submitted answers without manually downloading CSV files. Stop sifting through dense charts; just chat with your form matrix to get instant insights.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Tags:** data-collection, survey-analysis, response-tracking, form-automation, data-extraction

## Description

Managing feedback surveys shouldn't mean staring at spreadsheets or refreshing dashboards every fifteen minutes. This MCP connects Google Forms directly to your AI client, letting you talk to your data pipeline instead of wrestling with it. You can ask your agent specific questions—like 'What were the top three complaints from the Q3 event?'—and get an immediate summary built from thousands of responses. Need to know if a new question is structured correctly? Use the MCP to instantly validate the form's schema. This means you don't waste time verifying column headers or worrying about data types. Through Vinkius, your AI client gets access to this entire catalog, making it easy to connect Google Forms alongside other business tools for deep analysis. It simply makes complex feedback collection conversational.

## Tools

### get_form_metadata
Retrieves the detailed structure and field types (schema) for any specified Google Form.

### get_form_responses
Pulls all collected answers, row by row, from a specific form instance.

## Prompt Examples

**Prompt:** 
```
Read the form metadata and structure for the Form ID 'abc123xyz'.
```

**Response:** 
```
I've fetched the structure. The active Form is titled 'Post-Event Feedback 2024'. It contains 4 explicit questions, including 'Rate your experience (1-10)' and 'Freeform Comments'.
```

**Prompt:** 
```
Fetch the responses recorded today in the Sales Survey (Form ID abc). Summarize the general satisfaction.
```

**Response:** 
```
I've captured 22 recent responses. Across those payloads, the prevalent satisfaction score hovers between 8 and 9. Top positive highlight: 'Fast customer service'. Negative outliers point out a lack of documentation.
```

**Prompt:** 
```
List all active form instances under my account to find the latest specific quiz run.
```

**Response:** 
```
Search initialized. Under your root index I discovered two forms matching normal schemas: 'Marketing Q1 Trends' (ID 4122) and 'Staff Quiz Baseline' (ID 198a). Which one should I focus on?
```

## Capabilities

### List all active surveys
Find every form running under your account using its unique file ID.

### Check survey structure
Examine the metadata and schema of a specific form to see exactly what questions it asks.

### Retrieve all responses
Pull every single answer submitted for a given form into your chat window for analysis.

### Summarize feedback trends
Get an AI summary of general sentiment or specific score ranges from the collected answers.

### Validate question types
Confirm if a form field is set up as text, multiple choice, or a rating scale.

## Use Cases

### Determining post-launch product sentiment
A Product Manager needs to know if the new checkout flow is confusing. They ask their agent to 'Get all responses for the Checkout Survey' and ask for a summary of negative comments about payment fields. The agent pulls the raw data using `get_form_responses` and highlights common complaints instantly.

### Checking event survey readiness
An Event Coordinator needs to verify if their 'Speaker Feedback' form is ready for the next cohort. They use the MCP to call `get_form_metadata`, which immediately confirms the schema and shows that the required rating scale field is present.

### Comparing regional campaign performance
A Marketing Analyst manages three distinct campaigns. Instead of opening three separate reports, they ask their agent to list all active forms via the MCP, then target the specific form IDs to pull and compare response counts from each region in one chat session.

### Auditing data collection before launch
A PM wants to make sure a new quiz captures enough detail. They use `get_form_metadata` on the test form ID, confirming that it includes both quantitative rating fields and mandatory free-text comment sections.

## Benefits

- Stop downloading CSVs. Instead of refreshing massive spreadsheets, ask your agent to pull raw answers directly into the chat window for immediate analysis using `get_form_responses`.
- Pinpoint exactly what data you're collecting. Use `get_form_metadata` to verify the schema and check if a survey question was set up correctly before launch.
- Move beyond simple counts. Your agent can read all responses and summarize complex trends, like identifying patterns in open-ended comments that signal system failures or feature gaps.
- Handle large event data sets effortlessly. You don't need to write complex queries; you just tell your AI client which form ID to analyze and get the full picture instantly.
- Streamline onboarding for new analysts. Instead of spending hours learning Google Forms API documentation, you simply use natural language prompts with this MCP.

## How It Works

The bottom line is you don't have to write complex API calls; you just tell your AI client what data you want, and it handles the connection.

1. Install and subscribe to the Google Forms MCP via Vinkius.
2. Authorize access using standard OAuth 2.0 credentials pointing to your Workspace account.
3. Execute a read command, telling your agent exactly what data you need (e.g., 'Get all responses for the Q4 survey').

## Frequently Asked Questions

**How do I use Google Forms MCP to list all my forms?**
You can start by asking your agent to list all active form instances. The tool finds every form ID under your account, giving you a directory of all available surveys.

**Can the Google Forms MCP summarize open-ended comments?**
Yes. After running `get_form_responses`, your agent can analyze the raw text answers and provide summaries or categorize recurring themes from qualitative feedback.

**Do I need to manually download data if I use get_form_responses?**
No, you don't. This MCP streams all the collected responses directly into your chat environment for your agent to process and summarize immediately.

**What is the difference between `get_form_metadata` and `get_form_responses`?**
`get_form_metadata` reads the structure (the questions asked), while `get_form_responses` pulls the actual data (the answers given) for a specific form ID.

**Does Google Forms MCP handle quizzes and tests?**
Yes. It treats quiz responses just like any other survey feedback, allowing you to retrieve both the raw scores and comments attached to those submissions.