Generate AI-powered summaries and send them to Teams on schedule
Workflow Description
Scheduled automation that extracts content, processes it through OpenAI language models, aggregates and formats results, then automatically delivers them to Microsoft Teams channels. Eliminates manual reporting and ensures timely, intelligent updates reach your team consistently.
How it works
- 1.Automation triggers at predetermined intervals based on your configured schedule
- 2.Data is sent to OpenAI language model for analysis and intelligent insight generation
- 3.Results are aggregated and formatted in readable Markdown structure
- 4.Final message is automatically sent to specified Teams channels
Use cases
- Send daily AI-generated summaries of team performance or project metrics
- Publish automatically generated reports processed by language models to Teams
- Deliver smart alerts and content summaries to work groups without manual effort
Requirements
- Active Microsoft Teams account with message posting permissions
- Valid OpenAI API key to access language models
- Channel names or team identifiers where messages will be delivered
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (17)
Schedule Trigger
Schedule Trigger
Fetch Latest Channel Messages
Microsoft Teams
OpenAI Chat Model
OpenAI
Team Member Weekly Report Agent
LLM Chain
Merge Report With User Data
Set
OpenAI Chat Model1
OpenAI
Reports to Single List
Aggregate
Team Weekly Report Agent
LLM Chain
Markdown to HTML
Markdown
Send Report to Channel
Microsoft Teams
Sticky Note
Sticky Note
Group Messages By UserId
Code
Groups to Items
Split Out
Sticky Note1
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note6
Sticky Note