Yesterday Jared and I spent some time figuring out how to use Mail Merge with Gmail and Google Spreadsheets to send out automated emails and we thought we would pass this information along. These tools are a great way for teachers to easily collect and provide feedback to individual students via email. The steps are fairly easy:
- Create a Google Form/Spreadsheet with your data.
- Draft an email with fields that match your spreadsheet.
- Install the Edited with Mail Merger script in your Spreadsheet
- Send the emails to all of your students in three clicks.
Above is a YouTube video walking you through these steps. Finally, we have to give a shout-out to Alice Keeler, an edtech guru in the Central Valley, who inspired the idea and showed us how to do it through a post on her blog.
Joe & Jared