Route weather-based delivery holds with Open-Meteo, Gemini, Postgres, and ServiceNow
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 26 nodes and runs on a schedule (every 15 minutes) (plus 1 other trigger). Along the way it connects Postgres, Slack, Google Gemini Chat Model and ServiceNow. It also calls api.open-meteo.com over HTTP.
How it runs
Trigger: On a schedule (every 15 minutes) (plus 1 other trigger).
- Set Region Configuration (Edit Fields (Set)): sets 5 fields: region_name, zip_code, latitude…
- Log Error to Postgres (Postgres): uses Postgres
- Fetch Weather Data (HTTP Request): calls api.open-meteo.com
- Alert Ops via Slack (Slack): uses Slack
- Set Weather Severity Conditions (Edit Fields (Set)): sets 12 fields: region_name, zip_code, cooldown_hours…
- If: checks a condition and branches into true / false
- Check for Active Alerts (Postgres): run a query
- If: checks a condition and branches into true / false
- Log New Alert to Postgres (Postgres): uses Postgres
- Retrieve Delivery Manifests (Postgres): run a query
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: api.open-meteo.com
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 (15)
- Error Trigger
n8n-nodes-base.errorTrigger - Postgres
n8n-nodes-base.postgres - Slack
n8n-nodes-base.slack - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Aggregate
n8n-nodes-base.aggregate - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - ServiceNow
n8n-nodes-base.serviceNow
From the author
Quick overview Demo Video: https://youtu.be/ccEy0J-LKY This workflow polls Open-Meteo weather data every 15 minutes for a configured region, when severe conditions are detected, checks today’s delivery manifests in Postgres, use Gemini to identify impacted…