Send Gmail at Specific Date and Time which comes from a Google Sheet

Hi

We run online courses. At the moment I manually send an email 30 minutes before the start of the course to remind people to join.

The list of participants, their email addresses and times and dates of their courses, are in a google sheet.

I can write an automation which sends emails to anybody in the Google sheet, but I would like to also have it send at a specific time and date which it finds in the row data on the Google sheet.

Does anyone have any ideas of how to do this?

Thanks

I recorded a short screen-sharing video to explain the resolution.

Watch here: Loom | Free Screen & Video Recording Software | Loom

Let me know should you have any further questions and do not hesitate to reach out to us for help anytime.

1 Like