Summarize Slack Channel Activity for Weekly Reports with AI

### 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 threads, ideas, information, and decisions usually live in the moment and get lost just as quickly - and altogether forgotten by the weekend! Using this template, this doesn't have to be the case. Have AI crawl through last week's activity, summarize all threads, and generate a casual and snappy report to bring the team back into focus for the current week. A project manager's dream! ### How it works - A scheduled trigger is set to run every Monday at 6 am to gather all team channel messages within the last week. - Each message thread is grouped by user and data mined for replies. - Combined, an AI analyzes the raw messages to pull out interesting observations and highlights. - The summarized threads of the user are then combined together and passed to another AI agent to generate a higher-level overview of their week. These are referred to as the individual reports. - Next, all individual reports are summarized together into a team weekly report. This allows understanding of group and similar activities. - Finally, the team weekly report is posted back to the channel. The timing is important as it should be the first message of the week and ready for the team to glance over coffee. ### How to use - Ideally works best per project and where most of the comms happen on a single channel. Avoid combining channels and instead duplicate this workflow for more channels. - You may need to filter for specific team members if you want specific team updates. - Customize the report to suit your organization, team, or the channel. You may prefer to be more formal if clients or external stakeholders are also present. ### Requirements - Slack for chat platform - Gemini for LLM (or switch for other models) ### Customizing this workflow - If the Slack channel is busy enough already, consider posting the final report to email. - Pull in project metrics to include in the report. As extra context, it may be interesting to tie the messages to production performance. - Use an AI Agent to query for knowledge base or tickets relevant to the messages. This may be useful for attaching links or references to add context. - Channel not so busy or way too busy for 1 week? Play with the scheduled trigger and set an interval that works for your team.