Teachers who regularly collect information via forms or use forms to create online rubrics can send students emails directly from the spreadsheet with a script called FormEmailer. The screencast below demos how to install and use FormEmailer.
Just remember you always want to collect the student’s:
- Email address
You will also want to add a column titled “Feedback” or “Comments.” This is where you will record specific feedback you want to send in the email to students.
Quick Tip: If you want to process many emails, input the number of the line you want to start with, followed by an asterisk (i.e. 15*) and FormEmailer will process from that line to the end.
I hope this saves other teachers as much time as it has saved me! Please feel free to share your favorite script and any resources that helped you to use it!