Load row(s)

Load selected rows from a worksheet

Load one row when running a batch, otherwise row 2 from worksheet My Worksheet in spreadsheet My Sheet

fileId
rowNumber
rowIndex
date

With this building block you can load a single or multiple manually selected rows from a worksheet.

Use cases

  • Send out newsletters or documents for selected rows of a sheet
  • Print business cards or address labels

Configuration

Click on the bold parts in the title of the building block to configure the data to be loaded.

Click on given file to open a file picker that helps you to track down the Google Sheet you want to load and also gives you an option to create a new sheet from scratch.

Creating a new spreadsheet will open the new sheet in a new browser tab.

After selecting the Google Sheet the first worksheet will be preselected. Click on the bold name of the worksheet in the title of the building block to load a different worksheet.

The first row of the selected worksheet will be treated as header row. The output variables showing up in the output section of the building block will be derived from the header row.

You will find all columns of the selected worksheet as variables. The single line on the right of the variables indicate that each variable represents just a single value: they contain the value of the selected row.

You can the access the columns from the loaded row(s) by simply using the output variables on the right of the building block in your templates.

If you have selected to load just a single row and now want to create documents for each row you can click on the batch icon in the main toolbar or select Batch from the Run menu.

Click on one row or multiple rows to toggle if you want to load just a single selected row or multiple rows.

You can turn on user interaction on this block. If user interaction is enabled the flow will halt and let the user pick the row(s) to be loaded.

Click on the name of the selected Google Sheet to pick a different file from Google Drive.

If you have selected a Google Sheet you can pick the worksheet to be loaded by clicking on the bold worksheet name in the title of the building block.

The configuration dialog also allows you to specify the name and type of the output variable for each column.

You can then select the format of the loaded values:

Loading unformatted data is the right choice if you want to for perform calculations on the data or if you want to format the values with Ultradox.

Load the formatted values if you just want to insert the data in exactly the same format as it shows up in your sheet.

If your cells contain formulas and you want to print the formula instead of the calculated value, select the last option

 Reload

Click on the reload icon to scan the template again to track down added or removed variables. If you have renamed your template on Google Drive clicking on this button will also update the document name in Ultradox.

 Edit

Use the edit icon to edit the template in a new browser tab.

Useful combinations

Send emails to selected recipients in a worksheet

Load row(s)

Customer sheet
userName
userEmail

Generate HTML from template

userName
HTML doc

Send HTML email to ${userEmail}

userEmail
HTML email
HTML doc

In this simple example shows how to send a personalized email to all users stored in a worksheet. The Ultradox file is executed in a batch job causing the Load row(s) building block to successively load all rows of the selected worksheet and perform the following building blocks.

For each loaded row the a personalized email is generated based on a template document you design. The HTML email is then sent to the email recipient derived from the worksheet.

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: 10/3/20