Send Entra ID app credential expiry alerts via Microsoft Graph and Outlook
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs on a schedule (every day at 07:00). Along the way it connects Microsoft Outlook. It also calls graph.microsoft.com over HTTP.
How it runs
Trigger: On a schedule (every day at 07:00).
- Set Notification Configurations (Edit Fields (Set)): sets 7 fields: thresholdDays, expiredLookbackDays, hideRotated…
- Fetch App Registrations (HTTP Request): calls graph.microsoft.com
- Fetch Enterprise Apps (HTTP Request): calls graph.microsoft.com
- Merge: merges the data from its input branches
- Filter Expiring Credentials (Code): runs custom JavaScript code
- Fetch App Owners (HTTP Request): calls an HTTP API
- Add App Owners (Code): runs custom JavaScript code
- Build IT Summary Email (Code): runs custom JavaScript code
- Check Owner Notification (If): checks a condition and branches into true / false
- Send Summary Email (Microsoft Outlook): uses Microsoft Outlook
…plus 2 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 (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - If
n8n-nodes-base.if
From the author
Quick overview This workflow runs daily to scan Microsoft Entra ID (Azure AD) app registrations and enterprise apps via Microsoft Graph for expiring or recently expired client secrets and certificates, then sends an HTML summary alert through Microsoft…