AI Qwen-Vl-Plus powered car fleet maintenance alert system
Needs changesWhat this workflow does
This AI workflow has 17 nodes and runs on a schedule (every 24 hours). Along the way it connects Slack, Postgres and OpenRouter Chat Model.
How it runs
Trigger: On a schedule (every 24 hours).
- Simulate Vehicle Data (Edit Fields (Set)): sets 13 fields: vehicle_id, make, model…
- Fleet Data Source (Code): runs custom JavaScript code
- Analyze Maintenance Needs (Edit Fields (Set)): sets 7 fields: needs_oil_change, low_brake_pads, low_tire_pressure…
- Split Fleet Data (Loop Over Items (Split in Batches)): loops over the items in batches
- Check If Maintenance Needed (If): checks a condition and branches into true / false
- Generate Alert Details (Code): runs custom JavaScript code
- No Maintenance Needed (Edit Fields (Set)): sets 4 fields: vehicle_id, driver, summary…
- Send Slack Alert (Slack): uses Slack
- Log to Database (Postgres): uses Postgres
- Aggregate: combines items into one
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Maintenance Analyzer (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Maintenance Analyzer (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - Postgres
n8n-nodes-base.postgres - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter
From the author
How It Works Daily triggers automatically fetch fleet data and simulate key performance metrics for each vehicle. An AI agent analyzes maintenance requirements, detects potential issues, and routes alerts according to urgency levels. Fleet summaries are…