Back to Solutions
Automation

How to Generate Certificates Based on Sheet Conditions

Smart Certificates can be used to filter rows, ensuring that only those meeting a certain condition (like a "Passed" status) receive a document.

Want to see timestamps or seek to sections? Watch on Video Portal

How to Use

  1. 1 Use a formula in Google Sheets to mark rows as "Ready" or "Passed".
  2. 2 In the add-on, select only the filtered rows for generation.
  3. 3 Trigger the merge to send documents only to the qualified recipients.

Conditional FAQ

Can I use scores?

Yes, you can use a formula like =IF(A2>80, "Pass", "Fail") to trigger certs.

Does it skip empty rows?

Yes, the tool only processes rows that you select or that contain data.

Can I automate the check?

You can manually trigger the generation after your sheet updates.