n8n Weekly Health Report: Prometheus, GitHub & SMTP Email

Weekly Health Report for your self-hosted n8n—Prometheus, GitHub & SMTP in one email

This n8n workflow checks your self-hosted n8n instance every week and delivers a single, easy-to-read HTML health report via SMTP—covering version status, security audit results, latest stable GitHub releases, and failed executions from the past week.

What this workflow does

• Runs weekly (Mondays at 8am) or can be triggered manually to generate the report.
• Loads report settings including your n8n URL, Prometheus metrics endpoint, look-back window, and email recipients.
• Reads the running n8n version from Prometheus metrics (using your configured metrics URL; default is http://localhost:5678/metrics) and runs the n8n instance security audit.
• Checks GitHub releases by fetching the latest stable n8n versions from the n8n-io/n8n GitHub releases API.
• Summarizes recent failures by retrieving failed executions and workflow names, then grouping failures that occurred within the configured look-back window by workflow.
• Sends a combined report as both HTML and plain-text via SMTP, including version status, audit findings, and failure counts.

Use cases

• SaaS operators who want weekly n8n reliability reporting without checking logs.
• Automation engineers who need security audit visibility and fast awareness of outdated n8n versions.
• Teams monitoring workflow health and tracking which workflows are failing most over the last week.

Technical details

• Metrics (Prometheus): requires N8N_METRICS=true on your n8n instance.
• n8n API: uses an n8n API key for audit, executions, and workflow-list requests.
• GitHub integration: pulls latest stable releases from n8n-io/n8n.
• Nodes / steps: set, code, http request, email send, and a sticky note.

Before activating the schedule, update the instance URL, recipients, sender address, and look-back days in the report settings.