If you're not familiar with Autocrat, it's a document merge script. Pretty much, what that means is that you can have the data from any spreadsheet populated into a Doc template and saved to Drive or emailed out. What this means for me is that I can have someone fill out a Google form and have their input sent to a beautifully formatted, print-friendly document. So many uses!
If you would like to try this out for yourself, YOU CAN! You can fill out the form below to have a sample holiday mad lib automatically emailed to you! :)
- First, fill out this form: http://goo.gl/DnTN7f
- When you click submit, you will receive an email with your PDF mad lib. :)
What does it look like behind the scenes? First I created a Google Form...
Then I set up a Google Doc template using <<tags>> to match and pull information from the spreadsheet that was generated from the form data.
Then I went to the spreadsheet that was created from my form and added the Autocrat script (Tools > Script Gallery > search for Autocrat).
It's actually not as difficult as it looks. Autocrat is well-written and will walk you through the steps. Don't be afraid - just get in there and play! Here's what a completed merged document looks like:
You can see where the <<tags>> pulled my information and automatically plugged it into the template. Cool, huh?! Have you used Autocrat before? How are you using it in the classroom? I would love to hear your thoughts!