The first time, Google asks you to allow access. Here is what each permission is for.
Put column names in the first row and one person per row below it, for example:
| Name | Event | Date | |
|---|---|---|---|
| Anjali Nair | anjali@example.com | AI Builders Meetup | 22 November 2026 |
| മുഹമ്മദ് ഫായിസ് | faiz@example.com | AI Builders Meetup | 22 November 2026 |
Values are used exactly as the sheet shows them, so a date formatted as "22 November 2026" prints that way. CertLume adds five columns at the end: Merge Status, Certificate ID, Document Link, Verify Link and Merged At. Leave them there: they are how CertLume knows which rows are finished.
Press Ready-made and choose a design. CertLume creates it as a Google Slides file in your Drive. Open it to change the wording, colours or logo. Every document uses your edited version.
Press My own file and pick a Google Slides or Google Docs file. Slides suits certificates (one slide = one page). Docs suits letters and invoices with longer text. If the template has several slides or pages, the PDF has them all.
After you change the placeholders in a template, press Rescan in the sidebar.
Type a placeholder in double curly brackets where the data should go: {{Name}}, {{Course Title}}. CertLume matches it to the column with the same name, ignoring capitals, spaces and underscores. You can change any match in the sidebar, or choose Same text for everyone to fill it with fixed text, for example your organisation's name.
Built-in placeholders:
{{CertificateID}} | The unique ID, printed like 7K2QM-9XR4T |
{{VerifyURL}} | The link to the verify page |
{{QR}} | The QR code (see below) |
{{Today}} | Today's date, like 22 November 2026 |
Ready-made templates shrink long names to fit on one line. To do the same in your own Slides template, right-click the text box → Alt text, and set the description to certlume:fit:46:24:26. That means size 46 for up to 24 characters, smaller for longer names, but never below 26.
In Slides, draw a square box and type {{QR}} in it. The QR code fills that box. In Docs, put {{QR}} on its own line. The QR code opens certs.drakenlume.com/v/<ID>, which shows:
In the sidebar under QR verification, say what each of these four lines shows. You can use placeholders there too, for example {{Name}}. If you turn verification off, documents get an ID but no public page. That suits invoices.
Turn on Email each PDF, choose the column with email addresses, and write the subject and message. Placeholders work in both, and {{VerifyURL}} becomes a link. Emails are sent from your Google account with the PDF attached, so replies come to you.
Google limits how many emails an account can send per day: about 100 recipients for a personal Gmail account and 1,500 for Google Workspace. When the limit is reached, CertLume still makes the PDFs and marks those rows "not emailed".
Each new response then gets its document (and email) within a minute or two, even when the sidebar is closed. Turn the switch off to stop.
Press Generate and keep the sidebar open. CertLume works through the rows in batches. Each row gets a status in the sheet: Done, Done · emailed, Error: … or Limit reached.
Merge Status cell and press Generate. It keeps its certificate ID and does not count again.PDFs are saved in a Drive folder named "CertLume - your spreadsheet name". The sidebar links to it.
In the sidebar, under Revoke a certificate, enter its ID and, if you like, a reason. Its verify page then says it was withdrawn. Undo revoke makes it valid again. Only the Google account that issued a certificate can revoke it.
The Your plan box shows how many documents you have made this month. To upgrade, see pricing. If you have a code (for example from AppSumo), enter it under Have a code?. Codes add to your monthly limit and can be stacked.
Its column is not matched. Check the match in step 2 of the sidebar, and press Rescan if you edited the template.
Check that QR verification is on, and that the box contains only {{QR}}, with no other text. In Slides, the box must not be inside a group.
Use fonts from the Google Slides or Docs font menu. They are built into Google, so they print exactly as you see them.
You have used this month's documents. Upgrade, or continue next month. Finished rows are kept.
Email us with a screenshot of the sidebar and the status text from the sheet.