Google Apps Script: createCertificates.gs

Google Slide used in this project for reference: https://docs.google.com/presentation/d/1p_UbJUK2OWdeYtZA5dcaGwPRHlPzo9hQ18RnDCYk364/edit?usp=sharing

Automated Certificate Generator & Email Sender with Google Apps Script

This project is a Google Apps Script (GAS) solution that automatically generates certificates based on a Google Slides template and a data set in Google Sheets. It then sends these generated certificates via email to the corresponding recipients.

Features

• Bulk certificate generation from Google Slide templates
• Personalization based on Google Sheet data
• Automatic email delivery of certificates
• Fully customizable and easy to extend

Usage

To use this script, follow these steps:

1. Clone/Fork this GitHub repository (optional).
2. Open your Google Drive and create a new Apps Script project.
3. Copy the contents of createCertificates.gs and capitalizeEachWord.gs into your Apps Script project.
4. Follow the additional setup instructions detailed in the script comments.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Support & Contributions

• Please ⭐️ this repository if this project helped you!
• Contributions of all kinds welcome!

Keywords

Google Apps Script, Certificate Generation, Email Sending, Google Slides, Google Sheets, Automated Certificates