

Instead of the old version which had a panel on the right along with a pop-up window, now everything is handled in one central window. In order for the Add-ons option to appear in the top toolbar on Docs, you must first save that converted Microsoft file (ending with. Single Interface - AutoCrat now uses a modern, easy to navigate single interface window. In this tutorial I demonstrate how I use AutoCrat to merge certificates of completion for my webinars.īelow are several of the main updates in the latest version of AutoCrat:
#From google forms to google doc merge how to
Watch the video below to see a detailed walk-through of how to use version 3.0 of AutoCrat. See the rest of the blog post below for an overview of what's new in version 3.0 and watch my detailed tutorial video on how to use AutoCrat for merging. If you have experience with it, you will be excited to see all the new features. If you have never used AutoCrat before, you should absolutely try it out.

As of the time of this writing (June 2016) it has generated over 3,000 certificates for my webinars, something I never would have been able to do if it were not automated. Create a Google Document to Serve as Template.
#From google forms to google doc merge pdf
If you pass the quiz, then AutoCrat generates a PDF certificate of attendance to turn in to your school for one contact hour. Create a Google Sheet with at Least Two Rows of Information. After watching one of my 1-hour recorded webinars, you can take a short quiz to prove you watched the video. My most common use is to generate certificates of completion for the webinars I create. Learn more Smartsheet for Google Forms (formerly Smartsheet Sync Add-on) Google Workspace Marketplace> Send responses from your Google form to a new sheet in Smartsheet. You can think of it like the Google version of mail merge in Microsoft Word, but a lot more awesome!Ĭommon uses for AutoCrat include form letters, certificates, discipline reports, RTI forms, walk through documents, student schedules, and even “Madlib” stories. Smartsheet for Google Docs (formerly Smartsheet Merge Add-on for Google Docs) Google Workspace Marketplace> Leverage Smartsheet data in a Google Document merge.

If you are not familiar with AutoCrat it is tool that let’s you merge data from Google Sheets into Google Docs, PDFs, or even other Google Sheets. Update the Recipients column 1Mail Merge for Google Docs. Just this week the latest version was released bringing new features, ease of use, and better performance. Now, Google Docs does not offer you the functionality of mail merge as such. For several years AutoCrat has been one of my favorite and most used Add-ons for Google Sheets.
