Route airline disruption recovery with OpenAI, Slack, Twilio, and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 9 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI, Slack, Twilio and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Set Passenger & Trip Details (Edit Fields (Set)): sets 5 fields: pax_id, tier, itinerary…
- Fetch PNR Details (HTTP Request): calls an HTTP API
- Classify Impact with AI (OpenAI): uses OpenAI
- Route by Impact (Switch): routes items into 3 branches
- Post to VIP Slack Channel (Slack): uses Slack
- Submit Rebooking Request (HTTP Request): calls an HTTP API (POST)
- Send SMS Updates (Twilio): uses Twilio
- Update Ops Dashboard in Sheets (Google Sheets): append or update
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 (8)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - Switch
n8n-nodes-base.switch - Slack
n8n-nodes-base.slack - Twilio
n8n-nodes-base.twilio - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow receives flight disruption events via webhook, looks up passenger PNR details in a GDS API, uses OpenAI to choose a recovery path, then escalates to Slack or auto-rebooks via HTTP, notifies the passenger by Twilio SMS, and logs…