Nurture dental leads and manage appointments with Google Sheets, Gmail, Twilio, and Google Calendar
Ready for 3.0What this workflow does
This workflow has 32 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets, Twilio, Gmail and Google Calendar.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Normalize Lead Data (Edit Fields (Set)): sets 7 fields: leadName, leadPhone, leadEmail…
- Create Calendar Event (Google Calendar): uses Google Calendar
- Log Lead to Sheet (Google Sheets): append
- Update Lead Status - Booked (Google Sheets): update
- Valid Phone? (If): checks a condition and branches into true / false
- Wait: pauses until specific time
- Send Welcome WhatsApp (Twilio): send (sms)
- Send Welcome Email (Gmail): send (message)
- Send 24hr Reminder (Twilio): send (sms)
- Wait: waits 1 hours
…plus 17 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)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Twilio
n8n-nodes-base.twilio - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - No Operation, do nothing
n8n-nodes-base.noOp - Google Calendar
n8n-nodes-base.googleCalendar
From the author
Quick overview This workflow captures new dental leads via webhook, logs them to Google Sheets, and nurtures them with Twilio WhatsApp and Gmail messages until they book or are marked. When an appointment is booked via webhook, it creates a Google Calendar…