Skip to content
Book a demoStart free
Connectors

WorkflowMAX connector

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

WorkflowMAX connector pricing, tier and credits on kaivo.io

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

Sync your WorkflowMax data into BigQuery with Kaivo to analyse jobs, invoices, and project profitability.

CategoryProject Management
AuthenticationAPI key
SetupSelf-service

Getting started with the WorkflowMAX connector

Section titled “Getting started with the WorkflowMAX connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your WorkflowMAX 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
Your WorkflowMax OAuth 2.0 access token, sent as a Bearer token. Obtain it through the WorkflowMax (Xero) OAuth flow; first enable API access under your staff profile (staff list → your name → ‘Authorise 3rd Party Full Access’).

|

When you set up the connector, you provide:

Field Description
Account ID
Your WorkflowMax organisation ID, sent as a required header on every request. It is embedded in your OAuth access token (decode the JWT to read it).

| | Start Date |

Only sync records dated on or after this date.

|

Tables and columns synced from WorkflowMAX

Section titled “Tables and columns synced from WorkflowMAX”

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

clientgrouplist (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
taxable STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
clientlist (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_manager__name STRING
account_manager__uuid STRING
address STRING
city STRING
country STRING
fax STRING
is_archived STRING
is_deleted STRING
is_prospect STRING
name STRING
phone STRING
post_code STRING
postal_address STRING
referral_source STRING
uuid STRING
web_url STRING
website 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.
addressee STRING
email STRING
is_primary STRING
mobile STRING
name STRING
phone STRING
position STRING
salutation STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
clients_documents (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_by STRING
date STRING
folder STRING
text STRING
title STRING
url STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
costlist (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
code STRING
description STRING
note STRING
supplier__name STRING
supplier__uuid STRING
uuid STRING
unit_cost STRING
unit_price STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoice_current (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount STRING
amount_including_tax STRING
amount_outstanding STRING
amount_paid STRING
amount_tax STRING
client__name STRING
client__uuid STRING
contact__name STRING
contact__uuid STRING
date STRING
description STRING
due_date STRING
id STRING
job_text STRING
status STRING
type STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoicelist (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount STRING
amount_including_tax STRING
amount_outstanding STRING
amount_paid STRING
amount_tax STRING
client__name STRING
client__uuid STRING
contact__name STRING
contact__uuid STRING
date STRING
description STRING
due_date STRING
id STRING
job_text STRING
status STRING
type STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
job_tasks (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assigned__staff__name STRING
assigned__staff__uuid STRING
budget STRING
client__name STRING
client__uuid STRING
client_order_number STRING
contact__name STRING
contact__uuid STRING
date_created_utc STRING
date_modified_utc STRING
description STRING
due_date STRING
id STRING
manager__name STRING
manager__uuid STRING
name STRING
partner__name STRING
partner__uuid STRING
start_date STRING
state STRING
tasks__task__actual_minutes STRING
tasks__task__assigned__staff__allocated_minutes STRING
tasks__task__assigned__staff__name STRING
tasks__task__assigned__staff__uuid STRING
tasks__task__billable STRING
tasks__task__completed STRING
tasks__task__description STRING
tasks__task__due_date STRING
tasks__task__estimated_minutes STRING
tasks__task__name STRING
tasks__task__start_date STRING
tasks__task__task_uuid STRING
tasks__task__uuid STRING
uuid STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
joblist (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assigned__staff__name STRING
assigned__staff__uuid STRING
budget STRING
client__name STRING
client__uuid STRING
client_order_number STRING
date_created_utc STRING
date_modified_utc STRING
description STRING
due_date STRING
id STRING
manager__name STRING
manager__uuid STRING
name STRING
partner__name STRING
partner__uuid STRING
start_date STRING
state STRING
uuid STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
leadlist (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
client__name STRING
client__uuid STRING
contact__name STRING
contact__uuid STRING
date STRING
description STRING
dropbox STRING
estimated_value STRING
name STRING
owner__name STRING
owner__uuid STRING
state STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchaseorderlist (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount STRING
amount_including_tax STRING
amount_tax STRING
date STRING
delivery_address STRING
description STRING
id STRING
job__id STRING
job__name STRING
state STRING
supplier__name STRING
supplier__uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
quotelist (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount STRING
amount_including_tax STRING
amount_tax STRING
budget STRING
client__name STRING
client__uuid STRING
contact__name STRING
contact__uuid STRING
date STRING
description STRING
estimated_cost STRING
estimated_cost_including_tax STRING
estimated_cost_tax STRING
id STRING
name STRING
option_explanation STRING
state STRING
type STRING
uuid STRING
valid_date STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
stafflist (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
email STRING
mobile STRING
name STRING
payroll_code STRING
phone STRING
uuid STRING
web_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
supplierlist (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
fax STRING
name STRING
phone STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tasklist (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
name STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
timelist (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billable STRING
date STRING
job__id STRING
job__name STRING
minutes STRING
note STRING
staff__name STRING
staff__uuid STRING
task__name STRING
task__uuid 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 WorkflowMAX 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 WorkflowMAX?

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

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

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

Use joblist and job_tasks with costlist to compare billed work against costs.

Join invoicelist with clientlist to track revenue and outstanding balances.

Use leadlist and quotelist to follow work from lead to job.

Use WorkflowMAX data in your AI and BI tools

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

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

  • ClickUp: Sync ClickUp to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.
  • Harvest: Sync Harvest to BigQuery.
  • Jira: Sync Jira to BigQuery.
  • Kellokortti: Sync Kellokortti to BigQuery.