How to Create a Certificate of Completion with Google Forms
Quick answer: Google Forms cannot generate certificates on its own — there's no built-in PDF or certificate feature. The real workflow is to build a graded quiz in Forms, link its responses to a Google Sheet, design a certificate template in Slides or Docs, and use a third-party Google Sheets add-on (like Document Studio or Autocrat) to mail-merge each respondent's name and score into that template and export it as a PDF. For very small groups, you can skip the add-on and mail-merge manually.
If you've searched for how to add a certificate to a Google Form, it's worth saying plainly upfront: Google Forms itself has no certificate feature, no PDF generator, and no way to automatically hand a respondent a diploma-style document when they finish. That surprises a lot of people, since the need is common — course completions, training modules, workshop attendance. The good news is that the pieces to build this yourself are all free or low-cost, they just live in different places. This guide lays out the real, honest workflow.
Step 1: Build a graded quiz in Google Forms
Certificates of completion almost always depend on some measure of "did this person pass," so start with a proper graded quiz rather than a plain form. Open your form's Settings, turn on the Quizzes toggle, assign point values to each question, and mark correct answers so Forms can calculate a score automatically. Our full guide on building a quiz with Google Forms covers grading options, whether to release scores immediately or after review, and how to add explanations for incorrect answers.
Step 2: Link responses to a Google Sheet
Once your quiz is live, go to the Responses tab and click the green Sheets icon. This creates a linked spreadsheet where every submission lands as a new row, including a column for the respondent's total score. This spreadsheet is what everything downstream connects to — it's the bridge between the quiz and whatever tool generates your certificates.
Step 3: Design a certificate template with merge fields
Build your certificate as a normal design in Google Slides (better for a visually rich, landscape-oriented certificate) or Google Docs (simpler, more text-based). In place of the recipient's name, date, and score, insert placeholder text using a consistent format your merge tool can recognize — most add-ons expect something like {{Name}} or {{Score}}, matched to the exact column headers in your response Sheet. Take your time on this template, since it becomes every certificate everyone receives; get the layout, fonts, and any signature or logo image right once.
Step 4: Install a mail-merge add-on
This is the piece that actually does the work of turning spreadsheet rows into individual certificates. Search the Google Workspace Marketplace (accessible from Sheets via Extensions > Add-ons > Get add-ons) for a document-merge tool — Document Studio and Autocrat are two well-known examples that specialize in exactly this: merging spreadsheet rows into a Slides or Docs template and exporting the result as a PDF. These are third-party tools, not built by Google, so review their permissions and any pricing tiers before installing — some offer a free tier with limits, others are fully paid. We're describing the general workflow here rather than a specific version's exact menus, since these tools update their interfaces over time.
Step 5: Connect the template to your response sheet
Inside the add-on, you'll generally point it at your quiz's response Sheet as the data source and your certificate design as the template, then map each merge field in the template to the matching column header in the Sheet — the "Name" field to your form's name-collection column, "Score" to the score column Forms generated automatically, and so on. Most of these tools walk you through this mapping step with a simple dropdown per field.
Step 6: Set a passing score threshold
If certificates should only go to respondents who actually passed, configure a condition in the add-on so it only generates a document for rows where the score column meets your bar — for example, only rows scoring 80% or higher. This keeps you from accidentally handing a completion certificate to someone who didn't finish the quiz successfully, and it's typically a simple filter or condition setting within the add-on rather than anything you need to build with a formula.
Step 7: Run the merge and deliver certificates
Once your mapping and threshold are set, run the merge. The add-on generates a personalized PDF for each qualifying row, and most of these tools can also automatically email the PDF to the respondent's address if you collected one on the form. Review the first few generated certificates closely before letting a full batch or an automatic email trigger run, since a mismatched merge field is much easier to catch on one document than after fifty have already gone out.
The manual alternative for small groups
If you only have a handful of respondents — a small workshop or an internal team — an add-on might be more setup than you need. You can export your response Sheet (File > Download > CSV or Excel) and use the mail merge feature already built into Google Docs, Microsoft Word, or Canva to combine your certificate template with that exported list by hand. It's slower per batch but requires no add-on installation at all, which can be the simpler choice for a one-off event that won't repeat.
Keep the underlying data clean
Whichever path you take, the quality of your certificates depends entirely on clean underlying data — consistent name formatting, no stray blank rows, and a properly calculated score column. If you want to dig deeper into your response data before running a certificate batch, our guide on Google Forms response summary charts and general Apps Script automation for Google Forms cover ways to check and clean up your data programmatically if you're comfortable with a bit of scripting, as an alternative to a marketplace add-on.
FAQ
Does Google Forms have a built-in certificate generator?
No. Google Forms cannot generate certificates or PDFs on its own. To produce certificates, you need to pair a Forms quiz with a separate tool, typically a Google Sheets add-on that merges response data into a certificate template.
What's the general workflow for generating certificates from a Google Form?
Set up a graded quiz in Google Forms, link its responses to a Google Sheet, design a certificate template in Google Slides or Docs with merge fields for name and score, then use a mail-merge add-on from the Google Workspace Marketplace to connect the template to the response sheet, set a passing score threshold, and generate a PDF per respondent.
Can I create certificates without any add-on?
Yes, for small volumes. Export your response Sheet, and manually mail-merge the names and scores into a certificate template using any word processor's built-in mail merge feature, or by copying each recipient's details into a template one at a time.