Weekly team utilization digest from Clockify to Slack
Every Monday morning, we turn last week's Clockify time into a clear team utilization summary and post it to your Slack channel.
Clockify
Slack BotOperationsAI ReportsDaily DigestsEvery Monday at 8:00am, generate a weekly team time and utilization digest from Clockify and post it to Slack. Keep two settings easy to change at the top of the workflow: the weekly utilization target in hours (default 40) and the destination Slack channel.
First, pull the prior week's totals. Using Clockify's Generate a summary report operation, request a summary for the previous full calendar week (the most recent Monday through Sunday), grouped by project, by client, and by user. This gives you total hours tracked, the billable versus non-billable breakdown, and per-project, per-client, and per-person totals for the week.
Then list the team with Clockify's Find all users on a workspace operation, so you know everyone who should be logging time. This lets you include people who tracked zero hours and would not otherwise appear in the report totals.
Write a clear, well-structured digest that covers: total hours tracked across the team; the billable versus non-billable split with percentages; the top projects and top clients by hours; and each person's utilization measured against the weekly target (hours logged divided by the target, shown as a percentage). Explicitly call out, by name, anyone who logged well under target, and highlight any project whose hours spiked unusually compared with what is normal for it. To spot the spikes, also pull the summary report for the week before and compare project totals week over week.
Finally, post the finished digest to the chosen channel using Slack's Send a Message operation. Format it for quick scanning in Slack, with short sections and the under-target people and spiking projects clearly flagged near the top.
Keep the utilization target and the destination channel simple to adjust, so the team can change the target (for example from 40 to 35 hours) or point the digest at a different channel without rewriting the workflow.
Example output
Additional information
What does this prompt do?
- Every Monday, rolls up last week's tracked time across your whole team into one summary.
- Breaks down billable versus non-billable hours and ranks your busiest projects and clients.
- Shows each person's hours against a weekly target and flags anyone who logged well below it.
- Calls out any project whose hours jumped unexpectedly, then posts the digest to your Slack channel.
What do I need to use this?
- A Clockify account with your team tracking time in a shared workspace.
- A Slack workspace and a channel where the weekly digest should be posted.
- A weekly hours target to measure utilization against (40 hours by default).
How can I customize it?
- Change the weekly hours target used to measure utilization (for example 35 or 40).
- Pick which Slack channel receives the digest.
- Adjust the day and time it runs, or how far below target counts as under-logging.
FAQs
When does the digest arrive?
Can I set a different utilization target?
Which Slack channel does it post to?
Does it separate billable from non-billable time?
Will it flag people who under-logged?
Related templates
Every weekday morning, check that every Stripe payout actually landed in your Mercury account, and hear about it only when one did not.
Every weekday morning, get a Slack digest of the social posts still waiting on sign-off, with the ones about to go live flagged first.
Every Monday morning, last week's support tickets become a themed Miro board, so your product team can see what customers actually complain about.
Every weekday we find the contracts still waiting on a signature, resend the ones going stale, and post a prioritized chase list to Slack.
Every weekday at 6pm, any board your team edited today becomes a readable Notion write up, so the people who missed the session can catch up.
When a contract is fully signed, we read the agreed terms, move the matching HubSpot deal to closed won, and post a deal desk summary to Slack.
Stop compiling weekly time reports by hand.
Let this workflow turn your team's Clockify hours into a Slack-ready utilization digest every Monday morning.