FAQ

Can I use macros in my date range?

Yes! Coupler.io supports macros for dynamic date ranges. Common examples:

• {{lastweekstart}} and {{lastweekend}} — Pull last week's data

• {{thismonthstart}} — Pull from the first day of the current month

• {{thisyearstart}} — Pull from January 1 of the current year

• {{30daysago}} — Pull the last 30 days

This way your data flow updates automatically without manual edits. See the macros help article for more options.

What's the difference between Summary, Detailed, and Weekly reports?

• Summary — Aggregated hours by project, user, or date. Lightweight and fast; ideal for dashboards and high-level metrics.

• Detailed — Individual time entries with full context (description, tags, billable status, rates). Best for payroll, invoicing, and audits.

• Weekly — Hours grouped by week. Useful for capacity planning and trend analysis.

Start with Summary to test your connection, then switch to the report type that matches your use case.

Do I need to be a workspace admin to set up this integration?

You need workspace admin access to retrieve your Workspace ID from Clockify Settings. However, you can generate your own API key from your profile settings, even as a non-admin.

If you're not an admin, ask your workspace admin to share the Workspace ID (it's in the URL at clockify.me/workspaces/{ID}/settings), then generate your own API key.

Why am I getting a 404 error?

404 errors almost always mean your Workspace ID is incorrect or doesn't match your API key. Double-check:

1. Log into Clockify and go to Settings (Manage section)

2. Copy the ID directly from the URL—don't type it manually

3. Make sure you're a workspace admin (non-admins can't access Settings)

4. Verify your API key is valid (regenerate if unsure)

If you have the correct ID and key, try regenerating your API key and running the data flow again.

I got a 401 error. What do I do?

A 401 error means your API key is invalid or expired. Fix it by:

1. Go to Clockify profile settings

2. Scroll to the API section

3. Click Generate to create a new key

4. Copy it and update your Coupler.io data flow

5. Run the data flow again

API keys are user-specific and can expire if not used. Regenerating a fresh key usually resolves 401 errors immediately.

Can I filter by a specific user or project?

Not directly in Coupler.io settings. Clockify integration doesn't offer built-in user or project filters. However, you have two options:

1. Use spreadsheet formulas — Import the full report to Google Sheets, then use FILTER() or pivot tables to extract only the users or projects you need

2. Create multiple data flows — Set up separate imports for different date ranges or time periods, then manually separate them after import

This is a commonly requested feature; you can submit feedback to the Coupler.io team.

What happens if I don't set an end date?

If you set a start date but leave the end date blank, Coupler.io defaults to one month from the start date. For example:

• Start: 2024-11-01, End: (blank) → pulls data through 2024-12-01

To avoid surprises, always set both start and end dates explicitly. Remember that dates default to 00:00 (midnight), so if you want to include the full day of November 30, set the end date to 2024-12-01.

Can I send Clockify data to destinations other than Google Sheets?

Yes! Coupler.io supports multiple destinations:

• Google Sheets — Most common; good for dashboards and sharing

• BigQuery — For large-scale analysis and data warehousing

• Excel — For local file exports

• Looker Studio — For embedded dashboards

• AI destinations — Claude, ChatGPT, Gemini, Perplexity, and others for automated analysis and summarization

Choose the destination that fits your workflow. If you want to combine Clockify data with other sources, BigQuery or Google Sheets makes joining easier.

How do I set up a report that updates daily?

1. Create a data flow with Summary or Detailed report

2. Use a macro like {{30daysago}} to {{today}} to capture rolling daily data

3. After a successful manual run, go to Schedule and set it to refresh Daily at your preferred time

4. The data flow will run automatically each day and pull the latest entries

For a truly rolling window (e.g., last 30 days always), use dynamic macros so the date range shifts automatically.

Why is my imported data different from what I see in Clockify?

Common reasons:

1. Timezone mismatch — Clockify uses UTC. Your entries may appear at different times if your local timezone differs

2. Running timers — Time entries still in progress (timer running) won't be included until stopped

3. Rounding — Some reports round durations to the nearest minute or hour

4. Billable status — Summary reports may filter by billable status

Always verify data directly in Clockify's reporting interface before comparing. Check for running timers and confirm your timezone settings match.

Can I append data from multiple Clockify accounts into one sheet?

Yes, use Coupler.io's Append transformation:

1. Create separate data flows for each Clockify account (each with its own Workspace ID and API key)

2. Run both data flows to the same Google Sheets tab or append them in your destination

3. Add a column to identify which account each row came from

This lets you consolidate time data from multiple Clockify workspaces into a single dashboard or analysis.