Moving at the Speed of Creativity

Email Mail Merge Custom PDF Certificates with autoCrat for Google

By On · Tagged With: , , , , , , · 1 Comment

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, 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..

Tagged with → • • • • • •  
Share →

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

  1. Diane Woodard says:
    March 22, 2016 at 8:05 am

    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.

Sharing from Matthews, North Carolina! Connect with Wes on Mastodon.