Saturday was our fourth EdCampOKC conference in Oklahoma City and it was great! This year to provide professional development certificates to attendees afterward, our organizer team got fancy and used the free Google Add-On autoCrat.

autoCrat is a powerful, customizable script for Google Forms and Google Sheets which can create merged documents and then even email them to others. In this case, we used it to send customized professional development certificates to each EdCampOKC attendee who filled out our online event evaluation. This is an example of what the emailed certificates looked like, except participants received them as PDF attachments in email rather than as an image:

We used the following workflow to create these mail merged PDF certificates:

  1. Create an online survey using Google Forms. (this was ours)
  2. Create a Google Document to use as a certificate template. Use repeating brackets for places where you want to merge submitted spreadsheet data. Example: <<name>> (this was ours)
  3. Install the free autoCrat add-on for Google Sheets.
  4. On the Google Form, click to create a Google Sheet for the online form results.
  5. On the Google Sheet, from the Add-Ons menu select autoCrat.
  6. Choose your Google Document as your template file.
  7. Select the desired options for the autoCrat script, including “Run autoCrat when new forms are submitted.” You will choose to create a PDF file, save it in a specific folder in your Google Drive, add text to use as an email template (including merge fields, if desired) to send to form submitters, and identify the Google Sheet fields you want to use in your merged Google Doc.

This 13 minute video tutorial demonstrates these steps.

I want to share a BIG shout-out to my Wyoming / Montana friend, Diane Woodard (@dianewoodard), who told me how to do this in May 2015 at her Google Forms session at the WyTECC Conference in Rock Springs, Wyoming. You rock, Diane! 🙂

If you enjoyed this post and found it useful, consider subscribing to Wes' free, weekly newsletter. Generally Wes shares a new edition on Monday mornings, and it includes a TIP, a TOOL, a TEXT (article to read) and a TUTORIAL video. You can also check out past editions of Wes' newsletter online free!


Did you know Wes has published several eBooks and "eBook singles?" 1 of them is available free! Check them out! Also visit Wes' subscription-based tutorial VIDEO library supporting technology integrating teachers worldwide!

MORE WAYS TO LEARN WITH WES: Do you use a smartphone or tablet? Subscribe to Wes' free magazine "iReading" on Flipboard! Follow Dr. Wesley Fryer on Twitter (@wfryer), Facebook and Google+. Also "like" Wes' Facebook page for "Speed of Creativity Learning". Don't miss Wesley's latest technology integration project, "Show With Media: What Do You Want to CREATE Today?"

On this day..

Tagged with →  
Share →

One Response to Email Mail Merge Custom PDF Certificates with autoCrat for Google

  1. Diane Woodard says:

    Thanks Wes! Shelly’s Certificates look great! So thrilled to see that you will be in Denver in June! Hope to see you there!

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License.

Made with Love in Oklahoma City