Skip to content
Book a demoStart free
Connectors

Freshsales connector

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

Freshsales connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Freshsales 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 Freshsales CRM data into BigQuery with Kaivo to report on pipeline, accounts, and activity alongside the rest of your data.

CategoryCRM, Marketing & Sales
AuthenticationAPI key
SetupSelf-service

Getting started with the Freshsales connector

Section titled “Getting started with the Freshsales connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Freshsales 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
Freshsales API Key. See here. The key is case sensitive.

|

When you set up the connector, you provide:

Field Description
Domain Name
The Name of your Freshsales domain

|

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

accounts (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
city STRING
name STRING
email STRING
phone STRING
state STRING
avatar STRING
medium STRING
address STRING
country STRING
keyword STRING
twitter STRING
website STRING
zipcode STRING
facebook STRING
linkedin STRING
owner_id INT64
job_title STRING
last_name STRING
last_seen STRING
time_zone STRING
created_at STRING
first_name STRING
is_deleted BOOL
lead_score INT64
updated_at STRING
work_email STRING
external_id STRING
recent_note STRING
work_number STRING
customer_fit STRING
display_name STRING
territory_id INT64
mobile_number STRING
annual_revenue FLOAT64
last_contacted STRING
won_deals_count INT64
business_type_id INT64
industry_type_id INT64
last_assigned_at STRING
open_deals_count INT64
won_deals_amount STRING
open_deals_amount STRING
subscription_types STRING
last_contacted_mode STRING
number_of_employees INT64
subscription_status INT64
active_sales_sequences STRING
parent_sales_account_id INT64
completed_sales_sequences STRING
whatsapp_subscription_status STRING
last_contacted_via_sales_activity STRING
last_contacted_sales_activity_mode 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.
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.
completed_tasks (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
title STRING
description STRING
due_date STRING
targetable_id INT64
targetable_type STRING
possible STRING
owner_id INT64
status INT64
creater_id INT64
created_at STRING
updated_at STRING
outcome_id INT64
task_type_id INT64
updater_id INT64
completed_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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (71 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
city STRING
email STRING
state STRING
avatar STRING
locale STRING
mcr_id INT64
medium STRING
address STRING
country STRING
keyword STRING
twitter STRING
zipcode STRING
facebook STRING
linkedin STRING
owner_id INT64
job_title STRING
last_name STRING
last_seen STRING
time_zone STRING
created_at STRING
first_name STRING
is_deleted BOOL
lead_score INT64
updated_at STRING
work_email STRING
campaign_id INT64
external_id STRING
last_medium STRING
last_source STRING
recent_note STRING
work_number STRING
customer_fit INT64
display_name STRING
first_medium STRING
first_source STRING
territory_id INT64
web_form_ids STRING
last_campaign STRING
latest_medium STRING
latest_source STRING
mobile_number STRING
team_user_ids STRING
first_campaign STRING
last_contacted STRING
last_seen_chat STRING
lead_source_id INT64
total_sessions STRING
first_seen_chat STRING
latest_campaign STRING
won_deals_count INT64
last_assigned_at STRING
open_deals_count INT64
sales_account_id INT64
won_deals_amount STRING
contact_status_id INT64
open_deals_amount STRING
lifecycle_stage_id INT64
subscription_types STRING
last_contacted_mode STRING
subscription_status INT64
unsubscription_reason STRING
active_sales_sequences STRING
sms_subscription_status INT64
completed_sales_sequences STRING
other_unsubscription_reason STRING
whatsapp_subscription_status INT64
last_contacted_via_sales_activity STRING
last_contacted_sales_activity_mode 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.
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.
contacts_filters (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
deals_filter (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lost_deals (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
amount STRING
currency_id INT64
base_currency_amount STRING
sales_account_id INT64
deal_stage_id INT64
deal_reason_id INT64
deal_type_id INT64
owner_id INT64
expected_close STRING
closed_date STRING
lead_source_id INT64
campaign_id INT64
deal_product_id INT64
deal_payment_status_id INT64
probability INT64
created_at STRING
updated_at STRING
territory_id INT64
deal_pipeline_id INT64
stage_updated_time STRING
age INT64
recent_note STRING
completed_sales_sequences STRING
active_sales_sequences STRING
web_form_id INT64
upcoming_activities_time STRING
last_assigned_at STRING
last_contacted_sales_activity_mode STRING
last_contacted_via_sales_activity STRING
expected_deal_value STRING
is_deleted BOOL
team_user_ids STRING
avatar STRING
forecast_category INT64
deal_prediction_last_updated_at STRING
rotten_days INT64
has_products BOOL
products STRING
last_deal_prediction STRING
deal_prediction INT64
freddy_forecast_metrics 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.
open_deals (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
amount STRING
currency_id INT64
base_currency_amount STRING
sales_account_id INT64
deal_stage_id INT64
deal_reason_id INT64
deal_type_id INT64
owner_id INT64
expected_close STRING
closed_date STRING
lead_source_id INT64
campaign_id INT64
deal_product_id INT64
deal_payment_status_id INT64
probability INT64
created_at STRING
updated_at STRING
territory_id INT64
deal_pipeline_id INT64
stage_updated_time STRING
age INT64
recent_note STRING
completed_sales_sequences STRING
active_sales_sequences STRING
web_form_id INT64
upcoming_activities_time STRING
last_assigned_at STRING
last_contacted_sales_activity_mode STRING
last_contacted_via_sales_activity STRING
expected_deal_value STRING
is_deleted BOOL
team_user_ids STRING
avatar STRING
forecast_category INT64
deal_prediction_last_updated_at STRING
rotten_days INT64
has_products BOOL
products STRING
last_deal_prediction STRING
deal_prediction INT64
freddy_forecast_metrics 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.
open_tasks (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
title STRING
description STRING
due_date STRING
targetable_id INT64
targetable_type STRING
possible STRING
owner_id INT64
status INT64
creater_id INT64
created_at STRING
updated_at STRING
outcome_id INT64
task_type_id INT64
updater_id INT64
completed_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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
past_appointments (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
from_date STRING
date STRING
start STRING
end_date STRING
end STRING
time_zone STRING
title STRING
description STRING
creater_id INT64
targetable_id INT64
targetable_type STRING
possible STRING
location STRING
created_at STRING
updated_at STRING
is_allday BOOL
outcome_id INT64
latitude STRING
longitude STRING
checkedin_at STRING
checkedout_location STRING
can_checkin_checkout BOOL
checkedout_latitude STRING
checkedin_duration STRING
checkedout_longitude STRING
can_checkin BOOL
provider STRING
checkedout_at STRING
conference_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: past_appointments__appointment_attendees_attributes

Section titled “Subtable: past_appointments__appointment_attendees_attributes”
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.
sales_accounts_filter (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
upcoming_appointments (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
from_date STRING
date STRING
start STRING
end_date STRING
end STRING
time_zone STRING
title STRING
description STRING
creater_id INT64
targetable_id INT64
targetable_type STRING
possible STRING
location STRING
created_at STRING
updated_at STRING
is_allday BOOL
outcome_id INT64
latitude STRING
longitude STRING
checkedin_at STRING
checkedout_location STRING
can_checkin_checkout BOOL
checkedout_latitude STRING
checkedin_duration STRING
checkedout_longitude STRING
can_checkin BOOL
provider STRING
checkedout_at STRING
conference_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: upcoming_appointments__appointment_attendees_attributes

Section titled “Subtable: upcoming_appointments__appointment_attendees_attributes”
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: upcoming_appointments__targetables

Section titled “Subtable: upcoming_appointments__targetables”
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.
won_deals (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
amount STRING
currency_id INT64
base_currency_amount STRING
sales_account_id INT64
deal_stage_id INT64
deal_reason_id INT64
deal_type_id INT64
owner_id INT64
expected_close STRING
closed_date STRING
lead_source_id INT64
campaign_id INT64
deal_product_id INT64
deal_payment_status_id INT64
probability INT64
created_at STRING
updated_at STRING
territory_id INT64
deal_pipeline_id INT64
stage_updated_time STRING
age INT64
recent_note STRING
completed_sales_sequences STRING
active_sales_sequences STRING
web_form_id INT64
upcoming_activities_time STRING
last_assigned_at STRING
last_contacted_sales_activity_mode STRING
last_contacted_via_sales_activity STRING
expected_deal_value STRING
is_deleted BOOL
team_user_ids STRING
avatar STRING
forecast_category INT64
deal_prediction_last_updated_at STRING
rotten_days INT64
has_products BOOL
products STRING
last_deal_prediction STRING
deal_prediction INT64
freddy_forecast_metrics 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.

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

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

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

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

Use open_deals, won_deals, and lost_deals to track pipeline value and win rates over time.

Join contacts with accounts to understand your customers and where deals sit.

Bring open_tasks, completed_tasks, and appointments together to see how reps work accounts.

Group deals by stage to build a clearer view of expected revenue.

Use Freshsales data in your AI and BI tools

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

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