- Copy the template spreadsheet that I shared with you (File > Make a copy...) and add your section members' names and email addresses. This is now your section's template.
- Copy your section template for each set of audition feedback and name the spreadsheet with the date.
- Fill in the feedback.
- Click the "Send Emails" button.
- A popup may open stating that authorization is required, click continue and accept the permissions required by the script.
- "EMAIL_SENT" will appear in column K for each row as emails are sent. If the script encounters an error you can run it again, it will continue where it left off, not sending any duplicates.
If you have any questions about how to use this or something breaks, please let me know.
Use MailChimp's CSS inliner tool, here.