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?