Route cold-chain lot release decisions with OpenAI, Gmail and Telegram
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 16 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model, Google Drive, Google Sheets and Telegram and 1 more.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Normalise Lot Evidence (Edit Fields (Set)): sets or maps fields
- Fetch Stability Envelope (HTTP Request): calls an HTTP API (POST)
- Extract Excursion Facts (Information Extractor): extracts structured fields from text with AI, with model: Provide Extraction Model
- Compute Thermal Debt Score (Code): runs custom JavaScript code
- Check Immediate Quarantine (If): checks a condition and branches into true / false
- Create Quality Case (HTTP Request): calls an HTTP API (POST)
- Wait: waits 30 minutes
- Check Destroy Threshold (If): checks a condition and branches into true / false
- Draft Disposition Rationale (Basic LLM Chain): sends a prompt to an LLM, with model: Provide Drafting Model
- Alert Quality Leadership (Telegram): uses Telegram
…plus 3 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 (13)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Wait
n8n-nodes-base.wait - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - Gmail
n8n-nodes-base.gmail
From the author
Quick overview Receives cold-chain excursion telemetry via webhook, enriches it via an external stability API, and uses OpenAI to extract facts and draft disposition rationales. It routes lots for release, review, quarantine, or disposal while archiving…