Skip to content
Book a demoStart free
Connectors

Pipedrive connector

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

Pipedrive connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Pipedrive 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 Pipedrive deals, persons, organizations, and activities into BigQuery with Kaivo to track pipeline and sales performance alongside your data.

CategoryCRM
AuthenticationAPI key
SetupSelf-service

Getting started with the Pipedrive connector

Section titled “Getting started with the Pipedrive connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Pipedrive 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
The Pipedrive API token. The token can be found in Pipedrive under Settings > Personal preferences > API. More info on this Pipedrive help center article.

|

When you set up the connector, you provide:

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

|

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

activities (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
owner_id INT64
done BOOL
type STRING
due_date DATE
due_time STRING
duration STRING
busy BOOL
add_time TIMESTAMP
marked_as_done_time TIMESTAMP
subject STRING
public_description STRING
location__value STRING
location__subpremise STRING
location__street_number STRING
location__route STRING
location__sublocality STRING
location__locality STRING
location__lat FLOAT64
location__long FLOAT64
location__admin_area_level_1 STRING
location__admin_area_level_2 STRING
location__country STRING
location__postal_code STRING
location__formatted_address STRING
org_id INT64
person_id INT64
deal_id INT64
lead_id STRING
is_deleted BOOL
update_time TIMESTAMP
gcal_event_id STRING
google_calendar_id STRING
google_calendar_etag STRING
note STRING
creator_user_id INT64
conference_meeting_client STRING
conference_meeting_url STRING
conference_meeting_id STRING
priority INT64
_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.
email STRING
is_organizer BOOL
name STRING
person_id INT64
status STRING
user_id INT64
_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.
person_id INT64
primary_flag BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
activity_fields (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
field_code STRING
field_name STRING
field_type STRING
is_custom_field BOOL
is_optional_response_field BOOL
description STRING
ui_visibility__add_visible_flag BOOL
ui_visibility__details_visible_flag BOOL
_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 INT64
label 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.
field_code STRING
field_name STRING
field_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
activity_types (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
order_nr INT64
name STRING
key_string STRING
icon_key STRING
active_flag BOOL
color STRING
is_custom_flag BOOL
add_time STRING
update_time TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
currencies (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
code STRING
name STRING
symbol STRING
decimal_points INT64
active_flag BOOL
is_custom_flag BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
deal_fields (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
field_code STRING
field_name STRING
field_type STRING
is_custom_field BOOL
is_optional_response_field BOOL
description STRING
ui_visibility__add_visible_flag BOOL
ui_visibility__details_visible_flag BOOL
ui_visibility__projects_detail_visible_flag BOOL
ui_visibility__show_in_pipelines__show_in_all BOOL
important_fields__enabled BOOL
required_fields__enabled BOOL
_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 INT64
label 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.
field_code STRING
field_name STRING
field_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: deal_fields__ui_visibility__show_in_pipelines__pipeline_ids

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

Subtable: deal_fields__important_fields__stage_ids

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

Subtable: deal_fields__required_fields__stage_ids

Section titled “Subtable: deal_fields__required_fields__stage_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 INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
deal_products (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
deal_id INT64
product_id INT64
product_variation_id INT64
name STRING
order_nr INT64
item_price INT64
quantity INT64
discount_percentage INT64
duration INT64
duration_unit STRING
sum_no_discount INT64
sum INT64
currency STRING
active_flag BOOL
enabled_flag BOOL
add_time STRING
last_edit STRING
comments STRING
tax FLOAT64
quantity_formatted STRING
sum_formatted STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
deals (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
creator_user_id INT64
owner_id INT64
person_id INT64
org_id INT64
stage_id INT64
title STRING
value FLOAT64
currency STRING
add_time TIMESTAMP
update_time TIMESTAMP
stage_change_time TIMESTAMP
is_deleted BOOL
status STRING
probability FLOAT64
next_activity_id INT64
last_activity_id INT64
lost_reason STRING
visible_to INT64
close_time TIMESTAMP
pipeline_id INT64
won_time TIMESTAMP
first_won_time TIMESTAMP
lost_time TIMESTAMP
products_count INT64
files_count INT64
notes_count INT64
followers_count INT64
email_messages_count INT64
activities_count INT64
done_activities_count INT64
undone_activities_count INT64
participants_count INT64
expected_close_date DATE
last_incoming_mail_time TIMESTAMP
last_outgoing_mail_time TIMESTAMP
weighted_value_currency STRING
rotten_time TIMESTAMP
smart_bcc_email 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 INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
files (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
user_id INT64
log_id INT64
add_time TIMESTAMP
update_time TIMESTAMP
file_name STRING
file_size INT64
active_flag BOOL
inline_flag BOOL
remote_location STRING
remote_id STRING
s3_bucket STRING
url STRING
name STRING
description STRING
deal_id INT64
lead_id STRING
person_id INT64
org_id INT64
product_id INT64
activity_id INT64
deal_name STRING
lead_name STRING
person_name STRING
people_name STRING
org_name STRING
product_name STRING
mail_message_id INT64
mail_template_id INT64
cid STRING
file_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
filters (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
filter_code STRING
is_editable BOOL
active_flag BOOL
type STRING
temporary_flag STRING
user_id INT64
add_time TIMESTAMP
update_time TIMESTAMP
visible_to STRING
custom_view_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
goals (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
owner_id FLOAT64
title STRING
type__name STRING
assignee__type STRING
assignee__id FLOAT64
interval STRING
duration__start STRING
duration__end STRING
expected_outcome__target FLOAT64
expected_outcome__tracking_metric STRING
is_active BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: goals__type__params__pipeline_id

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

Subtable: goals__type__params__activity_type_id

Section titled “Subtable: goals__type__params__activity_type_id”
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 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.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lead_labels (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
color STRING
add_time STRING
update_time STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
leads (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
title STRING
owner_id INT64
creator_id INT64
person_id INT64
organization_id INT64
source_name STRING
is_archived BOOL
was_seen BOOL
value__amount INT64
value__currency STRING
expected_close_date DATE
next_activity_id INT64
add_time STRING
update_time 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.
mail (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
body_url STRING
account_id STRING
user_id INT64
mail_thread_id INT64
subject STRING
snippet STRING
mail_link_tracking_enabled_flag INT64
read_flag INT64
draft_flag INT64
synced_flag INT64
deleted_flag INT64
has_body_flag INT64
sent_flag INT64
sent_from_pipedrive_flag INT64
smart_bcc_flag INT64
message_time TIMESTAMP
add_time TIMESTAMP
update_time TIMESTAMP
has_attachments_flag INT64
has_inline_attachments_flag INT64
has_real_attachments_flag INT64
_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 INT64
email_address STRING
name STRING
linked_person_id INT64
linked_person_name STRING
mail_message_party_id INT64
_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 INT64
email_address STRING
name STRING
linked_person_id INT64
linked_person_name STRING
mail_message_party_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
notes (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
user_id INT64
deal_id INT64
person_id INT64
org_id INT64
lead_id STRING
content STRING
add_time TIMESTAMP
update_time TIMESTAMP
active_flag BOOL
pinned_to_deal_flag BOOL
pinned_to_person_flag BOOL
pinned_to_organization_flag BOOL
pinned_to_lead_flag BOOL
last_update_user_id INT64
organization__name STRING
person__name STRING
deal__title STRING
user__email STRING
user__name STRING
user__icon_url STRING
user__is_you BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organization_fields (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
field_code STRING
field_name STRING
field_type STRING
is_custom_field BOOL
is_optional_response_field BOOL
description STRING
ui_visibility__add_visible_flag BOOL
ui_visibility__details_visible_flag BOOL
ui_visibility__show_in_add_deal_dialog__show BOOL
ui_visibility__show_in_add_deal_dialog__order INT64
ui_visibility__show_in_add_person_dialog__show BOOL
ui_visibility__show_in_add_person_dialog__order INT64
important_fields__enabled BOOL
required_fields__enabled BOOL
_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 INT64
label 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.
field_code STRING
field_name STRING
field_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: organization_fields__important_fields__stage_ids

Section titled “Subtable: organization_fields__important_fields__stage_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 INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organizations (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
owner_id INT64
name STRING
open_deals_count INT64
related_open_deals_count INT64
closed_deals_count INT64
related_closed_deals_count INT64
email_messages_count INT64
people_count INT64
activities_count INT64
done_activities_count INT64
undone_activities_count INT64
files_count INT64
notes_count INT64
followers_count INT64
won_deals_count INT64
related_won_deals_count INT64
lost_deals_count INT64
related_lost_deals_count INT64
is_deleted BOOL
picture_id INT64
update_time TIMESTAMP
add_time TIMESTAMP
visible_to INT64
next_activity_id INT64
last_activity_id INT64
address__value STRING
address__subpremise STRING
address__street_number STRING
address__route STRING
address__sublocality STRING
address__locality STRING
address__admin_area_level_1 STRING
address__admin_area_level_2 STRING
address__country STRING
address__postal_code STRING
address__formatted_address 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 INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
permission_sets (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
assignment_count INT64
app STRING
type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
person_fields (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
field_code STRING
field_name STRING
field_type STRING
is_custom_field BOOL
is_optional_response_field BOOL
description STRING
ui_visibility__add_visible_flag BOOL
ui_visibility__details_visible_flag BOOL
ui_visibility__show_in_add_deal_dialog__show BOOL
ui_visibility__show_in_add_deal_dialog__order INT64
important_fields__enabled BOOL
required_fields__enabled BOOL
_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 INT64
label 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.
field_code STRING
field_name STRING
field_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: person_fields__important_fields__stage_ids

Section titled “Subtable: person_fields__important_fields__stage_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 INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
persons (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
owner_id INT64
org_id INT64
name STRING
first_name STRING
last_name STRING
open_deals_count INT64
related_open_deals_count INT64
closed_deals_count INT64
related_closed_deals_count INT64
participant_open_deals_count INT64
participant_closed_deals_count INT64
email_messages_count INT64
activities_count INT64
done_activities_count INT64
undone_activities_count INT64
files_count INT64
notes_count INT64
followers_count INT64
won_deals_count INT64
related_won_deals_count INT64
lost_deals_count INT64
related_lost_deals_count INT64
is_deleted BOOL
update_time TIMESTAMP
add_time TIMESTAMP
visible_to INT64
picture_id INT64
next_activity_id INT64
last_activity_id INT64
last_incoming_mail_time TIMESTAMP
last_outgoing_mail_time TIMESTAMP
_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.
label STRING
value STRING
primary BOOL
_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.
label STRING
value STRING
primary BOOL
_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 INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
pipelines (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
order_nr INT64
is_deleted BOOL
is_deal_probability_enabled BOOL
add_time TIMESTAMP
update_time TIMESTAMP
is_selected BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_fields (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
field_code STRING
field_name STRING
field_type STRING
is_custom_field BOOL
is_optional_response_field BOOL
description STRING
ui_visibility__add_visible_flag BOOL
ui_visibility__details_visible_flag BOOL
_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 INT64
label 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.
field_code STRING
field_name STRING
field_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
code STRING
description STRING
unit STRING
tax INT64
category STRING
is_deleted BOOL
is_linkable BOOL
visible_to INT64
owner_id INT64
add_time TIMESTAMP
update_time TIMESTAMP
billing_frequency STRING
billing_frequency_cycles INT64
_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.
product_id INT64
price INT64
currency STRING
cost INT64
direct_cost INT64
notes STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
roles (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
parent_role_id INT64
name STRING
active_flag BOOL
assignment_count STRING
sub_role_count STRING
level INT64
description STRING
_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.
id INT64
order_nr INT64
name STRING
is_deleted BOOL
deal_probability INT64
pipeline_id INT64
is_deal_rot_enabled BOOL
days_to_rotten INT64
add_time TIMESTAMP
update_time TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
default_currency STRING
locale STRING
lang INT64
email STRING
phone STRING
activated BOOL
last_login TIMESTAMP
created TIMESTAMP
modified TIMESTAMP
has_created_company BOOL
active_flag BOOL
timezone_name STRING
timezone_offset STRING
role_id INT64
icon_url STRING
is_you BOOL
is_deleted BOOL
_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.
app STRING
admin BOOL
permission_set_id 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 Pipedrive 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 Pipedrive?

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

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

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

Track deals through pipeline stages to measure stage-by-stage conversion, average deal age, and where deals stall.

Analyse won and lost deals by owner, value, and close date to measure win rates and build revenue forecasts.

Aggregate activities by type, user, and outcome to see which actions correlate with closed deals.

Combine organizations and persons with their deals to find your most valuable accounts and relationships.

Use Pipedrive data in your AI and BI tools

Section titled “Use Pipedrive data in your AI and BI tools”

Once Pipedrive 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 Pipedrive 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 Pipedrive 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.
  • Rentman: Sync Rentman to BigQuery.
  • Salesforce: Sync Salesforce to BigQuery.