Monitor data integrity and route severity-based alerts with GPT-4o, email and Slack
Ready for 3.0What 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).
- Workflow Configuration (Edit Fields (Set)): sets 7 fields: metricsApiUrl, biDashboardApiUrl, anomalyThreshold…
- Fetch Software Metrics (HTTP Request): calls an HTTP API
- Fetch BI Dashboard Data (HTTP Request): calls an HTTP API
- Merge Data Sources (Code): runs custom JavaScript code
- Data Validation Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Data Validation; output parser: Validation Output Parser
- Check for Anomalies (If): checks a condition and branches into true / false
- Orchestration Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Orchestration; output parser: Orchestration Output Parser
- Route by Severity (Switch): routes items into 2 branches
- Send Critical Alert Email (Send Email): sends an email over SMTP
- Send Critical Slack Alert (Slack): uses Slack
…plus 4 more steps. See the full node list below.
Services it uses
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)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - If
n8n-nodes-base.if - Switch
n8n-nodes-base.switch - Send Email
n8n-nodes-base.emailSend - Slack
n8n-nodes-base.slack
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…