Triage backflow compliance notices with Google Sheets, Gmail, Slack, OpenAI, and a state API
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 (cron 0 6 * * *). Along the way it connects Google Sheets, Slack, OpenAI Chat Model and Gmail. It also calls replace-state-ereporting-portal.example.gov over HTTP.
How it runs
Trigger: On a schedule (cron 0 6 * * *).
- Fetch Backflow Device Registry (Google Sheets): uses Google Sheets
- Split Out: splits a list into separate items
- Compute Days Since Last Test (Code): runs custom JavaScript code
- Normalize Device Record (Edit Fields (Set)): sets 6 fields: device_id, address, hazard_level…
- Check Device Data Completeness (If): checks a condition and branches into true / false
- Classify Compliance Status (Text Classifier): classifies text into categories with AI, with model: Compliance Classifier Model
- Flag Data Quality Issue (Slack): uses Slack
- Route By Compliance Status (Switch): routes items into 3 branches
- File State Non-Compliance Report (HTTP Request): calls replace-state-ereporting-portal.example.gov (POST)
- Send Test Reminder Notice (Gmail): uses Gmail
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: replace-state-ereporting-portal.example.gov
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 (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier - Switch
n8n-nodes-base.switch - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge
From the author
Quick overview This workflow runs daily, reads a Google Sheets backflow device registry, calculates overdue risk, and uses OpenAI to classify each device as Critical Overdue, Due Soon, or Compliant, then routes actions through a state reporting API, Gmail…