Wednesday, December 31, 2014

How to Send Emails from a Google Spreadsheet

As I do every year, I am taking this week to relax, recharge, and ski with friends. While I'm away I will be re-running the most popular posts of the year. This was the most popular post in June, 2014.

Have you ever found yourself sending strikingly similar though slightly different emails to all of your students or all of their parents at the same time? If so, you may have entered the email address, copied and pasted a message into the message, modified it slightly, then pressed send before repeating the process for the next message. That can be time consuming. Instead, save yourself a ton of time by sending emails from a Google Spreadsheet. Doing this requires adding a script to a Google Spreadsheet containing email addresses. It might sound complicated, but it really isn't. Watch the short video below from the Google Developers team to learn the process.

Applications for Education
Using this Google Spreadsheet script could be a great way to send similar though slightly customized messages to students and their parents. I might use it to send feedback to students on things that don't necessarily fit into the school's LMS.