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.

http://ift.tt/1sAvH3C
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.

This post originally appeared on Free Technology for Teachers if you see it elsewhere, it has been used without permission.

from Free Technology for Teachers http://ift.tt/1B4Aoow
via IFTTT

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s