Monitor n8n Incidents: Slack + Gmail Alerts, OpenAI Spend, Sheets

Monitor n8n Incidents Automatically—Slack + Gmail Alerts, OpenAI Spend & Health Digest

This n8n workflow continuously monitors your n8n instance for failing or runaway automations, sends detailed incident alerts to Slack and Gmail, estimates OpenAI token spend, and publishes a weekly operational health digest with anomaly detection to Google Sheets.

What this workflow does

• Runs on a schedule: hourly for an incident “guard” window and every Monday at 9 AM for a 7-day “digest” window.
• Queries your n8n REST API: lists active workflows (excluding this monitor) and pulls recent execution history for each workflow.
• Calculates health metrics: per-workflow runs, failures, error rate, and p95 duration, plus an estimated LLM cost by scanning execution data for token usage.
• Guard mode (hourly): checks Google Sheets (Guard_Log) to suppress repeat warnings using a cooldown. Classifies workflows as warning or critical, retrieves the latest failed execution details from the n8n API, and extracts the failing node and error message.
• Auto-mitigates critical workflows: automatically deactivates critical workflows via the n8n API unless they’re tagged as protected (e.g., “no-auto-disable” / “critical”). Then logs the incident to Google Sheets and posts a detailed alert to Slack.
• Digest mode (weekly): reads Google Sheets (Metrics_History), detects week-over-week anomalies, clusters similar error messages from sampled failures, and uses OpenAI (gpt-4o-mini) to generate an ops summary. Emails an HTML weekly digest via Gmail.

Use cases

• Prevent runaway automations by automatically disabling critical n8n workflows after repeated failures.
• Give your ops team instant incident context in Slack (failed node + error message) and a weekly trend report by email.
• Track OpenAI token spend alongside reliability metrics to spot cost drivers tied to failing workflows.

Technical details

• Integrations / nodes: if, set, code, gmail, slack, switch
• APIs & storage: n8n REST API, Google Sheets (Guard_Log, Metrics_History), OpenAI (gpt-4o-mini)