Overview

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. Tell Autocrat which fields to merge via <<merge tags>> and then let Autocrat mass-generate personalized files such as Docs and Sheets.

Applications Used:

Google Forms      |      Google Sheets      |      Google Slides

---

Steps

1. Fill out the form below
2. Check your email

---

Make sure to use double angle brackets around your placeholders     
<<first>>

click here to download a copy of this template

Applications Used:

Google Forms      |      Google Sheets      |      Google Docs

---

Steps

1. Fill out the form below
2. Check your email

---

Make sure to use double angle brackets around your placeholders     
<<first>>, <<teach>>, <<timestamp>>, etc.

click here to download a copy of this template

Autocrat

To add-on Autocrat to your Google Sheets,
you must go to G Suite Marketplace and select 'install'

Click here to install AutoCrat

From inside Google Sheets, launch AutoCrat.

Click Add-ons  >  Autocrat  >  Launch

Start Job

---

Name your merge job   >  click Next

---

Choose a template   >    click Next

Personally, I like to create my template first. I will also make sure the template is the last thing I had opened as it makes it easier to find when you get to this step.

---

Map source data to template   >   Next

---

Select the file settings   >   Next

• File Name
  • use dynamic fields to personalize
• Type
  • in this case:  Slides or PDF
• Output

---

select destination folder(s)   >   Next

---

Share docs & send email

• selection your options
• Here are my settings for this demo

---

We use AutoCrat to pre-print all of the check-in forms. 

check out https://support.google.com/docs/answer/2839737?hl=en&ref_topic=6063584

check out https://support.google.com/docs/answer/7322334?hl=en&ref_topic=6063584