Quick overview
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 Runs every day at 9 AM on a schedule. Sets the Google Sheet ID, sheet tab name, WhatsApp phone number ID, and calculates tomorrow’s date. Reads all appointment rows from the specified Google Sheets tab. Filters to appointments where the appointment_date is tomorrow and reminder_sent is not true. Sends a WhatsApp message to each remaining client using their phone_number and appointment details. Updates the corresponding Google Sheets row (matched by row_id) to set reminder_sent to true. Setup Add Google Sheets OAuth credentials and set the target spreadsheet ID and sheet/tab name in the configuration values. Add WhatsApp Business Cloud (WhatsApp) credentials and set your WhatsApp phone number ID used to send messages. Ensure your Google Sheet includes the columns row_id (unique), client_name, phone_number, service, appointment_time, appointment_date (yyyy-MM-dd), and reminder_sent (boolean). An n8n automation workflow template by Kanishka Shrivastava.
Kanishka Shrivastava
web
free
Others in the same category, ranked by how often they are opened.
