Automation library · Research and reporting

Summarise Slack channel activity for weekly reports

Started by a clock, and works across Slack. It hands the judgement calls to Gemini. 40 steps, 2 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini

Download free
40 stepsLarge: read it before trusting it with anything live
2Branches: places the flow splits
1Loop or waits
1Service it connects to

The flow

Starts it 2Model 6Logic 27Service 5

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

  1. 1Google Gemini Chat ModelLm Chat Google GeminiModel
  2. 2Google Gemini Chat Model1Lm Chat Google GeminiModel
  3. 3When Executed by Another WorkflowExecute Workflow triggerStarts it
  4. 4Google Gemini Chat Model2Lm Chat Google GeminiModel
  5. 5Monday @ 6amSchedule triggerStarts it
  6. 6Summarise ThreadsChain LlmModel
  7. 7Team Member Weekly Report AgentChain LlmModel
  8. 8SwitchSwitchLogic
  9. 9Team Weekly Report AgentChain LlmModel
  10. 10Get Last Week's MessagesSlackService
  11. 11Aggregate2AggregateLogic
  12. 12Merge with ResultsSetLogic
  13. 13Get UserSlackService
  14. 14Split Out1Split OutLogic
  15. 15Map Reply UserIdsSetLogic
  16. 16Post Report in Team ChannelSlackService
  17. 17Group By UserCodeLogic
  18. 18Messages to ItemsCodeLogic
  19. 19Loop Over ItemsSplit In BatchesLogic
  20. 20Has ReplyUsers?IfLogic
  21. 21Split OutSplit OutLogic
  22. 22Simplify MessageSetLogic
  23. 23Aggregate3SetLogic
  24. 24Message RefNo OpLogic
  25. 25Split Out2Split OutLogic
  26. 26Reply UsersSetLogic
  27. 27Map Users to MessagesExecute WorkflowLogic
  28. 28AggregateAggregateLogic
  29. 29Aggregate4AggregateLogic
  30. 30Get ThreadSlackService
  31. 31Get Reply UsersSlackService
  32. 32Messages to Items1CodeLogic
  33. 33Fetch Message RepliesExecute WorkflowLogic
  34. 34Get User InfoSetLogic
  35. 35FilterFilterLogic
  36. 36Aggregate Reply UsersAggregateLogic
  37. 37Summarize Message ThreadsExecute WorkflowLogic
  38. 38Simplify Thread CommentsSetLogic
  39. 39Aggregate ResultsSetLogic
  40. 40Aggregate1AggregateLogic

How it's built

Starts on
A clock
Steps
40, with 2 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Slack
Model
Gemini

Questions

What does it need to run?

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

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls Gemini. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 40 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 40 steps before you point it at anything that matters.