Route AV rental kit readiness with Airtable, OpenAI, Google Sheets, and Trello
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 Sheets, Gmail and Trello.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Normalise Kit Event (Edit Fields (Set)): sets 9 fields: recordId, eventId, baseId…
- Settle Stock Reservation Updates (Wait): waits 15 seconds
- Fetch Rental Reservation (HTTP Request): calls an HTTP API
- Fetch Kit Stock (HTTP Request): calls an HTTP API
- Shape Kit Readiness (Code): runs custom JavaScript code
- Check Kit Input Integrity (If): checks a condition and branches into true / false
- Classify Technician Constraints (Text Classifier): classifies text into categories with AI, with model: Supply Kit Classification Model
- Stop Invalid Kit Input (Code): runs custom JavaScript code
- Route Kit Policy (Switch): routes items into 3 branches
- Create Blocked Kit Task (Trello): uses Trello
…plus 4 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 (12)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Trello
n8n-nodes-base.trello
From the author
Quick overview This workflow receives an authenticated reservation-change webhook, fetches the matching reservation and kit stock from Airtable, calculates shortages and allowed substitutions, uses OpenAI to classify technician notes, and routes the…