1. Create master template Google document that includes the mail merge tags: << >>
2. Create Google Form for entering the information that will be merged.
3. Install and run the script on the response spreadsheet.
For teachers, sports teams, clubs, and administrators, Autocrat can be used to create and send certificates as needed. With just a few minutes of set-up, you can have a method for quickly generating certificates and have a record of all items organized on a spreadsheet.
Think of all the ways you could use this to promote positive interactions and recognize accomplishments!
- Perfect Attendance
- Honor Roll Certificate
- Free Homework Pass
- Athlete of the Week
- Student of the Week
I created a screencast demonstrating the process for certificate creation.