Handle voice receptionist bookings with Vapi, Google Calendar and Sheets
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Calendar and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Parse Vapi Tool Call (Code): runs custom JavaScript code
- Route by Tool Name (Switch): routes items into 3 branches
- Fetch Events from Google Calendar (Google Calendar): get many
- Create Event in Google Calendar (Google Calendar): uses Google Calendar
- Log Message to Google Sheets (Google Sheets): append
- Format Ignored Event Response (Code): runs custom JavaScript code
- Compute Open Slots (Code): runs custom JavaScript code
- Log Booking to Google Sheets (Google Sheets): append
- Email Message to Owner (Send Email): sends an email over SMTP
- Respond to Vapi (Respond to Webhook): sends the response back to the webhook caller
…plus 3 more steps. See the full node list below.
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 (7)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Google Calendar
n8n-nodes-base.googleCalendar - Send Email
n8n-nodes-base.emailSend - Respond to Webhook
n8n-nodes-base.respondToWebhook - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow handles Vapi voice agent tool calls to check Google Calendar availability, book appointments into Google Calendar, and capture phone messages, then logs outcomes to Google Sheets and notifies the owner by email. How it works 1.…