Import data from Clockify to Google Sheets

Connect Clockify to Google Sheets to import Summary, Weekly, or Detailed reports on a set schedule without any coding.

The 4 steps to complete the setup

  1. Fill out the Title field
  2. Set up your data source
  3. Set up your data destination
  4. Configure importer's settings

1. Fill out the "Title" field

Name your importer. We recommend you pick a name that will enable easy in-app navigation for you and your team.

2. Set up your data source

2.1. Fill out the "Report" field.

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

2.2. Fill out the "Workspace ID" field.

Enter the ID of your active workspace.

Where to get the Workspace ID?
  • Go to Clockify tracker => Settings => Workspace. You’ll find the ID of your active workspace in the page URL. For example:

2.3. Fill out the "API key" field.

Enter your personal API key.

Where to get the API key?
  • Go to Clockify tracker => Settings => Profile. Find the API section in the bottom of the page and click on Generate.

If you want to specify the date for your report to import, click Show advanced.

2.4. Fill out the "Start Date" field

Enter the start date for your report in format yyyy-mm-dd. For example: 2020-01-01

2.5. Fill out the "End Date" field.

Enter the end date for your report in format yyyy-mm-dd. For example: 2020-12-31

3. Set up your data destination

3.1. Fill out the "Sheet name" field.

Name the sheet, which will be receiving data. If the sheet with this name does not exist, will generate a new one for you.

Click Show advanced to set up optional parameters for your data destination. 

3.2. Fill out the "Cell address" field.

Type in the address of the first cell where the data range will be imported. The default value is A1.

4. Configure importer's settings

4.1. Enable the Automatic data refresh.

  • Specify import Frequency.

Check out more about Automatic data refresh.

Click Show advanced to set up optional settings.

4.2. Pick the Import Mode

Follow this link to read more about choosing a data import mode.

4.3. Add the "Last Update" column

If you want to add a column specifying the date of the last data refresh, toggle the  Last Update parameter on.

4.4. Save the changes.

Click Save to save the parameters for this integration or Save & Run to save the integration and run the initial import right away.

Book a free onboarding call! 
For any questions, feel free to email our team at