Doc Merge setup and help
How to set up a merge job, what the tags do, when documents are made, and what to do when a row fails.
Set up a job
- Open the spreadsheet with your data. For a Google Form, that's its responses spreadsheet (in the form: Responses > Link to Sheets).
- Click Extensions > Audeza Doc Merge > Open.
- Click New merge job. Give it a name, like "Certificates", and pick the tab with your rows.
- Click Choose a template and pick a Google Doc or Google Slides file. The editor lists its tags: green ones match a column, red ones don't.
- Click Choose a folder for the finished documents, pick PDF or an editable copy, and set the file name.
- Click Test with first row. You get one document named "TEST - ..." in the folder, and no status or email. Check it, delete it, then click Save.
Not ready to build a template? Click Try a sample first in the sidebar. It adds a tab called "Audeza sample", a certificate template and a folder, and makes three PDFs so you can see each piece.
Tags
Put a column's header between double angle brackets where its value should go: <<Full Name>>. Double curly braces work too: {{Full Name}}.
- Matching ignores case and extra spaces, so
<<full name>>fills from a column headed "Full Name". - Values come out the way the sheet shows them. Format a date or price column in Sheets and the document matches.
- A tag with no matching column comes out empty. The editor marks those in red before you save.
- Tags work in the body, tables, headers and footers of a Doc, and in any text box or table on a slide.
- Templates from Autocrat work as they are.
Output and file names
PDF makes a PDF in your folder and nothing else; the working copy behind it is deleted. Editable Doc (or Slides) keeps the filled-in copy, so you can change it by hand afterwards.
The file name can use tags too: Certificate - <<Full Name>>. Characters that aren't allowed in file names, like / and :, become dashes. If a name comes out empty, the job name and row number are used.
Only some rows
Under Only some rows, pick a column and a test: is, contains or is not empty. For example, merge only rows where "Passed" is "Yes". The test ignores case. Rows that don't pass stay without a status, so if the value changes later, the row merges at the next run.
Turn on Email each document and set who gets it, usually a tag like <<Email Address>>. Subject and message can use tags. A PDF is attached; an editable copy is sent as a link.
- Emails go out from your own Google account, so replies come to you.
- Google limits how many recipients an account can email a day: about 100 on a free Gmail™ account and 1,500 on Google Workspace. The sidebar shows what's left today.
- When the allowance runs out, the job stops and the remaining rows wait. They merge on their own after it resets, within 24 hours.
- If a row has no valid address, it fails before any document is made, with "Error: No email address to send to" in its status.
When does it merge?
- After each form response, usually within a minute.
- Every hour, for rows added any other way and anything left over.
- When you click Merge now in the sidebar or the Extensions menu. In the sidebar it works in short steps with a progress bar, so long jobs finish. You can stop it at any point.
The automatic runs start when you save your first job. If the sidebar says Auto-merge is off for you, click Turn on auto-merge.
The status column
Each job adds two columns after your last header: Merge status: <job> and Merge link: <job>. You can move them; the add-on finds them by their header.
- Empty: the row hasn't merged yet.
- Merged 2026-11-08 10:31 (and , emailed): done. The link opens the document.
- Error: ...: the row failed and won't retry until you clear the cell.
To merge a row again, clear its status cell. If an email failed after the document was made, the status says so; delete that document first so you don't end up with two.
Run log and alerts
The sidebar's Activity list shows the latest documents with a link to each, and every failure with its reason. When a job fails during an automatic run, you get an email from alerts@audeza.com, at most once per job and error a day. Click Send test in the sidebar to check alerts reach your inbox, and add alerts@audeza.com to your contacts.
Limits
- Free plan: 50 documents a month per Google account, counted from the 1st. At the limit, rows wait until next month or until you upgrade. You get one email about it a month.
- Speed: about 2 to 5 seconds per document. A run started by a trigger stops after 4.5 minutes and the next run continues.
- Google's daily limits on script run time and email apply to every add-on. The sidebar shows the email allowance.
- Templates: Google Docs and Google Slides. Word files need converting first: open the file in Google Docs, then File > Save as Google Docs.
- Not yet supported: images from a column, and one table row per sheet row.
Fixing permissions
If the sidebar says Permissions missing, click Fix permissions and allow every item. If a job says it can't find the template or folder, it was deleted, moved to the trash, or shared with you by someone who removed your access. Edit the job and pick it again.
Several editors
Jobs and the run log belong to the spreadsheet, so every editor sees and can edit them. Each job runs automatically under the account of whoever last saved it: that account's free allowance and email limit apply, and its emails come from that account. If you save a job someone else set up, it switches to running as you. That way nobody's account sends email they didn't approve. Clicking Merge now runs every job as you, right away. Two runs never merge the same row twice.
Billing
Buy with the same Google account you use in Sheets, then click Check my license in the sidebar's plan panel. Paid with another email? Write to support@audeza.com and we'll move the license. The Audeza bundle unlocks Doc Merge and Choice Sync Pro together. Cancel from the link in your receipt; Pro lasts until the end of the period you paid for.
Uninstalling
Delete your jobs in the sidebar (this also removes your triggers), then remove the add-on in Extensions > Add-ons > Manage add-ons. Documents already made and the status columns stay where they are.
Support
Email support@audeza.com. The developer answers. A screenshot of the sidebar and the status cell's text help a lot.