App Icon
Flexible, easy to use document merge tool that creates PDF or shared Documents from spreadsheet data.
Works with:
10,000,000+
Overview
Automate the creation and sharing of personalized documents with autoCrat.

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 documents.  Optionally send the documents as email attahchments.  Optionally tell Autocrat to run when new forms are submitted to created truly automated processes.

***** NEW FEATURES as of v3.1 release  08/14/2017 ********
Now you can use Google Slides as your template in Autocrat.  Merge data from Google Spreadsheets directly into a single Google Slide Presentation. 

***** NEW FEATURES as of v3.0 release  05/07/2016 ********

In response to user feedback and demand, the new version of Autocrat now has the following upgrades and new features:

 -- A single, simpler user interface.  We got rid of the sidebar.  Everything happens through the primary dialogue.
 -- More modern design/interface.
 -- Cleaner code under the hood. Hopefully you notice faster performance and more reliable triggers.
 -- Single document mode.  You can now produce a single document for a merge job.  E.g. a single doc or PDF, with each row of data that meets your job criteria merged into it.  Previously you could only create one document per row of data.  This was one of the most asked for feature requests.  (NOTE:  This only works for docs at the moment, not spreadsheets)
 -- Image merge.  You can now merge images into your docs from a publicly hosted image URL.
 -- Hyperlink merge. Easily add hyperlinks to your merged Google docs.

View the user/help guide here:  https://docs.google.com/document/d/1WTGSSlH6gwUHpipusPKLIsgfFUamDbFbJ7JaoG6-ZBo/edit#heading=h.y1q61e2vhshm
Additional information
Privacy policy
Terms of service
Autocrat will ask for the permissions shown below. Learn more
Autocrat will need access to your Google account
This will allow Autocrat to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete all of your Google Drive files
View your Google Drive apps
See, edit, create, and delete all your Google Sheets spreadsheets
Connect to an external service
Allow this application to run when you are not present
Send email as you
View and manage data associated with the application
View and manage your forms in Google Drive
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Autocrat
October 5, 2014
*****Some key updates that respond to user ratings prior to Oct 1st, 2014 The Add-on's author, Tim Cargan, was supporting it as a volunteer (while attending high school full time). As of late September, 2014 New Visions CloudLab developer Jared Carrano has taken over as lead project maintainer, with Tim continuing on an advisory capacity. As of October 3rd, 2014 the autoCrat Add-on now allows for merges to automatically trigger on Google Form submit. This feature was missing from the original release because Google released Add-ons without support for installable triggers, now possible thanks to the hard work of Google's engineers.
Is this review helpful?
Yes
No
Profile Picture
A User of Autocrat
November 8, 2016
Initially the new single document feature seemed like a great idea. It works fine with their sample template. Unfortunately it does not format our documents correctly. As a workaround we use Autocrat to create multiple pdfs and then merge them with an addon called "Mergy". If they can debug the single document feature so it works reliably I would give it four or five stars.
Is this review helpful?
Yes
No
Profile Picture
Tom Vovers - SCE JSC
December 17, 2018
AutoCrat has grown up! Very nice to use now. Easy to map fields on the document with spreadsheet columns. One suggestion. My merge contains sensitive information. The final confirmation information includes the link sent by email, however when I open the document (in this case a pdf) it does not show this sharing setting. I want to make sure that the link sent requires users to be a member of my domain.
Is this review helpful?
Yes
No
Profile Picture
Kate Fisher
May 7, 2014
Love the autocrat script, but not fully loving the add-on yet. Can't wait for form submission trigger to work.
Is this review helpful?
Yes
No
Profile Picture
A User of Autocrat
February 8, 2016
I was trying to find a way to notify a specific counselor when a student referral form was submitted through Google Forms. I searched many different options but nothing worked the way I wanted it to. I came across autoCrat and found that it served that purpose and much, much more! It's a great way to turn a form submission into a user-friendly document.
Is this review helpful?
Yes
No
Profile Picture
A User of Autocrat
January 15, 2016
When it works, it works well. However, I've had lots of times where it simply hangs when trying to save settings or run a merge. Not sure why it hangs, but it happens maybe once out of every 5 times when I'm doing a simple mail merge. I've also like to see a new feature. It would be nice to have the option of generating a combined PDF/DOC rather than individual PDF/DOCs for each data entry. This would make it easier to print everything at once.
Is this review helpful?
Yes
No
Profile Picture
A User of Autocrat
May 15, 2019
Scheduling jobs using the time or event triggers doesn't work. It is definitely not a "truly automated process". It would be a great product if they could manage to fix that but it has been broken for over a year so I am not too hopeful. Looking for something else to replace it...
Is this review helpful?
Yes
No
Profile Picture
Nora Burton
March 25, 2017
I love Autocrat! I'm a 5th grade teacher and a huge fan. The updates are FANTASTIC! I cannot thank you enough for saving me so much time. One of my favorite ways to use it is to communicate student progress with parents. BIG TIME SAVER! Great add-on!
Is this review helpful?
Yes
No
Profile Picture
A User of Autocrat
March 11, 2016
Of this kind of productivity tool, I like this app the most so far. Sometimes, it exhibits some instabilities or inconsistencies when it comes to opening the document template from the Drive, and setting up the conditions for selecting the rows also have not worked for me (which is not that criticial because one can overcome it by manually filling up the undesired rows by some dummy character), but the most important part works quite well and therefore surpasses some minor glitches.
Is this review helpful?
Yes
No
Profile Picture
Andrea Duwel
September 25, 2014
I preferred the old version, but the new version still worked. I was able to merge documents for 119 out of 120 rows in my matrix. I don't know why one row was not able to merge. There are several complaints in other reviews that individual reports cannot automatically be emailed to individual recipients. Autocrat actually does have that feature and I just used it. Where you have the option of writing email addresses, simply write $emails (or whatever the name of the column that has the email addresses is called) and each individual will be emailed their personal copy of the template. The feature is available, but the video demonstration and the written instructions to not explain it.
Is this review helpful?
Yes
No
1-10 of 920
Search
Clear search
Close search
Google apps
Main menu