Data Overview

Coupler.io pulls two types of data from Google Forms: the structure of the form itself and the responses submitted by respondents. Together, these give you a complete picture of both what you asked and what people answered.

Entities

Entity	What it contains
Forms	Form title, description, question text, question types, answer options, and form-level settings
Form responses	One row per submission — respondent ID, submission timestamp, and answers to each question

Available fields

Forms fields

Field	Description
form_id	Unique identifier for the form
title	The title of the form
description	The description shown to respondents
document_title	The document title (may differ from the visible form title)
is_quiz	Whether the form is set up as a quiz
item_id	Unique ID for each question or item
item_title	The question text
item_description	Optional helper text shown under the question
item_type	Question type (e.g., multiple choice, short answer, checkboxes, linear scale)
required	Whether the question is marked as required
options	Available answer choices (for multiple choice and checkbox questions)

Form responses fields

Field	Description
response_id	Unique identifier for each submission
form_id	The form this response belongs to
create_time	Timestamp when the response was submitted
last_submitted_time	Timestamp of the most recent edit to the response
respondent_email	Email address of the respondent (only available if the form collects emails)
item_id	The question this answer belongs to
item_title	The question text at time of submission
answer_value	The respondent's answer
score	Score awarded (quiz forms only)

Common field combinations

• Response analysis: response_id + create_time + item_title + answer_value — the core dataset for analyzing what respondents said

• Response volume tracking: form_id + create_time — count submissions over time to track response rates

• Quiz scoring: response_id + respondent_email + score — identify how individuals performed

• Answer distribution: item_title + answer_value — group and count answers to see which options are most popular

Use cases by role

Marketers

• Export lead generation form responses into Google Sheets or BigQuery for CRM enrichment

• Track submission volume over time to measure campaign performance

• Merge responses from multiple campaign forms using the Append transformation in Coupler.io

• Send open-text feedback to ChatGPT or Claude for sentiment analysis and theme extraction

HR & Operations

Researchers & Educators

Platform-specific notes

• Google Forms does not provide real-time webhooks — Coupler.io polls the API on your chosen schedule

• The respondent_email field is only populated if the form has Collect email addresses enabled in settings

• If you edit a question after responses have been collected, the item_title in older responses may differ from the current question text

• File upload question types return a Google Drive file URL, not the file itself

• For forms with many questions, each question appears as a separate row in the Forms entity — use the Form responses entity for a respondent-per-row view

• The API returns a maximum of 5,000 responses per request; Coupler.io handles pagination automatically