Summarise MS Teams Channel Activity for Weekly Reports with AI

Say goodbye to forgotten team updates! 🧠💬

This automation crawls your MS Teams chat history, summarizes each team member’s weekly activity using AI, and delivers a smart, engaging recap every Monday morning—so your team starts the week aligned and focused.

Perfect for remote teams, project managers, and async workplaces where key decisions often get buried in chat.

What it does:

⏰ Runs every Monday at 6 AM via scheduled trigger
📥 Gathers messages and replies from the past 7 days in a Teams channel
👤 Groups activity by team member for individual insights
🧠 Summarizes each member’s contributions with OpenAI
📊 Combines individual reports into a team-wide recap
📤 Posts the final report back to the Teams channel (or email)

✅ Setup guide & importable automation included

Pro tips:

Works best per project—duplicate for multiple channels

Tweak the tone: casual for internal, formal for client-facing

Add project KPIs or ticket links for richer weekly overviews

Need help setting this up across teams or connecting other data sources? We offer full configuration and tuning for a one-time fee.