Format date for 1 week

How To
,
1

Hi
I have a Googlesheet table with rows sorted by date (dd/mm) with the name and email of a customer opposite. I would like to be able to trigger the sending of an email on Sunday to all customers whose date is between Monday and Sunday of the current week. thanks in advance. I think you should use a date format but I don’t know how to configure it

1 Like
2

Hey @Volomax_Chute_libre

You can schedule your scenario every sunday and can set the filter for "date from google sheet "later than or equal to {{addDays(now);-6}}

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation