Skip to content
Book a demoStart free
Connectors

Nutshell connector

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

Nutshell connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Nutshell 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 CRM data instead of moving it.

Sync your Nutshell CRM data into BigQuery with Kaivo to report on pipeline, accounts, and activity in one place.

CategoryCRM
AuthenticationAPI key
SetupSelf-service

Getting started with the Nutshell connector

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

Field Description
API Token

When you set up the connector, you provide:

Field Description
Username

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

account_types (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
modified_time FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
accounts (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
avatar_url STRING
href STRING
html_url STRING
html_url_path STRING
id STRING
initials STRING
links__account_type STRING
links__industry STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • accounts__addresses (13 columns)
  • accounts__emails (4 columns)
  • accounts__links__contacts (4 columns)
  • accounts__links__files (4 columns)
  • accounts__links__related_files (4 columns)
  • accounts__links__tags (4 columns)
  • accounts__phones (4 columns)
  • accounts__urls (4 columns)
accounts_list_items (90 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
avatar_url STRING
fields__account_type__value__type STRING
fields__account_type__value__id STRING
fields__account_type__value__name STRING
fields__address__address_1 STRING
fields__address__city STRING
fields__address__country STRING
fields__address__postal_code STRING
fields__address__state STRING
fields__address__value STRING
fields__created_time__absolute_localized_string STRING
fields__created_time__timestamp FLOAT64
fields__created_time__value STRING
fields__creator__value__type STRING
fields__creator__value__avatar_url STRING
fields__creator__value__id STRING
fields__creator__value__initials STRING
fields__creator__value__name STRING
fields__email_click_count__value FLOAT64
fields__email_click_rate__value STRING
fields__email_open_count__value FLOAT64
fields__email_open_rate__value STRING
fields__industry__value__type STRING
fields__industry__value__id STRING
fields__industry__value__name STRING
fields__last_contacted_time__absolute_localized_string STRING
fields__last_contacted_time__timestamp FLOAT64
fields__last_contacted_time__value STRING
fields__last_logged_activity_15_time__absolute_localized_string STRING
fields__last_logged_activity_15_time__timestamp STRING
fields__last_logged_activity_15_time__value STRING
fields__last_logged_activity_1_time__absolute_localized_string STRING
fields__last_logged_activity_1_time__timestamp STRING
fields__last_logged_activity_1_time__value STRING
fields__last_logged_activity_8_time__absolute_localized_string STRING
fields__last_logged_activity_8_time__timestamp STRING
fields__last_logged_activity_8_time__value STRING
fields__name__value STRING
fields__num_child_accounts__value FLOAT64
fields__number_of_contacts__value FLOAT64
fields__number_of_emails_received__value FLOAT64
fields__number_of_emails_sent__value FLOAT64
fields__number_of_leads__value FLOAT64
fields__number_of_lost_leads__value FLOAT64
fields__number_of_open_leads__value FLOAT64
fields__number_of_won_leads__value FLOAT64
fields__origin__value__type STRING
fields__origin__value__avatar_url STRING
fields__origin__value__id STRING
fields__origin__value__name STRING
fields__owner__value__type STRING
fields__owner__value__avatar_url STRING
fields__owner__value__id STRING
fields__owner__value__initials STRING
fields__owner__value__name STRING
fields__postal_code__value STRING
fields__value_of_lost_leads__formatted_value__formatted STRING
fields__value_of_lost_leads__formatted_value__prefix STRING
fields__value_of_lost_leads__formatted_value__suffix STRING
fields__value_of_lost_leads__formatted_value__value FLOAT64
fields__value_of_lost_leads__value STRING
fields__value_of_open_leads__formatted_value__formatted STRING
fields__value_of_open_leads__formatted_value__prefix STRING
fields__value_of_open_leads__formatted_value__suffix STRING
fields__value_of_open_leads__formatted_value__value FLOAT64
fields__value_of_open_leads__value STRING
fields__value_of_won_leads__formatted_value__formatted STRING
fields__value_of_won_leads__formatted_value__prefix STRING
fields__value_of_won_leads__formatted_value__suffix STRING
fields__value_of_won_leads__formatted_value__value FLOAT64
fields__value_of_won_leads__value STRING
html_url STRING
html_url_path STRING
id STRING
initials STRING
is_deleted BOOL
links__entity__type STRING
links__entity__href STRING
links__entity__id STRING
map_url STRING
primary_info STRING
primary_name STRING
related_info STRING
related_name STRING
related_type STRING
related_url STRING
related_url_path STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • accounts_list_items__fields__child_accounts__value (10 columns)
  • accounts_list_items__fields__clicked_email_sequence_templates__value (4 columns)
  • accounts_list_items__fields__contact_ids__value (4 columns)
  • accounts_list_items__fields__contacts__value (10 columns)
  • accounts_list_items__fields__ctct_lists__value (4 columns)
  • accounts_list_items__fields__in_progress_email_sequence_templates__value (4 columns)
  • accounts_list_items__fields__lead_ids__value (4 columns)
  • accounts_list_items__fields__leads__value (4 columns)
  • accounts_list_items__fields__no_reply_email_sequence_templates__value (4 columns)
  • accounts_list_items__fields__opened_email_sequence_templates__value (4 columns)
  • accounts_list_items__fields__parent_account__value (10 columns)
  • accounts_list_items__fields__phones__value__fax (4 columns)
  • accounts_list_items__fields__phones__value__home (4 columns)
  • accounts_list_items__fields__phones__value__mobile (4 columns)
  • accounts_list_items__fields__phones__value__other (4 columns)
  • accounts_list_items__fields__phones__value__phone (4 columns)
  • accounts_list_items__fields__phones__value__work (4 columns)
  • accounts_list_items__fields__received_email_sequence_templates__value (4 columns)
  • accounts_list_items__fields__received_reply_email_sequence_templates__value (4 columns)
  • accounts_list_items__fields__tags__value (4 columns)
  • accounts_list_items__latlon (4 columns)
activities (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
agenda STRING
created_time FLOAT64
end_time FLOAT64
href STRING
html_url STRING
html_url_path STRING
id STRING
is_all_day BOOL
is_cancelled BOOL
is_editable BOOL
is_flagged BOOL
is_logged BOOL
is_media_logged BOOL
is_overdue BOOL
links__activity_type STRING
links__creator STRING
links__logger STRING
logged_time FLOAT64
modified_time FLOAT64
name STRING
start_time FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • activities__links__accounts (4 columns)
  • activities__links__comments (4 columns)
  • activities__links__contacts (4 columns)
  • activities__links__leads (4 columns)
  • activities__links__users (4 columns)
activity_types (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
is_benchmarkable BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
audiences (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
is_web_fx BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
competitor_maps (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
links__competitor STRING
links__lead STRING
name STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
competitors (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
modified_time FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
avatar_url STRING
first_name STRING
href STRING
html_url STRING
html_url_path STRING
id STRING
initials STRING
job_title STRING
jobs JSON
last_name STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • contacts__addresses (14 columns)
  • contacts__emails (6 columns)
  • contacts__links__accounts (4 columns)
  • contacts__links__files (4 columns)
  • contacts__links__related_files (4 columns)
  • contacts__links__tags (4 columns)
  • contacts__phones (10 columns)
  • contacts__urls (4 columns)
contacts_custom_fields (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts_list_items (111 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
avatar_url STRING
fields__account_type__value__type STRING
fields__account_type__value__id STRING
fields__account_type__value__name STRING
fields__address__address_1 STRING
fields__address__city STRING
fields__address__country STRING
fields__address__postal_code STRING
fields__address__state STRING
fields__address__value STRING
fields__company_address__address_1 STRING
fields__company_address__city STRING
fields__company_address__country STRING
fields__company_address__postal_code STRING
fields__company_address__state STRING
fields__company_address__value STRING
fields__created_time__absolute_localized_string STRING
fields__created_time__timestamp FLOAT64
fields__created_time__value STRING
fields__creator__value__type STRING
fields__creator__value__avatar_url STRING
fields__creator__value__id STRING
fields__creator__value__initials STRING
fields__creator__value__name STRING
fields__email__value STRING
fields__email_click_count__value FLOAT64
fields__email_click_rate__value STRING
fields__email_last_click_time__absolute_localized_string STRING
fields__email_last_click_time__timestamp FLOAT64
fields__email_last_click_time__value STRING
fields__email_last_open_time__absolute_localized_string STRING
fields__email_last_open_time__timestamp FLOAT64
fields__email_last_open_time__value STRING
fields__email_open_count__value FLOAT64
fields__email_open_rate__value STRING
fields__engagement_rating__value FLOAT64
fields__industry__value__type STRING
fields__industry__value__id STRING
fields__industry__value__name STRING
fields__job_title__value STRING
fields__last_contacted_time__absolute_localized_string STRING
fields__last_contacted_time__timestamp FLOAT64
fields__last_contacted_time__value STRING
fields__last_logged_activity_15_time__absolute_localized_string STRING
fields__last_logged_activity_15_time__timestamp STRING
fields__last_logged_activity_15_time__value STRING
fields__last_logged_activity_8_time__absolute_localized_string STRING
fields__last_logged_activity_8_time__timestamp STRING
fields__last_logged_activity_8_time__value STRING
fields__marketing_last_contacted_time__absolute_localized_string STRING
fields__marketing_last_contacted_time__timestamp STRING
fields__marketing_last_contacted_time__value STRING
fields__marketing_status__value STRING
fields__name__value STRING
fields__number_of_emails_received__value FLOAT64
fields__number_of_emails_sent__value FLOAT64
fields__number_of_leads__value FLOAT64
fields__number_of_lost_leads__value FLOAT64
fields__number_of_open_leads__value FLOAT64
fields__number_of_won_leads__value FLOAT64
fields__origin__value__type STRING
fields__origin__value__avatar_url STRING
fields__origin__value__id STRING
fields__origin__value__name STRING
fields__owner__value__type STRING
fields__owner__value__avatar_url STRING
fields__owner__value__id STRING
fields__owner__value__initials STRING
fields__owner__value__name STRING
fields__phone__value STRING
fields__postal_code__value STRING
fields__primary_account_owner__value__type STRING
fields__primary_account_owner__value__avatar_url STRING
fields__primary_account_owner__value__id STRING
fields__primary_account_owner__value__initials STRING
fields__primary_account_owner__value__name STRING
fields__unsubscribed_from_all_emails__value STRING
fields__value_of_lost_leads__formatted_value__formatted STRING
fields__value_of_lost_leads__formatted_value__prefix STRING
fields__value_of_lost_leads__formatted_value__suffix STRING
fields__value_of_lost_leads__formatted_value__value FLOAT64
fields__value_of_lost_leads__value STRING
fields__value_of_open_leads__formatted_value__formatted STRING
fields__value_of_open_leads__formatted_value__prefix STRING
fields__value_of_open_leads__formatted_value__suffix STRING
fields__value_of_open_leads__formatted_value__value FLOAT64
fields__value_of_open_leads__value STRING
fields__value_of_won_leads__formatted_value__formatted STRING
fields__value_of_won_leads__formatted_value__prefix STRING
fields__value_of_won_leads__formatted_value__suffix STRING
fields__value_of_won_leads__formatted_value__value FLOAT64
fields__value_of_won_leads__value STRING
html_url STRING
html_url_path STRING
id STRING
initials STRING
is_deleted BOOL
links__entity__type STRING
links__entity__href STRING
links__entity__id STRING
map_url STRING
primary_info STRING
primary_name STRING
related_info STRING
related_name STRING
related_type STRING
related_url STRING
related_url_path STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • contacts_list_items__fields__account_ids__value (4 columns)
  • contacts_list_items__fields__account_tags__value (4 columns)
  • contacts_list_items__fields__accounts__value (10 columns)
  • contacts_list_items__fields__audiences__value (6 columns)
  • contacts_list_items__fields__bounced_drip_sequences__value (4 columns)
  • contacts_list_items__fields__bounced_editions__value (6 columns)
  • contacts_list_items__fields__clicked_drip_sequences__value (4 columns)
  • contacts_list_items__fields__clicked_editions__value (6 columns)
  • contacts_list_items__fields__clicked_email_sequence_templates__value (4 columns)
  • contacts_list_items__fields__ctct_lists__value (4 columns)
  • contacts_list_items__fields__in_progress_drip_sequences__value (4 columns)
  • contacts_list_items__fields__in_progress_email_sequence_templates__value (4 columns)
  • contacts_list_items__fields__lead_ids__value (4 columns)
  • contacts_list_items__fields__leads__value (10 columns)
  • contacts_list_items__fields__no_reply_email_sequence_templates__value (4 columns)
  • contacts_list_items__fields__opened_email_sequence_templates__value (4 columns)
  • contacts_list_items__fields__phones__value__fax (4 columns)
  • contacts_list_items__fields__phones__value__home (4 columns)
  • contacts_list_items__fields__phones__value__mobile (4 columns)
  • contacts_list_items__fields__phones__value__other (4 columns)
  • contacts_list_items__fields__phones__value__phone (4 columns)
  • contacts_list_items__fields__phones__value__work (4 columns)
  • contacts_list_items__fields__received_all_messages_drip_sequences__value (6 columns)
  • contacts_list_items__fields__received_drip_sequences__value (4 columns)
  • contacts_list_items__fields__received_editions__value (6 columns)
  • contacts_list_items__fields__received_email_sequence_templates__value (4 columns)
  • contacts_list_items__fields__received_reply_email_sequence_templates__value (4 columns)
  • contacts_list_items__fields__sent_editions__value (6 columns)
  • contacts_list_items__fields__subscribed_audiences__value (6 columns)
  • contacts_list_items__fields__tags__value (7 columns)
  • contacts_list_items__fields__unsubscribed_audiences__value (4 columns)
  • contacts_list_items__fields__viewed_drip_sequences__value (4 columns)
  • contacts_list_items__fields__viewed_editions__value (6 columns)
  • contacts_list_items__latlon (4 columns)
events (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
action STRING
actor_type STRING
created_time FLOAT64
id STRING
links__actor STRING
payload_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • events__changes (6 columns)
  • events__links__comments (4 columns)
  • events__links__payloads (4 columns)
filters (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_time FLOAT64
href STRING
id STRING
is_deleteable BOOL
is_immutable BOOL
is_shared BOOL
is_updateable BOOL
links__user STRING
name STRING
report_type STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • filters__links__users_and_teams (4 columns)
industries (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
modified_time FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lead_products (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
links__lead STRING
links__product STRING
name STRING
price__amount STRING
price__currency STRING
price__formatted STRING
product_type STRING
quantity FLOAT64
unit STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
leads (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
avatar_url STRING
href STRING
html_url STRING
html_url_path STRING
id STRING
initials STRING
links__account_type STRING
links__industry STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • leads__addresses (13 columns)
  • leads__emails (4 columns)
  • leads__links__contacts (4 columns)
  • leads__links__files (4 columns)
  • leads__links__related_files (4 columns)
  • leads__links__tags (4 columns)
  • leads__phones (4 columns)
  • leads__urls (4 columns)
leads_custom_fields (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • leads_custom_fields__enum (4 columns)
leads_list_items (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
avatar_url STRING
fields__name__value STRING
fields__owner__value__type STRING
fields__owner__value__avatar_url STRING
fields__owner__value__id STRING
fields__owner__value__initials STRING
fields__owner__value__name STRING
fields__status__value__description STRING
fields__status__value__value STRING
fields__value__formatted_value__formatted STRING
fields__value__formatted_value__prefix STRING
fields__value__formatted_value__suffix STRING
fields__value__formatted_value__value FLOAT64
fields__value__value STRING
html_url STRING
html_url_path STRING
id STRING
is_deleted BOOL
links__entity__type STRING
links__entity__href STRING
links__entity__id STRING
map_url STRING
primary_account__type STRING
primary_account__html_url STRING
primary_account__html_url_path STRING
primary_account__id STRING
primary_account__name STRING
primary_contact__type STRING
primary_contact__html_url STRING
primary_contact__html_url_path STRING
primary_contact__id STRING
primary_contact__name STRING
primary_info STRING
primary_name STRING
priority STRING
related_info STRING
related_name STRING
related_type STRING
related_url STRING
related_url_path STRING
sort_key STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • leads_list_items__fields__accounts__value (10 columns)
  • leads_list_items__fields__contacts__value (10 columns)
  • leads_list_items__latlon (4 columns)
leads_report (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
key STRING
name STRING
prefix STRING
summary__bucket STRING
summary__bucket_type STRING
summary__count__formatted STRING
summary__count__prefix STRING
summary__count__suffix STRING
summary__count__value FLOAT64
summary__total__formatted STRING
summary__total__prefix STRING
summary__total__suffix STRING
summary__total__value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • leads_report__data (16 columns)
  • leads_report__data__count__subvalues (4 columns)
  • leads_report__data__segments (4 columns)
  • leads_report__data__total__subvalues (4 columns)
  • leads_report__summary__count__subvalues (4 columns)
  • leads_report__summary__segments (4 columns)
  • leads_report__summary__total__subvalues (4 columns)
notes (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
body STRING
body_markup STRING
created_time FLOAT64
href STRING
html_url STRING
html_url_path STRING
id STRING
is_editable BOOL
links__parent STRING
parent_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • notes__links__comments (4 columns)
pipelines (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
can_access BOOL
default BOOL
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • pipelines__links__stages (4 columns)
products (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
href STRING
id STRING
modified_time FLOAT64
name STRING
price__amount STRING
price__currency STRING
price__currency_symbol STRING
price__formatted STRING
prices___1_markets__amount STRING
prices___1_markets__currency STRING
prices___1_markets__currency_symbol STRING
prices___1_markets__formatted STRING
product_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sources (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
href STRING
id STRING
modified_time FLOAT64
name STRING
source_type FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stages (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
active_avatar_url STRING
complete_avatar_url STRING
id STRING
incomplete_avatar_url STRING
links__stageset STRING
name STRING
overdue_avatar_url STRING
position FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
color_type STRING
count FLOAT64
href STRING
id STRING
modified_time FLOAT64
name STRING
tag_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
agent_status STRING
avatar_url STRING
can_access_email_marketing BOOL
first_name STRING
has_set_password BOOL
id STRING
initials STRING
is_administrator BOOL
is_enabled BOOL
is_hidden_from_filters BOOL
is_viewing_restricted BOOL
modified_time FLOAT64
name STRING
permissions__can_access_billing BOOL
permissions__can_access_crm BOOL
permissions__can_access_full_campaigns BOOL
permissions__can_access_marketing BOOL
permissions__can_access_setup BOOL
permissions__can_assign_entities BOOL
permissions__can_bulk_edit BOOL
permissions__can_delete_entities BOOL
permissions__can_export BOOL
permissions__can_import BOOL
permissions__can_manage_email_templates BOOL
permissions__can_merge_entities BOOL
permissions__can_use_inbox BOOL
permissions__can_use_or_try_inbox BOOL
permissions__can_use_people_iq BOOL
permissions__can_view_shared_emails BOOL
phonecaller_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • users__emails (4 columns)
  • users__links__teams (4 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Nutshell 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 Nutshell?

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

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

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

Use leads and leads_report to track pipeline value and conversion over time.

Join accounts with contacts to understand your customers.

Use activities and activity_types to measure follow-up across the team.

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

  • Custobar: Sync Custobar to BigQuery.
  • HubSpot: Sync HubSpot to BigQuery.
  • Attio: Sync Attio to BigQuery.
  • Cuuma: Sync Cuuma to BigQuery.
  • Pipedrive: Sync Pipedrive to BigQuery.
  • Rentman: Sync Rentman to BigQuery.