Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Email Each Student a Note

Email Each Student a Note

Email Each Student a Note

Send Personal Emails to All Your Students

If you have ever wanted to email an individualized note to each student, it can be tedious to compose an email per student. Use the template below to easily write a note to each student and send the note through email.



Send Comments
  1. Use the Add-ons menu to locate “Send Comments.”
    send comments
  2. In cell B2 title what the note or comment is in reference to.
  3. In addition to the personalized note, you can add an overall note that goes to each student. Write this note in cell F2.
  4. Copy and paste your student roster into column A.
  5. Copy and paste each students email address into column B.
    Suggestion: Use the File menu to make a copy of the spreadsheet to create your own template that already contains your students email addresses.
  6. Write each student an individual note or comment into column E.
  7. Since you pasted the entire roster into column A, there may be students who you do not wish to email a comment. Place an X in column C for any student who should not receive an email.

Email Each Student a Note

After setting up the spreadsheet, use the sidebar menu to click on the “Send Emails” button. This will generate an email to each student.
send emails


If you are a Google Apps for Education school (of course you are) and the script does not work, it is possible that the person who manages  your Google Apps domain has blocked 3rd party scripts. Try running it in Gmail instead of your school account to see if that solves the issue.

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

4 thoughts on “Email Each Student a Note

  1. LOVE this! Teach P.E. and will use this so often. I made a copy and inserted my comments. When the email sent, it placed “Comment on” in front of my actual comment. I changed that box to read “Good News:” but it would save it or email it. Any suggestions? Thank you!

    1. I intentionally created this to be super basic. The email it sends is a template you can not edit. (You can if you are not intimidated to edit the script by going to the Tools menu and choosing script editor.) So the bad news is that to use this script, you have to accept the emails the way they are. It is intended to be a fast way to email each student a personal note. Hopefully you have a roster of your students names and email addresses that is easy to copy and paste.

  2. So to be super explicit- I can edit the script to change pieces if i want to? I would like to remove the “Comment on” and the Roster name from the subject line… Thanks in advance for confirming this for me! I absolutely LOVE that you created this; if i can make these edits then this will be a huge time saver for when I have to email passwords and usernames out to kids and parents.

    1. To change the default email…. you need to edit my code. Go to the tools menu and choose “Script editor” and then edit the message. Not for the faint of heart.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.