Appointment reminder via WhatsApp from Google Sheets

What it does

How to set it up

1. 1

   Connect the google credential

   This template uses google in: Leer agenda. Create or pick the credential and assign it in those nodes.

2. 2

   Connect the whatsapp_business credential

   This template uses whatsapp_business in: Recordar por WhatsApp. Create or pick the credential and assign it in those nodes.

3. 3

   Prepare the agenda

   Create a Citas sheet with the headers nombre, telefono, fecha, hora, servicio. The phone includes the country code (for example 34600111222).

4. 4

   Create the template in Meta

   Create and get approved the utility template recordatorio_cita with 3 variables: name, time and service.

5. 5

   Connect and test

   Pick the sheet in Leer agenda and your credentials in Recordar por WhatsApp. Add an appointment for tomorrow with your own phone and run the workflow manually.

6. 6

   Activate the workflow

   Workflows are installed inactive. Once everything is set, activate it.