Back to Blog

How to Integrate Clockify Data With Google Sheets and Import Reports

Time-tracking apps replaced the old fashioned way of tracking time in spreadsheets. Now you don’t have to track time manually. Click on the button that runs the clock and pause or stop when needed. You can also edit the tracked time, as well as enjoy other features available with time trackers. Clockify is a popular time-tracking software. Today we’ll explain how you can integrate it with Google Sheets and import summary & detailed reports using a specialized add-on: Coupler.io.

Why export data from time tracking-tools?

Most of the time trackers provide exportable reports. In Clockify, you can download your data as a PDF, CSV, or XLSX file, and use it for customized reporting and calculations, such as resource planning, payroll, invoicing, and so on. Entrepreneurs and small-to-medium businesses mostly use spreadsheets for these purposes. And Google Sheets is the best you can have because it’s free, cloud-based, and provides collaboration capabilities. 

To pull out data from Clockify to Google Sheets you need to:

  • Download your time-tracking report as a CSV file.
  • Upload the CSV file to Google Sheets.

This seems quite handy and easy. But what if you need to do this manipulation recurrently – every month or even every week? In this case, you would like to have Clockify connected to Google Sheets to update data automatically. We know how to make this happen.

How to integrate Clockify with Google Sheets

Install Coupler.io

Coupler.io is a Google Sheets add-on that lets you import data from different sources, including CSV files. Install it via this link or find it on the G Suite Marketplace:

For more information about the add-on and available integrations, please visit the Coupler.io home page.

Set up a CSV importer 

An importer is an integration that connects Google Sheets to a specific app or data source. There is no dedicated importer for Clockify, but we’ll use CSV instead. For this, open Coupler.io in the Add-ons tab of a spreadsheet, click on the +Add Importer button and choose CSV.

In our blog post, “Import CSV into Google Sheets”, we explained how to set up the CSV importer for regular data imports from online published CSVs. To pull data from Clockify, you’ll need to focus on the following parameters:

  • Title – add the name of your data source. 
  • Sheet Name – type in the name of your sheet.  
  • Automatic data refresh – enable this function and pick the schedule that you want to use for Coupler.io to update data in your spreadsheet.
  • CSV URL – insert the following CSV URL:
https://global.api.clockify.me/workspaces/{your-workspace-id}/reports/summary?export=csv

How to get {your-workspace-id}:

  1. Go to Workspace 

  2. Click on the Settings button 

  3. Copy {your-workspace-id} from the page URL

Unfold the Additional section and fill in the following fields as well:

  • HTTP method – select the POST request method
  • Request headers – insert two request headers: 
content-type: application/json
x-api-key: {replace-with-your-API-key}

To generate x-api-key, go to Profile Settings => API and click on Generate.

  • Request body – use one of the following strings depending on the type of report you need.

Request body for Clockify Summary Report

startDate: '2020-01-01T00:00:00.000Z' 
endDate: '2020-12-31T23:59:59.999Z' 
isDetailed: false
billable: BOTH
description: ''
sortDetailedBy: timeAsc  
firstTime: true
archived: Active
me: TEAM
includeTimeEntries: true                 
name: ''
groupingOn: true
groupedByDate: false
page: 0
count: 500
roundingOn: false
groupBy: PROJECT
subgroupBy: TIME_ENTRY
weeklyGroupBy: PROJECT
weeklySubgroupBy: TIME
userGroupIds: []
userIds: []
projectIds: []
clientIds: []
taskIds: []
tagIds: []
//pick the start date 
//pick the end date



 //pick timeDsc for descending order









//choose the parameter to group by

Request body for Clockify Summary Report

startDate: '2020-01-01T00:00:00.000Z' 
endDate: '2020-12-31T23:59:59.999Z' 
isDetailed: true
billable: BOTH
description: ''
sortDetailedBy: timeAsc  
firstTime: true
archived: Active
me: TEAM
includeTimeEntries: true                 
name: ''
groupingOn: true
groupedByDate: false
page: 0
count: 500
roundingOn: false
groupBy: PROJECT
subgroupBy: TIME_ENTRY
weeklyGroupBy: PROJECT
weeklySubgroupBy: TIME
userGroupIds: []
userIds: []
projectIds: []
clientIds: []
taskIds: []
tagIds: []
//pick the start date 
//pick the end date



 //pick timeDsc for descending order









//choose the parameter to group by

That’s it. Your CSV importer adapted for Clockify is ready. Here is how it should look:

Click on Add Importer to save it. Check out the Coupler.io knowledge base to learn more about the Settings section. Run your Clockify importer to pull data to Google Sheets.

Use case: a daily updated dashboard of time-tracked projects

Let’s check out a simple example of how you can visualize your data imported to Google Sheets from Clockify. We’ll build a dashboard with a few charts that will regularly update. This is possible thanks to the automatic data refresh feature provided by Coupler.io. 

Once the data is in the spreadsheet, we’ll use specific functions to extract the required data and apply charts to it. The data will update daily, so the dashboard will look like this:

For your convenience, you can download the template with the dashboard to inspect the details.

To wrap up: manual or automatic export? 

The process we described above may seem a bit tricky because you have to manipulate the browser Dev Tools. However, you won’t have to do this each time you want to pull data from Clockify. Once the importer is set up, your data will go to the Google Sheets automatically (if the re-import option has been activated), or when you click on the Run importer button. This is a time-efficient solution that will definitely increase your productivity. We encourage you to check out other integrations provided by Coupler.io. Also, please feel free to share your feedback in the comments. Good luck!

Back to Blog

Access your data
in a simple format for free!

Start Free