I would like to automatically get an email notification based on an existing date in Google sheets. The use case is to follow up on booking inquiries.
To cut down on holds on dates that do not materialize, my policy is to keep the hold for 2 weeks then release the hold. If the party goes ahead with the booking, I convert the status of the hold to a booking.
The dates and times of the start of the hold are already loaded into a Google Sheet cell. I would like to get an email after 2 weeks passes from that date. This would allow me to then follow up with the party in a timely manner.
Example:
Booking 1: 1/1/2023 => auto email to me on 1/15/2023
Booking 2: 1/15/2023 => auto email to me on 1/30/2023
The caveat that I have is that I would only want that to happen once per row, and old rows would still remain in the spreadsheet.
Best answer by Troy Tessalone
View original
