Scan workflows for 3.0-breaking nodes and OpenAI model shutdowns with email alerts
Needs changesWhat this workflow does
This workflow has 14 nodes and runs on a schedule (every week at 07:00) (plus 1 other trigger). Along the way it connects Slack and Google Sheets.
How it runs
Trigger: On a schedule (every week at 07:00) (plus 1 other trigger).
- Settings (Edit Fields (Set)): sets 8 fields: fromEmail, alertTo, instanceUrl…
- Get all workflows (n8n): get many (workflow)
- Scan (Code): runs custom JavaScript code
- Build error alert (Edit Fields (Set)): sets 2 fields: subject, text
- Compare with last run (Code): runs custom JavaScript code
- Email error alert (Send Email): sends an email over SMTP
- Build HTML report (Code): runs custom JavaScript code
- Anything to report? (If): checks a condition and branches into true / false
- Email report (Send Email): sends an email over SMTP
- Post Slack summary (Slack): uses Slack
…plus 2 more steps. See the full node list below.
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:
- $getPairedItem expression helper in Scan: replace with $('Node').item, $('Node').itemMatching(i) or $('Node').pairedItem().
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| $getPairedItem expression helper Scan | $('Node').item, $('Node').itemMatching(i) or $('Node').pairedItem() |
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - n8n
n8n-nodes-base.n8n - Send Email
n8n-nodes-base.emailSend - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick Overview This workflow runs manually to fetch all workflows from your n8n instance via the n8n API, scans them for node types removed in n8n 3.0 and for OpenAI model IDs with published shutdown dates, and emails you a single plain-text report. How it…