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.
4. **Connect Google Services in n8n**
- Add credentials for **Google Sheets, Google Slides, Google Drive, and Gmail**.
- Replace placeholders (`Sheet ID`, `Slides template ID`, `Destination folder ID`) in the workflow.
5. **Customize Gmail Delivery**
- Update the subject and body of the Gmail node.
- The certificate PDF will be automatically attached to each email.
---
#### 🎨 Customization Options
- **Certificate Design**: Modify your Slides template (logos, colors, extra fields).
- **Dynamic Fields**: Add placeholders like `[COURSE]` or `[DATE]` and map them from your sheet.
- **Email Body**: Personalize with variables such as `{{$json["Name"]}}`.
- **File Naming**: Adjust file naming in the "Copy File" and "Download File" nodes.
---
This template streamlines certificate distribution, making it ideal for **schools, universities, training programs, and webinars**.