Templates / Automate travel business operations with Postgres, Google Sheets and Voice API

Automate travel business operations with Postgres, Google Sheets and Voice API

Ready for 3.0

by Oneclick AI Squad ✓ · 415 views · created 2025-07-16 · CRM

Ready 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 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).

  1. Validate Trip Details (Postgres): select
  2. Update Booking Record (Postgres): create or update
  3. Format Lead Information (Edit Fields (Set)): sets 1 field: Phone_number
  4. Log User Input (Google Sheets): append or update
  5. Deliver Organizer Info (Respond to Webhook): sends the response back to the webhook caller
  6. Send Booking Confirmation (Respond to Webhook): sends the response back to the webhook caller
  7. Initiate Marketing Outreach (HTTP Request): calls api.vapi.ai (POST)
  8. Relay Response to System (Respond to Webhook): sends the response back to the webhook caller

Services it uses

PostgresGoogle Sheets

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)

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…

Excerpt from Oneclick AI Squad's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.