Loading...

Typeform

Answers to your Typeform forms (one column per question), responses per day, visits and completion rate.

The Typeform connector brings your form data into the sheet: individual responses with one column per question, or aggregated counts (responses per day, per platform, per answer to a question), plus the form insights (visits, completion rate, drop-offs per question).

The connection does not use a Google login: you enter a Typeform Personal Access Token, created from Account > Personal tokens > Generate a new token with the accounts:read, forms:read and responses:read scopes. The token is verified immediately and works for accounts on both the global and the EU data center (the connector detects which one to use).

In the report you pick the form as the "property": that form's questions and hidden fields automatically appear among the dimensions ("Q: ..." and "Hidden: ..." entries).

Metrics and dimensions are split into three categories, one per report: responses (the responses, filtered by period), insights (visits and completion per platform, all-time figure for the form) and insights_questions (views and drop-offs per question, all-time figure for the form).

Available metrics

Metric Period Aggregation Note
Responses period sum responses category. Number of completed responses in the period.
Time to Complete (seconds, total) period sum responses category. Sum of the seconds between landing and submission.
Time to Complete (seconds, average) period avg responses category. Recalculated per row and in the totals as total time / responses.
Score (total) period sum responses category. Sum of the score calculated by Typeform (quiz/logic), 0 if the form does not use it.
Score (average) period avg responses category. Total score / responses.
Total Visits all-time sum insights category. All-time figure for the form, the report period is ignored.
Unique Visits all-time sum insights category. All-time figure for the form.
Responses (Insights) all-time sum insights category. All-time figure for the form, it can differ from the responses category count because the latter is filtered by period.
Completion Rate (%) all-time avg insights category. As calculated by Typeform, as a percentage. The totals row uses the form-level value provided by Typeform.
Average Time (seconds) all-time avg insights category. Average completion time, converted from milliseconds to seconds.
Views all-time sum insights_questions category. How many times the question was viewed, all-time.
Drop-offs all-time sum insights_questions category. How many respondents left the form on that question, all-time.
Drop-off Rate (%) all-time avg insights_questions category. Drop-offs / views x 100, recalculated in the totals too.

Available dimensions

Dimension Note
Date (Submitted) responses category. Submission date of the response, in the sheet timezone. On its own it yields responses per day.
Submitted At responses category. Full submission date and time.
Landed At responses category. Date and time the respondent opened the form.
Response ID responses category. Add it to get one row per individual response.
Response Token responses category. Technical response identifier used by Typeform.
Form ID All categories.
Form Title All categories.
Platform responses and insights categories: desktop, phone, tablet or other.
Browser responses category.
Referer responses category. URL of the page the form was opened from.
User Agent responses category.
Network ID responses category. Anonymous network identifier assigned by Typeform.
Q: <question> (one per form question) responses category. One dimension per question of the selected form, named after the question text. Multiple choices comma separated, rankings in the respondent's order ("A > B > C"), yes/no as true/false. Questions inside groups or matrices appear as "Group / Question".
Hidden: <name> (one per hidden field) responses category. The hidden field value passed in the form URL (e.g. utm_source).
Question ID insights_questions category.
Question Ref insights_questions category. The readable reference assigned to the question in Typeform.
Question Title insights_questions category.
Question Type insights_questions category (e.g. multiple_choice, short_text, rating).

Known limits

  • One category per report
    responses, insights and insights_questions read different endpoints with different granularity: a single report cannot mix metrics or dimensions from different categories, saving blocks it. To compare them you need separate reports.
  • Completed responses only
    The responses category only includes fully submitted responses (response_type=completed): partial responses do not appear. How many started without finishing comes from the insights (visits vs responses, drop-offs per question).
  • Insights have no period and are not on every plan
    The insights and insights_questions categories are always the all-time figure for the form (the Typeform API does not accept a date range) and the Insights API is not available on every Typeform plan: in that case the report returns an explicit Typeform error (403).
  • Max 50,000 responses per report and a few minutes of delay
    The connector downloads at most 50,000 responses per single report (50 pages of 1,000): narrow the period for larger forms. Typeform itself warns that responses from roughly the last 30 minutes may not be available through the API yet.

Execution notes

In the responses category the report period filters responses by submission date (submitted_at, in UTC); only completed responses are included, not partial ones. Rows are aggregated by the dimensions you choose: with only "Date (Submitted)" you get responses per day, adding "Response ID" you get one row per response. Averages (time to complete, score) and the totals row are always recalculated as a ratio of sums, never as an average of averages.

The insights and insights_questions categories ignore the report period: the Typeform Insights API only returns the all-time figure for the form since its creation. "Completion Rate" is a percentage (0-100), "Average Time" is converted to seconds (the API returns milliseconds).

Dates and times are shown in the sheet's timezone (script settings), while Typeform shows them in the account's timezone: close to midnight the same response can fall on two different days in the two tools.

Typeform limits the API to 2 requests per second per account: on forms with tens of thousands of responses a run can take a few dozen seconds.