Google Apps Script: DriveApp, PropertiesService, SpreadsheetApp, GmailApp, SlidesApp. Google Slides, Google Sheets.
Have you ever wondered how people create certificates en mass and send them out automatically? You are in the right place.
In this tutorial, we are going to:
- Create Certificates of Attendance for multiple attendees using Google Slides and a list of attendees in Google Sheets.
- Send those certificates as an attached PDF to the attendees.
We’ll set it up so it is super user-friendly with a handy menu in your Google Slide template so that all you have to do is to update your Google Sheet of names each time you run the course and then click a few buttons.
Also, we will run an example so you can see how it all works and what you need to do to set it up.
For the coders out there, I think I have documented the Google Apps Script code enough for you to figure out how to quickly implement your own project. However, I have also added a smalls discussion of some parts of the code at the end.
This is a standalone tutorial. However, it draws from two main tutorials if you want to explore those first (Though it is not essential):
- Google Apps Script: Create multiple versions of a document based on Google Sheet Data and a Google Doc Template (Mail Merge)
- Create a Student Certificate of Attendance with Google Slides and Export it as a PDF or Print it
Let’s get cracking.