{"product_id":"n8n-workflow-recover-no-show-appointments-google-calendar-twilio-gmail","title":"n8n Workflow: Recover No-Show Appointments (Google Calendar + Twilio + Gmail)","description":"\u003ch3\u003eRecover No-Show Appointments Automatically with Google Calendar + Twilio + Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow detects “no-show” events in your Google Calendar and immediately sends a rebooking link via \u003cstrong\u003eTwilio SMS\u003c\/strong\u003e (when a phone number is available) and \u003cstrong\u003eGmail\u003c\/strong\u003e. It also logs every follow-up to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—so you can reduce missed revenue without manual outreach.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e on a schedule to stay responsive to new no-shows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Google Calendar\u003c\/strong\u003e for events from the last three hours that contain a configurable \u003cstrong\u003eno-show marker word\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates\u003c\/strong\u003e by skipping events already handled in previous executions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts attendee details\u003c\/strong\u003e (name and email) from the event.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses a phone number\u003c\/strong\u003e from the event description when available.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a rebooking link\u003c\/strong\u003e via \u003cstrong\u003eTwilio SMS\u003c\/strong\u003e if a phone number exists, then sends the same rebooking link via \u003cstrong\u003eGmail email\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a follow-up record\u003c\/strong\u003e to a Google Sheets tab to track who was contacted and how.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAppointment-based businesses (consulting, coaching, services) that want an automated “rebook now” message after a confirmed no-show.\u003c\/li\u003e\n  \u003cli\u003eOperators who need auditable reporting of outreach attempts, including channels used and original appointment time.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building reliable customer recovery flows without duplicate notifications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e: searches events in the last three hours using a marker word.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTwilio\u003c\/strong\u003e: sends SMS using your configured Twilio sending number (only when a phone number is parsed).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: emails the rebooking link to the attendee email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: appends a row to the \u003cstrong\u003e“No-shows”\u003c\/strong\u003e tab with fields like name, email, phone, channels, contacted_at, original_time, and missed_appointment.\u003c\/li\u003e\n  \u003cli\u003eLogic and orchestration include nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and a \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eRequirements:\u003c\/strong\u003e Google account (Calendar, Sheets, Gmail), a \u003cstrong\u003eTwilio\u003c\/strong\u003e account with SMS-capable phone number, and your configured rebooking link.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938266505395,"sku":"N8N-19004","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DVwUcFrBa9dI-yZeMf5A_I8EppWYK.png?v=1788340998","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-recover-no-show-appointments-google-calendar-twilio-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}