Hello, everyone.
I have a google sheet with different client’s appointments, in different date and time. I’m building a scenario to search rows and check the date and time of each row and send notifications on client’s whatsapp. I’ve put a router to send 4 different notifications by z-api in whatsapp, but i’m having trouble to set the filter.
example:
The scheduled date and time is: May 6th 2025 14:00
- 1st reminder should be 24h before that.
- 2nd reminder should be 2h before that.
- 3rd reminder should be 1h before that.
- 4th reminder should be 5 minutes before, sendind the google meet link.
Can anyone help me?
It’s sending all messages at the same time, now, and not some hours before the event.