Autocrat is a multi-purpose document merge tool that allows you to take data from a spreadsheet and merge it into a document via a template. You will have the option to send the documents as email attachments. Knowing how to mail merge is useful for creating rubrics, report cards, certificates, and classroom-related letters and documents in bulk. You can even use Autocrat to generate MadLibs!

Before Autocrat can mass-generate personalized documents, you will need to tell Autocrat which fields to merge via <<merge tags>>. You can create Auotocrat templates using either Google Docs or Google Slides.

In our first example, I am going to use Autocrat to create student login cards using sheet data. You'll get a look at how to configure Autocrat to create the desired end product and a summary of the different options you have when configuring a job. Finally, you'll see how to easliy run the job when created and what the finished product looks like.

In this example, I use Sheets to grade student projects and then use Autocrat to generate a rubric for each student with the inputted data. During this tutorial you'll also see how to configure Auotcrat to merge documents based on a specified condition and automatically share the merged document with each student.

For our final scenario, I have a Google Form that community members use to reserve tickets for the school musical. When a person submits the form, I want that person to receive an email instantly that includes a ticket to the event and other important event details.

In this tutorial, we are going to take a look at how to configure Autocrat to create a truly streamlined process by setting a trigger that tells Autocrat to create and share a document each time a new form is submitted. Once you know how to do this, you will be able to do things like send certificates upon successful completion of a quiz, create MadLib activities, and generate other automated documents.