Rebook disrupted flights and notify passengers with Claude, Google Sheets, and Twilio
Needs changesWhat this workflow does
This AI workflow has 23 nodes and runs on a schedule (every minute). Along the way it connects AI Agent and Anthropic Chat Model. It also calls sheets.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every minute).
- Fetch Live Flight Status Feed (HTTP Request): calls an HTTP API
- Fetch Active Bookings (HTTP Request): calls an HTTP API
- JS - Rename Flight Status Values (Code): runs custom JavaScript code
- JS - Rename Booking Values (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- JS - Match Bookings & Detect IROPS Impact (Code): runs custom JavaScript code
- Split Out: splits a list into separate items
- JS - Format Ops Log Record (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Wait: pauses before continuing
…plus 11 more steps. See the full node list below.
Services it uses
HTTP calls to: sheets.googleapis.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI - Generate Rebooking Decision (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent..
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI - Generate Rebooking Decision (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Split Out
n8n-nodes-base.splitOut - Wait
n8n-nodes-base.wait - Filter
n8n-nodes-base.filter - AI Agent
@n8n/n8n-nodes-langchain.agent - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic
From the author
Quick overview This workflow runs on a schedule to check flight status against active bookings in Google Sheets, logs an IROPS audit trail, and for severe delays or cancellations uses Anthropic Claude to choose the best alternate flight from inventory and…