A simple mail merge for Google Sheets using Google Apps Script. Suggestions and improvements welcome.
Instructions:
- Open a Google Sheet with the email addresses of people you want to send a mass email to
- Click Tools > Script editor to open the Google Apps Script page
- Highlight everything (the "myFunction {" stuff) and delete it
- Go to the sendEmails.gs file in this repository and copy the whole thing.
- Paste it into your script editor. Click Save (the little floppy disk in the toolbar)
- Follow the instructions in the comments (light red text that starts with //). Note that Gmail will only let you send about 100 emails at once.
- Click Save again and click the bug button to debug your script before running it (the play button)
- Follow the instructions to authorize the app to use your Gmail account
Made at the Hacks/Hackers New Orleans hackathon for Open Data Day 2018.