Output Configuration

The Output Configuration determines how generated documents are named, which output formats are created, and how the results are written back to your spreadsheet.

Click Open to review or modify the Output Configuration for the selected sheet.

Required Settings

Before the Output Configuration can be saved, you must configure the following settings:

• A column used for document names

• At least one output format

Document Name

Select the spreadsheet column that contains the filenames to use for generated documents.

After a document is created, AnyMerge Docs automatically renames it using the value from the selected column.

If PDF generation is enabled, the .pdf extension is automatically appended to PDF filenames.

Important: Filename values must not be empty. If a row does not contain a filename, the add-on will display an error and stop processing that row.

Output Formats

Choose which document formats should be generated. You must select at least one output format before the configuration can be saved.

NOTE: When creating a new Output Configuration, Google Docs™ is selected as the default output format. You can optionally enable PDF output as well.

Google Docs™

Enable this option to generate Google Docs™ documents.

Insert URL

Select a column where AnyMerge Docs inserts the Google Drive™ URL of each generated Google Docs™ document.

This makes it easy to open or share the generated documents later.

Insert ID

Select a column where AnyMerge Docs inserts the Google Drive™ file ID of each generated Google Docs™ document.

File IDs can be useful when integrating with other systems or automation workflows.

PDF

Enable this option to convert generated Google Docs™ documents into PDF files.

Insert URL

Select a column where AnyMerge Docs inserts the Google Drive™ URL of each generated PDF document.

Insert ID

Select a column where AnyMerge Docs inserts the Google Drive™ file ID of each generated PDF document.

GENERAL SETTINGS

Insert Timestamp

Select a column where AnyMerge Docs records when a row has been successfully processed.

The timestamp is written only after the document has been generated successfully.

This can help you answer questions such as:

• Which rows have already been processed?

• When was a document generated?

• Which records still need attention?

Note: Timestamps are formatted according to the locale configured in your Google Sheets™ spreadsheet.

Output Configuration is the final step before document generation. Once configured, AnyMerge Docs not only creates documents, but also helps you track the results directly from your spreadsheet.