Skip to content
Book a demoStart free
Connectors

Jotform connector

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

Jotform connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Jotform 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 JotForm submissions into BigQuery with Kaivo to analyse form responses and trends without exporting spreadsheets.

CategorySurveys & Email
AuthenticationAPI key
SetupSelf-service

Getting started with the Jotform connector

Section titled “Getting started with the Jotform connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Jotform 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 API Key.

Field Description
API Key
Your JotForm API key. You can generate one in your JotForm account under Settings → API.

|

When you set up the connector, you provide:

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

| | Base URL Prefix |

Select the API region: Standard (https://api.jotform.com), EU (https://eu-api.jotform.com), or HIPAA (https://hipaa-api.jotform.com).

| | Enterprise URL |

Your JotForm Enterprise API URL, e.g. your-domain.com/API or subdomain.jotform.com/API.

|

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

form_files (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
url STRING
date STRING
name STRING
size STRING
form_id STRING
uploaded STRING
username STRING
submission_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
form_properties (85 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
v4 STRING
font STRING
hash STRING
slug STRING
count STRING
owner STRING
title STRING
height STRING
status STRING
styles STRING
unique STRING
is_hipaa STRING
theme_id STRING
fontsize STRING
form_type STRING
is_eu_form STRING
alignment STRING
fontcolor STRING
form_width STRING
inject_css STRING
page_color STRING
pagetitle STRING
style_json STRING
thanktext STRING
assign_slug STRING
background STRING
expire_date STRING
full_screen STRING
label_width STRING
responsive STRING
smart_embed STRING
uses_new_pdf STRING
card_theme_id STRING
is_encrypted STRING
line_spacing STRING
optioncolor STRING
submit_error STRING
unique_field STRING
default_theme STRING
is_new_pdf_user BOOL
sendpostdata STRING
attach_invoice STRING
form_owner_name STRING
highlight_line STRING
active_redirect STRING
invoice_enabled STRING
last_question_id STRING
mobile_go_button STRING
error_navigation STRING
limit_submission STRING
show_jot_form_logo STRING
show_progress_bar STRING
thank_you_icon_src STRING
theme_revision_id STRING
clear_field_on_hide STRING
creation_language STRING
page_title_changed STRING
thank_you_image_src STRING
submission_headers STRING
thank_you_fill_again STRING
form_strings_changed STRING
prevent_cloning_form STRING
thank_you_page_layout STRING
allow_submission_edit STRING
hide_mail_empty_fields STRING
thank_you_download_pdf STRING
default_email_assigned STRING
form_owner_account_type STRING
hide_submission_header STRING
message_of_limited_form STRING
stateless_color_scheme STRING
thank_you_selected_pd_fs STRING
payment_strings_changed STRING
thank_you_edit_submission STRING
datetime_migration_status STRING
hide_empty_submission_fields STRING
is_payment_store_in_basic_fields STRING
hide_non_input_submission_fields STRING
new_payment_ui_for_new_created_forms STRING
default_auto_responder_email_assigned STRING
datetime_migration_includes_birth_date 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.
type STRING
to STRING
body STRING
from STRING
html STRING
name STRING
dirty STRING
reply_to STRING
subject STRING
send_date STRING
unique_id STRING
attachment STRING
send_on_edit STRING
send_on_submit STRING
pdfattachment STRING
last_question_id STRING
branding21_email STRING
hide_empty_fields STRING
upload_attachment 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.
version STRING
theme STRING
options STRING
show_status STRING
first_page_only STRING
primary_language STRING
original_language STRING
save_user_language STRING
detect_user_language 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.
description STRING
pid STRING
icon STRING
name STRING
order STRING
price STRING
trial STRING
images STRING
period STRING
options STRING
setupfee STRING
custom_price STRING
has_quantity STRING
payment_uuid STRING
recurringtimes STRING
fit_image_to_canvas STRING
connected_products STRING
custom_price_source STRING
has_expanded_option STRING
has_special_pricing STRING
connected_categories 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.
type STRING
id STRING
link STRING
index STRING
terms STRING
action STRING
priority 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.
hyg_check_pid STRING
hyg_check_props STRING
hyg_check_stock STRING
hyg_check_coupon STRING
hyg_check_category_id STRING
hyg_product_uuid_check STRING
hyg_is_the_template_new_ui STRING
hyg_is_long_text_truncated STRING
hyg_is_product_list_hidden STRING
hyg_check_multiple_gateway STRING
hyg_check_connected_products STRING
hyg_check_products_in_donation_form STRING
hyg_single_select_required_value_fix 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.
url STRING
email STRING
error STRING
numeric STRING
sold_out STRING
currency STRING
cyrillic STRING
fill_mask STRING
less_than STRING
one_error STRING
required STRING
alphabetic STRING
done_button STRING
field_error STRING
please_wait STRING
require_one STRING
see_all_text STRING
date_invalid STRING
date_limited STRING
done_message STRING
invalid_time STRING
just_sold_out STRING
alphanumeric STRING
cc_invalid_cvc STRING
confirm_email STRING
general_error STRING
selected_time STRING
multiple_error STRING
validate_email STRING
free_email_error STRING
geo_timeout_desc STRING
max_digits_error STRING
next_button_text STRING
not_enough_stock STRING
prev_button_text STRING
required_legend STRING
review_back_text STRING
upload_filesize STRING
word_limit_error STRING
cancel_selection STRING
cc_invalid_number STRING
geo_timeout_title STRING
require_every_row STRING
see_errors_button STRING
slot_unavailable STRING
start_button_text STRING
submission_limit STRING
cc_missing_details STRING
cc_missing_product STRING
confirm_clear_form STRING
disallow_decimals STRING
general_page_error STRING
incomplete_fields STRING
no_slots_available STRING
require_every_cell STRING
restricted_domain STRING
review_submit_text STRING
selection_sold_out STRING
submit_button_text STRING
upload_extensions STRING
cancel_appointment STRING
cc_missing_donation STRING
geo_permission_desc STRING
grading_score_error STRING
input_carret_error_a STRING
input_carret_error_b STRING
upload_filesizemin STRING
word_min_limit_error STRING
former_selected_time STRING
geo_permission_title STRING
max_characters_error STRING
max_selections_error STRING
min_characters_error STRING
min_selections_error STRING
no_upload_extensions STRING
progress_middle_text STRING
cc_invalid_expire_date STRING
cc_invalid_expire_year STRING
character_limit_error STRING
date_invalid_separate STRING
geo_not_available_desc STRING
past_dates_disallowed STRING
sub_product_items_left STRING
age_verification_error STRING
cc_invalid_expire_month STRING
geo_not_available_title STRING
character_min_limit_error STRING
cc_donation_min_limit_error STRING
choose_a_file_info_message STRING
max_file_size_info_message STRING
multiple_file_uploads_on_leave STRING
not_enough_stock_remained_items STRING
multiple_file_uploads_size_error STRING
multiple_file_uploads_type_error STRING
multiple_file_uploads_empty_error STRING
drag_and_drop_files_here_info_message STRING
multiple_file_uploads_min_size_error STRING
multiple_file_uploads_upload_failed STRING
multiple_file_uploads_file_limit_error 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.
logo STRING
title STRING
is_active STRING
sub_title STRING
button_text STRING
show_question_count 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.
value JSON
_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
title STRING
image_src STRING
sub_title STRING
redirect_link STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: form_properties__payment_strings

Section titled “Subtable: form_properties__payment_strings”
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.
tax_tax STRING
total_total STRING
coupon_apply STRING
coupon_blank STRING
coupon_enter STRING
coupon_valid STRING
coupon_change STRING
coupon_expired STRING
coupon_invalid STRING
total_subtotal STRING
shipping_shipping STRING
product_list_name_az STRING
product_list_name_za STRING
product_list_sort_by STRING
product_list_all_text STRING
product_list_clear_sort STRING
product_list_search_text STRING
product_list_price_lowest STRING
product_list_price_highest STRING
product_list_categories_text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: form_properties__submission_settings

Section titled “Subtable: form_properties__submission_settings”
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 JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: form_properties__payment_list_settings

Section titled “Subtable: form_properties__payment_list_settings”
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.
show_search STRING
show_category STRING
product_categories STRING
product_list_layout STRING
show_category_title STRING
min_total_order_amount STRING
show_min_total_order_amount STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
forms (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
new STRING
url STRING
count STRING
title STRING
height STRING
status STRING
archived STRING
favorite STRING
username STRING
created_at STRING
has_payment BOOL
updated_at STRING
payment_props__type STRING
payment_props__gateway STRING
payment_props__question_id FLOAT64
last_submission STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
questions (173 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
alt STRING
mde STRING
qid STRING
cols STRING
days STRING
hint STRING
name STRING
rows STRING
size STRING
step STRING
text STRING
clear STRING
order STRING
print STRING
today STRING
width STRING
format STRING
middle STRING
min_age STRING
months STRING
prefix STRING
states STRING
suffix STRING
cc_title STRING
form_id FLOAT64
maxsize STRING
options STRING
sandbox STRING
show_spb STRING
shuffle STRING
special STRING
wysiwyg STRING
auth_only STRING
currency STRING
lite_mode STRING
multiple STRING
paypal_bt STRING
readonly STRING
required STRING
sub_label STRING
use_image STRING
allow_time STRING
auto_fixed STRING
clear_text STRING
input_mask STRING
limit_date STRING
nonprofit STRING
other_text STRING
print_text STRING
show_total STRING
style_size STRING
sub_header STRING
subfields STRING
sublabels__day STRING
sublabels__area STRING
sublabels__city STRING
sublabels__full STRING
sublabels__hour STRING
sublabels__last STRING
sublabels__year STRING
sublabels__first STRING
sublabels__month STRING
sublabels__phone STRING
sublabels__price STRING
sublabels__state STRING
sublabels__cc_ccv STRING
sublabels__masked STRING
sublabels__middle STRING
sublabels__postal STRING
sublabels__prefix STRING
sublabels__suffix STRING
sublabels__country STRING
sublabels__minutes STRING
sublabels__litemode STRING
sublabels__cc_number STRING
sublabels__addr_line1 STRING
sublabels__addr_line2 STRING
sublabels__debit_card STRING
sublabels__cc_exp_year STRING
sublabels__cc_last_name STRING
sublabels__cc_exp_month STRING
sublabels__cc_first_name STRING
sublabels__item_subtotal STRING
sublabels__cc_card_expiry STRING
sublabels__pay_with_paypal STRING
sublabels__pay_with_credit_card STRING
text_align STRING
total_cost STRING
allow_other STRING
entry_limit STRING
header_type STRING
image_align STRING
label_align STRING
merchant_id STRING
only_future STRING
payment_cid STRING
spread_cols STRING
style_color STRING
style_label STRING
style_shape STRING
time_format STRING
use_decimal STRING
validation STRING
button_align STRING
button_style STRING
country_code STRING
decimal_mark STRING
default_date STRING
default_time STRING
domain_check STRING
encrypt_icon STRING
header_image STRING
is_validated STRING
payment_type STRING
start_week_on STRING
style_layout STRING
auto_calendar STRING
builder_label STRING
compound_hint STRING
confirmation STRING
default_value STRING
disallow_free STRING
donation_text STRING
order_summary STRING
bill_to_address STRING
date_separator STRING
entry_limit_min STRING
pay_later_ratio STRING
prefix_choices STRING
allowed_domains STRING
edit_button_text STRING
enable_light_box STRING
has_geolocation STRING
input_mask_value STRING
next_button_text STRING
pay_later_layout STRING
required_inputs STRING
show_card_fields STRING
age_verification STRING
donation_options STRING
has_autocomplete STRING
my_bag_button_text STRING
pay_later_enabled STRING
confirmation_hint STRING
pay_later_logo_type STRING
pay_later_text_size STRING
payment_field_type STRING
remove_button_text STRING
update_button_text STRING
validate_lite_date STRING
verification_code STRING
allow_custom_amount STRING
pay_later_text_color STRING
show_question_count STRING
vertical_text_align STRING
allow_custom_domains STRING
previous_button_text STRING
donation_amount_field STRING
subscribe_button_text STRING
back_to_list_button_text STRING
confirmation_sublabel STRING
is_only_connected_to_spb STRING
pay_later_logo_position STRING
custom_country_dropdown STRING
custom_value_donation_text STRING
pay_later_background_color STRING
country_dropdown_default_text STRING
is_payment_store_in_basic_fields BOOL
show_predefined_donation_values STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
reports (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
url STRING
share__share_link STRING
title STRING
fields STRING
status STRING
form_id STRING
form_url STRING
settings STRING
list_type STRING
created_at STRING
form_count FLOAT64
form_title STRING
updated_at STRING
is_protected BOOL
last_submission 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.
value JSON
_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.
value JSON
_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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
submissions (56 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
ip STRING
new STRING
flag STRING
notes STRING
status STRING
answers___1__type STRING
answers___1__name STRING
answers___1__text STRING
answers___1__order STRING
answers___2__type STRING
answers___2__name STRING
answers___2__text STRING
answers___2__order STRING
answers___3__type STRING
answers___3__name STRING
answers___3__text STRING
answers___3__order STRING
answers___4__type STRING
answers___4__name STRING
answers___4__text STRING
answers___4__order STRING
answers___4__answer__last STRING
answers___4__answer__first STRING
answers___4__sublabels STRING
answers___4__pretty_format STRING
answers___5__type STRING
answers___5__name STRING
answers___5__text STRING
answers___5__order STRING
answers___5__answer STRING
answers___6__type STRING
answers___6__name STRING
answers___6__text STRING
answers___6__order STRING
answers___6__answer__full STRING
answers___6__input_mask STRING
answers___6__sublabels STRING
answers___6__country_code STRING
answers___6__pretty_format STRING
answers___6__input_mask_value STRING
answers___7__type STRING
answers___7__name STRING
answers___7__text STRING
answers___7__order STRING
answers___7__answer__day STRING
answers___7__answer__year STRING
answers___7__answer__month STRING
answers___7__answer__datetime STRING
answers___7__sublabels STRING
answers___7__time_format STRING
answers___7__pretty_format STRING
form_id STRING
created_at STRING
_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 Jotform 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 Jotform?

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

It depends on how much history is in your Jotform 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 Jotform’s schema changes?

Section titled “What happens when Jotform’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 Jotform, 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 Jotform 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 Jotform connector in Kaivo and all of its synced data is deleted with it.

Use submissions and questions to summarise answers and response trends over time.

Join forms with submissions to see which forms get the most use.

Bring reports and form data into BigQuery to report on them next to your other sources.

Join submissions with your CRM or product data for a fuller picture.

Once Jotform 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 Jotform 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 Jotform connector pricing and plan details.