Automation library · Research and reporting

Send weekly TMetric time reports to employees on Slack

Started by a clock, and works across Slack and n8n data table. 34 steps, 2 branches, 3 loops or waits: large, and worth reading before you trust it with anything live.

Large

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

The flow

Starts it 2Logic 19Service 13

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

  1. 1Run Once a WeekSchedule triggerStarts it
  2. 2SetupManual triggerStarts it
  3. 3GlobalsSetLogic
  4. 4Is running Setup?IfLogic
  5. 5Get TMetric UsersHttp RequestService
  6. 6Get TMetric User Work ScheduleHttp RequestService
  7. 7Get TMetric Time Off RequestsHttp RequestService
  8. 8List data tablesData TableService
  9. 9Split Users DataItem ListsLogic
  10. 10Rename KeysRename KeysService
  11. 11Edit FieldsSetLogic
  12. 12Does Data table already exist?IfLogic
  13. 13Add User Work ScheduleMergeLogic
  14. 14Group Time off requestsSetLogic
  15. 15Get TMetric Users for user mappingHttp RequestService
  16. 16Create a data tableData TableService
  17. 17Add Time off requestsMergeLogic
  18. 18Remove DuplicatesRemove DuplicatesLogic
  19. 19Get many usersSlackService
  20. 20User RepoSetLogic
  21. 21Filter out usersFilterLogic
  22. 22Process Each User SeparatelySplit In BatchesLogic
  23. 23Send form for each userSplit In BatchesLogic
  24. 24Get row(s)Data TableService
  25. 25MergeMergeLogic
  26. 26Get Tmetric Time Entries per userHttp RequestService
  27. 27Merge user info with time entriesMergeLogic
  28. 28Send message and wait for responseSlackService
  29. 29Send a messageSlackService
  30. 30Filter out running tasksFilterLogic
  31. 31WaitWaitLogic
  32. 32Upsert row(s)Data TableService
  33. 33Extract data from Time EntriesSetLogic
  34. 34Calculate data for personalized messageCodeLogic

How it's built

Starts on
A clock
Steps
34, with 2 branches, 3 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Slack, n8n data table
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Slack account. 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 34 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 34 steps before you point it at anything that matters.