Unbilled-Time Catcher
You had the call, you did the work, and it never made it onto a bill. This workflow compares yesterday's calendar against yesterday's time entries and emails each attorney the matters with activity and no time logged. Free n8n workflow, yours to keep.
Import it into n8n
- The button above downloads the workflow as a .json file — that is the whole download.
- In n8n, open the workflows list, choose Import from File, and select the file you just downloaded.
- Open each node flagged with a warning and connect your own credentials — none of ours are in the file.
- Run it once manually before you activate it, and check the output is what you expect.
How it works
- Runs every day at 7am (by default) and fetches the prior day’s Clio calendar entries, time entries, and open matters.
- Compares calendar entries to time entries at the matter level to identify matters with calendar activity but no logged time, estimating hours from start/end times (or a default duration).
- Groups the unbilled items by each matter’s responsible attorney and builds a per-attorney digest email with itemized matters and total estimated hours.
- Sends the digest content to a separate audit/guardrail workflow for logging, then emails the digest to each attorney.
- Runs every Monday at 8am (by default) and fetches the last 7 days of Clio calendar entries, time entries, and open matters.
- Repeats the unbilled-activity detection for the week, computes a firm-wide estimated dollar impact using a configurable hourly rate, logs the summary via the audit/guardrail workflow, and emails the weekly summary to the firm.
Compliance: never touches your legal work
This automation only handles operational steps — sending, routing, and moving data. It doesn’t draft, analyze, or make any legal judgment, consistent with ABA Opinion 512.
What’s inside
- The unbilled-time workflowImport one JSON file. Every morning it checks yesterday and sends what it found.
- Hours estimated from the calendarStart and end times give you a number to correct, instead of reconstructing a day from memory.
- Split by responsible attorneyEach attorney gets their own list. Nobody scrolls past four colleagues to find their two.
- 20-minute deploy guide + LoomConnect your case management and your email. No developer needed.
✓ Works great when
- You bill hourly and your calendar reflects real work
- Your calendar and time entries both live in Clio
- You suspect the leak is real but cannot size it
✗ What breaks at scale
- You want draft time entries created, not just flagged
- Email and call logs need checking too
- Your calendar events are not reliably linked to matters
Frequently asked
What do I need to run this?
An n8n instance, Clio API access covering calendar, activities, and matters, and an email account. About twenty minutes.
Does it create time entries for me?
No. It tells you what looks unbilled and what the hours probably were. You enter the time, because you are the one certifying that the work happened.
How accurate are the estimated hours?
They come from the calendar event, so they are as accurate as your calendar. Treat them as a prompt, not a number to bill. The point is that you remember the work.
What if my events are not linked to matters?
Matching gets thin, because the free version keys off the matter link. Loose calendar hygiene usually needs a Build with fuzzier matching on client names and subjects.
Does it check email and calls?
Not in the free version, which reads the calendar. Email and call-log scanning is a Done-for-You Build, $5,000 to $15,000.
Want the version built for your firm?
Done-for-You Build.
The free workflow finds the gap and shows it to you. When you want draft entries written for one-click approval, email and calls checked too, and matching that survives an untidy calendar, that is a Done-for-You Build. We wire it into your stack and hand it back tested.
What you get
- Draft time entries written for one-click approval
- Email and call activity checked alongside the calendar
- Matter matching that survives inconsistent event names
- Capture-rate reporting by attorney over time


