Templates / Monitor data integrity and route severity-based alerts with GPT-4o, email and Slack

Monitor data integrity and route severity-based alerts with GPT-4o, email and Slack

Ready for 3.0

by Cheng Siong Chin ✓ · 68 views · created 2026-02-01 · Document Extraction, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 19 nodes and runs on a schedule (every 15 minutes). Along the way it connects OpenAI Chat Model and Slack.

How it runs

Trigger: On a schedule (every 15 minutes).

  1. Workflow Configuration (Edit Fields (Set)): sets 7 fields: metricsApiUrl, biDashboardApiUrl, anomalyThreshold…
  2. Fetch Software Metrics (HTTP Request): calls an HTTP API
  3. Fetch BI Dashboard Data (HTTP Request): calls an HTTP API
  4. Merge Data Sources (Code): runs custom JavaScript code
  5. Data Validation Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Data Validation; output parser: Validation Output Parser
  6. Check for Anomalies (If): checks a condition and branches into true / false
  7. Orchestration Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Orchestration; output parser: Orchestration Output Parser
  8. Route by Severity (Switch): routes items into 2 branches
  9. Send Critical Alert Email (Send Email): sends an email over SMTP
  10. Send Critical Slack Alert (Slack): uses Slack

…plus 4 more steps. See the full node list below.

Services it uses

OpenAI Chat ModelSlack

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 (11)

From the author

How It Works This workflow automates continuous data integrity monitoring and intelligent alert management across multiple data sources. Designed for data engineers, IT operations teams, and business intelligence analysts, it solves the critical challenge of…

Excerpt from Cheng Siong Chin's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.