Templates / Reroute delayed shipments with OpenAI, Google Sheets, Telegram, Slack, and Gmail

Reroute delayed shipments with OpenAI, Google Sheets, Telegram, Slack, and Gmail

Ready for 3.0

by Rahul Joshi ✓ · 20 views · created 2026-09-08 · Engineering, AI Chatbot

Ready 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 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).

  1. Read Active Shipments (Google Sheets): uses Google Sheets
  2. Detect Delays (Code): runs custom JavaScript code
  3. Build Delay Summary (Code): runs custom JavaScript code
  4. Any Delays Found? (If): checks a condition and branches into true / false
  5. Send Delay Summary (Telegram): uses Telegram
  6. Split Delayed Shipments (Split Out): splits a list into separate items
  7. Get Alternate Routes (HTTP Request): calls an HTTP API
  8. Analyze Reroute Options (AI) (OpenAI): uses OpenAI
  9. Parse AI Recommendation (Code): runs custom JavaScript code
  10. 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

Google SheetsTelegramOpenAISlackGmail

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)

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…

Excerpt from Rahul Joshi's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.