Moving at the Speed of Creativity by Wesley Fryer

Email Mail Merge Custom PDF Certificates with autoCrat for Google

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 for Google Sheets by Wesley Fryer, on Flickr
autoCrat for Google Sheets” (CC BY 2.0) by  Wesley Fryer 

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:

Example EdCampOKC Certificate by Wesley Fryer, on Flickr
Example EdCampOKC Certificate” (CC BY 2.0) by  Wesley Fryer 

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, subscribe to Wes’ free newsletter. Check out Wes’ video tutorial library, “Playing with Media.” Information about more ways to learn with Dr. Wesley Fryer are available on wesfryer.com/after.

On this day..


Posted

in

,

by

Comments

One response to “Email Mail Merge Custom PDF Certificates with autoCrat for Google”

  1. Diane Woodard Avatar
    Diane Woodard

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