spreadsheet

Creating Custom Email Lists from a Spreadsheet

Gmail is great for creating lists of email addresses for mass mailings. But, if you have dozens of students, it’s tedious to either, A) type every email into the list one by one, or B) go through the directory of thousands of students to add them to your group. I wrote up a Google Sheets template which will add emails right from the Sheet using a custom script. You put the name of the group into the input box and it does the rest. Take a look at the video below for how it works. You can jump into your...