Skip to content

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

License

Notifications You must be signed in to change notification settings

ryanrwatkins/Google-Sheet-Event-Reminder-Emails

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 

Repository files navigation

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.

About

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

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published