{"product_id":"voice-assistant-appointment-booking-via-google-calendar-sheets","title":"Voice Assistant Appointment Booking via Google Calendar + Sheets","description":"\u003ch3\u003eTurn voice calls into scheduled appointments—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow exposes a webhook that your voice assistant can use to \u003cstrong\u003echeck availability\u003c\/strong\u003e, \u003cstrong\u003ebook\u003c\/strong\u003e, \u003cstrong\u003ereschedule\u003c\/strong\u003e, or \u003cstrong\u003ecancel\u003c\/strong\u003e appointments by syncing \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e events with a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e bookings log—returning a single spoken-style confirmation sentence for each tool call.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives voice-assistant tool calls via webhook:\u003c\/strong\u003e A POST request provides a tool call name and arguments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload:\u003c\/strong\u003e The workflow extracts the \u003cem\u003etoolCallId\u003c\/em\u003e, function name, caller phone number, requested datetime, and other fields, then loads existing bookings from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks availability (check_availability):\u003c\/strong\u003e Reads upcoming \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e events, calculates the next open time slots within configured business hours, and skips weekends and conflicting times.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBooks appointments (book_appointment):\u003c\/strong\u003e Validates the requested datetime and name, checks for scheduling conflicts in Google Calendar, and either offers an alternative or creates a new calendar event.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs bookings to Sheets:\u003c\/strong\u003e When created, it appends a row to the \u003cstrong\u003eBookings\u003c\/strong\u003e tab with appointment details, the \u003cstrong\u003eevent ID\u003c\/strong\u003e, and status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReschedules or cancels:\u003c\/strong\u003e Finds the caller’s existing booking in Google Sheets by matching the \u003cstrong\u003elast 7 digits\u003c\/strong\u003e of the phone number, then updates or deletes the matching Google Calendar event and returns a confirmation message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a webhook response:\u003c\/strong\u003e Responds with JSON containing the \u003cem\u003etoolCallId\u003c\/em\u003e and a single human-readable sentence, including graceful error messaging for unknown functions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAI\/voice front desks that schedule service appointments without manual admin work\u003c\/li\u003e\n  \u003cli\u003ePhone-based booking that can handle reschedule and cancel requests reliably\u003c\/li\u003e\n  \u003cli\u003eSaaS operators needing a simple availability + booking log using Google Calendar + Sheets\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/tools: \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e (create\/read\/update\/delete events) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Bookings tab log and lookup)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132924612787,"sku":"N8N-20145","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bDsXftl_smxMIbcRZTqd2_Hg35KLmW.png?v=1790760176","url":"https:\/\/buyflowscripts.com\/products\/voice-assistant-appointment-booking-via-google-calendar-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}