Monitor data quality with Notion rules, SQL checks & AI-powered alerts
Ready for 3.0Ready 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 17 nodes and runs on a schedule (every day at 07:00). Along the way it connects Postgres, Notion, OpenAI and Jira Software and 2 more.
How it runs
Trigger: On a schedule (every day at 07:00).
- Get database data (Notion): work with database
- split batch (Loop Over Items (Split in Batches)): loops over the items in batches
- Switch: routes items into 2 branches
- Product anomalies (Postgres): run a query
- check orders (Postgres): run a query
- build summary (Code): runs custom JavaScript code
- AI analysis and recommendation (OpenAI): uses OpenAI
- run metadata (Edit Fields (Set)): sets 5 fields: run_date, run_id, env…
- calculate trend (Code): runs custom JavaScript code
- Issue condition (If): checks a condition and branches into true / false
…plus 6 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 (12)
- Postgres
n8n-nodes-base.postgres - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Notion
n8n-nodes-base.notion - OpenAI
@n8n/n8n-nodes-langchain.openAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Switch
n8n-nodes-base.switch - If
n8n-nodes-base.if - Jira Software
n8n-nodes-base.jira - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail
From the author
Description This workflow continuously validates data quality using rules stored in Notion, runs anomaly checks against your SQL database, generates AI-powered diagnostics, and alerts your team only when real issues occur. Notion holds all data quality rules…