Send daily appointment reminders from Google Sheets to WhatsApp
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.
Nodes used (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - WhatsApp Business Cloud
n8n-nodes-base.whatsApp
What it does
Quick overview This workflow runs daily to read appointment bookings from Google Sheets, filter for tomorrow’s appointments that have not been reminded yet, send each client a WhatsApp reminder message, and then update the sheet to mark the reminder as sent. How it works 1. Runs every day at 9 AM on a schedule. 2. Sets the Google Sheet ID, sheet tab name, WhatsApp phone number ID, and calculates tomorrow’s date. 3. Reads all appointment rows from the specified Google Sheets tab. 4. Filters to appointments where the appointmentdate is tomorrow and remindersent is not true. 5. Sends a WhatsApp message to each remaining client using their phonenumber and appointment details. 6. Updates the corresponding Google Sheets row (matched by rowid) to set remindersent to true. Setup 1. Add Google Sheets OAuth credentials and set the target spreadsheet ID and sheet/tab name in the configuration values. 2. Add WhatsApp Business Cloud (WhatsApp) credentials and set your WhatsApp phone number ID used to send messages. 3. Ensure your Google Sheet includes the columns rowid (unique), clientname, phonenumber, service, appointmenttime, appointmentdate (yyyy-MM-dd), and remindersent (boolean).