Sync Cal.com no-show appointments with HighLevel CRM, WhatsApp, and Google Sheets
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, HighLevel and WhatsApp Business Cloud.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- If: checks a condition and branches into true / false
- Fetch Booking Info (HTTP Request): calls an HTTP API
- Set No-Show Details (Edit Fields (Set)): sets 10 fields: patientEmail, patientName, patientPhone…
- Read No-Show Log in Sheets (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Find CRM Contacts (HighLevel): get many
- If: checks a condition and branches into true / false
- Update CRM Status (HighLevel): uses HighLevel
- Set CRM Update Fields (Edit Fields (Set)): sets 4 fields: start, end, difference_time_in_hrs…
- Append No-Show to Sheets (Google Sheets): append
…plus 2 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 (8)
- Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - No Operation, do nothing
n8n-nodes-base.noOp - HighLevel
n8n-nodes-base.highLevel - WhatsApp Business Cloud
n8n-nodes-base.whatsApp
From the author
Quick overview This workflow receives Cal.com no-show webhook events, fetches full booking details, updates the matching contact in HighLevel (GoHighLevel), logs the no-show to Google Sheets, and sends a WhatsApp reschedule link when the no-show count is…