Summarise Slack channel activity for weekly reports with AI
Ready for 3.0What this workflow does
This AI workflow has 40 nodes and runs on a schedule (cron 0 6 * * 1) (plus 1 other trigger). Along the way it connects Slack and Google Gemini Chat Model.
How it runs
Trigger: On a schedule (cron 0 6 * * 1) (plus 1 other trigger).
- Get Last Week's Messages (Slack): history (channel)
- Switch: routes items into 3 branches
- Group By User (Code): runs custom JavaScript code
- Get User (Slack): work with user
- Split Out: splits a list into separate items
- Map Reply UserIds (Edit Fields (Set)): sets 1 field: replyUsers
- Split Out: splits a list into separate items
- Messages to Items (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Has ReplyUsers? (If): checks a condition and branches into true / false
…plus 24 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (15)
- Slack
n8n-nodes-base.slack - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - Filter
n8n-nodes-base.filter - No Operation, do nothing
n8n-nodes-base.noOp - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Switch
n8n-nodes-base.switch - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
This n8n template lets you summarize team member activity on Slack for the past week and generates a report. For remote teams, chat is a crucial communication tool to ensure work gets done but with so many conversations happening at once and in multiple…