Record and confirm WhatsApp (Twilio) appointments with Google 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 18 nodes and runs on a schedule (cron 0 9 * * *) (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (cron 0 9 * * *) (plus 1 other trigger).
- Read Appointments in Sheets (Google Sheets): uses Google Sheets
- Normalize Response Data (Edit Fields (Set)): sets 3 fields: telefono, respuesta, Telefono
- Filter: keeps only the items that match a condition
- Route by Response Type (Switch): routes items into 2 branches
- Prepare WhatsApp Message (Edit Fields (Set)): sets 2 fields: telefono_whatsapp, mensaje
- Update Status to Confirmed (Google Sheets): update
- Update Status to Cancelled (Google Sheets): update
- Request Valid Response (HTTP Request): calls an HTTP API (POST)
- Post WhatsApp Reminder via Twilio (HTTP Request): calls an HTTP API (POST)
- Send Confirmation Message (HTTP Request): calls an HTTP API (POST)
…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)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Webhook
n8n-nodes-base.webhook - Switch
n8n-nodes-base.switch - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick overview This workflow uses Google Sheets and Twilio WhatsApp to send daily appointment reminders for tomorrow’s bookings and to process incoming WhatsApp replies to confirm or cancel appointments, updating the appointment status in Google Sheets and…