Automation library · Money admin

Turn agency timesheets into invoices and alerts with Odoo

Started by a clock, and works across Gmail and Slack. 26 steps: large, and worth reading before you trust it with anything live.

Large

Download free
26 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
0Loops or waits
2Services it connects to

The flow

Starts it 3Logic 11Service 12

The steps in the order they run, from what starts it.

  1. 1Weekly Trigger, Fri 5pm (Timesheet Review)Schedule triggerStarts it
  2. 2Daily Trigger, Billable Hours Check (6pm)Schedule triggerStarts it
  3. 3Hourly Trigger, Poll Paid InvoicesSchedule triggerStarts it
  4. 4Compute This Week WindowSetLogic
  5. 5Get Project Timesheet Entries (Last 90 Days)OdooService
  6. 6Client Billing Map (Config, Ops-Maintained)CodeLogic
  7. 7Search Recently Paid InvoicesOdooService
  8. 8Get Timesheet Entries This WeekOdooService
  9. 9Get Active EmployeesOdooService
  10. 10Match to Billing Map & Compute Unbilled HoursCodeLogic
  11. 11Alert Ops, Billing Data Fetch FailedGmailService
  12. 12Notify PM, Invoice PaidSlackService
  13. 13Alert Ops, Payment Poll FailedGmailService
  14. 14Aggregate Hours by Employee & Flag GapsCodeLogic
  15. 15Aggregate Hours by Project This WeekCodeLogic
  16. 16Alert Ops, Timesheet/Employee Fetch FailedGmailService
  17. 17Projects Crossing 10h ThresholdFilterLogic
  18. 18Log Payment Notify FailuresNo OpLogic
  19. 19Keep Employees Needing ReminderFilterLogic
  20. 20Send Weekly Hours Summary to PMGmailService
  21. 21Create Draft Invoice in OdooOdooService
  22. 22Send Timesheet ReminderSlackService
  23. 23Log Path A Notification FailuresNo OpLogic
  24. 24Email Draft Invoice to ClientGmailService
  25. 25Log Invoice Create/Send FailuresNo OpLogic
  26. 26Mark Project as Invoiced (Update Cursor)CodeLogic

How it's built

Starts on
A clock
Steps
26
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Slack
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Gmail and Slack accounts. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

No. Every step is fixed logic or a call to a service, so it does the same thing every time.

How long does it take to set up?

Take your time. At 26 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 26 steps before you point it at anything that matters.