How to Send Certificates from Google Sheets (2026)
"Send certificates from Google Sheets" almost always means one of two things — and the right tool depends on which. If your spreadsheet is the response sheet of a Google Form, the simplest path is CertifyAll, which issues a certificate per submission automatically. If it's a standalone list of names with no form behind it, a Sheets mail-merge add-on like Autocrat fits better — or you route the list through a form first. This guide explains both honestly so you pick the one that matches your data instead of fighting the wrong tool.
First, which Google Sheet do you have?
Every Google Form automatically stores its answers in a linked Google Sheet. So a request to "make certificates from a Sheet" splits cleanly in two:
| Your situation | Best tool | Why |
|---|---|---|
| Sheet is a Google Form's response sheet, names keep arriving | CertifyAll | Issues a certificate per submission automatically; quiz gating + Drive backup built in |
| Standalone spreadsheet, fixed list, no form | Autocrat (or import to a Form) | Mail-merges existing rows into a template in one batch |
Get this right first and the rest is easy. Pick the wrong one and you'll be wrestling a spreadsheet mail merge when a form would have done it — or vice versa.
Case A: your Sheet is a Form response sheet → use CertifyAll
This is the common case: people fill out a Google Form (a quiz, a registration, a course sign-off), their answers land in the response Sheet, and you want each of them to get a certificate. CertifyAll does exactly this, triggered by the submission rather than the row:
- Open the Google Form behind your Sheet. (From the response Sheet, it's the form that feeds it.) Enable Collect email addresses if it isn't already.
- Design the certificate in Google Slides with placeholders —
{{name}},{{date}},{{score}}— matching your form's columns. See the template guide. - Connect CertifyAll, paste the Slides URL, map placeholders to questions, and (optionally) set a passing score.
- Each response gets a certificate. As submissions arrive in the Sheet, CertifyAll emails each respondent their personalized PDF and files a copy in Drive — bulk happens naturally as the data comes in.
Case B: a standalone spreadsheet of names
If your names live in a spreadsheet that isn't tied to a form — an exported attendee list, a roster someone shared, a CSV you imported — you have two good options:
- Mail-merge with Autocrat. Autocrat is a free Google Sheets add-on that merges each row into a Docs or Slides template, exports a PDF, and emails it. It's the natural tool for a closed list. The trade-offs are a multi-step setup wizard and no quiz-score gating (it sees rows, not scores). We cover it in the pillar guide and the add-on comparison.
- Route the list through a Form. If new names will keep arriving, or you want quiz gating and Drive backup, it's often cleaner to collect them with a Google Form (paste the list into a form's pre-fill, or have people self-register) and then use CertifyAll. You trade a one-time list for an automated pipeline.
Which method to choose
| If… | Use |
|---|---|
| Names arrive via a Google Form | CertifyAll |
| You want quiz/pass gating | CertifyAll |
| You want Drive backup & retry emails | CertifyAll |
| You have a fixed, closed list and no form | Autocrat (one-time merge) |
| New names keep coming | CertifyAll (Form-fed) |
In short: if there's a form — or could be — CertifyAll is simpler and more capable. For a truly one-off closed spreadsheet, Autocrat's batch merge is the honest answer.
Frequently asked questions
Can I generate certificates from a Google Sheet?
Yes, two ways depending on the data. If the Sheet is a Google Form's response sheet, CertifyAll generates and emails a certificate per submission automatically. If it's a standalone list with no form, a mail-merge add-on like Autocrat merges each row into a template — or collect the names through a Form and use CertifyAll.
What's the easiest way to make certificates from a list of names?
Collect the names with a Google Form (or import your list into one) and connect CertifyAll: it generates a personalized PDF per response from your Slides template and emails it automatically — avoiding the multi-step spreadsheet mail merge, with quiz gating and Drive backup included.
Does CertifyAll work from a Google Sheet directly?
CertifyAll runs inside Google Forms and is triggered by submissions, not spreadsheet rows. Because every Form stores responses in a linked Sheet, certificates effectively come "from the Sheet" — but the trigger is the form. For a standalone spreadsheet with no form, use a Sheets mail-merge add-on like Autocrat, or route the list through a form first.
How do I send certificates in bulk from Google Sheets?
For data collected via a Form, CertifyAll issues a certificate per submission automatically, so bulk happens as responses arrive. For a fixed spreadsheet of existing names, Autocrat runs a one-time merge across all rows. Choose based on whether new names keep coming (Forms + CertifyAll) or you have a closed list (Autocrat).
Is there a free way to send certificates from Google Sheets data?
Yes. CertifyAll's free plan issues up to 20 certificates per month from Google Form responses, with email delivery and Drive backup. Autocrat is free for spreadsheet mail merges but needs more setup and can't gate on a quiz score. CertifyAll Pro removes the limit and watermark at $5.99/month.