Skip to content
Book a demoStart free
Connectors

Flowlu connector

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

Flowlu connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Flowlu 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 Flowlu CRM and project data into BigQuery with Kaivo to report on pipeline, projects, and billing in one place.

CategoryCRM, Project Management
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Flowlu 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
The API key to use for authentication

|

When you set up the connector, you provide:

Field Description
Company
Your Flowlu company subdomain (e.g. if your Flowlu URL is mycompany.flowlu.com, enter mycompany).

|

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

account (64 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
vat STRING
vat1 STRING
vat2 STRING
account_category_id FLOAT64
active FLOAT64
address STRING
address_legal STRING
bank_details STRING
billing_address_line_1 STRING
billing_address_line_2 STRING
billing_address_line_3 STRING
billing_city STRING
billing_country STRING
billing_state STRING
billing_zip STRING
created_date STRING
email STRING
email_personal STRING
extra_fields STRING
first_name STRING
guid_1c STRING
honorific_title_id FLOAT64
id FLOAT64
industry_id FLOAT64
last_activity_id FLOAT64
last_activity_model STRING
last_activity_time STRING
last_name STRING
link_facebook STRING
link_google STRING
link_instagram STRING
link_linkedin STRING
link_vk STRING
merged_to FLOAT64
middle_name STRING
name STRING
name_legal STRING
name_legal_full STRING
organization_employee_count FLOAT64
organization_expenses FLOAT64
organization_registration_date STRING
organization_revenue FLOAT64
owner_id FLOAT64
phone STRING
phone2 STRING
phone3 STRING
ref STRING
ref_id FLOAT64
shipping_address_line_1 STRING
shipping_address_line_2 STRING
shipping_address_line_3 STRING
shipping_city STRING
shipping_country STRING
shipping_state STRING
shipping_zip STRING
skype STRING
telegram STRING
timezone STRING
updated_date STRING
web STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_categories (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
assignee_id FLOAT64
color STRING
created_date STRING
id FLOAT64
name STRING
ordering FLOAT64
parent_id FLOAT64
project_id FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_epics (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_by FLOAT64
created_date STRING
end_date STRING
id FLOAT64
is_completed FLOAT64
name STRING
ordering FLOAT64
project_id FLOAT64
start_date STRING
updated_by FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_issue_relation_names (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_date STRING
id FLOAT64
name STRING
tree_type FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_issue_relation_types (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
child_relation_name_id FLOAT64
created_date STRING
id FLOAT64
name STRING
parent_relation_name_id FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_issue_type (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
color STRING
created_date STRING
icon STRING
id FLOAT64
is_default FLOAT64
name STRING
ordering FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_issues (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
archived_date STRING
assignee_id FLOAT64
category_id FLOAT64
completed_date STRING
created_date STRING
creator_id FLOAT64
effort FLOAT64
epic_id FLOAT64
estimate FLOAT64
id FLOAT64
is_archived FLOAT64
name STRING
number FLOAT64
number_label STRING
ordering FLOAT64
parent_issue_id FLOAT64
priority FLOAT64
project_id FLOAT64
ref STRING
ref_id STRING
sprint_id FLOAT64
type_id FLOAT64
updated_date STRING
value STRING
workflow_stage_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_sprints (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active FLOAT64
changelog STRING
created_date STRING
deadline STRING
id FLOAT64
name STRING
project_id FLOAT64
standup_time STRING
start_date STRING
started FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_stages (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
color STRING
created_date STRING
id FLOAT64
name STRING
ordering FLOAT64
status FLOAT64
updated_date STRING
workflow_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agile_workflows (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_date STRING
id FLOAT64
name STRING
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
bank_account (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
account_group_id FLOAT64
active FLOAT64
bcy_balance FLOAT64
closed_at STRING
currency_exchange_rate FLOAT64
currency_id FLOAT64
excluded_balance FLOAT64
fixed_balance FLOAT64
fixed_balance_date STRING
id FLOAT64
manager_id FLOAT64
name STRING
ordering FLOAT64
ordering_by_group FLOAT64
org_id FLOAT64
pls_bcy_balance FLOAT64
pls_fixed_balance FLOAT64
pls_fixed_balance_date STRING
ref STRING
ref_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
calendar (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
color STRING
created_by FLOAT64
created_date STRING
etag STRING
id FLOAT64
name STRING
sync_type FLOAT64
timezone STRING
updated_by FLOAT64
updated_date STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_fields (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
active FLOAT64
alias STRING
api_use_alias FLOAT64
cache_parent_id FLOAT64
cache_value STRING
fieldset_id FLOAT64
formula STRING
group_id FLOAT64
group_label_field_id FLOAT64
hidden_detail FLOAT64
hint STRING
id FLOAT64
model STRING
module STRING
name STRING
ordering FLOAT64
parent_id FLOAT64
required FLOAT64
scope_id FLOAT64
show_in_mobile FLOAT64
show_on_detail_page FLOAT64
webhook_use_alias FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_fields_field_sets (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
group_field STRING
group_id FLOAT64
id FLOAT64
model STRING
module STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customer_payment (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
bank_account_id FLOAT64
charge FLOAT64
complete_date STRING
created_by FLOAT64
created_date STRING
crm_company_id FLOAT64
currency_id FLOAT64
date STRING
enddate STRING
id FLOAT64
is_complete FLOAT64
is_manual FLOAT64
is_owed FLOAT64
name STRING
need_approve FLOAT64
ordering FLOAT64
org_id FLOAT64
owner_id FLOAT64
project_id FLOAT64
project_stage_id FLOAT64
ref STRING
ref_id STRING
ref_uuid STRING
reference STRING
startdate STRING
status FLOAT64
status_pls FLOAT64
total FLOAT64
updated_by FLOAT64
updated_date STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
emails (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
account_id FLOAT64
comment STRING
email STRING
id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
estimates (67 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
active FLOAT64
adjustment FLOAT64
adjustment_description STRING
assignee_id FLOAT64
bill_from_address STRING
bill_from_city STRING
bill_from_country_id FLOAT64
bill_from_state STRING
bill_from_zip STRING
bill_to_address STRING
bill_to_city STRING
bill_to_country_id FLOAT64
bill_to_state STRING
bill_to_zip STRING
company_phone STRING
company_phone2 STRING
company_vat STRING
company_vat2 STRING
contact_person STRING
contact_person_position STRING
created_by FLOAT64
currency_code STRING
currency_id FLOAT64
customer_id FLOAT64
customer_legal_name STRING
customer_name STRING
discount FLOAT64
discount_before_tax FLOAT64
estimate_emailed_date STRING
estimate_footer_text STRING
estimate_number FLOAT64
estimate_number_print STRING
estimate_terms_text STRING
exchange_rate FLOAT64
expire_date STRING
group_id FLOAT64
id FLOAT64
invoice_date STRING
is_discount_percent FLOAT64
model STRING
model_id FLOAT64
module STRING
org_id FLOAT64
org_phone STRING
org_phone2 STRING
org_vat STRING
org_vat2 STRING
pricelist_id FLOAT64
ref STRING
ref_id STRING
reference_number STRING
shipping_charge FLOAT64
status_id FLOAT64
sub_total FLOAT64
tax1 FLOAT64
tax1_included FLOAT64
tax2 FLOAT64
tax2_included FLOAT64
tax_total FLOAT64
template_id FLOAT64
total FLOAT64
updated_by FLOAT64
updated_date STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoice (92 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
adjustment FLOAT64
adjustment_description STRING
assignee_id FLOAT64
bank STRING
bank_id FLOAT64
bcy_paid_total FLOAT64
bill_from_address STRING
bill_from_city STRING
bill_from_country_id FLOAT64
bill_from_state STRING
bill_from_zip STRING
bill_to_address STRING
bill_to_city STRING
bill_to_country_id FLOAT64
bill_to_state STRING
bill_to_zip STRING
category_id FLOAT64
company_phone STRING
company_phone2 STRING
company_vat STRING
company_vat2 STRING
contact_person STRING
contact_person2 STRING
contact_person2_position STRING
contact_person_position STRING
created_by FLOAT64
created_date STRING
currency_code STRING
currency_id FLOAT64
customer_id FLOAT64
customer_legal_name STRING
customer_name STRING
discount FLOAT64
discount_before_tax FLOAT64
due_date STRING
estimate_id FLOAT64
exported_1c FLOAT64
group_id FLOAT64
id FLOAT64
invoice_date STRING
invoice_emailed_date STRING
invoice_footer_text STRING
invoice_number FLOAT64
invoice_number_print STRING
invoice_terms_text STRING
is_discount_percent FLOAT64
is_invoice_emailed FLOAT64
is_reminder_sent FLOAT64
is_template FLOAT64
model STRING
model_id FLOAT64
module STRING
note STRING
org_account_id FLOAT64
org_id FLOAT64
org_phone STRING
org_phone2 STRING
org_vat STRING
org_vat2 STRING
paid_date STRING
payment_options STRING
paymethod_id FLOAT64
plan_money_id FLOAT64
plan_money_total FLOAT64
pm_currency_id FLOAT64
pricelist_id FLOAT64
ps_currency_id FLOAT64
pscy_paid_total FLOAT64
recurring_invoice_id FLOAT64
ref STRING
ref_id STRING
reference STRING
reminders_sent_date STRING
shipping_charge FLOAT64
show_add_sign_string FLOAT64
status_id FLOAT64
sub_total FLOAT64
tax1 FLOAT64
tax1_included FLOAT64
tax2 FLOAT64
tax2_included FLOAT64
tax_total FLOAT64
template_id FLOAT64
template_name STRING
total FLOAT64
updated_by FLOAT64
updated_date STRING
use_multiple_pm FLOAT64
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoice_contacts (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
contact_id STRING
email_id FLOAT64
id FLOAT64
invoice_emailed FLOAT64
invoice_emailed_date STRING
invoice_id FLOAT64
is_primary FLOAT64
reminders_sent FLOAT64
reminders_sent_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoice_items (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
bcy_paid_total FLOAT64
discount STRING
discount_amount FLOAT64
discount_is_percent FLOAT64
id FLOAT64
invoice_id FLOAT64
item_id FLOAT64
name STRING
online_payment_subject_type FLOAT64
online_payment_type FLOAT64
online_payment_vat FLOAT64
ordering FLOAT64
paid_date STRING
paid_total FLOAT64
plan_money_id FLOAT64
plan_money_total FLOAT64
quantity FLOAT64
ref STRING
ref_id STRING
sub_total FLOAT64
tax1 FLOAT64
tax1_amount FLOAT64
tax1_included FLOAT64
tax2 FLOAT64
tax2_amount FLOAT64
tax2_included FLOAT64
tax_displayed STRING
tax_total FLOAT64
total FLOAT64
unit_id FLOAT64
unit_price FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lead (43 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active FLOAT64
adjustment FLOAT64
adjustment_description STRING
assignee_id FLOAT64
auto_calc STRING
budget FLOAT64
cf_1 STRING
cf_2 STRING
cf_2_value STRING
closing_comment STRING
closing_date STRING
closing_status_id FLOAT64
contact_company STRING
contact_email STRING
contact_id FLOAT64
contact_mobile STRING
contact_name STRING
contact_phone STRING
contact_position STRING
contact_web STRING
created_by FLOAT64
created_date STRING
customer_id FLOAT64
deadline STRING
id FLOAT64
last_activity_id FLOAT64
last_activity_model STRING
last_activity_time STRING
merged_to_id FLOAT64
name STRING
ordering FLOAT64
pipeline_id FLOAT64
pipeline_stage_id FLOAT64
pricelist_id FLOAT64
ref STRING
ref_id FLOAT64
shipping_charge FLOAT64
source_id FLOAT64
start_date STRING
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lists (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active FLOAT64
color STRING
created_by FLOAT64
created_date STRING
icon STRING
id FLOAT64
name STRING
ordering FLOAT64
updated_by FLOAT64
updated_date STRING
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
loss_reason (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active FLOAT64
id FLOAT64
name STRING
ordering FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
pipeline (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id FLOAT64
name STRING
ordering FLOAT64
type_access STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_categories (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active FLOAT64
created STRING
created_by FLOAT64
id FLOAT64
name STRING
parent_id FLOAT64
ref STRING
ref_id STRING
updated STRING
updated_by FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_list (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
active FLOAT64
article STRING
category_id FLOAT64
code STRING
code_ean STRING
code_isbn STRING
code_mpn STRING
code_upc STRING
created STRING
created_by FLOAT64
full_description STRING
id FLOAT64
manufacturer_id FLOAT64
name STRING
online_payment_subject_type FLOAT64
online_payment_type FLOAT64
online_payment_vat FLOAT64
pricelist_currency_1 STRING
pricelist_price_1 STRING
ref STRING
ref_id STRING
tax FLOAT64
tax_desc STRING
tax_included FLOAT64
taxable FLOAT64
unit_id FLOAT64
uom_id FLOAT64
updated STRING
updated_by FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_manufacturer (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active FLOAT64
created STRING
created_by FLOAT64
crm_company_id FLOAT64
currency_id FLOAT64
id FLOAT64
name STRING
ref STRING
ref_id STRING
updated STRING
updated_by FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
product_price_list (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
active FLOAT64
created STRING
created_by FLOAT64
default FLOAT64
id FLOAT64
name STRING
ordering FLOAT64
ref STRING
ref_id STRING
updated STRING
updated_by FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
project_observers (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
project_id FLOAT64
role FLOAT64
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
projects (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
archive_date STRING
archive_description STRING
bill_taxes FLOAT64
billing_type FLOAT64
briefcase_id FLOAT64
created_by FLOAT64
created_date STRING
crm_lead_id FLOAT64
customer_crm_contact_id FLOAT64
customer_id FLOAT64
default_bill_time_type STRING
default_billing_rate FLOAT64
default_employee_cost_rate FLOAT64
default_invoice_item_format STRING
default_invoice_split_type_in_project FLOAT64
default_only_completed_task STRING
default_time_cost_type STRING
enddate STRING
estimated_expenses FLOAT64
estimated_revenue FLOAT64
extra_fields STRING
id FLOAT64
is_archive FLOAT64
manager_id FLOAT64
name STRING
ordering FLOAT64
priority FLOAT64
project_type_id FLOAT64
ref STRING
ref_id STRING
stage_id FLOAT64
startdate STRING
tasks_workflow_id FLOAT64
updated_by FLOAT64
updated_date STRING
use_default_invoice_split_type FLOAT64
uuid STRING
workspace_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
st_projects_users (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
project_id FLOAT64
role FLOAT64
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
task_lists (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_by FLOAT64
created_date STRING
id FLOAT64
list_id FLOAT64
task_id FLOAT64
updated_by FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
task_workflows (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active FLOAT64
created_by FLOAT64
id FLOAT64
name STRING
ordering FLOAT64
updated_by FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tasks (64 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
all_day FLOAT64
archive_status FLOAT64
closed_by FLOAT64
closed_date STRING
cost FLOAT64
cost_type STRING
created_date STRING
crm_account_id FLOAT64
deadline STRING
deadline_allowchange FLOAT64
event_access_type FLOAT64
event_busy_status FLOAT64
event_calendar_id FLOAT64
event_color STRING
event_etag STRING
event_location STRING
event_sync_type FLOAT64
event_type FLOAT64
extra_fields STRING
first_closed_date STRING
id FLOAT64
is_archive STRING
is_hidden FLOAT64
is_repeat FLOAT64
model STRING
model_id FLOAT64
module STRING
name STRING
ordering FLOAT64
owner_id FLOAT64
parent_id FLOAT64
plan_end_date STRING
plan_start_date STRING
prev_task_id FLOAT64
price FLOAT64
price_type STRING
priority FLOAT64
project_checkitem_id FLOAT64
project_stage_id FLOAT64
public_template FLOAT64
rating FLOAT64
ref STRING
ref_id STRING
report STRING
report_complete STRING
responsible_id FLOAT64
return_count FLOAT64
start_date STRING
status_firstviewdate STRING
status_updated_by FLOAT64
status_updated_date STRING
task_checkbyowner FLOAT64
template_id FLOAT64
time_estimate FLOAT64
time_spent FLOAT64
updated_by FLOAT64
updated_date STRING
uuid STRING
workflow_id FLOAT64
workflow_stage_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
timesheet (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
aggregated_time_estimate FLOAT64
amount_timeestimate FLOAT64
amount_timespent FLOAT64
bill_amount_timeestimate FLOAT64
bill_amount_timespent FLOAT64
bill_cost_timeestimate FLOAT64
bill_cost_timespent FLOAT64
bill_time FLOAT64
bill_time_estimate FLOAT64
bill_time_type STRING
billing_rate FLOAT64
billing_status FLOAT64
cost_time_type STRING
created_by FLOAT64
created_date STRING
currency_id FLOAT64
employee_cost_rate FLOAT64
id FLOAT64
invoice_id FLOAT64
is_billable FLOAT64
is_billable_employee FLOAT64
model STRING
model_id FLOAT64
module STRING
parent_sheet_id FLOAT64
rate FLOAT64
time_estimate FLOAT64
time_spent FLOAT64
unbill_time FLOAT64
unbill_time_estimate FLOAT64
updated_by FLOAT64
updated_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transactions (44 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
description STRING
bcy_charge FLOAT64
bcy_income FLOAT64
bcy_outcome FLOAT64
business_line_id FLOAT64
category_id FLOAT64
charge FLOAT64
created_by FLOAT64
created_date STRING
crm_account_id FLOAT64
currency_exchange_rate FLOAT64
currency_id FLOAT64
date STRING
id FLOAT64
income FLOAT64
invoice_id FLOAT64
is_charge FLOAT64
is_generated FLOAT64
is_storno FLOAT64
manager_id FLOAT64
name STRING
ordering FLOAT64
org_account_id FLOAT64
org_id FLOAT64
outcome FLOAT64
plan_money_id FLOAT64
plan_money_total FLOAT64
pm_currency_id FLOAT64
project_id FLOAT64
ref STRING
ref_id FLOAT64
ref_uuid STRING
reference STRING
reference_id FLOAT64
status FLOAT64
store_doc_currency_id FLOAT64
store_doc_id FLOAT64
store_doc_total FLOAT64
updated_by FLOAT64
updated_date STRING
uuid 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 Flowlu 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 Flowlu?

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

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

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

Use lead and pipeline to track pipeline value and conversion over time.

Join projects with tasks to follow delivery and workload.

Use invoice and customer_payment to track revenue and outstanding balances.

Once Flowlu 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 Flowlu 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 Flowlu 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.