A Tutorial on How to Generate E-Certificates after Accomplishing the Google Form

Some people are more comfortable using YouTube videos for this tutorial, but if you are like me, I prefer reading instructions. So, this post is A Tutorial on How to Generate E-Certificates after Accomplishing the Google Form.

Honestly, I am always amazed that after accomplishing evaluation sheets using Google Forms, I can instantly get my e-certificates for the webinars I attended.

And, when we were holding our webinars, I tried learning how to do it, and let me share with you the easy steps I followed on How to Generate E-Certificates.

Step 1. Create your E-Certificate Layout

You may use Canva to create the layout of your certificate. You should finalize your design and proceed to Step 2.

Step 2. Upload your E-Certificate design to Google Slides.

Make sure to fix the size of your layout to the size of the slide. This will be the final e-certificate layout, so consider that in adjusting the borders.

Step 3. Put the << TAGS >>

Here is an example of how I did it:

Add TEXT BOX and stretch the length of the box up to the end of the line below the tags. These tags generate the name, and there are participants with long names.

Previously, I experienced requests from the participants to re-generating their e-certs because their names have overlapping characters or the fonts are too small. These << >> in the image above are examples of how the text for the names will be written and how the textbox will determine the length it can accommodate. Just do the estimates.

Step 4. Create your Google Form

* Make sure you use the same Google Account for your Google Slides and Forms. If you’re not, merging cannot happen.

In your Google Form, set a Short Answer Box where they will type in their names (the texts appearing in the e-certificate). Moreover, if you want an automated sending of e-certs to their emails, ensure that the Google Form will be COLLECTING email addresses in the settings.

STEP 5. Set up Autocrat for merging of forms.

In your Google Form, click the RESPONSES and then generate the EXCEL SHEET for the RESPONSES.

Click on EXTENSIONS, and in the Drop down; you’ll see AUTOCRAT; hover your mouse and click LAUNCH. Name your MERGE JOB:

Locate the layout you have created in the Google Slide.

**Map your << >> to the column in the RESPONSES on the instruction you provided in the form where they will write their NAMES.**

In this 4th Step, you can use the << >> for the FILES NAME so that each certificate generated is their FULL NAME. Next, I prefer a PDF certificate instead of Google Slide output and Single Output for individual sending of the e-certs.

All certificates sent to their emails will also be generated for you, and in this Step, you create the FOLDER, where the e-certificates will be saved.

You may skip the 6th and 7th steps; in Step 8, click YES for SHARE DOC to get a copy of the sent certificates. Share doc as PDF. Do not allow collaborators; if you want to hide your email creating these e-certificates, set it to NO-REPLY ADDRESS.

Drag DOWN.

Set where you will be sending their certificates in TO:

By the way, this blue arrow on the left is where you can copy the tags representing the columns in the RESPONSES sheet. So, when they accomplish the Google Form with their email address, this << email address >> column is generated.