{"product_id":"n8n-technician-visit-booking-workflow-google-calendar-slots","title":"n8n Technician Visit Booking Workflow: Google Calendar Slots","description":"\u003ch3\u003eAutomate technician booking with Google Calendar slots—instantly send options and confirm the chosen time\u003c\/h3\u003e\n\u003cp\u003eThis n8n Technician Visit Booking Workflow receives a booking request via webhook, checks a technician’s \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e for availability, emails the customer \u003cstrong\u003ethree one-click time options\u003c\/strong\u003e using \u003cstrong\u003eGmail\u003c\/strong\u003e, and then books the selected slot back into Google Calendar—while logging everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and escalating exceptions to \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives booking requests\u003c\/strong\u003e through a \u003cstrong\u003ePOST webhook\u003c\/strong\u003e, then maps the job type to a visit duration and a \u003cstrong\u003e14-day availability search window\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks calendar availability\u003c\/strong\u003e by reading busy events from Google Calendar across the search window and calculating up to \u003cstrong\u003ethree available visit slots\u003c\/strong\u003e across different days.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends offered slots\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e with \u003cstrong\u003eclickable links\u003c\/strong\u003e, and appends the booking offer to the Google Sheets sheet named \u003cstrong\u003e“Bookings”\u003c\/strong\u003e (logging each offered state).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates when no slots exist\u003c\/strong\u003e: if availability is empty, it sends a \u003cstrong\u003eTelegram\u003c\/strong\u003e message to dispatch the customer details for manual booking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirms customer choice\u003c\/strong\u003e when the customer clicks a slot using a second webhook; it looks up the booking in Google Sheets and proceeds only if the row is still in an \u003cstrong\u003e“offered”\u003c\/strong\u003e state.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBooks the appointment\u003c\/strong\u003e in Google Calendar, updates the Google Sheets row to \u003cstrong\u003e“booked”\u003c\/strong\u003e, and sends a \u003cstrong\u003econfirmation email\u003c\/strong\u003e plus an \u003cstrong\u003eHTML confirmation page\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily reminders\u003c\/strong\u003e: every morning it sends next-day reminders for booked visits, and escalates unclicked offers older than \u003cstrong\u003e48 hours\u003c\/strong\u003e to Telegram, then marks them \u003cstrong\u003eexpired\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomation engineers building a service dispatch system that offers selectable technician appointment times.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators adding self-serve scheduling without manual calendar checks.\u003c\/li\u003e\n  \u003cli\u003eField service businesses reducing scheduling delays by auto-confirming via one-click links.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ integrations:\u003c\/strong\u003e if, code, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, plus a \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e Google Sheets “Bookings” with headers including \u003cstrong\u003ebooking_id\u003c\/strong\u003e and \u003cstrong\u003ecreated_at\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalendar actions:\u003c\/strong\u003e read busy events, create appointments, and update booking status.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45822088347827,"sku":"N8N-18092","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/wWRl4s3bEpAi7FA0Mm3hn_8cLDjVmg.png?v=1786525408","url":"https:\/\/buyflowscripts.com\/products\/n8n-technician-visit-booking-workflow-google-calendar-slots","provider":"N8N Commerce","version":"1.0","type":"link"}