Automate restaurant marketing & booking with Excel, VAPI voice agent & calendar
Ready for 3.0What this workflow does
This workflow has 9 nodes and runs on Google Sheets events (row added) (plus 1 other trigger). Along the way it connects Google Sheets and Google Calendar. It also calls api.vapi.ai over HTTP.
How it runs
Trigger: On Google Sheets events (row added) (plus 1 other trigger).
- Prepare Lead Data (Edit Fields (Set)): sets 1 field: Phone
- Store User Response (Sheet) (Google Sheets): append or update
- Loop Through Leads (Loop Over Items (Split in Batches)): loops over the items in batches
- Extract Booking/Order Info (Code): runs custom JavaScript code
- Start Marketing Call (VAPI) (HTTP Request): calls api.vapi.ai (POST)
- Schedule Delivery/Table Booking (Google Calendar): uses Google Calendar
- Send Response to VAPI (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 (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Google Calendar
n8n-nodes-base.googleCalendar - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
This n8n template demonstrates how to create a comprehensive marketing automation and booking system that combines Excel-based lead management with voice-powered customer interactions. The system utilizes VAPI for voice communication and Excel/Google Sheets…