Skip to content
Book a demoStart free
Connectors

Typeform connector

Set up the Typeform connector in Kaivo: authentication, configuration, the 6 BigQuery tables it syncs, and answers to common questions.

Typeform connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Typeform data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your survey and email data instead of moving it.

Sync your Typeform forms and responses into BigQuery with Kaivo to analyse survey and form data alongside the rest of your data.

CategorySurveys & Email
AuthenticationAPI key
SetupSelf-service

Getting started with the Typeform connector

Section titled “Getting started with the Typeform connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Typeform account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Private Token.

Field Description
Private Token
Log into your Typeform account and then generate a personal Access Token.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

| | Form IDs to replicate |

When this parameter is set, the connector will replicate data only from the specified forms. Otherwise, all forms in your Typeform account will be replicated. You can find form IDs in your form URLs. For example, in the URL “https://mysite.typeform.com/to/u6nXL7” the form ID is u6nXL7.

|

Kaivo syncs 6 tables from Typeform into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

forms (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier of the form
type STRING Type of the form
created_at TIMESTAMP Date and time when the form was created
last_updated_at TIMESTAMP Date and time when the form was last updated
published_at TIMESTAMP Date and time when the form was published
title STRING Title of the form
workspace__href STRING URL of the workspace
theme__href STRING URL of the theme
settings__language STRING Language of the form
settings__progress_bar STRING Progress bar settings
settings__meta__allow_indexing BOOL Flag indicating if indexing is allowed
settings__meta__title STRING Title of the form
settings__meta__description STRING Description of the form
settings__meta__image__href STRING URL of the form image
settings__hide_navigation BOOL Flag indicating if navigation is hidden
settings__is_public BOOL Flag indicating if the form is public
settings__is_trial BOOL Flag indicating if the form is a trial version
settings__show_progress_bar BOOL Flag indicating if progress bar is displayed
settings__show_typeform_branding BOOL Flag indicating if Typeform branding is displayed
settings__are_uploads_public BOOL Flag indicating if uploads are public
settings__show_time_to_complete BOOL Flag indicating if time to complete is displayed
settings__redirect_after_submit_url STRING URL to redirect after form submission
settings__google_analytics STRING Google Analytics settings
settings__facebook_pixel STRING Facebook Pixel settings
settings__google_tag_manager STRING Google Tag Manager settings
settings__capabilities__e2e_encryption__enabled BOOL Flag indicating if end-to-end encryption is enabled
settings__capabilities__e2e_encryption__modifiable BOOL Flag indicating if encryption is modifiable
settings__notifications__self__enabled BOOL Flag indicating if self notifications are enabled
settings__notifications__self__subject STRING Subject of self notifications
settings__notifications__self__message STRING Message for self notifications
settings__notifications__self__reply_to STRING Email address for self notifications
settings__notifications__respondent__enabled BOOL Flag indicating if respondent notifications are enabled
settings__notifications__respondent__subject STRING Subject of respondent notifications
settings__notifications__respondent__message STRING Message for respondent notifications
settings__notifications__respondent__reply_to STRING Email address for respondent replies
settings__cui_settings__avatar STRING Avatar settings
settings__cui_settings__is_typing_emulation_disabled BOOL Flag indicating if typing emulation is disabled
settings__cui_settings__typing_emulation_speed STRING Speed of typing emulation
_links__display STRING Display information related to the form
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: forms__settings__notifications__self__recipients

Section titled “Subtable: forms__settings__notifications__self__recipients”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: forms__settings__notifications__respondent__recipients

Section titled “Subtable: forms__settings__notifications__respondent__recipients”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier of the welcome screen
ref STRING Reference of the welcome screen
title STRING Title of the welcome screen
properties__show_button BOOL Flag indicating if the button is displayed
properties__share_icons BOOL Icons for sharing the welcome screen
properties__button_mode STRING Mode of the button
properties__button_text STRING Text of the button
properties__redirect_url STRING URL to redirect on button click
attachment__type STRING Type of the attachment
attachment__placement STRING Placement of the attachment
layout__type STRING Type of the layout
layout__placement STRING Placement of the welcome screen layout
layout__attachment__type STRING Type of the attachment
layout__attachment__href STRING URL of the attached file
layout__attachment__scale FLOAT64 Scale of the attachment
layout__properties__brightness FLOAT64 Brightness settings of the welcome screen
layout__properties__description STRING Description of the welcome screen
layout__properties__focal_point__x FLOAT64
layout__properties__focal_point__y FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier of the thank you screen
ref STRING Reference of the thank you screen
title STRING Title of the thank you screen
properties__show_button BOOL Flag indicating if the button is displayed
properties__share_icons BOOL Icons for sharing the thank you screen
properties__button_mode STRING Mode of the button
properties__button_text STRING Text of the button
properties__redirect_url STRING URL to redirect on button click
attachment__type STRING Type of the attachment
attachment__placement STRING Placement of the attachment
layout__type STRING Type of the layout
layout__placement STRING Placement of the thank you screen layout
layout__attachment__type STRING Type of the attachment
layout__attachment__href STRING URL of the attached file
layout__attachment__scale FLOAT64 Scale of the attachment
layout__properties__brightness FLOAT64 Brightness settings of the thank you screen
layout__properties__description STRING Description of the thank you screen
layout__properties__focal_point__x FLOAT64
layout__properties__focal_point__y FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING Type of logic
ref STRING Reference of the logic
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action STRING Action to be taken
details__to__type STRING Type of activity
details__to__value STRING Value of the activity
details__target__type STRING Type of the target
details__target__value STRING Value of the target
details__value__type STRING Type of value
details__value__value STRING Value to be assigned
condition__op STRING Operation to be performed
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: forms__logic__actions__condition__vars

Section titled “Subtable: forms__logic__actions__condition__vars”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING Type of the variable
value STRING Value of the variable
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier of the field
title STRING Title of the field
ref STRING Reference of the field
properties__randomize BOOL Flag indicating if choices should be randomized
properties__allow_multiple_selection BOOL Flag indicating if multiple selections are allowed
properties__allow_other_choice BOOL Flag indicating if an ‘Other’ choice is allowed
properties__vertical_alignment BOOL Vertical alignment of the choices
validations__required BOOL Flag indicating if the field is required
type STRING Type of the field
attachment__type STRING Type of the attachment
attachment__href STRING URL of the attached file
layout__type STRING Type of the layout
layout__placement STRING Placement of the field in the layout
layout__attachment__type STRING Type of the attachment
layout__attachment__href STRING URL of the attached file
layout__attachment__scale FLOAT64 Scale of the attachment
layout__properties__brightness FLOAT64 Brightness settings of the field
layout__properties__description STRING Description of the field
layout__properties__focal_point__x FLOAT64
layout__properties__focal_point__y FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: forms__fields__properties__choices

Section titled “Subtable: forms__fields__properties__choices”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier of the choice
ref STRING Reference to the choice
label STRING Label of the choice
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
images (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
file_name STRING The name of the image file.
id STRING The unique identifier of the image.
src STRING The URL or path to access the image file.
width INT64 The width of the image in pixels.
height INT64 The height of the image in pixels.
media_type STRING The type of media file, e.g., image/jpeg, image/png, etc.
avg_color STRING The average color of the image.
has_alpha BOOL Boolean indicating if the image has an alpha channel.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
responses (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
response_id STRING ID of the response
response_type STRING Type of the response
landed_at STRING Timestamp when the respondent landed on the form
landing_id STRING ID of the landing page
submitted_at STRING Timestamp when the response was submitted
token STRING Token associated with the response
form_id STRING ID of the form
metadata__user_agent STRING User agent information
metadata__platform STRING Platform information
metadata__referer STRING Referer information
metadata__network_id STRING Network ID
calculated__score INT64 Calculated score
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
key STRING Variable key
type STRING Type of the variable
text STRING Textual variable
number FLOAT64 Numeric variable
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
field__id STRING ID of the form field
field__ref STRING Reference to the form field
field__type STRING Type of the form field
type STRING Type of response
text STRING Textual answer
choice__id STRING ID of the chosen option
choice__label STRING Label of the chosen option
number FLOAT64 Numeric answer
date TIMESTAMP Date and time answer
email STRING Email answer
phone_number STRING Phone number answer
boolean BOOL Boolean answer
file_url STRING URL of the file uploaded
url STRING URL answer
payment__amount STRING Amount paid
payment__last4 STRING Last 4 digits of the payment card
payment__name STRING Name on the payment card
payment__success BOOL Payment success status
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: responses__answers__choices__ids

Section titled “Subtable: responses__answers__choices__ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: responses__answers__choices__labels

Section titled “Subtable: responses__answers__choices__labels”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
themes (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
background__brightness FLOAT64 The brightness level of the background
background__href STRING The URL reference for the background image
background__layout STRING The layout style of the background
colors__answer STRING Color of answer text
colors__background STRING Background color
colors__button STRING Color of buttons
colors__question STRING Color of question text
fields__alignment STRING Alignment of form field elements
fields__font_size STRING Font size for form fields
font STRING Font settings for the theme
has_transparent_button BOOL Indicates if the theme includes a transparent button
id STRING Unique identifier for the theme
name STRING Name of the theme
rounded_corners STRING Indicates if the theme has rounded corners
screens__alignment STRING Alignment of screen elements
screens__font_size STRING Font size for screen elements
visibility STRING Visibility settings for the theme
updated_at TIMESTAMP Timestamp of when the theme was last updated
created_at TIMESTAMP Timestamp of when the theme was created
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
webhooks (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING The timestamp when the webhook was created
enabled BOOL Indicates if the webhook is currently enabled
form_id STRING The unique identifier of the form associated with the webhook
id STRING The unique identifier of the webhook
tag STRING A tag to categorize or label the webhook
updated_at STRING The timestamp when the webhook was last updated
url STRING The URL where the webhook data is sent
verify_ssl BOOL Indicates whether SSL verification is enforced for the webhook URL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
workspaces (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id STRING The unique identifier of the account associated with the workspace.
default BOOL Flag indicating if this workspace is set as the default workspace.
forms__count FLOAT64 The total number of forms belonging to this workspace.
forms__href STRING The URL to retrieve the list of forms associated with this workspace.
id STRING The unique identifier of the workspace.
name STRING The name of the workspace.
self__href STRING The URL to retrieve the details of this workspace.
shared BOOL Flag indicating if this workspace is shared with other users.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Typeform supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Typeform?

Section titled “How long does the initial sync take for Typeform?”

It depends on how much history is in your Typeform account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Typeform’s schema changes?

Section titled “What happens when Typeform’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Typeform, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Typeform instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Typeform connector in Kaivo and all of its synced data is deleted with it.

Aggregate responses to track results and trends over time.

Analyse forms and responses to measure completion and drop-off.

Break responses down by segment to compare how different groups answer.

Join Typeform responses with support or sales data in BigQuery to connect feedback to outcomes.

Once Typeform data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Typeform data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Typeform connector pricing and plan details.