As a high school teacher with 150+ students, it can be challenging to give personal attention to each student. I remember one time a parent calling me with a concern about her kid and I thought “he’s doing fine” but upon digging into the evidence the mom was right to call me with concern. I realized that this kid smiles at me a lot so I mistake that for him doing well, but in truth, I was not very observant about this young man.
Parents do not always read newsletters. One theory I have is that it is because it is not about their kid. This Add-on script allows me to reflect on each student and write an individual observation or note. The email/newsletter then contains something for each parent about their kid.
This template helps personal emails to parents.
Email Parents Add-On
You will need to authorize the script by clicking on ADVANCED and then the small link “Go to Email Parents” at the bottom. Then you will need to type the word “Continue.” See at the bottom for screenshots on the screenshot warning.
Create Email Message
Send Email Message
Reuse This Spreadsheet
There is no need to retype the roster of students and their parents’ email addresses. Simply reuse this same spreadsheet. Use the Add-on menu to “Start” and choose “Create Email Message” in the sidebar. This creates a new sheet, reusing the roster information you already entered.
Click on the tiny link at the bottom that says “Go to Email Parents”
This gloom and doom security warning is an over reaction to the Google Docs spoofing scam a few months ago. Google is telling you that no one at Google has looked at my code. I do not code anything malicious. You can use the Tools menu and go to Script Editor if you want to review the code.