Start your week with a clear team summary. This build reads last week of Microsoft Teams chats, turns them into simple updates, and posts one clean report for everyone. It helps managers and project leads see wins, blockers, and decisions without digging through threads.

A schedule kicks things off. The flow pulls channel messages from Microsoft Teams, groups them by the person who wrote them, and uses an AI model to create a short report for each user. Those mini reports are combined into one team recap, so patterns are easy to spot. The content is turned from markdown into HTML and posted back to the same channel on Monday morning. The steps reduce noise, keep context, and make progress simple to scan.

You only need Microsoft Teams and OpenAI accounts. Set your team and channel, pick your run time, and adjust the prompts to match your voice and sections. Expect to save one to two hours each week and keep everyone aligned without extra meetings. This build fits project channels, client rooms, and remote teams that rely on chat for updates.

• Scheduled run builds the report at a set time each week
• Microsoft Teams node fetches all channel messages
• Code step groups messages by user so each person gets a summary
• Split step processes each user group one at a time
• OpenAI model writes a mini report for every team member
• Aggregate step combines all individual reports into one list
• Second AI step creates a single team wide weekly recap
• Markdown is converted to HTML for clean channel posting
• Final message is sent back to the chosen Microsoft Teams channel

• Reduce manual report writing from 2 hours to 10 minutes
• Automate 90% of weekly recap work with consistent delivery
• Summarize 100% of channel messages into one view
• Connect Microsoft Teams and OpenAI in one flow
• Scale to thousands of messages without extra effort
• Improve update accuracy by using actual chat history

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Microsoft Teams and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Connect Microsoft Teams: Double click the Fetch Latest Channel Messages node, open the Credential to connect with menu, click Create new credential, and follow the on screen steps to sign in and approve access. Use a clear name like MS Teams Main. Repeat for the Send Report to Channel node.
4. Connect OpenAI: In your OpenAI account, create a new API key on the API Keys page. In n8n, double click an OpenAI Chat Model node, choose Create new credential, paste the API key, and save.
5. Set the schedule: Open the Schedule Trigger node and choose a weekly run time, for example Monday at 06:00 in your time zone.
6. Select your Microsoft Teams channel: In the Fetch Latest Channel Messages node, pick the correct Team and Channel from the dropdowns or paste the IDs. Save the node.
7. Test data pull: Click Execute Node on the Fetch Latest Channel Messages node and confirm you see recent messages in the output.
8. Verify grouping: Run the Group Messages By UserId node and check that each item represents one user with a messages list.
9. Tune the writing style: Open the Team Member Weekly Report Agent and Team Weekly Report Agent nodes. Edit the instructions to set tone, sections, and length.
10. Send a safe test: In the Send Report to Channel node, temporarily choose a private or test channel. Run the workflow once and confirm the HTML message renders correctly.
11. Check formatting: Ensure the Markdown to HTML node outputs to the html field and the Send Report to Channel node uses content type html.
12. Enable and monitor: Turn on the workflow and watch the first scheduled run. Review Executions if errors appear and adjust credentials or IDs as needed.
13. Troubleshoot common issues: If nothing posts, confirm channel permissions, verify OpenAI quota, ensure the correct Team and Channel IDs, and re run the fetch step to check for data.