Automated certificate generator with Google Sheets, Slides, PDF & Gmail delivery

Automated Certificate Generator with Google Sheets, Slides, and Gmail Delivery 🎓

This workflow is designed for educators, trainers, and event organizers who want to automatically generate and send digital certificates.

It takes participant data from Google Sheets, personalizes a Google Slides certificate template, converts it into PDF, saves it in Google Drive, and emails it directly to participants using Gmail.

---

✅ Setup Instructions

1. Prepare Google Sheets - Create a sheet with these required columns: - Name → Participant’s full name - Email → Recipient email address - Score (optional) → For filtering or record keeping - Add at least one row of test data.

2. Create Google Slides Template - Design your certificate (branding, colors, etc.). - Add a placeholder [NAME] where the participant’s name should appear.

3. Set up Google Drive - Create a folder to store generated PDF certificates. - Copy the folder URL for use in the workflow.