Automated Certificate Generation from Google Forms

Every term, training cycle, or professional development day ends the same way for most Australian educators: the quiz closes, responses land in a spreadsheet, and the clock starts ticking on the most thankless administrative task in education — producing individual certificates.

If you have thirty students, that is thirty PDFs. If you run three courses a term, that is ninety. If you work in a registered training organisation or a TAFE running assessments across multiple cohorts simultaneously, the number compounds fast. It is slow, repetitive, error-prone, and nobody went into teaching to do it.

Google Forms already collects everything you need to issue a certificate — the participant's name, their email address, their score. The gap is the step that converts that structured data into a personalised, emailed certificate. That gap is exactly what Certify'em closes.

Certify'em is a free Google Workspace Marketplace add-on built specifically for educators. Install it on a Google Form quiz, point it at a certificate template, set a pass mark, and it handles the rest. When a student submits their quiz and meets your threshold, they receive a personalised certificate in their inbox — automatically, within minutes, without any manual action on your part.

This tutorial covers the full setup: building your quiz form correctly, installing and configuring Certify'em, designing a certificate template that looks professional, adding conditional logic so only passing students receive one, and setting up email delivery. Where Certify'em's limitations become relevant, Autocrat and Document Studio fill the gap.

Who This Tutorial Is For

This workflow is directly relevant if you are:

• A classroom teacher who runs Google Forms quizzes and wants to reward students with a completion or achievement certificate without touching a file manually
• A training coordinator or RTO administrator issuing certificates of completion or participation after online modules, face-to-face workshops, or blended delivery
• A corporate learning and development professional tracking compliance training and needing automatic confirmation of completion for staff and their managers
• A professional association or industry body issuing CPD certificates after an examination or course
• A school administrator managing assessment events at scale where individual certificate production is a genuine administrative bottleneck

Once configured, this system runs automatically for every subsequent submission. It does not require a dedicated staff member to operate. It does not require specialised software or an IT budget. It runs on tools your school or organisation already has access to.

Method 1: Certify'em — The Purpose-Built Certificate Add-On

Certify'em is the most direct solution for educators generating certificates from Google Forms. Unlike general-purpose document merge tools, it was designed exclusively for this workflow: quiz submitted, score checked against a pass threshold, certificate generated and emailed if the participant passes.

It is free. It is available on the Google Workspace Marketplace. And it works from inside the Google Form editor, which means no spreadsheet setup, no scripting, and no row mapping required.

Step 1: Configure Your Google Form as a Quiz

Certify'em requires your form to be a graded quiz. Google Forms has native quiz functionality built in — it just needs to be switched on.

1. Open your Google Form and click the Settings tab (the gear icon at the top right).
2. Under the Quizzes section, toggle Make this a quiz on.
3. Under Release grade, select Immediately after each submission. This is required for Certify'em to fire automatically — if you review grades manually, the trigger will not work.
4. Go to each question in your form and click Answer key to assign correct answers and point values.
5. Add an Email question to your form and mark it as required. This field feeds the email address that Certify'em will send the certificate to. Use the native Email question type so Google Forms validates the format automatically.
6. Add a Short answer question asking for the participant's full name. Mark it as required. This feeds the name field in your certificate template.

A critical point: if you are using Google Workspace for Education, confirm with your school's Google administrator that respondents can submit email addresses that are valid for your domain. If your form is restricted to organisation accounts only, the email field will be pre-populated from the signed-in account — which can simplify setup but limits who can participate.

Step 2: Install Certify'em from the Google Workspace Marketplace

1. In the Google Form editor, click the three-dot menu (More options) in the upper right corner.
2. Select Add-ons from the menu.
3. The Google Workspace Marketplace will open as an overlay. Search for Certify'em.
4. Click the Certify'em listing and then Install.
5. Grant the permissions Certify'em requests. It requires access to your Google Forms data (to read responses and scores) and Gmail (to send the certificate email). Both permissions are necessary for the add-on to function.

Once installed, Certify'em appears in the same three-dot menu under Add-ons > Certify'em.

Admin note for school and organisational accounts: Certify'em must be permitted by your Google Workspace administrator before individual users can install it. Administrators can approve it through the Admin Console under Apps > Google Workspace Marketplace apps > App access control. If installation fails with a permissions error, the request needs to go to your Workspace admin first.

Step 3: Design Your Certificate Template in Google Docs

Certify'em generates certificates from a Google Docs template stored in your Google Drive. The template uses merge tags — specific placeholder text that Certify'em replaces with each participant's actual data during generation.

The supported merge tags in Certify'em are:

Setting up the document:

1. Create a new Google Doc from your Google Drive.
2. Go to File > Page setup and change the orientation to Landscape. A4 landscape (297mm x 210mm) is the standard certificate format in Australia.
3. Set generous margins — 25mm on all sides at minimum. This gives the certificate a structured, bordered look even without a graphic frame.
4. Design your certificate layout with the following content hierarchy:
5. Your organisation name and logo at the top (use Insert > Image > Upload from computer to add a logo)
6. "Certificate of Completion" or "Certificate of Achievement" as the dominant heading in a larger, formal font
7. The line "This certifies that" followed by {{name}} on its own line — make the name visually prominent, at least 24pt, in a distinctive or script-style font
8. "has successfully completed" followed by the course title
9. Score and date: "with a score of {{score}} on {{date}}"
10. A signature area at the bottom — either a scanned signature image or a printed name and title in a formal font

Typography recommendations:

For a certificate that looks like it belongs on a noticeboard rather than in a recycling bin, apply some typographic care. Use Playfair Display or Merriweather for the main heading for a sense of formality. Use Open Sans or Lato for body text. The participant's name should be the most visually dominant element on the page — significantly larger than any other text. If you are not confident designing this from scratch in Google Docs, design the layout in Canva using their certificate template library, export it as a PNG, and import it as a background image in your Google Doc with the merge tag text boxes layered on top.

Save the document in a Google Drive folder you will remember. You will need the document URL when configuring Certify'em.

Step 4: Configure Certify'em

Open your Google Form and go to Add-ons > Certify'em > Configure from the three-dot menu.

The Certify'em configuration panel appears as a sidebar with the following fields:

Template URL: Paste the full URL of your Google Docs certificate template. You can copy this from your browser's address bar when the template document is open.

Pass percentage: Enter the minimum score required to receive a certificate, expressed as a whole number percentage. For example, 80 means participants who score 80% or above receive a certificate. Participants below this threshold receive nothing from Certify'em — though you can set up a separate notification for them using Google Forms' built-in response receipts.

Name field: From the dropdown, select the form question that collects the participant's full name. Certify'em maps this response to the {{name}} tag in your template.

Email field: Select the form question that collects the participant's email address. Every certificate will be sent to the address provided in this field.

Email subject: Write a subject line for the certificate email. Keep it specific and professional. For example: Your Certificate of Completion — Year 10 Science Assessment Term 1

Email body: Write the email body the participant will receive alongside their certificate. Keep it brief. For example:

Congratulations on successfully completing the assessment. Your certificate of achievement is attached to this email as a PDF. Please keep it for your records.

Sender name: Enter the name the email should appear to come from — your name, your school's name, or the name of the department running the course.

Click Save to activate Certify'em on your form. It is now live. Every new quiz submission that meets your pass threshold will automatically trigger certificate generation and delivery.

Step 5: Test Before Opening to Participants

Never deploy a certificate automation workflow to real participants without testing it first. Run your own test submissions using a personal email address you can access.

Submit the form at least twice:

1. A submission with answers that score above your pass threshold — verify the certificate arrives in your email, the name and score are correct, the date is right, and the formatting is intact
2. A submission with answers that score below the threshold — verify no certificate is sent

When the certificate arrives, open the PDF attachment and check:

• No merge tags appear in the final output (if you see {{name}} instead of an actual name, there is a field mapping problem in your configuration)
• The logo image displays correctly and has not been cropped or stretched
• The landscape orientation held — some email clients can reformat attachments unexpectedly
• The participant's name is spelled correctly and matches what was entered in the form

Fix any issues in either the template or the Certify'em configuration, save, and test again before opening the form to students.

Method 2: Autocrat — More Control, Still Free

Autocrat is a free Google Sheets add-on that handles document generation more broadly than Certify'em. While Certify'em works inside the Google Form editor and is optimised for quiz-based certificate delivery, Autocrat operates from the linked Google Sheets response spreadsheet and gives you more flexibility over both what triggers certificate generation and what the output looks like.

Use Autocrat instead of Certify'em when:

• You need certificates for participation rather than a scored quiz — no pass/fail threshold, every submitter receives one
• You want to manually review and approve specific rows before certificates are issued, rather than firing on every submission
• You want to save a copy of every generated certificate to a Google Drive folder for your records alongside emailing it
• You are generating certificates from a form that does not use Google Forms' native quiz scoring
• You need the merge template to pull from additional columns you have added to the spreadsheet — such as a manually entered course title or cohort identifier

Setting Up Autocrat

Link your Google Form to a response spreadsheet: In the Google Form editor, click the Responses tab and then the green Sheets icon. This creates or links a Google Sheets spreadsheet where every submission will populate a new row automatically.

Prepare your spreadsheet columns: Autocrat maps merge tags to column headers. If your form question is "What is your full name?", the column in your spreadsheet will have that as its header. Rename the column headers in the sheet to clean, short labels — "Full Name", "Email Address", "Score", "Course Title" — so your merge tags are easy to manage.

Install Autocrat: Open the linked response spreadsheet. Go to Extensions > Add-ons > Get add-ons and search for Autocrat. Install it and grant the required permissions.

Prepare your Google Docs template: Autocrat uses <<double angle bracket>> merge tags rather than the {{curly brace}} format Certify'em uses. Design your certificate template with tags like:

• <<Full Name>>
• <<Course Title>>
• <<Completion Date>>
• <<Score>>

The text inside the angle brackets must match your spreadsheet column headers exactly, including capitalisation and spacing.

Create a new Autocrat job: Open Autocrat from Extensions > Autocrat and click New Job.

• Template: Select your Google Docs certificate template from Google Drive
• Tags: Autocrat will scan your template and list the merge tags it finds — map each one to the matching column in your spreadsheet
• Output file name: Use merge tags to create a unique file name for each certificate — for example, Certificate - <<Full Name>> - <<Completion Date>>
• Output type: Choose PDF to email an attached PDF; choose Document to keep an editable version in Google Drive alongside the PDF
• Destination folder: Choose a Google Drive folder where all generated certificates will be saved
• Email options: Enable "Send email", select the column containing participant email addresses, write your subject line and body, and Autocrat will attach the generated PDF automatically

Add a row filter for conditional generation (optional): If you only want certificates to go to participants who achieved a certain score, click Add filter in the job configuration. Set the column to your score column, the condition to "is greater than or equal to", and the value to your minimum pass score. Rows that do not meet this condition are skipped.

Set the trigger to "On form submit": In the final step of the job setup, select Run on form submit so Autocrat fires automatically for each new response.

Method 3: Document Studio — When Quality Matters More Than Cost

Document Studio, by Digital Inspiration, is the premium option for certificate automation. Unlike Certify'em and Autocrat, it is not free — individual licences start at approximately AUD $77 per year. But it supports capabilities neither free tool can match: embedding QR codes into certificates (useful for verification), embedding uploaded images from form responses, generating certificates from HTML templates with precise styling control, and running multi-step workflows that generate, convert, email, and file the certificate in a single triggered action.

Document Studio is worth the investment for RTOs and training providers who need certificates to meet a higher bar of professionalism — for example, a certificate with a QR code that links to a verification page proving the credential is real. It is also the better choice if your certificate design requires image merge fields, such as inserting each student's photo from a form upload into their certificate.

For most classroom teachers and school administrators, Certify'em handles the requirement cleanly at zero cost. Document Studio is an upgrade for organisations where the certificate itself is a credentialling document with reputational weight behind it.

Template Design: Making Certificates Worth Keeping

The template determines whether a certificate ends up pinned to a wall or deleted immediately after download. A few design decisions have a disproportionate impact on the result.

Orientation and size: A4 landscape is the standard. Set this in Google Docs under File > Page setup before designing anything else — changing orientation later will reflow all your text.

Structure: The spatial hierarchy on a certificate should follow this order of visual prominence:
1. The participant's name — the largest, most prominent element on the page
2. The achievement statement — "has successfully completed" followed by the course or assessment name
3. The issuing organisation's name and logo
4. Supporting details — date, score, validating authority
5. A signature or authorisation element

Borders and frames: A clean border gives a certificate structure without requiring complex graphic design. In Google Docs, you can create a border by inserting a single-cell table set to the full page width, adjusting the border width to 3-4pt, and placing all your certificate content inside the table cell. This creates a clean, formal frame with no graphic design skill required.

Fonts: Avoid the default Arial and Times New Roman. Google Fonts available in Google Docs include Playfair Display, Cormorant Garamond, and EB Garamond for formal headings; Open Sans and Source Sans Pro for body text. Mixing a serif heading font with a sans-serif body creates the contrast that reads as "professional" without effort.

Colour: A single accent colour used sparingly — typically the organisation's brand colour — applied to the certificate heading or border can elevate the visual quality significantly. Keep the background white or near-white; coloured certificate backgrounds rarely print well.

Logo placement: Insert the logo at the top centre or top left. Keep it proportional — a logo that dominates the top quarter of the certificate competes with the participant's name for attention. A logo at 15-20% of the page width is typically proportionate.

Conditional Generation: Only Send to Those Who Qualify

The point of conditional certificate generation is twofold: it preserves the value of the certificate (a certificate everyone receives regardless of performance is worth less than one that requires a standard to be met), and it reduces administrative noise for participants who did not pass.

In Certify'em: Conditional generation is handled by the pass percentage setting. Set it once and Certify'em enforces it on every submission. Participants who do not meet the threshold receive no certificate and no email from Certify'em. If you want those participants to receive acknowledgment of their attempt, configure a separate response receipt through Google Forms itself — go to Settings > Responses > Send responders a copy of their response and enable it for all submissions, or use a Google Forms email notification that triggers for every submission regardless of score.

In Autocrat: Add a row filter to your job configuration as described in the setup steps above. You can stack multiple conditions — for example, process only rows where the score is 80 or above AND where the "Certificate Issued" column is blank (preventing duplicate certificates if the job runs again after the initial trigger).

In Document Studio: Conditional generation uses the "Filter" option in the workflow settings. You can also use Document Studio's conditional template feature, which selects a different certificate template depending on the form response — for example, a "Distinction" certificate for scores above 90% and a "Pass" certificate for scores between 70% and 89%, with a different visual design for each tier.

Email Delivery: What Participants Actually Receive

The email that arrives with the certificate matters almost as much as the certificate itself. A cold, generic email from a no-reply address with an attachment undermines the significance of the achievement.

Consider these elements when writing your certificate delivery email:

Subject line: Be specific. "Your Certificate — [Course Name] Assessment" is better than "Certificate Attached". Participants searching their email for a certificate six months later need enough information to find it.

Email body: Three or four sentences is the right length. Congratulate the participant by name if your tool supports it (Certify'em's email body does not support merge tags, but Autocrat and Document Studio do). State what the certificate is for. Mention that the PDF is attached. Invite them to contact you if they have questions.

Sender name: Use your name, your school's name, or the department name — not a generic system name. "RTO Compliance Team, ACME Training" is more reassuring than "Certify'em Notification".

Attachment format: PDF is universally expected and universally readable. All three tools produce PDF output. Do not send a Google Docs link instead — participants may not have Google accounts, and document links can break if sharing permissions change.

Timing: Certify'em and Autocrat fire within seconds to minutes of form submission. Set participant expectations accordingly — if your assessment is time-sensitive, they can expect their certificate to arrive almost immediately. If processing takes longer due to form response volume or script execution queuing, note this in your post-submission confirmation page.

Resources and Next Steps

If your school or organisation is not yet on Google Workspace, or you are evaluating whether your current plan supports Marketplace add-ons and quiz features in Google Forms, the following link covers current plan options available to Australian institutions and businesses.

Explore Google Workspace plans for Australian teams and schools — Every Google Workspace plan includes Google Forms with quiz functionality, Google Sheets, Google Docs, and access to the Workspace Marketplace where Certify'em and Autocrat are available for free installation. Google Workspace for Education is available at no cost to qualifying Australian schools and universities — contact your school's Google administrator or your Google reseller to confirm eligibility and plan details.

For Document Studio, visit digitalinspiration.com/docs/document-studio for documentation, template examples, and licence purchase information.

Conclusion

Manual certificate production is a problem that looks small until it is not. The moment a single cohort becomes three cohorts, or a single assessment becomes a weekly assessment cycle, the time cost becomes real — and it is time taken away from the parts of teaching and training that actually matter.

The workflow described in this tutorial removes that cost entirely. A student submits their quiz. Certify'em checks their score. If they pass, a personalised certificate is generated from your template and emailed to the address they provided in the form. You receive a clean response sheet with a complete record of every submission. You do not touch a single file.

Start with Certify'em if you are using Google Forms' native quiz scoring and want to be up and running in under an hour. Install the add-on, link your certificate template, set your pass mark, and test with yourself before opening to participants.

Move to Autocrat if you need participation certificates without score thresholds, want to save certificates to Google Drive alongside emailing them, or need to manage certificate issuance from the response spreadsheet rather than the form editor.

Upgrade to Document Studio if your certificates are credentialling documents where professionalism and verification matter — QR codes, image merge fields, and multi-step delivery workflows justify the modest annual licence cost for RTOs and professional training providers.

The underlying principle is straightforward: your form already collects the data. These tools convert that data into action automatically, at the moment of submission, every time.

If you are new to Google Workspace Marketplace apps and want to understand how they fit into your broader Workspace environment, our guide to auditing and managing Marketplace apps covers everything your administrator needs to know about reviewing, approving, and monitoring add-ons across your organisation. For a broader look at automating Google Forms beyond certificates, our Google Forms business use cases guide covers 20 practical workflows you can implement today.

Ash Ganda is the founder of CloudGeeks, a Google Workspace consultancy helping Australian businesses and educational institutions get more from their cloud tools. Practical advice, no jargon. insights.cloudgeeks.com.au