Audeza Doc Merge

Turn form responses into PDFs

Certificates, receipts, confirmation letters. Each new Google Forms™ response or Google Sheets™ row fills your Google Docs™ or Google Slides™ template, becomes a PDF in the folder you pick, and can go straight to the person's inbox.

Free for 50 documents a month. Already use Autocrat? Your templates work as they are.

How it works

  1. Write a template. A Google Doc or Slides file with tags like <<Full Name>> and <<Course>>, one for each column you want filled in.
  2. Create a merge job. In your spreadsheet, open Extensions > Audeza Doc Merge > Open. Pick the tab, the template and an output folder. Click Test with first row to see one document before you save.
  3. Let it run. Each new form response becomes a document within a minute. Rows added another way merge at the next hourly run, or when you click Merge now.

It tells you when something breaks

Merge add-ons tend to stop without a word: a trigger dies, a permission lapses, a batch times out. You find out when someone asks where their certificate is. Doc Merge is built to say so first.

It sees only what you pick

The add-on opens the template and the folder you choose in Google's file picker, the documents it creates, and the spreadsheet it's open in. It can't browse the rest of your Drive. Most merge add-ons ask to see, edit and delete every file in your Google Drive, which is a common reason school IT admins block them. Your rows and documents never pass through our servers. Emails go out from your own account.

What people make with it

Guides and comparisons

Pricing

Buy with the same Google account you use in Sheets, then click "Check my license" in the sidebar. Polar handles payment, sales tax and VAT.

Questions

Do my Autocrat templates work?

Yes. Doc Merge reads the same <<Column header>> tags, and also {{Column header}}. Matching ignores case and extra spaces. The job editor lists every tag in your template and marks the ones with no matching column before you save.

How fast does a new response become a PDF?

Usually within a minute of the form being submitted. Rows you paste into the sheet by hand merge at the next hourly run, or right away when you click Merge now.

How many emails can it send?

As many as Google allows your account: about 100 recipients a day on a free Gmail account and 1,500 on Google Workspace. The sidebar shows what's left today. When it runs out, rows wait and merge after the allowance resets.

What if a row fails?

Its status cell says why, for example "Error: No email address to send to". Fix the sheet or the template, clear that status cell, and the row merges at the next run.

How do I merge a row again?

Clear its "Merge status" cell. That's the only switch, so nothing re-merges by surprise.

Can other editors of the spreadsheet use it?

Yes. Jobs and the run log belong to the spreadsheet, so every editor sees them. Each job runs automatically under the account of whoever last saved it, so its emails go out from that person's account, never from someone who didn't approve the change.

Launching soon

Doc Merge is in Google's review for the Google Workspace Marketplace. Want it the day it's listed? Email us and we'll write once, when it's live.