A certificate generator is only useful if it handles the version of the problem you actually have: not one certificate, but a whole list of them. This workflow turns a Google Sheet of recipients into a folder of finished, personalized PDF certificates. Design the certificate once, and never open a design tool for it again.
What people generate with it
The sheet is the source of truth
Each row renders one certificate. Click through the rows to see the mapping:
| AName | BCourse | CCompleted | DScore | |
|---|---|---|---|---|
| 1 | Alexandrina Konstantinopoulos | Data Analytics 101 | July 2, 2026 | 94% |
| 2 | Li Wei | Data Analytics 101 | July 2, 2026 | 88% |
| 3 | Sam Carter | Data Analytics 101 | July 3, 2026 | 91% |
Rendered from row 1, one per row
Add ten more rows next week, run the workflow again, and only the new certificates render.
Why this beats mail merge
Word mail merge can stamp names onto a page, but it breaks the moment the design matters: fonts render differently, layouts shift with long names, and images degrade. Orshot renders each certificate from a real design template, so a name like "Alexandrina Konstantinopoulos" fits the same layout as "Li Wei" thanks to automatic text fitting. Your logo, brand fonts, and colors stay exact on every certificate.
Set it up once, use it every cohort
Connect the sheet, map the columns, and save the workflow. From then on, issuing certificates for a new batch means updating the spreadsheet, which someone on your team was doing anyway. You can also run it on a schedule, or automatically whenever a new row appears.
