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).
Tags
Google Sheets
WhatsApp Business CloudRelated workflows
See all Google Sheets→W
Add data from a photo to Google Sheets
Automatically adding expense receipts to Google Sheets with Telegram, Mindee API, Twilio, and n8n.
Transform data in Google Sheets
This workflow appends, lookup, updates, and reads data from a Google Sheet spreadsheet. Set node: The Set node is used to generate data that we want to add to Google Sheets. Depending on your use-case you might have data coming from a different source. For example, you might be fetching data from a WebHook call. Add the node that will fetch the data that you want to add to the Google Sheet. Use can then use the Set node to set the data that you want to add to the Google Sheets. Google Sheets node: This node will add the data from the Set node in a new row to the Google Sheet. You will have to enter the Spreadsheet ID and the Range to specify which sheet you want to add the data to. Google Sheets1 node: This node looks for a specific value in the Google Sheet and returns all the rows that contain the value. In this example, we are looking for the value Berlin in our Google Sheet. If you want to look for a different value, enter that value in the Lookup Value field, and specify the column in the Lookup Column field. Set1 node: The Set node sets the value of the rent by $100 for the houses in Berlin. We pass this new data to the next nodes in the workflow. Google Sheets2 node: This no
Automated congratulations with Google Sheets, Twilio, and n8n
Explore this workflow on its official n8n template page.