NOTE: This tool can only be installed from the OLD Google Sheets. If you have converted to the new Google Sheets and would still like to install autoCrat, please make a copy of this (old) Google Sheet and navigate to Tools -> Script Gallery and search for the script. If you would like to try the autoCrat Add-on for the NEW sheets, click here. Beware that the new autoCrat Add-on does not have form-triggered capability at this time.
The autoCrat script enables you to automate the creation of personalized documents and emails from the cloud. The script is a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents. The user first creates a template Google Doc. autoCrat can then populate the template document with data from a Google Spreadsheet.
Join the Apps Script for Edu Community!
If you have any questions about using autoCrat, or to share out successes you've had in using it, please join the Apps Scripts for Education - Builders and Users Google Plus community!
Using the formula copy down feature - available on both autoCrat and formMule