Make and the WhatsApp Business API

:us_outlying_islands:
I want to create an automation using Google Sheets, Make, and the WhatsApp Business API. Whenever a cell in the “Status” column of any row in my Google sheet is updated with the value “Scheduled” , I would like a custom message to be sent automatically on WhatsApp. The message must include: * The name of the customer (from a column, e.g., “Customer Name”) * The date and time of the appointment (e.g., from the “Appointment Date” column) * The day of the week (calculated from the date) * The name of the salesperson assigned to the customer (e.g., from the “Salesperson” column) The message should look like this: Hello [NAME], your appointment has been scheduled for [DAY] [DATE]. Our assigned [SELLER] will take care of you. We are expecting you! Please provide a complete step-by-step guide , including even the simplest or obvious steps (such as creating the Make account, connecting the sheet, using filters, configuration, etc.). Include the technical steps, but explain them in a way that even a non-technical user can follow.

How do I do it ? The configuration of whatsapp API with half already done it now I need to figure out how to do in any row in the column Status is put scheduled and how to make it understand it because that is where it all starts from then I need to figure out how to put the day of the week that must refer to the date of the appointment


Voglio creare un’automazione utilizzando Google Sheets, Make e l’API di WhatsApp Business. Ogni volta che una cella della colonna “Stato” di qualsiasi riga del mio foglio Google viene aggiornata con il valore “Schedulato” , desideroso che venga inviato automaticamente un messaggio personalizzato su WhatsApp. Il messaggio deve includere: * Il nome del cliente (da una colonna, ad esempio “Nome Cliente”) * La data e ora dell’appuntamento (es. dalla colonna “Data Appuntamento”) * Il giorno della settimana (calcolato dalla data) * Il nome del venditore assegnato al cliente (es. dalla colonna “Venditore”) Il messaggio dovrebbe essere simile a questo: Ciao [NOME], il tuo appuntamento è stato programmato per [GIORNO] [DATA]. Il nostro incaricato [VENDITORE] si prenderà cura di te. Ti aspettiamo! Per favore, fornisci una guida passo-passo completa , includendo anche i passaggi più semplici o ovvi (come la creazione dell’account Make, la connessione del foglio, l’uso dei filtri, la configurazione, ecc.). Include i passaggi tecnici, ma spiegali in modo che anche un utente non tecnico possa seguirli.

Come faccio ? La configurazione di whatsapp API con metà lo già fatta adesso mi serve capire come fare in una qualsiasi riga nella colonna Stato viene messo schedulato e come farlo capire a make perché è da lì che parte il tutto poi devo capire come mettere il giorno della settimana che deve far riferimento alla data dell’appuntamento

Welcome to the Make community!

To allow others to assist you, please try to use English on this forum. This will help others around the world understand your question better and you’ll likely get your question answered faster!

If you could please edit and insert a translated copy of your question into your post above, that would be very helpful. Thank you for your understanding!

I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

You could adapt the following tutorial to do exactly this, as you will only need to create a calculated field on the Google Sheet that includes the name of the client and date.