Get a clear weekly update without reading every Slack message. The flow pulls last week of channel activity, summarizes each thread with AI, builds a report for each person, and posts a short team recap every Monday morning. Great for project leads and remote teams that want quick context and next steps.

Here is how it runs. A schedule at 6am on Monday fetches the full message history from a chosen Slack channel for the last seven days. Messages are simplified, grouped by author, and each thread’s replies are pulled in to capture full context. The system maps reply users, looks up user profiles, and filters out unwanted items. Gemini is used twice. First to summarize each thread, and then to write a weekly report per person and a final team summary. Subworkflows and split steps handle large message sets cleanly and keep item references stable.

To use it, connect a Slack workspace and a Google Gemini API key. Point the Slack nodes to the right channel and leave the default one week filter, or adjust it to your needs. Expect status prep to drop from hours to minutes and a steady Monday report that helps the team align, share wins, and spot blockers.

• Scheduled run every Monday at 6am to collect last week of channel messages.
• Slack history fetch with a one week time filter and full thread replies.
• Groups messages by author and maps reply user IDs to real profiles.
• AI thread summaries using the Google Gemini chat model for quick context.
• Second AI pass creates per person weekly reports and a team summary.
• Subworkflows and split steps manage large item loops without losing references.
• Posts the final report back to the selected Slack channel.

• Reduce manual recap work from 2 hours to 10 minutes
• Automate 90% of weekly reporting steps
• Connect Slack and Gemini in one flow
• Handle busy channels with dozens of threads without extra effort
• Deliver a consistent Monday 6am update every week

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Slack and Google Gemini. See the Tools Required section above for links to create accounts with these services.
3. In n8n, open the Slack nodes such as Get Last Week's Messages and Post Report in Team Channel. In the Credential to connect with dropdown, click Create new credential and follow the on screen instructions to connect Slack.
4. Invite the n8n Slack app to your target channel and ensure the app has access to read channel history and user info. Post any message in the channel so you have fresh data to test.
5. Set the Slack channel in the Get Last Week's Messages and Get Thread nodes. Use the channel picker to choose the correct channel instead of the default value.
6. Open each Google Gemini Chat Model node. In the Credential dropdown, click Create new credential. Generate an API key in your Google AI account, paste it, and save.
7. Confirm the model is available. The nodes use models/gemini-2.0-flash. If your account does not support it, select a model your key can access.
8. Check the Schedule node labeled Monday @ 6am. Set your desired time and ensure the n8n instance time zone matches your team’s preference.
9. Run a test by executing the workflow once. If no results appear, shorten the date range in the Slack node to the last 1 day and try again.
10. Verify that thread summaries look clear and that user names resolve. If user lookups fail, reconnect Slack credentials and make sure the app has users read permission.
11. Review the final message posted to Slack. Adjust the AI prompts in the Summarise Threads and report agent nodes to match your tone and reporting style.
12. Enable the workflow so it posts the report each Monday. Monitor the first week to confirm timing and content meet your needs.