PICKED FROM N8N.IO · REPORTING & OPERATIONS

Every Monday at 6 am, this workflow collects the past week's Slack messages from a team channel and groups them by person. Google Gemini summarises each person's threads, then writes a short overview of the team's week and posts the report back to a Slack channel.

Template by Jimleuk · 8.6k views on n8n.io · listed there as “Summarise Slack channel activity for weekly reports with AI”

THE WORKFLOW40 NODES
#Get Last Week'sMessages≡Simplify Message{}Group By User⊟Split Out{}Messages to Items#Get User⊞Aggregate⊟Split Out1#Get Thread⊞Aggregate1≡Simplify ThreadComments▽Filter–Message Ref⊟Split Out2≡Map Reply UserIds#Get Reply UsersLGoogle GeminiChat Model✦Summarise Threads⊞Aggregate2⊞Aggregate ReplyUsers≡Reply UsersLGoogle GeminiChat Model1SLoop Over Items≡Aggregate3⊞Aggregate4EWhen Executed byAnother Workflow⑂SwitchEMap Users toMessages≡Get User InfoEFetch MessageReplies⑂Has ReplyUsers?{}Messages toItems1≡Aggregate Results✦Team MemberWeekly Report Ag…≡Merge withResults✦Team WeeklyReport AgentLGoogle GeminiChat Model2#Post Report inTeam ChannelESummarize MessageThreads◷Monday @ 6am
DIFFICULTY
Advanced
NODES
40
USES AI
Yes
PUBLISHED
May 2025

001 / WHAT HAPPENS

  1. 01

    A schedule trigger runs on Monday at 6 am.

  2. 02

    The Slack node fetches the last seven days of channel messages, grouped by author.

  3. 03

    Sub-workflows fetch thread replies and look up the Slack users involved.

  4. 04

    Gemini summarises each person's threads, then writes a weekly report for each team member.

  5. 05

    A final AI step writes the team overview and posts it in a Slack channel.

WHO IT SUITS

Suits a distributed or busy team that makes decisions in Slack threads and wants a weekly recap without anyone writing it.

CONNECTS

  • Slack
  • Google Gemini

002 / BEFORE YOU USE IT HERE

  • !Staff messages are sent to Google Gemini, an overseas AI provider, which is a cross-border disclosure under APP 8, so say so in your privacy policy and tell staff.
  • !Set the workflow timezone to Australia/Sydney (or your city) so 6 am on Monday means your Monday.
  • !Summaries of individual staff activity can read as monitoring. Agree with your team what is reported, and review the first few reports before they post publicly.

LOCAL SWAP

Swap the Gemini model nodes for OpenAI or Anthropic if you prefer a different provider.

Need n8n and the AI hosted in Australia? →

004 / QUESTIONS

Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.

Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.

We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.

Book a free call→