Team Weekly Report Generator
detail.loadingPreview
Automates the generation and dissemination of team weekly reports based on Microsoft Teams message activity.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of generating weekly reports for team members and the entire team. It pulls messages from a Microsoft Teams channel, summarizes individual contributions, and then synthesizes these into a comprehensive team report. The final report is then converted to HTML and posted back to the Teams channel.
Key Features
- Fetches messages from a specified Microsoft Teams channel.
- Groups messages by user to analyze individual activity.
- Utilizes OpenAI to generate personalized weekly reports for each user, focusing on wins and challenges.
- Compiles individual reports into a single, holistic team weekly report.
- Converts the final team report from Markdown to HTML for better formatting.
- Posts the HTML-formatted report back to the Microsoft Teams channel.
How To Use
- Import the workflow: Load this JSON into your n8n instance.
- Configure Microsoft Teams credentials: Set up and select your Microsoft Teams OAuth2 credentials.
- Configure OpenAI credentials: Set up and select your OpenAI API credentials.
- Set Team and Channel IDs: In the
microsoftTeamsnodes, ensure theteamIdandchannelIdare correctly set to your desired Microsoft Teams environment. - Adjust Schedule: Configure the
Schedule Triggernode to run the workflow at your preferred interval (e.g., weekly on Monday morning). - Review OpenAI Prompts: Examine the
textandmessagesparameters in theOpenAI Chat ModelandTeam Weekly Report Agentnodes to fine-tune the report generation and tone.
Apps Used
Workflow JSON
{
"id": "29f4e826-239a-429a-bbe2-c043fafb2ce4",
"name": "Team Weekly Report Generator",
"nodes": 0,
"category": "Reporting & Analytics",
"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: 29f4e826-239a...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Verification Info
Related Integrations
Related Workflows
Discover more workflows you might like
Online Marketing Weekly Report
Generates a weekly report summarizing key marketing metrics from Google Ads, Meta Ads, and Google Analytics.
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automate Shipment Tracking with Telegram and n8n
Streamline your logistics operations by automating shipment tracking with Telegram and n8n. This workflow allows drivers to easily share updates, and ensures timely notifications to your team.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
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.