Tutorial

Learn how to create multiple certificates in Google Slides

1. Open the Google Slide you will be using as your template

Find or make a Google Slide that will be your certificate template

2. Fill the textbox for the person's name with the text "<<NAME>>"

Make sure not to include the quotation marks

3. Create a Google Sheet with the people's names

Make sure the sheet only contains the names, and they are all in the first column

4. Find and copy the ID of the Google Sheet

It can be found in the url like so: https://docs.google.com/spreadsheets/d/ID_WOULD_BE_HERE/edit

5. In the Google Slide, go to Tools -> Script Editor, and copy the code from Code.gs into the editor

You can find the code here: https://github.com/jere-mie/Certificate-Generator

6. Copy the Google Sheet ID into the appropriate spot

This should be in the "var ss" declaration located on line 15:

var ss = SpreadsheetApp.openById('ENTER_SHEETS_ID_HERE');

7. Run the script!

Simply hit the run icon (like a play icon) at the top to run the script, and it will automatically edit the template slide to include a unique certificate for each name in the Google Sheet

That's It! If you have any questions or issues, email jeremie@bornais.ca

In the future, I plan on releasing this as both a standalone addon for Google Slides, as well as a web app that can be run by anyone from a convenient site.

Google Sites

Report abuse