Clockify

Clockify is a time tracking platform that helps teams log hours, track projects, and generate detailed time reports. With Coupler.io, you can automatically sync your Clockify time data to Google Sheets, BigQuery, Looker Studio, or other destinations to build live dashboards and reports without manual exports.

Why connect Clockify to Coupler.io?

• Automate time reporting — Pull Summary, Detailed, or Weekly reports directly into your spreadsheets or data warehouse

• Real-time dashboards — Keep your time tracking metrics up-to-date with scheduled refreshes

• No manual exports — Eliminate copy-paste workflows and sync data on a schedule

• Multi-destination support — Send data to Google Sheets, Excel, BigQuery, Looker Studio, or AI destinations like Claude and ChatGPT for analysis

Prerequisites

• A Clockify account with workspace admin access (required to retrieve your Workspace ID)

• An API key generated from your Clockify profile settings

• A destination account (Google Sheets, BigQuery, Excel, etc.)

Quick start

If you're new to Coupler.io, start with the Summary report to test the connection. It's the simplest report type and helps you verify your credentials are correct before moving to Detailed or Weekly reports.

How to connect

1

Sign in to Coupler.io and create a new data flow. Select Clockify as your source.

2

Get your Workspace ID. Log in to Clockify, go to Settings in the Manage section, and copy the ID from the URL address bar. For example, in the URL https://clockify.me/workspaces/5e450bcf1fffab54e1b0e8e5/settings, the workspace ID is 5e450bcf1fffab54e1b0e8e5. (You must be a workspace admin to access this.)

3

Generate an API key. Go to your Clockify profile settings, scroll to the API section at the bottom, and click Generate. Copy the key.

4

Enter your credentials in Coupler.io. Paste your Workspace ID and API key into the connection form.

5

Choose a report type. Select Summary, Detailed, or Weekly depending on the level of detail you need.

6

Set your date range (optional). Use the date picker to specify start and end dates. If left blank, the default range is one month from the start date. Macros are supported for dynamic date ranges (e.g., {{lastweekstart}}—see FAQ for examples).

7

Choose your destination. Select Google Sheets, BigQuery, Excel, Looker Studio, or an AI destination (Claude, ChatGPT, Gemini, etc.).

8

Run the data flow manually. Click Run to test the connection and verify data is pulling correctly. A successful manual run is required before you can schedule automatic refreshes.

Report types overview

Report Type	Best For	Details
Summary	High-level metrics	Total hours by project, user, or date. Simplest report; good for dashboards.
Detailed	Complete time entries	Individual time entries with descriptions, tags, and billable status.
Weekly	Weekly analysis	Hours aggregated by week. Useful for weekly planning and capacity reports.