Automated Weekly Team Reports from Microsoft Teams
detail.loadingPreview
Effortlessly generate insightful weekly team reports from your Microsoft Teams channel messages. This workflow automatically collects messages, uses AI to summarize contributions, identify wins and challenges, and posts a consolidated, engaging report back to your team.
About This Workflow
Streamline your team's communication and recognition with this powerful workflow that automates the generation and distribution of weekly team reports. It begins by fetching all relevant messages from a specified Microsoft Teams channel over the past week. These messages are then processed by an AI model (GPT-4.1-mini) to create individual summaries for each team member, highlighting their contributions, wins, and any challenges. A second AI pass aggregates these individual reports into a comprehensive team-wide summary, designed to motivate and inform. The final markdown report is converted to HTML for better formatting and posted back into the Microsoft Teams channel, ensuring everyone stays updated and celebrated.
Key Features
- Automated Data Fetching: Seamlessly pull messages from your Microsoft Teams channels.
- AI-Powered Summarization: Leverage advanced AI to distill key insights and achievements from conversations.
- Individual & Team Reports: Generates personalized member reports and a consolidated team overview.
- Win & Challenge Identification: Highlights successes and flags areas for attention.
- Scheduled Execution: Runs automatically on a recurring schedule (e.g., every Monday).
- Markdown to HTML Conversion: Ensures a well-formatted and visually appealing final report.
How To Use
- Connect Services: Authenticate your Microsoft Teams and OpenAI accounts within n8n.
- Configure Trigger: Set up the 'Schedule Trigger' node to run the workflow at your desired frequency (e.g., weekly on Monday morning).
- Specify Teams Channel: In the 'Fetch Latest Channel Messages' node, provide the
teamIdandchannelIdfor the channel you want to monitor. - Define Individual Report Prompt: Customize the
messagesin the 'Team Member Weekly Report Agent' node to tailor the AI's output for individual summaries (e.g., prompt for specific focus areas). - Define Team Report Prompt: Adjust the
messagesin the 'Team Weekly Report Agent' node to shape the overarching team summary. - Set Output Channel: In the 'Send Report to Channel' node, confirm the
teamIdandchannelIdwhere the final HTML report should be posted.
Apps Used
Workflow JSON
{
"id": "8758d0ee-b8c2-41ba-8567-93f02efc4998",
"name": "Automated Weekly Team Reports from Microsoft Teams",
"nodes": 29,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 8758d0ee-b8c2...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.