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 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.
Robust Concurrency Control for n8n Workflows with Redis
Prevent simultaneous execution of critical n8n workflows or tasks using a centralized, Redis-backed locking mechanism. This reusable utility workflow ensures data integrity and resource management by allowing other workflows to acquire, check, and release locks.
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.
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.
Automate DOCX to PDF Conversion and Save Locally
This workflow automates the process of converting a Microsoft Word DOCX file to a PDF document. It downloads a source DOCX file, uses ConvertAPI to perform the conversion, and then saves the resulting PDF file directly to your local disk.