Audeza Doc Merge

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

  1. Open the spreadsheet with your data. For a Google Form, that's its responses spreadsheet (in the form: Responses > Link to Sheets).
  2. Click Extensions > Audeza Doc Merge > Open.
  3. Click New merge job. Give it a name, like "Certificates", and pick the tab with your rows.
  4. 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.
  5. Click Choose a folder for the finished documents, pick PDF or an editable copy, and set the file name.
  6. 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}}.

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.

Email

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.

When does it merge?

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.

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

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.