Date triggered email
Hello, my name is Paul and I have tried your mail merge app in google sheets and it works great. Congratulations, it is a fine app.
I have a question, can I trigger mail merge to send an email when a value in a certain cell reaches for example ”1”. I have to send emails from google sheets 1 day before a specific date as a reminder. The sheet looks like this:
|First Name||Last Name||Phone||Expiration date||Days to expiration|
the last column is the trigger, when it reaches ”1” (meaning 1 day before overdue) the email should be sent. Is there a possibility in mail merge for this?
Have a nice day