n8n AI Workflow: Weekly MS Teams Activity Summary Reports

Automatically generate a weekly AI summary of MS Teams activity—every Monday

This n8n AI workflow scans last week’s MS Teams conversations, summarizes each team member’s activity with AI, then compiles everything into a casual, snappy team weekly report—posted back to the channel so everyone starts the week aligned.

What this workflow does

• Runs on schedule: a scheduled trigger executes every Monday at 6am to collect team channel messages from the past week.
• Groups activity by user: messages are grouped by each user so you can see individual contributions and participation patterns.
• Creates individual AI highlights: AI analyzes raw messages and replies to pull out interesting observations, key moments, and highlights for each person.
• Builds a team weekly report: all individual reports are combined and summarized into a single team-level weekly summary, helping the group spot similar themes and shared progress.
• Posts at the right time: the workflow posts the team report back to the channel as the first message of the week—ready for quick review “over coffee.”

Use cases

• Remote team alignment: turn fast-moving MS Teams threads into a weekly recap that reduces lost decisions and forgotten context.
• Project manager visibility: quickly understand who discussed what, and which topics gained traction during the week.
• Single-channel project reporting: best when most communication happens in one Teams channel; duplicate the workflow per project to avoid mixing unrelated discussions.

Technical details

• Core flow: set, code, markdown, split out, aggregate, sticky note
• Workflow goal: scheduled weekly MS Teams activity summarization using AI to generate individual and team reports

If you want an n8n automation workflow that turns “all those messages” into a clear weekly MS Teams summary, this template is built for exactly that.