Send personalized appreciation certificate to employees

[choraria]

Solution title: Send personalized appreciation certificate to employees

One sentence summary: Automatically customize an existing Google Slide certificate template with employee data in Google Sheets and share them using Gmail.

Description: Using the employee data from a Google Sheet and the 'Employee Certificate' template from Google Slides, we can automate the process of generating fully personalized appreciation certificates and send them as PDF attachments via Gmail in a matter of minutes.

Design Details: Manually creating customized employee certificates in Google Slides can be tiresome. Having to download, attach and send them to each individual can get equally cumbersome. Google Apps Script is the perfect tool to simplify such repetitive work and also eliminate any accidents that end-up having one employee get an appreciation certificate of another.

This setup would make use of the 'Employee Certificate' template from Google Slides and a Google Sheet with all the employee details. The script would start by making a copy of the template and replace some of the key placeholders (like Employee Name, Company name etc.) with data from the sheet. Once a slide for every employee is created, we then run another function that would extract individual slides as a PDF attachment and send it to each employee's email ID.

[choraria]

Workflow (video): https://www.youtube.com/watch?v=tLIqSn7f0VU
Blog post: https://script.gs/send-personalized-appreciation-certificate-to-employees/

[sqrrrl]

👍

Sounds good, go ahead with a PR when you're ready. Thanks!

[choraria]

@sqrrrl - done 🙂

Here's the link to the PR - #151