How to Create Certificates From Google Forms (Pass-Only Quizzes)

By CertificateJoy Team · Published

Google Forms can grade a quiz, but it can't decide who gets a certificate. Link responses to a Sheet, add one formula to convert the raw score to a percentage and a second to label each row Pass or Fail, export only the Pass rows as a CSV, then upload that file to a free bulk certificate generator. The whole path is free, needs no add-on installs, and never leaves your browser.

Google Forms will happily grade a quiz. What it won’t do is decide, on its own, who’s earned a certificate for passing it. Turn on quiz mode, set an answer key, and every response gets a score like 24/30. That’s it. There’s no setting anywhere in Forms for “only send a certificate to people who scored at least 80%” — that logic doesn’t exist in the product, and it’s the reason a search for this problem turns up a pile of Zapier tutorials, paid Google Workspace add-ons, and automation platforms instead of a single toggle.

You don’t need any of those to solve it. This guide covers the actual landscape — what a native Forms setup gives you, three ways other people plug that gap, and the one that costs nothing and never requires you to hand a third-party company access to your Gmail or your quiz data. Then it walks through the exact Sheets formulas and the bulk-issuing step, end to end.

The whole path runs on tools you already have open: Google Forms, Google Sheets, and a browser-based bulk certificate generator.

Key takeaways

  • Google Forms has no native pass/fail certificate gate. Quiz mode grades and stores a raw score; deciding who “passed” and acting on that is left entirely to you.
  • The raw Score column is a fraction, not a percentage. 24/30 needs one formula before you can compare it to a threshold or sort by it meaningfully.
  • A second formula does the actual gating. One IF formula against your threshold turns every row into a clean Pass or Fail label you can filter on.
  • Google Sheets excludes filtered-out rows from CSV exports. Hide the Fail rows with a filter, download as CSV, and you already have a passers-only file — no extra tab required.
  • You don’t need an add-on for batch issuing. Add-ons like Certify’em or CertifyForms are built for instant, per-submission emailing. If issuing once a cohort closes is fine, a free bulk generator does the same job with no install.
  • Files-in-the-browser tools are the more private option for a spreadsheet that contains names and scores, since nothing gets uploaded to a third-party server in the first place.

Why Google Forms won’t gate certificates for you

Quiz mode in Forms is a grading feature, not a credentialing feature. Turn it on, add an answer key with points per question, and every submission gets scored automatically the moment it comes in. That part works well and needs no workaround.

What quiz mode does not do is act on that score. There’s no field in Forms settings for a passing threshold, no option to route high scorers one way and low scorers another, and no certificate output of any kind — Forms was never built to issue documents. The response sheet Google creates for you typically shows the score as a fraction like 24/30 in a column literally titled “Score,” and that’s where its job ends.

That gap is exactly why the search results for this problem are dominated by third-party tools instead of a Google help article: Certifier documents connecting Google Forms to its platform through a linked Sheet, several Google Workspace add-ons exist purely to add the missing pass/fail logic, and spreadsheet blogs walk through the formulas needed just to get a usable percentage out of that Score column.

Google Forms already does the grading. Everything after that is a spreadsheet formula and a free export tool.

Four ways issuers solve “only certify who passed”

Before building anything, it’s worth knowing the actual field of options, because each one trades off differently on cost, setup effort, and what happens to your recipients’ data.

Google Workspace add-ons. Tools like Certify’em, CertifyForms, SEAL, and CertifyAll install directly into your Form or Sheet and email a certificate the instant someone passes, built from a Google Slides template. Certify’em specifically requires an email-address question to appear first in the form so it knows where to send the result. The convenience is real, but you’re granting a third-party add-on access to your form, your Gmail send permissions, and your respondents’ data, and some of these tools have paid tiers past a certain volume.

Automation platforms plus a credential tool. Certifier documents integrations with Zapier, Make, and Pipedream, all routed through a linked Sheet that triggers credential issuance on every new row. This is the most flexible path — you get real hosted verification pages and automatic delivery — but it stitches together three separate accounts (Forms, the automation platform, and the credential platform), and most of those platforms’ free tiers run out fast once a cohort is more than a handful of people.

Mail-merge add-ons. Autocrat is a free Sheets add-on that merges spreadsheet rows into a Google Docs or Slides template and can email the result automatically. It’s a longtime favorite in schools specifically for certificates. It stays inside your own Google account rather than a third-party SaaS product, but it still requires an install, Drive and Gmail permissions, and template setup in Slides, and it has no built-in verification or QR code.

Sheets formulas plus a free bulk generator. No install, no OAuth grant to anyone, no subscription. You add two formulas to the response sheet, export just the rows that passed, and upload that file to a browser-based bulk certificate generator. You give up instant per-submission emailing — this is a batch step you run once a cohort or quiz window closes — but it’s free, keeps the spreadsheet in your own hands the entire time, and is the fastest path if you don’t already have a Workspace add-on or automation subscription in place.

"Verification page" means a public record a recruiter or registrar can check without emailing you directly.

The rest of this guide walks through the last row in detail, since it’s the one that needs the most explaining and the least trust in a third party.

The manual method, step by step

The formulas in step 3 are the only part that isn't click-and-done. They're spelled out below.

1. Turn on quiz mode and add an answer key

In your form, open Settings → Quizzes and enable “Make this a quiz.” Then open each graded question, choose Answer key, mark the correct answer, and assign it a point value. A question left ungraded won’t count toward the score, which is fine for optional or reflective questions but changes your denominator, so decide deliberately which questions carry points.

If you need every respondent to be identifiable in the certificate, also require an email address or name field, since Forms won’t add one for you by default the way some certificate add-ons do.

From the Responses tab, click the green Sheets icon and choose Create a new spreadsheet (or select an existing one). Every future submission now lands as a new row automatically, and Google typically adds a Score column showing the raw result as a fraction, such as 24/30.

Don’t manually edit existing rows or columns in this response sheet — treat it as a raw data feed and do your formula work in additional columns, or better, on a separate tab that references it.

3. Add a percentage formula and a Pass/Fail formula

The Score column is a text fraction, not a number you can compare against a threshold. Insert a new column next to it and convert it first. If your score sits in column B, one reliable formula is:

=INDEX(SPLIT(B2,"/"),1)/INDEX(SPLIT(B2,"/"),2)

Format that column as a percentage (Format → Number → Percent). This splits the fraction on the slash and divides the two halves — it’s one of a few equivalent patterns for this exact conversion, documented alongside REGEXREPLACE and LEFT/SEARCH alternatives if you’d rather avoid SPLIT.

Next, add a second column that turns the percentage into a decision. With your percentage in column C and a 70% threshold:

=IF(C2>=0.7,"Pass","Fail")

Adjust 0.7 to whatever passing bar your program actually uses. To have both formulas fill in automatically as new responses arrive, wrap each in an ArrayFormula in row 1 instead of copying the formula down manually every time someone submits.

4. Export only the people who passed

You have two easy options here, and neither needs a new tab or a script.

Filter in place. Select your data range, click Data → Create a filter, then use the filter dropdown on your Pass/Fail column to show only “Pass.” Google Sheets excludes rows hidden by a filter from File → Download → Comma Separated Values (.csv), so the exported file already contains only the people who passed.

Or pull a clean copy with FILTER(). On a new tab, reference the source sheet and condition:

=FILTER('Form Responses 1'!A1:E, 'Form Responses 1'!D1:D="Pass")

This is the better option if you want to keep the full response history untouched on its original tab while working from a separate, always-current passers list. Either way, end up with a sheet that has one row per passer and clear column headers — name, and whatever else your certificate needs.

5. Bulk-generate certificates from the passers file

Save your passers sheet as a CSV (or keep it as an XLSX/XLS — both work) and upload it to a free bulk certificate generator. Map your name column to Recipient name, which is the only required field; course, issue date, and certificate ID are optional and fall back to whatever default you set on the tool if your spreadsheet doesn’t include them.

A few things worth knowing about this step specifically:

  • It handles up to 100 rows in a single export, which comfortably covers most single-quiz cohorts.
  • Everything runs in your browser. Your quiz roster, including names and scores, is never uploaded to or stored on a server.
  • Preview a couple of rows before generating the full batch — the same rule that applies to any bulk certificate issue applies here: a bad column mapping repeats itself across every certificate, not just one.
  • Pick your design, confirm the wording matches what you actually measured (see the next section on thresholds before calling something “certified”), and download a ZIP of personalized PDFs.
The two formulas in step 3 are what turns the left side into the right side.

Setting your pass threshold (and what to do with close scores)

Decide your threshold before the quiz opens, not after you see the results. Picking 70% because the first cohort’s average happened to land at 71% is how a “pass” stops meaning anything.

Threshold Typical use
100% Compliance or safety quizzes where partial understanding isn’t acceptable
80% Course knowledge checks meant to confirm someone paid attention, not gatekeep
70% Common academic default; pairs well with allowing one retake
60% Long or optional enrichment quizzes where you’d rather reward engagement than filter hard

Two edge cases are worth planning for before your first cohort hits them:

  • Retakes. If your form allows multiple submissions per person, decide whether you’ll certify on the best attempt or the latest one, and filter your Sheet accordingly before exporting. Otherwise the same person can show up twice in your passers file with two different outcomes.
  • Close misses. Someone who scores 68% against a 70% threshold did real work and might reasonably expect some acknowledgment. A pattern that keeps that fair without diluting the credential: issue a Certificate of Achievement to anyone who cleared the threshold, and a separate Certificate of Participation to anyone who completed the quiz but didn’t. Run steps 3 and 4 twice with two different Pass/Fail formulas — one at your real threshold, one at a lower “attempted” bar — to build both lists.

Common mistakes

  • Filtering by score instead of the percentage. A raw 24/30 and a raw 18/25 look similar sorted as text but are 80% and 72% respectively. Always filter on the percentage or Pass/Fail column, never the raw Score text.
  • Forgetting the header row when exporting. A FILTER() formula that starts at row 2 won’t carry your column headers into the export tab; add them back manually or your bulk generator’s column mapping step will have nothing to match against.
  • Changing the threshold after some certificates are already out. If you tighten or loosen the bar mid-cohort, some people end up certified under a rule others didn’t get. Lock the threshold before the quiz opens and change it only for the next quiz, not retroactively.
  • Mapping the email column where the name column belongs. It’s an easy mix-up when your form collects email first (a common Certify’em-style requirement) — double-check the mapping preview before generating the full batch.
  • Treating “certified” and “completed” as interchangeable in the wording. A quiz that people passed supports achievement language; a quiz everyone was simply required to take, regardless of score, only supports completion language. See our guide to certificate wording examples if you’re unsure which claim your data actually backs up.

How CertificateJoy fits in

CertificateJoy’s free bulk certificate generator is built for exactly the last mile of this workflow: take a spreadsheet you’ve already cleaned and filtered, map its columns to a certificate design, and download personalized PDFs for everyone in it, without an account and without your data leaving your browser.

If you outgrow the batch-export step and want every certificate emailed automatically with its own hosted verification page and QR code the moment someone passes, that’s the workspace CertificateJoy is building next. Get started with CertificateJoy to be part of early access, or keep using the free tool on its own for as long as a manual batch step fits how you run your quizzes.

FAQ

Can Google Forms automatically send a certificate only to people who pass a quiz? Not on its own. Google Forms quiz mode will grade responses and show a raw score like 24/30, but it has no built-in setting for withholding a certificate from anyone who scores below a threshold. You either add a Sheets formula to filter passers yourself, or install a third-party Google Workspace add-on that adds that logic.

How do I turn a Google Forms quiz score into a percentage in Sheets? If your Score column shows fractions like 24/30, use =INDEX(SPLIT(B2,"/"),1)/INDEX(SPLIT(B2,"/"),2) and format the result as a percentage. Copy the formula down the column, or wrap it in an ArrayFormula so it fills in automatically as new responses arrive.

What’s the easiest way to bulk-generate certificates from a filtered Google Sheet? Filter or export just the rows that passed, save that as a CSV with a name column and any other fields your certificate needs, then upload it to a bulk certificate generator. Map the columns, preview a sample, and download a ZIP of personalized PDFs in one pass.

Do I need Zapier, Make, or an add-on to issue Google Forms certificates? Only if you want a certificate emailed the instant someone submits the quiz. If issuing once per cohort or once a quiz window closes is fine, Sheets formulas plus a free bulk generator get you there with no third-party account, no OAuth permissions granted to another company, and no subscription.

Is it safe to upload a spreadsheet of quiz results to a certificate generator? Check the specific tool’s privacy claims before uploading anything with personal data. CertificateJoy’s free bulk certificate generator processes your file entirely in your browser; the spreadsheet is never uploaded to or stored on a server, which matters more here than with a generic design tool since a quiz roster can include names and scores.

Can I issue a different certificate to people who almost passed? Yes, and it often reduces support emails from people who missed the cutoff by a point or two. A common pattern is two tiers: a Certificate of Achievement for anyone who met the pass threshold, and a Certificate of Participation for anyone who completed the quiz but didn’t reach it. Run the same formula-and-filter workflow twice with different thresholds.

Sources and methodology

This guide draws on documentation and product pages checked in September 2026:

Third-party pricing, feature availability, and free-tier limits change frequently — verify current terms directly with each provider before relying on them. This article was last reviewed on September 27, 2026.