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.
Clockify
Google SheetsOperationsFinanceData SyncThis 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.
What does this prompt do?
- 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 do I need to use this?
- 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).
How can I customize it?
- 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.
FAQs
Does this work with the free version of Clockify?
When exactly does a new row get added?
How is the tracked time shown in the sheet?
Will this break my existing spreadsheet formulas?
Can the whole team share one timesheet?
Related templates
Stage a batch of filings overnight, then approve each completed form from a screenshot before anything is ever submitted.
Review every conversation Fin closed as resolved, judge which ones actually stuck, and see what the gap is worth against your bill.
Work every return, damage and warranty claim in one queue, with the order, the delivery date and a policy-backed recommendation already on screen.
See exactly which ingredients next week needs based on what you actually sold, adjust anything by hand, then build a one-click grocery cart.
See follower growth, posting cadence, format mix and engagement rate for your brand and every competitor you track, side by side on one board.
Open one screen to see how every service in your Jobber price book actually performed: how often it sold, what you charged, and where prices swing.
Stop copy-pasting time entries into spreadsheets.
Let every completed Clockify timer flow straight into your Google Sheets timesheet, always current and ready for payroll and client billing.