Docs

Using CertLume

Getting started

  1. Install CertLume from the Google Workspace Marketplace.
  2. Open your Google Sheet and choose Extensions → CertLume → Open CertLume.
  3. Pick a template, check the column matches, and press Preview row 1.
  4. When the preview looks right, press Generate.

The first time, Google asks you to allow access. Here is what each permission is for.

Your sheet

Put column names in the first row and one person per row below it, for example:

NameEmailEventDate
Anjali Nairanjali@example.comAI Builders Meetup22 November 2026
മുഹമ്മദ് ഫായിസ്faiz@example.comAI Builders Meetup22 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.

Templates

Ready-made

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.

Your own

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.

Placeholders

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

Long names

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.

QR verification

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.

Email

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".

Google Forms

  1. In your Google Form, open Responses → Link to Sheets and choose your spreadsheet.
  2. In CertLume, select the responses sheet and set up the template, columns and email as usual.
  3. Switch on Make and send a document for each new response.

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.

Generating

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.

PDFs are saved in a Drive folder named "CertLume - your spreadsheet name". The sidebar links to it.

Revoking a certificate

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.

Plans and codes

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.

Troubleshooting

A placeholder stays empty in the PDF

Its column is not matched. Check the match in step 2 of the sidebar, and press Rescan if you edited the template.

The QR code is missing

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.

Fonts look different in the PDF

Use fonts from the Google Slides or Docs font menu. They are built into Google, so they print exactly as you see them.

"Limit reached"

You have used this month's documents. Upgrade, or continue next month. Finished rows are kept.

Something else

Email us with a screenshot of the sidebar and the status text from the sheet.