Typeform connector

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

Written By Lauri Raivio

Last updated 16 days ago

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.

What is the Typeform connector

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

Category	Surveys & Email
Authentication	API key
Setup	Self-service

Getting started with the Typeform connector

Sign up for Kaivo and create a workspace.
Connect your Typeform account.
Choose which tables to sync.
Wait for the initial sync to finish.
Query your data in BigQuery or your favourite AI or BI tool.

Authenticating Typeform

Authenticate with your Private Token.

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

Configuring the Typeform connector

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.

Tables and columns synced from Typeform

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: formssettingsnotificationsselfrecipients

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: formssettingsnotificationsrespondentrecipients

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__welcome_screens

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.

Subtable: forms__thankyou_screens

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.

Subtable: forms__logic

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.

Subtable: formslogicactions

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: formslogicactionsconditionvars

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.

Subtable: forms__fields

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: formsfieldsproperties__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.

Subtable: responses__variables

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.

Subtable: responses__answers

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: responsesanswerschoices__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: responsesanswerschoices__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.

How the Typeform sync works

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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.

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.

Common use cases for Typeform data

Response analysis

Aggregate responses to track results and trends over time.

Completion rates

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

Segment feedback

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

Feedback and operations together

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

Use Typeform data in your AI and BI tools

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.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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

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

Gmail: Sync Gmail to BigQuery.
Iterable: Sync Iterable to BigQuery.
Klaviyo: Sync Klaviyo to BigQuery.
Mailchimp: Sync Mailchimp to BigQuery.
Twilio SendGrid: Sync Twilio SendGrid to BigQuery.
Surveypal: Sync Surveypal to BigQuery.

Was this helpful?

Still need help? Share an idea