Pick row(s)

Let users of your app pick one or multiple rows from a worksheet

Let user pick one row from worksheet My Worksheet in spreadsheet My Sheet

fileId
rowNumber
rowIndex
date

With this building block the user of the app can load a single or multiple rows from a worksheet.

When dragging this block into the flow you can either select an existing Google Sheet from Google Drive or you can create a new one. If you choose to select an existing sheet, a file picker dialog will help to locate the sheet on your Google Drive.

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

The building block shows all the columns found in the selected worksheet on the right-hand side. All of these variables will get a green sheet icon.

Use cases

  • Let user pick data from a sheet and merge the selected data into your documents or emails
  • Send out newsletters or documents for selected rows of a sheet
  • Print business cards or address labels using data from Google Sheets

Configuration

Click on the bold text parts in the title of the building block to configure this block.

Click on one row or multiple rows to toggle whether the user can select just a single selected row or multiple rows.

As 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.

 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 all 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: 7/13/19