Automated Weekly Slack Activity Summary Report

This n8n workflow automates the collection, summarization, and reporting of Slack message activity within a team over a week. It begins by fetching all messages from Slack channels each Monday at 6 am using a scheduled trigger. The workflow then groups messages by user, fetches reply threads, and summarizes conversations using AI models, providing insights on individual contributions, significant discussions, and key highlights. It generates both individual and team-wide weekly reports, which are then automatically posted back to a designated Slack channel to keep the team aligned and motivated.

The process involves multiple steps: collecting messages, analyzing conversations, generating summaries, and compiling comprehensive reports. It leverages subworkflows for efficient data management and AI integrations for meaningful analysis. This setup is ideal for teams that rely heavily on Slack for communication and want automated weekly summaries to improve team transparency, motivation, and accountability.