AutoCrat is another add-on for Google Sheets that is changing the face of education. At first glance, it might not seem like that interesting of a tool, but its many applications make this a super valuable add-on! AutoCrat is another neat invention of CloudLab, one of the leading innovators in the add-ons for Education developer space. AutoCrat is an add-on that allows you to merge information from your spreadsheets into other formats, like documents or PDFs. It has a simple user interface that makes formatting, storing, and sharing information a breeze.
Who is using Autocrat?
Anyone who uses Google Sheets has access to AutoCrat. It is a free merge tool that is available in the add-ons store. Although AutoCrat was designed for teachers and administrators, just about anyone can use it to automate processes. It is also loved by students, researchers, and businesses.
What can you do with AutoCrat?
With AutoCrat, you can take information stored in spreadsheets and easily convert it into a Google Docs, PDF, or even a slideshow!
It sounds simple, but many people are taking this tool and using it to enhance their workflows so they can free up time for more important tasks.
How can you access AutoCrat?
It is really simple to get add-ons for Sheets. The fastest way is to click this link to install the Autocrat add-on from the Google Workspace Marketplace.
Simply click the Install button and the add-on will be added to your Google Sheets account.
Alternatively, you can get the add-on by following these steps:
- Open a spreadsheet.
- Click the Add-ons button in the navigation menu.
- Click the Get add-ons button.
- A window will pop up for you to browse.
- Type ‘Autocrat’ in the search box.
- Click the Install button to get the add-on.
You are ready to start using AutoCrat!
First, click Add-ons → AutoCrat → Open
Click New Job, then you will be prompted to give your first merge job a name!
After naming the job, click Next.
In this step, you will need to choose a template for your merge. Today we will choose to have AutoCrat create an example template for us. When you create your own templates, you can save them to and select them from your drive.
In the past, AutoCrat only worked with Google Docs, but now it also integrates with Google Slides. This is really exciting for users who want to create custom presentations from within spreadsheets.
In this step, you need to map the source data from the spreadsheet to its correct place in the template. You can choose from standard text, hyperlinks, or images.
You will need to create a corresponding tag for each area of the Doc or Slide you want the information to be populated into.
Next, give a file name for the output document that the add-on will create.
Select a folder in your Google Drive that the document will be inserted into.
(Optional) Choose a folder reference.
(Optional) Set conditional rules for your merge.
For example, if you are sending out a letter about grades from a student roster, you may choose to only send out letters to students who are receiving failing grades within the course.
Next, we will select editing/commenting and sharing settings for our merge.
After that, send out any emails to anyone we may want to share the Doc or Slideshow with.
For the last step of the merge set-up, we have the option to choose if we want this merge to run based on any specific triggers like a form submission or at a designated time interval.
Some users can fully automate certain processes using these triggers. For example, you can have students submit essay questions via Google Forms, and their answers will populate into a Google Sheet. Reading these answers within a sheet cell could obviously be quite cumbersome!
You can set a trigger so that the students submissions are merged right into a PDF or Doc, that go into a specific class folder. Use automatically generated Docs too for grading, commenting, or even peer review! After specifying triggers, press Save.
Finally, click the play button symbol to start the merging sequence.
You will see your Google Sheet change a bit—now there will be a cell with a link to the Doc that was created for this demo.
Ok—that does it! Your first AutoCrat merge has been set up, and will now be displayed as an existing job when you run the add-on.
For inspiration and ideas, check out our list of the top 5 Google Sheets add ons for education. Alternatively, take a look at the related articles below.
Editor’s note: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.