Triage VIP Outlook emails using Excel, GPT-4o and Microsoft To Do
Needs changesWhat this workflow does
This workflow has 11 nodes and runs on Microsoft Outlook events (plus 1 other trigger). Along the way it connects Microsoft Outlook, Microsoft Excel 365 and Microsoft To Do.
How it runs
Trigger: On Microsoft Outlook events (plus 1 other trigger).
- Deduplicate Threads (Code): runs custom JavaScript code
- Send Error Email (Microsoft Outlook): uses Microsoft Outlook
- Excel: Read VIP Sheet (Microsoft Excel 365): read rows
- Code: runs custom JavaScript code
- Strip HTML Bloat (HTML): parses or builds HTML
- AI: Analyze Urgency (OpenAI): uses OpenAI
- Parse AI Output (Code): runs custom JavaScript code
- Is Urgent? (If): checks a condition and branches into true / false
- Create VIP To Do Task (Microsoft To Do): create
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in AI: Analyze Urgency: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) AI: Analyze Urgency | OpenAI node (AI section) |
Nodes used (9)
- Microsoft Outlook Trigger
n8n-nodes-base.microsoftOutlookTrigger - Code
n8n-nodes-base.code - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - HTML
n8n-nodes-base.html - OpenAI
n8n-nodes-base.openAi - If
n8n-nodes-base.if - Microsoft To Do
n8n-nodes-base.microsoftToDo - Error Trigger
n8n-nodes-base.errorTrigger - Microsoft Outlook
n8n-nodes-base.microsoftOutlook
From the author
Quick overview This workflow polls Microsoft Outlook every 5 minutes, deduplicates email threads, checks senders against a VIP list in Microsoft Excel, uses OpenAI (GPT-4o) to detect urgency, and creates a Microsoft To Do task for urgent VIP emails while…