I have a simple question : using Gsheet, I have a file where other have actions to perform before a specific date. Is there a way to send an email automatically generated when the time remaining from that specific date is for example less than 1 day ? And ideally whithout opening Gsheet ?
Am I dreaming ?
Thanks for you reply
I know how to do it for example with app script but I have to trigger it manually to send email.