Automated Certificate Generator with Google Sheets, Slides, PDF & Gmail Delivery

Description

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

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.

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

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

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.

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.