Autocrat - Google Sheets Add-On
Autocrat is an Add-On in Google Sheets that lets you merge the spreadsheet data with a Google Doc, Sheet, or Slide. You can create a Google Form to gather information from a group of people (students, teachers, parents, etc.), then run Autocrat in the Google Sheet of results that merges the fields into a Google template you created. You can set it up so the Google Doc is automatically emailed to the participant when they complete the form.
Examples: Have your students/teachers complete a Google Form when they've finished a project/training. Upon submitting the Form, they receive an email with a certificate of completion congratulating them for their hard work. It's all automated using Autocrat! Great for administrators to use for teacher walkthrough feedback, too!
Step 1: Create your Google Form
Step 2: Create your Google Doc template
Step 3: Set up Autocrat in the Form's spreadsheet of responses
See the blog below for more information.
How to use Autocrat
My favorite add-on right now is Autocrat for Google Sheets. I learned about it from Amy Mayer +friEdTechnology at TCEA 2015 and Kim Es...