Hey guys, when my users register for my event we send their data (date + time of the event) to a google sheet. I want to send a whatsapp notification (I’m using a webhook for that) 15 minutes before the event happen. How can I do that?
TIA!
1 Like
HI @gersonrfr
It isn’t easy to trigger exactly 15 minutes before the event happens. If you want to follow the exact minute, you must create an app script to watch for the same and then trigger Make.
The easy method is to loop through each row using the Google sheet module “Search rows” every 5 or 10 Mins. If there is an expected time difference, trigger WhatsApp message and update the sheet’s status column (create one if not added) to “Sent”.
Ensure that you filter the Search rows for the status that does not contain “Sent”.
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
Wouldn’t that skyrocket the number of operations?
We created this video for precisely this use case.
