Clockify data source

Learn how to set up a Clockify data source and then move this data to one of the supported by Coupler.io data destinations.

Set up your data source
Transform your data with Coupler.io
Set up your data destination
Update your data automatically on schedule

1.Set up your data source

1.1. Select an application: Clockify

1.2. Fill out the "Report" field

Select a report type to import: Summary, Weekly, or Detailed.

1.3. Fill out the "Workspace ID" field

Go to Clockify => click the three dots next to the workspace name on the top rigth side of the screen => click the workspace settings => You’ll find the ID of your active workspace in the page URL.

Example:

Link:

https://app.clockify.me/workspaces/5eac156c109fe9152341d25e/settings#settings

The Workspace Id in the link will be:

5eac156c109fe9152341d25e

1.4. Fill out the "API key" field

Enter your personal API key.

Where to get the API key?

Go to Clockify => click on your profile picture in the top right corner => Preferences => Advanced. Finally, click the Generate button.

1.5. Fill out the "Start Date" field

This field supports macro. Learn more.

1.6. Fill out the "End Date" field

The default time for any date value is 00:00 (midnight). For example, if you need data for the whole of November 2021, specify 2021-11-01 as the start date and 2021-12-01 as the end date.

This field supports macro. Learn more.

Note:

If the start date is absent and the end date is absent for the Clockify data flow, then we take data for the last month. More precisely: a month ago (beginning of the day) until upcoming midnight today (end of the day). This is related to how Clockify returns data via API.

Usage examples of the start & end date setting:

if the start date is present and the end date is absent then we take the start date until (start date + 1 month);
if the start date is absent and the end date is present then we take a month ago (beginning of the day) until upcoming midnight today (end of the day);
if the start date is present and the end date is present then we take the start date until the end date.

2. Transform your data with Coupler.io

With Coupler.io's Preview and Transformation block, you can:

Preview your data for accuracy.
Manage columns by hiding, or rearranging key data.
Apply filters and sorting to focus on relevant information.
Add formula-based fields.
Combine datasets for a comprehensive analysis.

For a detailed guide on how to utilize these features, follow this link to our comprehensive tutorial.

3. Set up your data destination

Continue setting up the integration depending on the system you want to import data to. Select your tool from the list of supported data destinations and follow the relevant setup guide.

4. Update your data automatically on schedule

Turn on "Automatic data refresh" in the data flow so your data remains up-to-date in the destination without requiring manual updates.

You can schedule data imports at specific intervals (e.g., hourly, daily, weekly) and/or days, allowing you to have up-to-date information available for analysis, reporting, or decision-making. This automation enhances efficiency and ensures your reports or dashboards are always populated with the latest data.

For a detailed guide on how to utilize this feature, follow this link to our comprehensive tutorial.