Audeza Doc Merge

How to make certificates from a Google Form

A quiz or a training sign-off in Google Forms™, a certificate template in Google Slides™, and every person who passes gets their own PDF certificate by email a minute after they submit. Here's the whole setup.

1. Collect what the certificate needs

Your form needs at least the name as it should appear on the certificate, and an email address. Turn on Settings > Responses > Collect email addresses so the address is checked. For a quiz, the score lands in its own column of the responses sheet.

Link the form to a spreadsheet: in the form, Responses > Link to Sheets.

2. Make the template

Slides is easiest for certificates: it's already landscape and you can place text anywhere. Make one slide with your design, and type tags where each person's details go:

Tags ignore case and extra spaces. Use the exact header words, though; the add-on marks any tag with no matching column in red before you save.

3. Create the merge job

  1. In the responses spreadsheet, open Extensions > Audeza Doc Merge > Open and click New merge job.
  2. Pick the "Form Responses 1" tab, your Slides template, and a Drive folder for the certificates.
  3. Keep the output as PDF and set the file name to Certificate - <<Full Name>>.
  4. For a quiz, under Only some rows, pick the score column and the passing condition. For a pass/fail question, use "is" and "Yes".
  5. Turn on Email each document. Send to <<Email Address>>, with a subject like Your certificate, <<Full Name>>.
  6. Click Test with first row, open the test PDF, check the layout, then click Save.

4. What happens next

Each new response gets its certificate within about a minute. The sheet shows Merged and a link next to every row, so you can see at a glance who has theirs. If a row fails, say from a mistyped email address, its status says so, and you get one email about it. Fix the address in the sheet, clear the status cell, and that certificate goes out at the next run.

Responses you already had merge too: click Merge now in the sidebar to send them all at once with a progress bar.

How many certificates can I send?

The free plan makes 50 documents a month. Pro removes the limit for $49 a year. Email is limited by Google, not by us: about 100 recipients a day on a free Gmail™ account and 1,500 on Google Workspace. If you hit the limit, the rest wait and go out the next day on their own.

Same setup, other documents: donation receipts from a form, or any form response as a PDF.