Certificate Generator from Google Sheets: Bulk Issue Guide

To generate certificates from Google Sheets, keep one row per recipient with clean name, email, course and date columns, then choose a route. A mail-merge add-on or Apps Script turns each row into a Google Slides PDF. Downloading the sheet as a CSV and bulk-issuing it in QRCertificates turns each row into a signed certificate with a QR code that opens a live public verification page.

Your roster, registrations or class list probably already live in a sheet. Here is how to turn it into certificates without retyping a name.

Can Google Sheets generate certificates on its own?

No. Sheets stores and sorts data. It has no certificate layout, no PDF output per row and no way to prove later that a certificate came from you. Every method pairs the sheet with a second tool, so prepare the sheet first:

• One row per recipient and one header row, with no merged cells or blank rows.
• Separate columns for full name, email, course or event, and completion date.
• Names exactly as they should print, because whatever sits in the cell is what prints.
• One date format down the whole column, such as 12 October 2026.
• A status column such as Passed or Attended, so you can filter to the people who qualify.

How does the Google Slides mail merge route work?

This free, do-it-yourself option suits internal recognition that nobody outside your team will check.

• Step 1: Design the certificate in Google Slides, with placeholders such as {{Name}} and {{Course}} where the data should go.
• Step 2: Install a mail-merge add-on from the Google Workspace Marketplace, such as Autocrat, or write a short Apps Script that copies the template for each row.
• Step 3: Map each placeholder to a column header and run the merge to create one PDF per row in Drive.
• Step 4: Email the PDFs through the add-on or Gmail, keeping an eye on daily sending limits for large lists.

At scale, scripts and add-ons can time out or hit quotas, and someone has to own the fixes. The output is a flat PDF, so anyone with an editor can change a name or a date. There is no record anyone outside your team can check, so verification requests land in your inbox, and a certificate sent in error cannot be withdrawn.

How do you bulk-issue verifiable certificates from a Google Sheet?

If you issue by cohort or event, this route reuses your sheet and adds proof to every certificate.

• Step 1: Filter the sheet to qualifying recipients, then choose File, Download, Comma-separated values to save the current tab as a CSV.
• Step 2: In QRCertificates, upload your own artwork or start from a template, and place fields on it with a live preview.
• Step 3: Import the CSV and map each column, such as name, email, course and date, to a field on the design.
• Step 4: Preview a few rows, including the longest name and any name with accents or non-Latin characters, then issue the batch and follow its progress in real time.
• Step 5: Deliver by branded email, with delivery tracking and one-click resend for any message that bounces.

Every certificate is cryptographically signed and carries a QR code plus a short human-readable code. Both open your public verification page, which confirms the issuer and shows whether the certificate is still valid, so an edited copy fails the check. The features page covers delivery options, and our CSV certificate guide covers file preparation.

Can certificates issue automatically when a new row is added?

Yes. If rows arrive one at a time, connect the sheet to an automation tool. In Zapier, Make or n8n, watch for new or updated rows, continue only when the status column says Passed, send the row to QRCertificates to issue, and write the certificate ID back to the sheet so it doubles as your register. Developers can call the REST API and use webhooks directly. If your rows come from a form, our Google Forms certificate guide walks through the same pattern.

Which route should an issuer choose?

The deciding question is who will rely on the certificate. If an employer, university, client or auditor needs to confirm it is real, a flat PDF from Drive cannot answer them, and a live verification page can. Issuers in India also get billing in rupees with GST invoices, plus GSTIN verification so verifiers see a confirmed issuer name. Compare plans on the pricing page.

Is there a free certificate generator for Google Sheets?

Add-ons and Apps Script cost nothing beyond Workspace. QRCertificates has a free plan, so you can issue a small test batch from your sheet and scan the QR code yourself before choosing a plan.

Do I need Apps Script or any coding?

No. The CSV route needs only Google Sheets and a browser. Zapier, Make and n8n are no-code tools if you want rows to issue automatically, and developers can use the REST API.

Can I add a working QR code to a Slides template?

You can paste a QR image, but it has nothing trustworthy to point at. A useful QR code needs a unique, signed record for each certificate and a live page that shows its current status. QRCertificates creates both for every recipient.

What if I spot a typo after the certificates are sent?

Fix the cell, re-issue a corrected certificate, then revoke the original with a reason. The old QR code will show it as revoked. See our guide to certificate revocation.

Does the same process work with an Excel file?

Yes. Any spreadsheet saved as a CSV works the same way, whether it comes from Google Sheets, Excel or LibreOffice. Our Microsoft Forms certificate guide covers the Excel workflow step by step.

Your Google Sheet already holds the list. Issue your next batch as signed, QR-verifiable certificates with a live verification page and a GST invoice for your records. Start issuing free with QRCertificates.