Convert Outlook emails to Planner tasks and monitor Secure Score with Teams alerts in M365
Ready for 3.0What this workflow does
This workflow has 31 nodes and runs on a schedule (every 30 minutes) (plus 2 other triggers). Along the way it connects Microsoft Outlook and Microsoft Teams. It also calls graph.microsoft.com over HTTP.
How it runs
Trigger: On a schedule (every 30 minutes) (plus 2 other triggers).
- Get Unread Emails (Microsoft Outlook): get many
- Get Latest Secure Score (HTTP Request): calls graph.microsoft.com
- Send Error Notification Email (HTTP Request): calls an HTTP API (POST)
- Any Emails? (If): checks a condition and branches into true / false
- Calculate Security Score Percentage (Code): runs custom JavaScript code
- One Email at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
- Is Score Below 80%? (If): checks a condition and branches into true / false
- Extract Task from Email (Code): runs custom JavaScript code
- Get Existing Planner Tasks (HTTP Request): calls an HTTP API
- Post Security Teams Summary (Microsoft Teams): work with channel message
…plus 16 more steps. See the full node list below.
Services it uses
HTTP calls to: graph.microsoft.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Microsoft Teams
n8n-nodes-base.microsoftTeams - Wait
n8n-nodes-base.wait - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Keep your IT operations moving, every action email becomes a tracked task, and every security alert lands where it belongs, automatically. Every IT team deals with the same two problems: important emails that should become tasks but don't, and security…