Help & Support
Send Feedback
autoCrat
Flexible, easy to use document merge tool that creates PDF or shared Documents from spreadsheet data.
New Visions CloudLab
2,277,082 users
Works with
Install
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.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.
 -- New Robot!  The autoCrat robot got a major redesign thanks to the immensely talented Måns Swanberg (mansswanberg.com)


View the user/help guide here:  https://docs.google.com/document/d/1WTGSSlH6gwUHpipusPKLIsgfFUamDbFbJ7JaoG6-ZBo/edit#heading=h.y1q61e2vhshm


Reviews
April 3, 2017
Feature request: launch the google doc created after it is created by autocrat.
Submit reply
Cancel
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!
Submit reply
Cancel
March 24, 2017
Cannot access google drive. Sucks.
Submit reply
Cancel
March 17, 2017
I love this add-on, it saves me SO. MUCH. TIME. I am running into some struggles though which is why I cannot give it 5 stars. I have it set up to run every hour and it will do great then all of a sudden, stop so I feel like it isn't as time-saving as it could be because I have to babysit it.
Submit reply
Cancel
March 4, 2017
My use case is a Google Sheet with embedded form which club members use to fill out an event entry form. Autocrat is then used to format their input into a Google Doc which is emailed to them as a PDF attachment. For various reasons they need to print and sign the form and hand it in at the event. The email is also copied to our events secretary for their records. Being new to Autocrat I don't have version 2 baggage and so my comments are as a first time user of version 3.0.0. beta. The main difficulty I encountered was with <<tag>> expansion. Because I'm using a form, the sheet headings are taken from the question, so for example, if your question in the form is labelled "Email Address" then that will be the column heading in the sheet. If in your document template you set a tag <<email>> you can map the column heading to the tag in the job set-up. But - if you try to use that <<tag>> anywhere other than in the document (say in the document filename or in the email address lines, subject or body) it will NOT be expanded. After nearly giving up on Autocrat and trying a different plug-in, I went back to Autocrat and changed my tags - so instead of using <<email>>, I used <<Email Address>> - that is, I used EXACTLY the same text in the tag as the sheet. And my <<tag>> expansion in the email now works. My expectation was a mapped <<tag>> should work anywhere, so I think this is a bug or "undocumented feature" but there is a simple work-around once you know it. Second - if you modify your form structure and save it, under some circumstances Autocrat deletes the existing merge job, so you have to build it again. Not too much of a problem EXCEPT it wipes out your email template as well, and that can be a hassle to rebuild if you haven't saved a copy of it somewhere else. Again, once you know about this, you can work around it by building your email template separately and then pasting the material into the fields, but it would be good if Autocrat let you save and re-use the email template you build in the interface. Notwithstanding the above, I'm impressed - I was not looking forward to trying to develop my own code to do this job, and I can see other potential uses for this plug-in.
Submit reply
Cancel
February 25, 2017
Aws/ome for what I need!
Submit reply
Cancel
February 20, 2017
Over all great product, but the speed at which is merges is slower that everything else out there. Did a test run of 36 entries and it took many minutes for it to complete in singe PDF mode or merged PDF. I have a list of about 10,000 I needed to merge. This wont work for you till they get the speeds much-much higher.
Submit reply
Cancel
February 10, 2017
Occasionally buggy, but I'm happy to put up with it because of the number of hours this has saved me and my team. Truly transformative.
Submit reply
Cancel
February 2, 2017
Looks very helpful, but I have a question. How specifically can you merge publicly hosted images into the document?
Submit reply
Cancel
February 1, 2017
Looking for a way to eliminate empty lines where data does not exist. Example, John Doe 123 Main Street <<address line 2>> Dallas Tx 12345
Submit reply
Cancel
1-10 of 102
Additional information
Version
309
Updated
August 30, 2016
Search
Clear search
Close search
Google apps
Main menu