Recover missed appointments with Google Calendar, Twilio, Gmail and Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs on a schedule (every hour). Along the way it connects Google Calendar, Twilio, Gmail and Google Sheets.
How it runs
Trigger: On a schedule (every hour).
- Config (edit me) (Edit Fields (Set)): sets 4 fields: business_name, booking_link, from_number…
- Find Marked Events (Google Calendar): get many (event)
- Only New No-Shows (Remove Duplicates): removes duplicate items
- Pull Attendee Details (Edit Fields (Set)): sets 5 fields: attendee_email, attendee_name, attendee_phone…
- Is There a Phone Number? (If): checks a condition and branches into true / false
- Text the Rebooking Link (Twilio): send (sms)
- Email the Rebooking Link (Gmail): uses Gmail
- Log the Recovery (Google Sheets): append
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 (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Calendar
n8n-nodes-base.googleCalendar - Remove Duplicates
n8n-nodes-base.removeDuplicates - If
n8n-nodes-base.if - Twilio
n8n-nodes-base.twilio - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow runs hourly to find Google Calendar events marked with a “no-show” keyword, then sends a rebooking link via Twilio SMS (when a phone number is available) and Gmail email, and appends a follow-up record to Google Sheets. How it…