Optimize fleet routes and anomaly alerts with GPT-4, Slack and Postgres

by Cheng Siong Chin ✓ · 40 views · created 2026-01-18 · Engineering, AI Summarization

What this workflow does

This AI workflow has 28 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Postgres and Slack.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

1. Workflow Configuration (Edit Fields (Set)): sets 9 fields: trafficApiUrl, weatherApiUrl, maxSpeedThreshold…
2. Merge: merges the data from its input branches
3. Normalize Telemetry Data (Code): runs custom JavaScript code
4. Validate Data Quality (Code): runs custom JavaScript code
5. Remove Duplicate Events (Remove Duplicates): removes duplicate items
6. Fetch Traffic & Weather Data (HTTP Request): calls an HTTP API
7. Merge: merges the data from its input branches
8. Route Optimization Agent (AI Agent): runs an AI agent, with model: OpenAI GPT-4 Model; output parser: Route Optimization Output Parser
9. Anomaly Detection Agent (AI Agent): runs an AI agent, with model: OpenAI GPT-4 Model for Anomaly; output parser: Anomaly Detection Output Parser
10. Apply Business Rules (Code): runs custom JavaScript code

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

Services it uses

OpenAI Chat ModelPostgresSlack

Before you upgrade to n8n 3.0

Nodes used (17)

• Webhookn8n-nodes-base.webhook
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• Remove Duplicatesn8n-nodes-base.removeDuplicates
• HTTP Requestn8n-nodes-base.httpRequest
• AI Agent@n8n/n8n-nodes-langchain.agent
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Switchn8n-nodes-base.switch
• Waitn8n-nodes-base.wait
• Postgresn8n-nodes-base.postgres
• Slackn8n-nodes-base.slack
• Send Emailn8n-nodes-base.emailSend
• Ifn8n-nodes-base.if
• Respond to Webhookn8n-nodes-base.respondToWebhook

From the author

How It Works This workflow automates veterinary clinic operations and client communications for animal hospitals and veterinary practices managing appointments, inventory, and patient care. It solves the dual challenge of maintaining medical supply levels…

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