Skip to content
Book a demoStart free
Connectors

JobNimbus connector

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

JobNimbus connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your JobNimbus 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 JobNimbus data into BigQuery with Kaivo to report on jobs, contacts, and activity across your pipeline.

CategoryCRM, Project Management
AuthenticationAPI key
SetupSelf-service

Getting started with the JobNimbus connector

Section titled “Getting started with the JobNimbus connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your JobNimbus 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
API key to use. Find it by logging into your JobNimbus account, navigating to settings, and creating a new API key under the API section.

|

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

activities (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_by STRING
created_by_name STRING
customer STRING
date_created FLOAT64
date_updated FLOAT64
is_active BOOL
is_archived BOOL
is_editable BOOL
is_status_change BOOL
jnid STRING
location__id FLOAT64
note STRING
primary__type STRING
primary__id STRING
primary__name STRING
primary__new_status FLOAT64
primary__number STRING
record_type FLOAT64
record_type_name STRING
sales_rep STRING
sales_rep_name STRING
source 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.
id 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
name STRING
new_status FLOAT64
number STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (60 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
actual_time FLOAT64
address_line1 STRING
address_line2 STRING
approved_estimate_total FLOAT64
approved_invoice_due FLOAT64
approved_invoice_total FLOAT64
attachment_count FLOAT64
city STRING
company STRING
country_name STRING
created_by STRING
created_by_name STRING
customer STRING
date_created FLOAT64
date_end FLOAT64
date_start FLOAT64
date_status_change FLOAT64
date_updated FLOAT64
disable_auto_text BOOL
display_name STRING
email STRING
estimated_time FLOAT64
fax_number STRING
first_name STRING
geo__lat FLOAT64
geo__lon FLOAT64
home_phone STRING
is_active BOOL
is_archived BOOL
is_sub_contractor BOOL
is_user BOOL
jnid STRING
last_budget_gross_margin FLOAT64
last_budget_gross_profit FLOAT64
last_budget_revenue FLOAT64
last_estimate FLOAT64
last_estimate_date_created FLOAT64
last_estimate_date_estimate FLOAT64
last_invoice FLOAT64
last_invoice_date_created FLOAT64
last_invoice_date_invoice FLOAT64
last_name STRING
location__id FLOAT64
mobile_phone STRING
number STRING
recid FLOAT64
record_type FLOAT64
record_type_name STRING
sales_rep STRING
sales_rep_name STRING
state_text STRING
status FLOAT64
status_name STRING
task_count FLOAT64
website STRING
work_phone STRING
zip 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.
id 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.
files (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
content_type STRING
created_by STRING
created_by_name STRING
customer STRING
date_created FLOAT64
date_file_created FLOAT64
date_updated FLOAT64
filename STRING
is_active BOOL
jnid STRING
md5 STRING
primary__type STRING
primary__id STRING
primary__name STRING
record_type FLOAT64
record_type_name STRING
size 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 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.
id 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
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
jobs (64 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
actual_time FLOAT64
address_line1 STRING
address_line2 STRING
all_day BOOL
all_day_end_date STRING
all_day_start_date STRING
approved_estimate_total FLOAT64
approved_invoice_due FLOAT64
approved_invoice_total FLOAT64
attachment_count FLOAT64
city STRING
country_name STRING
created_by STRING
created_by_name STRING
customer STRING
date_created FLOAT64
date_end FLOAT64
date_start FLOAT64
date_status_change FLOAT64
date_updated FLOAT64
estimated_time FLOAT64
geo__lat FLOAT64
geo__lon FLOAT64
is_active BOOL
is_archived BOOL
jnid STRING
last_budget_gross_margin FLOAT64
last_budget_gross_profit FLOAT64
last_budget_revenue FLOAT64
last_estimate FLOAT64
last_estimate_date_created FLOAT64
last_estimate_date_estimate FLOAT64
last_invoice FLOAT64
last_invoice_date_created FLOAT64
last_invoice_date_invoice FLOAT64
location__id FLOAT64
name STRING
number STRING
parent_approved_estimate_total FLOAT64
parent_approved_invoice_due FLOAT64
parent_approved_invoice_total FLOAT64
parent_fax_number STRING
parent_home_phone STRING
parent_last_estimate FLOAT64
parent_last_invoice FLOAT64
parent_mobile_phone STRING
parent_work_phone STRING
primary__type STRING
primary__id STRING
primary__name STRING
primary__number STRING
recid FLOAT64
record_type FLOAT64
record_type_name STRING
sales_rep STRING
sales_rep_name STRING
state_text STRING
status FLOAT64
status_name STRING
task_count FLOAT64
zip 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.
id 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
name STRING
number 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.
tasks (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
actual_time FLOAT64
all_day BOOL
all_day_end_date STRING
all_day_start_date STRING
created_by STRING
created_by_name STRING
customer STRING
date_created FLOAT64
date_end FLOAT64
date_start FLOAT64
date_updated FLOAT64
estimated_time FLOAT64
hide_from_calendarview BOOL
hide_from_tasklist BOOL
is_active BOOL
is_archived BOOL
is_completed BOOL
jnid STRING
location__id FLOAT64
number STRING
priority FLOAT64
recid FLOAT64
record_type FLOAT64
record_type_name STRING
title 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.
id 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
name STRING
number 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 JobNimbus 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 JobNimbus?

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

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

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

Use jobs and tasks to follow work from lead to completion.

Join jobs with contacts to track pipeline and conversion over time.

Use activities to measure follow-up and where jobs stall.

Use JobNimbus data in your AI and BI tools

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

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

  • Custobar: Sync Custobar to BigQuery.
  • HubSpot: Sync HubSpot to BigQuery.
  • Attio: Sync Attio to BigQuery.
  • ClickUp: Sync ClickUp to BigQuery.
  • Cuuma: Sync Cuuma to BigQuery.
  • GitHub: Sync GitHub to BigQuery.