Skip to content
Book a demoStart free
Connectors

Clockify connector

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

Clockify connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Clockify 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 Clockify time tracking data into BigQuery with Kaivo to analyse hours, billable time, and project profitability.

CategoryProject Management
AuthenticationAPI key
SetupSelf-service

Getting started with the Clockify connector

Section titled “Getting started with the Clockify connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Clockify 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 Clockify API key. Generate one at User Settings.

|

When you set up the connector, you provide:

Field Description
Workspace ID
Your Clockify workspace ID. Found in the URL when logged in, e.g. app.clockify.me/en/workspaces/[workspace_id]/settings.

|

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

clients (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING Client’s physical address.
archived BOOL Indicates if the client is archived (true) or active (false).
email STRING Client’s contact email address.
id STRING Unique identifier for the client.
name STRING Name of the client.
note STRING Additional notes related to the client.
workspace_id STRING Identifier for the workspace to which the client belongs.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
projects (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
archived BOOL Indicates if the project is archived or not.
billable BOOL Indicates if the project is billable or not.
budget_estimate JSON The estimated budget for the project.
client_id STRING The ID of the client associated with the project.
client_name STRING The name of the client associated with the project.
color STRING Color code used to visually identify the project.
cost_rate JSON Cost rate for the project.
duration STRING Total duration tracked for the project.
estimate__type STRING Type of estimation (e.g., hours, days).
estimate__estimate STRING Estimated time for the project.
hourly_rate__amount INT64 Hourly rate amount.
hourly_rate__currency STRING Currency of the hourly rate.
id STRING Unique identifier for the project.
name STRING Name of the project.
note STRING Additional notes or comments related to the project.
public BOOL Indicates if the project is public or private.
template BOOL Indicates if the project is a template or not.
time_estimate__type STRING Type of time estimation (e.g., hours, days).
time_estimate__active BOOL Indicates if the time estimate is active or not.
time_estimate__estimate STRING Estimated time for the project.
time_estimate__include_non_billable BOOL Indicates if non-billable time is included in the estimate.
time_estimate__reset_option STRING Option to reset the time estimate.
workspace_id STRING ID of the workspace to which the project belongs.
_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.
cost_rate JSON Cost rate for the membership.
hourly_rate JSON Hourly rate for the membership.
membership_status STRING Status of the membership.
membership_type STRING Type of membership.
target_id STRING ID of the target associated with the membership.
user_id STRING ID of the user associated with the membership.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
archived BOOL Indicates if the tag is archived or active.
id STRING Unique identifier for the tag.
name STRING Name of the tag.
workspace_id STRING Identifier of the workspace to which the tag belongs.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tasks (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
budget_estimate FLOAT64 Estimated budget for the task.
assignee_id STRING The unique identifier of the user assigned to the task.
billable BOOL Indicates whether the task is billable or not.
cost_rate JSON Cost rate associated with the task.
duration STRING Total duration of the task.
estimate STRING Estimated time required to complete the task.
hourly_rate JSON Hourly rate for billing purposes.
id STRING Unique identifier of the task.
name STRING Name or title of the task.
project_id STRING Unique identifier of the project the task belongs to.
status STRING Current status of the task.
_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 Unique identifier of a user.
_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.
time_entries (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billable BOOL Indicates if the time entry is billable or not
description STRING Description or notes about the time entry
id STRING Unique identifier for the time entry
is_locked BOOL Indicates if the time entry is locked or not
kiosk_id STRING Identifier for the kiosk associated with the time entry
project_id STRING Unique identifier for the project related to the time entry
tag_ids JSON Identifiers of tags associated with the time entry
task_id STRING Unique identifier for the task related to the time entry
time_interval__duration STRING Duration of the time entry
time_interval__end STRING End timestamp of the time entry
time_interval__start STRING Start timestamp of the time entry
type STRING Type of the time entry (e.g., time, leave, holiday)
user_id STRING Unique identifier for the user associated with the time entry
workspace_id STRING Unique identifier for the workspace of the time entry
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: time_entries__custom_field_values

Section titled “Subtable: time_entries__custom_field_values”
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.
user_groups (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier for the user group.
name STRING Name of the user group.
workspace_id STRING Identifier for the workspace to which the user group belongs.
_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 User ID of a member in the group.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active_workspace STRING The ID of the active workspace for the user.
default_workspace STRING The default workspace ID for the user.
email STRING The email address of the user.
id STRING The unique identifier of the user.
name STRING The name of the user.
profile_picture STRING URL to the user’s profile picture.
settings__alerts BOOL User’s alerts settings.
settings__approval BOOL User’s approval settings.
settings__collapse_all_project_lists BOOL User’s preference for collapsing all project lists.
settings__dashboard_pin_to_top BOOL User’s preference for pinning dashboard to the top.
settings__dashboard_selection STRING User’s dashboard selection.
settings__dashboard_view_type STRING User’s preferred dashboard view type.
settings__date_format STRING User’s preferred date format.
settings__group_similar_entries_disabled BOOL User’s preference for grouping similar entries.
settings__is_compact_view_on BOOL User’s preference for compact view.
settings__lang STRING User’s preferred language.
settings__long_running BOOL User’s long running settings.
settings__multi_factor_enabled BOOL Whether multi-factor authentication is enabled.
settings__my_start_of_day STRING User’s start of day setting.
settings__onboarding BOOL User’s onboarding settings.
settings__project_list_collapse INT64 User’s project list collapse setting.
settings__project_picker_task_filter BOOL User’s task filter for project picker.
settings__pto BOOL User’s PTO settings.
settings__reminders BOOL User’s reminder settings.
settings__scheduled_reports BOOL User’s scheduled reports settings.
settings__scheduling BOOL User’s scheduling settings.
settings__send_newsletter BOOL User’s preference for receiving newsletters.
settings__show_only_working_days BOOL User’s preference for showing only working days.
settings__summary_report_settings__group STRING Group setting for summary report.
settings__summary_report_settings__subgroup STRING Subgroup setting for summary report.
settings__theme STRING User’s preferred theme.
settings__time_format STRING User’s preferred time format.
settings__time_tracking_manual BOOL User’s manual time tracking settings.
settings__time_zone STRING User’s preferred time zone.
settings__week_start STRING User’s preferred start of the week.
settings__weekly_updates BOOL User’s settings for receiving weekly updates.
status STRING User’s status.
_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.

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

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

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

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

Use time_entries to track billable versus non-billable hours by project and client.

Join time_entries with projects and clients to compare logged time against budgets.

Group hours by user and user_group to see how time is spent across the team.

Bring tasks and tags together to understand where effort goes within each project.

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