Create-and-Send-Personalized-Certificates-using-GAS

Using standalone Google apps script on a Google sheet, Google Slide to create and send appreciation certificates automatically.

Steps

Create a Folder on your Google Drive.
Make a Copy from Certificate Slide then move it to your folder.
Make a Copy from Certificate Sheet then move it to your folder.
Create an Empty folder inside your folder.
Create a Google Apps Script inside your folder then replace the content of Code.gs with Code.gs.
Inside your Google Apps Script replace the tempFolderId with the empty folder id.
Inside your Google Apps Script replace the slideTemplateId with the Certificate Slide ID.
Inside your Google Apps Script replace the sheetId with the Certificate Sheet ID.
Add your Name, title, and team Name.
For Each Event you will only need to add your Event Name.