Turn Clockify hours into monthly client billing drafts

On the first business day of each month at 9am, prepare client billing drafts from last month's tracked time in Clockify and stage them as Gmail drafts for review. Do not send anything: every message must be left as an unsent Gmail draft so a person can sanity-check the numbers before it ever reaches a client.

First, generate a Clockify summary report for last calendar month using Clockify's Generate a summary report, filtered to billable time and grouped by client and then by project. Pull client details, including each client's name and email address, with Find clients on a workspace. Read each project's billable hourly rate with Get all projects on a workspace.

For each client that had billable time last month, group the billable hours by project and format each project's hours to two decimals. Compute the amount owed for a project by multiplying its hours by that project's billable rate. Note that Clockify stores rate amounts as integers in the currency's minor unit (cents), so divide the rate by 100 before treating it as a dollar figure. Sum the per-project amounts into a single total owed for the client.

Then write a clean, itemized billing email for the client: one line per project showing the project name, its hours (two decimals), the rate, and the amount, followed by the total owed. Address the email to the client's email address from Clockify. Create it with Gmail's Create a Draft, one draft per client, and leave it as an unsent draft.

Skip any client with no billable time last month so no empty bills are drafted. Always format hours to two decimals. Never send a draft automatically: the whole point is to keep a human in the loop before any money-related message goes out.