Clockify

Adding the data source

By adding the Clockify data source to Kondado, you can access your data in your Data Warehouse or Data Lake – process also known as ETL or ELT

To add the Clockify data source, follow the steps below:

1) Log in to your Clockify account

Attention: The Clockify user used must have WORKSPACE_OWN or WORKSPACE_ADMIN permissions for the workspaces you want to replicate

2) Click on your profile picture in the left sidebar and then on “Profile settings”

3) In the API section you will find your API key (click on “Generate” if you don't have your API key yet). copy this value

4) Login to Kondado, go to the add data sources section and select the Clockify data source

5) On the data source data filling page, paste the value obtained in step (3) in “API key”

6) Now just name your data source and click SAVE

Pipeline

Relationship Chart

Gráfico de relacionamento entre tabelas

Workspaces

Field	Type
id	text
canseetimesheet	boolean
automaticlock__firstday	text
automaticlock__olderthanvalue	float
automaticlock__changeday	text
automaticlock__olderthanperiod	text
automaticlock__type	text
automaticlock__dayofmonth	float
isprojectpublicbydefault	boolean
projectfavorites	boolean
onlyadminscreatetag	boolean
forcetags	boolean
onlyadminscreateproject	boolean
tracktimedowntosecond	boolean
timeroundinginreports	boolean
hourlyrate__currency	text
hourlyrate__amount	float
timetrackingmode	text
onlyadminsseebillablerates	boolean
onlyadminsseepublicprojectsentries	boolean
onlyadminscreatetask	boolean
projectpickerspecialfilter	boolean
forceprojects	boolean
canseetracker	boolean
projectgroupinglabel	text
forcetasks	boolean
forcedescription	boolean
defaultbillableprojects	boolean
name	text
imageurl	text
locktimeentries	timestamp
onlyadminsseealltimeentries	boolean
onlyadminsseedashboard	boolean
round__minutes	float
round__round	text
featuresubscriptiontype	text

Projects

Field	Type
id	text
archived	boolean
name	text
color	text
billable	boolean
clientid	text
timeestimate__active	boolean
timeestimate__estimate	text
timeestimate__type	text
timeestimate__resetoption	text
note	text
public	boolean
workspaceid	text
template	boolean
hourlyrate__currency	text
hourlyrate__amount	float
duration	text
estimate__estimate	text
estimate__type	text
clientname	text
costrate__currency	text
costrate__amount	float

Clients

Field	Type
id	text
archived	boolean
workspaceid	text
address	text
name	text

Users

Main Object

Field	Type
id	text
status	text
profilepicture	text
name	text
activeworkspace	text
settings__timetrackingmanual	boolean
settings__groupsimilarentriesdisabled	boolean
settings__dashboardviewtype	text
settings__dateformat	text
settings__weekstart	text
settings__iscompactviewon	boolean
settings__longrunning	boolean
summaryreportsettingsgroup	text
summaryreportsettingssubgroup	text
settings__dashboardpintotop	boolean
settings__weeklyupdates	boolean
settings__sendnewsletter	boolean
settings__mystartofday	text
settings__timeformat	text
settings__timezone	text
settings__dashboardselection	text
settings__projectlistcollapse	float
settings__collapseallprojectlists	boolean
defaultworkspace	text
email	text

memberships

Field	Type
user_id	text
costrate	text
targetid	text
membershipstatus	text
membershiptype	text
hourlyrate_amount	float
hourlyrate_currency	text

User Groups

Field	Type
id	text
workspaceid	text
name	text

Time Entries

Main Object

Field	Type
id	text
timeinterval__duration	text
timeinterval_start	timestamp
timeinterval_end	timestamp
islocked	boolean
workspaceid	text
description	text
taskid	text
billable	boolean
projectid	text
userid	text

Field	Type
timeentry_id	text
tag_id	text

Add Clockify as a data source on Kondado

Connect your Clockify time-tracking data to Kondado for ETL/ELT into your data warehouse or lake.

Verify Clockify permissions

Log in to Clockify with a user that has WORKSPACE_OWN or WORKSPACE_ADMIN permissions for the workspaces you want to replicate.

Generate your Clockify API key

Click your profile picture in the left sidebar, go to "Profile settings", then find or generate your API key in the API section and copy it.

Add Clockify on Kondado

Configure and save the connection

Paste your API key into the "API key" field, name your data source, and click SAVE to complete the setup.

Choose your destination and start syncing

Send your Clockify data to a destination like a data warehouse or BI tool. Note: this pipeline does not capture deletions unless you use the integral version.

Frequently asked questions

What permissions does my Clockify user need for Kondado integration?▼

The Clockify user must have WORKSPACE_OWN or WORKSPACE_ADMIN permissions for the workspaces you want to replicate. Without these permissions, Kondado cannot access the workspace data.

Where do I find my Clockify API key?▼

In your Clockify account, click your profile picture in the left sidebar, select "Profile settings", and look in the API section. If you don't have an API key yet, click "Generate" to create one.

Does the Clockify pipeline capture deleted records?▼

No, this pipeline does not capture deletions. If a record is deleted in Clockify, it will remain at the destination until the table undergoes advanced editing. Kondado provides an integral version that always reads all data if you need full synchronization.

What Clockify data entities are available through Kondado?▼

The pipeline includes Workspaces, Projects, Clients, Users (with memberships), User Groups, Tags, and Time Entries (with tags). Each entity has documented fields and data types as shown in the relationship chart.

Can I send Clockify data to BI tools or spreadsheets?▼

Yes, after adding the Clockify source, you can route data to various destinations. Explore data-to-dashboards options or connect to BI tools and spreadsheets for reporting and analysis.

Written by

Thassyo Pereira·Published 2023-07-18·Updated 2026-04-25