Setting filters to send z-api whatsapp notifications

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.