# Auto-log Clockify time entries to a Google Sheets timesheet

> Every time you stop a timer in Clockify, we add a fully labeled row to your Google Sheets timesheet, so payroll and client billing stay current.

- Workflow type: code
- Services: Clockify, Google Sheets
- Categories: Operations, Finance
- Published: 2026-07-17

## What it does

- Watches Clockify and adds a new row to your timesheet the moment a time entry is stopped.
- Fills in the team member, client, project, task, description, date, hours tracked, and whether the time is billable.
- Converts each entry's tracked time into decimal hours (so 1 hour 30 minutes becomes 1.5) for clean payroll and billing math.
- Always appends in the same column order, so your pivots, totals, and formulas keep working.

## What you'll need

- A Clockify account where your team tracks time.
- A Google account with a Google Sheets timesheet ready to receive rows (a header row helps keep columns aligned).

## Prompt

This is a deterministic code workflow. Use Clockify's completed-time-entry poll trigger ("Monitor Clockify for completed time entries") as the source. It fires every time a running timer is stopped and the time entry is completed. The poll payload carries the entry's IDs and fields: the workspace ID, the user (team member) ID, the project ID, the task ID, the description, the billable flag, and the time interval with start, end, and an ISO-8601 duration such as PT1H30M.

The payload gives IDs, not names, so resolve the human-readable names before writing the row. Call Clockify's "Get all projects on a workspace" to map the project ID to its project name and to read the project's client ID; request the hydrated project list so each project also carries its tasks, letting you match the entry's task ID to a task name. Call Clockify's "Find clients on a workspace" to map that client ID to the client name. Call Clockify's "Find all users on a workspace" to map the user ID to the team member's name.

Convert the entry's ISO-8601 duration into decimal hours: parse the hours, minutes, and seconds out of the PT#H#M#S string and compute hours + minutes/60 + seconds/3600, rounded to two decimals (so PT1H30M becomes 1.5). Take the entry date from the start time, formatted as YYYY-MM-DD.

Append exactly one row to the Google Sheets timesheet using Google Sheets "Append Values". Keep this fixed column order so downstream pivots and formulas keep working: date, team member, client, project, task, description, duration in decimal hours, and billable (written as Yes or No). Append after the last row of the existing table so nothing is overwritten.

If a lookup cannot resolve a name (for example an entry with no client or no task), write an empty cell for that column rather than skipping the entry, so every completed time entry always produces exactly one timesheet row.

## How to customize

- Change which columns appear or reorder them to match your existing timesheet layout.
- Point it at a specific tab, or keep a separate sheet per client or per month.
- Filter it to log only billable time, or only entries from certain projects.

## FAQ

### Does this work with the free version of Clockify?

Yes. Tracking and completing time entries is available on Clockify's free plan, so this runs on any Clockify account.

### When exactly does a new row get added?

As soon as a running timer is stopped and the time entry is completed in Clockify. Entries that are still running are not logged until they finish.

### How is the tracked time shown in the sheet?

We convert Clockify's tracked time into decimal hours, so 1 hour 30 minutes becomes 1.5, ready for payroll and billing formulas.

### Will this break my existing spreadsheet formulas?

No. Each entry is added as a new row in a fixed column order, so pivots, totals, and formulas keep working without any manual cleanup.

### Can the whole team share one timesheet?

Yes. Every logged entry includes the team member's name, so a single shared timesheet stays accurate for everyone.

Use this prompt in General Input: https://www.generalinput.com/prompts/auto-log-clockify-time-entries-to-a-google-sheets-timesheet