How to automate course certificate generation
If you run training, courses, workshops, or webinars, your attendees expect a personalized certificate. Doing 300 by hand is a nightmare. Here's how to ship them in 5 minutes.
The setup (one-time, 20 minutes)
1. Build your certificate template
Use the built-in Certificate of completion template (free) or Diploma (Pro, more formal). Customize in Google Docs with:
- Your organization's logo (top center)
- Serif font like Garamond for the recipient name
- Decorative border (Insert → Drawing → Shape with stroke)
- Instructor signature image
- Your colors
2. Add a unique certificate ID
So recipients can verify authenticity, include {{CertificateID}}. In your sheet, use:
=CONCATENATE("CERT-2026-", TEXT(ROW()-1, "0000"))
Produces CERT-2026-0001, 0002, etc.
3. Set up your attendees sheet
Columns: Recipient | Email | Course | Hours | Date | Instructor | Organization | CertificateID
Import from your LMS, Eventbrite, Teachable, or wherever your attendees come from (CSV import works great).
The workflow (5 minutes)
- Add or import your attendees list
- Open the sidebar, pick the template, click Generate
- (Pro plan) Auto-email each certificate to attendees
Bonus: distinguish levels of achievement
If you have pass/distinction/highest distinction tiers, use smart templates (Starter+):
{% if Score >= 95 %}with highest distinction
{% else %}{% if Score >= 85 %}with distinction
{% else %}{% if Score >= 70 %}with merit
{% endif %}{% endif %}{% endif %}
Bonus: LinkedIn-friendly share links
On Pro+, every certificate gets a public share URL like pdf.sheet-to-pdf.com/abc123. Email this to attendees with a suggested caption:
I just completed {{Course}} at {{Organization}}.
View my certificate: pdf.sheet-to-pdf.com/{{ShareHash}}
Attendees post it on LinkedIn. That's free marketing for your training program.
Verification system
If someone later wants to verify a certificate, you can look up the CertificateID in your sheet. For more formal verification, build a simple page at yourdomain.com/verify?id=CERT-2026-0001 that returns "Valid — issued to Sarah Chen on May 30, 2026".
Cost analysis
300 certificates per cohort:
- Manual: 5 minutes × 300 = 25 hours. At €30/hour = €750.
- Sheet to PDF Starter (€5/mo): setup once, 5 minutes per cohort. Saves €745 the first cohort.