Reroute delayed shipments with OpenAI, Google Sheets, Telegram, Slack, and Gmail
Ready for 3.0What this workflow does
This AI workflow has 22 nodes and runs on a schedule (every 30 minutes). Along the way it connects Google Sheets, Telegram, OpenAI and Slack and 1 more.
How it runs
Trigger: On a schedule (every 30 minutes).
- Read Active Shipments (Google Sheets): uses Google Sheets
- Detect Delays (Code): runs custom JavaScript code
- Build Delay Summary (Code): runs custom JavaScript code
- Any Delays Found? (If): checks a condition and branches into true / false
- Send Delay Summary (Telegram): uses Telegram
- Split Delayed Shipments (Split Out): splits a list into separate items
- Get Alternate Routes (HTTP Request): calls an HTTP API
- Analyze Reroute Options (AI) (OpenAI): uses OpenAI
- Parse AI Recommendation (Code): runs custom JavaScript code
- Requires Human Approval? (If): checks a condition and branches into true / false
…plus 11 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 (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - Split Out
n8n-nodes-base.splitOut - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - Slack
n8n-nodes-base.slack - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs every 30 minutes to detect delayed shipments from Google Sheets, sends a delay summary to Telegram, uses OpenAI to recommend alternate routes from a routing API, requests approval in Slack when needed, updates the carrier TMS…