Summarise MS Teams channel activity for weekly reports with AI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day). Along the way it connects Microsoft Teams and OpenAI Chat Model.
How it runs
Trigger: On a schedule (every day).
- Fetch Latest Channel Messages (Microsoft Teams): get many (channel message)
- Group Messages By UserId (Code): runs custom JavaScript code
- Groups to Items (Split Out): splits a list into separate items
- Team Member Weekly Report Agent (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model
- Merge Report With User Data (Edit Fields (Set)): sets or maps fields
- Reports to Single List (Aggregate): combines items into one
- Team Weekly Report Agent (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model
- Markdown: converts between Markdown and HTML
- Send Report to Channel (Microsoft Teams): work with channel message
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Microsoft Teams
n8n-nodes-base.microsoftTeams - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Edit Fields (Set)
n8n-nodes-base.set - Aggregate
n8n-nodes-base.aggregate - Markdown
n8n-nodes-base.markdown - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut
From the author
This n8n template lets you summarize individual team member activity on MS Teams for the past week and generates a report. For remote teams, chat is a crucial communication tool to ensure work gets done but with so many conversations happening at once and in…