Skip to content

Latest commit

 

History

History
6 lines (5 loc) · 803 Bytes

File metadata and controls

6 lines (5 loc) · 803 Bytes

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.