Certificate generator from Google Sheets

Make a certificate for every name in a sheet (course completions, awards, attendance) as Google Slides or PDF, and email each one.

1. Design the certificate in Google Slides

Use a single landscape slide. Put tags where the details go: <<Name>>, <<Course>>, <<Date>>. Keep tags in their own text boxes so long names can be resized.

2. List recipients in a sheet

One row per certificate, with column headers matching the tags (Name, Course, Date, Email). A column like Passed lets you merge only rows where it says Yes.

3. Run the merge

Start TrustyMerge in the sheet, pick the Slides template and a folder, choose PDF, name files like <<Name>> - Certificate, add the condition, and run. Every row gets its PDF link in the sheet.

4. Send them

Turn on email to send each certificate as an attachment; replies come to you. The free plan covers 50 certificates a month; Pro covers 5,000; the School plan covers a whole Workspace domain. See pricing.