Clockify

Google Sheets + Clockify Integration

Query from Clockify into Google Sheets

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho, PayPal, etc.


It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on.

What is Clockify?

Clockify is the only completely free time tracking software for teams. It's a simple time tracker and timesheet app for tracking work hours across projects.

Clockify to Google Sheets: Use Case(s)

> Pull data from Clockify objects and store it into a spreadsheet - Query

Clockify

Sheet Director

Google Sheets

Setting up Clockify in Sheet Director

Choose App and Service:

  • Select Clockify from the list of applications.

  • Select service as Query.


Clockify Configuration

  • Enter your Clockify API key

  • Click on connect to Clockify to connect to Clockify so that you can pull data.


To get API Key

  • On your clockify application go to "Profile settings"

  • Down you can get your API key

Once Clockify is connected successfully the following screen appears.


  • Select the required Workspace.

  • Select the source as required Entities or Reports.

Reports

  • Select a report.

  • Select the required groups.

  • Sheet Director allows you to select only 3 groups.

  • Select the required parameters for Filter.

  • Mention the required Start Date.

  • Mention the required End Date.

  • Click "+" to add more Filters.

  • Select the required Sorting order. It may be Ascending or Descending.

Entities

Once Clockify is connected successfully the following screen appears.


  • Select the required Workspace.

  • Select the source as required Entities or Reports.

  • Select the source as Entities.

  • Select the required Fields.

  • Select the required Filters.

  • Select the required Field, operator & value.

  • Select the required User.

  • Click "+" to add more Filters.

  • Mention the maximum result required.

Destination Settings:

  • Configure the destination settings to save the executed data.

Scheduler Settings:

  • Switch on Run automatically to execute services automatically in background.

Notification Settings:

  • Configure the Notification settings to setup the email templates and add attachments.

  • Click on execute to pull the data into sheet

  • Click save to save the service

Sample Output

Reports

Summary Report

Entities

Time Entries