/Google-Sheet-Event-Reminder-Emails

Use Google Sheet to manage your Calendar events and sent email reminders

Creative Commons Zero v1.0 UniversalCC0-1.0

Google-Sheet-Event-Reminder-Emails (Google Apps Script)

Use Google Sheet to manage your Calendar events and sent email reminders

This Google Script will send emails (e.g., reminder messages) based on dates in a Google Sheet. The information in the Google Sheet can also set up Google Calendar events on specific dates, as shown in this script: https://github.com/ryanrwatkins/Google-Sheet-to-Calendar. The script also imports a list of email recipients from another tab in the Sheet using this Google Sheet notation: =textjoin(", ", 1, members!B2:B) to put them into a comma separated format. For instance, if you maintain a large list of people whom should get the event reminder (but not be subscribed to the Calendar) then you can bring that list into the script and use it for the BCC field.