Send weekly self-hosted instance health reports via Prometheus, GitHub and SMTP email
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs on a schedule (every week at 08:00) (plus 1 other trigger). It uses only n8n's built-in nodes. It also calls api.github.com over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00) (plus 1 other trigger).
- Set report settings (Edit Fields (Set)): sets 5 fields: instanceUrl, metricsUrl, lookbackDays…
- Read version from metrics (HTTP Request): calls an HTTP API
- Run security audit (n8n): generate (audit)
- Get n8n releases from GitHub (HTTP Request): calls api.github.com
- Get failed executions (n8n): get many (execution)
- Get workflow names (n8n): get many (workflow)
- Build health report (Code): runs custom JavaScript code
- Send report by email (Send Email): sends an email over SMTP
HTTP calls to: api.github.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 - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - n8n
n8n-nodes-base.n8n - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend
From the author
Quick overview This workflow runs weekly to check your self-hosted n8n instance version and security audit status, fetches the latest stable n8n releases from GitHub, summarizes failed executions from the last week, and sends a single HTML health report via…