Automate travel business operations with Postgres, Google Sheets and Voice API
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs when an HTTP POST request hits its webhook URL (plus 3 other triggers). Along the way it connects Postgres and Google Sheets. It also calls api.vapi.ai over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 3 other triggers).
- Validate Trip Details (Postgres): select
- Update Booking Record (Postgres): create or update
- Format Lead Information (Edit Fields (Set)): sets 1 field: Phone_number
- Log User Input (Google Sheets): append or update
- Deliver Organizer Info (Respond to Webhook): sends the response back to the webhook caller
- Send Booking Confirmation (Respond to Webhook): sends the response back to the webhook caller
- Initiate Marketing Outreach (HTTP Request): calls api.vapi.ai (POST)
- Relay Response to System (Respond to Webhook): sends the response back to the webhook caller
Services it uses
HTTP calls to: api.vapi.ai
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 (7)
- Webhook
n8n-nodes-base.webhook - Postgres
n8n-nodes-base.postgres - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
From the author
This comprehensive n8n workflow automates the entire travel business call management process, from initial customer inquiries to trip bookings and marketing outreach. The system handles incoming calls, validates trip details, processes bookings, captures…