Catalog Merge

Create catalogs from the data in a Google Sheet

With this Ultradox automation you can automate the creation of your catalogs. Ultradox uses data stored in a Google Sheet to create a catalog in PDF format.

Configuration

After copying the example to your Google Drive (My Drive), you will find the following files and folders in the Catalog Merge project folder:

The Ultradox automation Catalog Merge, the Google Sheet Products, the Google Docs template Catalog Template and the Catalogs folder.

Catalog Merge (Ultradox automation)

Ultradox loads the data with the help of the Load row(s) building block and passes it to the Generate PDF building block. This links the data with the Google Docs template Catalog Template.

Products (Google Sheet)

Open the Google Sheet Products and enter the appropriate content for your listing in the corresponding columns.

Catalog template (Google Docs)

Open the Google Docs template Catalog Template.

This template only consists of two pages:

the first page is the title page of the catalog, the second page contains the template from which the individual catalog pages are generated.

Design the title as you like and customize content and appearance. Be careful not to delete the last line of the first page, which is part of the foreach loop of the second page.

A foreach loop creates a section in the catalog for each row in the document.

On the second page follow the further lines of the template from which the individual pages of your catalogue are created. The result can be previewed.

Change the appearance of the variable lines in font, font size and font color, but not their syntax.

Preview

Open the Ultradox automation Catalog Merge to create a preview of your catalog.

Select the Generate PDF building block in the automation and click on the preview button located on the top right of the block. Ultradox will then generate a preview in a new browser window.

If you are satisfied with the result, you are ready to generate your catalog.

Run

Open the Ultradox Automation Catalog Merge and click on the Run button in the Automation menu bar. Ultradox then creates a PDF document of your catalog and archives the document in the folder called Catalogs.

That's it! You have successfully automated the production of your catalogues.

Questions and Feedback

If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.

If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.

Last Updated: 6/15/20