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! 🙂

Did you know Wes has published several eBooks and "eBook singles?" 1 of them is available free! Check them out!

Do you use a smartphone or tablet? Subscribe to Wes' free magazine "iReading" on Flipboard!

If you're trying to listen to a podcast episode and it's not working, check this status page. (Wes is migrating his podcasts to Amazon S3 for hosting.) Remember to follow Wesley Fryer on Twitter (@wfryer), Facebook and Google+. Also "like" Wesley's Facebook pages for "Speed of Creativity Learning" and his eBook, "Playing with Media." Don't miss Wesley's latest technology integration project, "Mapping Media to the Curriculum."

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