Summarise MS Teams Channel Activity for Weekly AI Reports

This n8n workflow automates the summarization of Microsoft Teams channel activity from the past week, ideal for remote teams and project managers. It triggers every Monday at 6am to fetch messages, groups them by user, and leverages AI to analyze raw messages and replies, extracting key observations, highlights, and insights into individual contributions.

Individual reports are generated first, providing personalized activity overviews. These are then aggregated and summarized into a comprehensive team weekly report, highlighting group trends, similar activities, and overall team focus. The final report is posted directly back to the Teams channel as the first message of the week, ensuring the team starts Monday aligned and informed.

Benefits include preventing information loss in busy chat threads, fostering accountability, and saving hours of manual review. Use cases span project management, HR for team health checks, and any collaborative remote environment. Customize for formality, filter users or channels, and duplicate for multiple teams—requires MS Teams access and AI credentials.