Automated Weekly Slack Team Activity Summarization

This n8n workflow automates the process of gathering, analyzing, and summarizing Slack messages from the past week to generate a comprehensive team activity report. It begins with scheduled triggers or external workflow triggers to fetch all relevant messages from a specified Slack channel over the last week. The workflow then groups messages by user, retrieves replies, and summarizes threads using AI models like Google Gemini. These summaries are aggregated into individual reports for each team member, highlighting wins, challenges, and notable activity. Subsequently, these individual insights are compiled into a final team-wide report that captures overall progress, key achievements, and concerns. The entire reporting cycle concludes with the automated posting of the compiled report into the Slack channel, fostering transparent communication and team motivation. This workflow is especially useful for remote teams, project updates, and weekly performance reviews, saving time and ensuring nothing valuable is overlooked.