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”
- DIFFICULTY
- Advanced
- NODES
- 40
- USES AI
- Yes
- PUBLISHED
- May 2025
001 / WHAT HAPPENS
- 01
A schedule trigger runs on Monday at 6 am.
- 02
The Slack node fetches the last seven days of channel messages, grouped by author.
- 03
Sub-workflows fetch thread replies and look up the Slack users involved.
- 04
Gemini summarises each person's threads, then writes a weekly report for each team member.
- 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? →003 / MORE FOR REPORTING & OPERATIONS
- 15 NODESAI
REPORTING & OPERATIONS
Chat with Google Drive documents using Gemini and Pinecone
Google DriveGoogle GeminiPineconeAdvancedby Mihai Farcas352k views - 8 NODESAI
REPORTING & OPERATIONS
Ask an AI assistant questions about your Notion knowledge base
NotionOpenAIIntermediateby Max Tkacz51.1k views - 19 NODESAI
REPORTING & OPERATIONS
Book follow-up meetings from Google Meet transcripts with AI
Google CalendarGoogle DriveOpenAIGoogle MeetAdvancedby Jimleuk34.5k views
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→