Fill cancelled appointments from a waitlist with Google Sheets, Google Calendar and Twilio
Ready for 3.0What this workflow does
This workflow has 17 nodes and runs on Google Sheets events (row update). Along the way it connects Google Sheets, Twilio and Google Calendar.
How it runs
Trigger: On Google Sheets events (row update).
- Format Date & Time (Code): runs custom JavaScript code
- Cancelled & Not Yet Offered? (Filter): keeps only the items that match a condition
- Mark Waitlist Processing Started (Google Sheets): update
- Get Waiting Candidates (Google Sheets): uses Google Sheets
- Loop Over Waitlist Candidates (Loop Over Items (Split in Batches)): loops over the items in batches
- Mark Slot Unfilled (Google Sheets): update
- Mark Candidate Offered (Google Sheets): update
- Notify Owner - No Fill (Twilio): uses Twilio
- Send Waitlist Offer (Twilio): uses Twilio
- Wait: pauses until webhook
…plus 6 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 (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Sheets
n8n-nodes-base.googleSheets - Twilio
n8n-nodes-base.twilio - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Google Calendar
n8n-nodes-base.googleCalendar - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code
From the author
Quick overview This n8n workflow watches a Google Sheets appointments list for cancellations, then texts matching waitlist candidates via Twilio to claim the open slot within 20 minutes and, on confirmation, books the appointment in Google Calendar and…