Перейти к содержимому

Auto-Mail Certificates in 10 Minutes

TRY IT ONCE

0:00 / 0:00

Auto-Mail Certificates in 10 Minutes

17 просмотров · 5 дней назад
TRY IT ONCE
6 подписчиков
17 просмотров · 5 дней назад
📥 Want to try it yourself? Get the complete code here: 🔗 https://bit.ly/4xOW8VE Instead of manually creating certificates, converting them to PDF and sending them one by one, this simple automation does the entire process automatically. 📊 Google Sheet stores the participant details 📄 Google Slides works as the certificate template ⚙️ Apps Script replaces the placeholders automatically 📥 Certificate is converted to PDF 📧 PDF is attached and emailed to the participant The script reads the participant's name, email, gender, department and designation from the Google Sheet, creates a copy of the certificate template, replaces the required fields, converts the certificate into PDF and sends it by email. What you will learn • Read participant details from Google Sheets • Select the required row automatically • Copy a Google Slides certificate template • Replace placeholders with participant details • Convert Google Slides to PDF • Send the PDF automatically through Gmail • Create a personalized email greeting Certificate placeholders used Full Name This is useful for training certificates, participation certificates, workshop certificates, employee programs and other similar documents. Try the automation yourself and save repetitive manual work! 🚀 Google Sheets + Google Slides + Apps Script = Simple Certificate Automation