Repeat
Purpose of this building block
The Repeat building blocks lets you perform actions on each item in a loaded list. No matter if you have loaded rows from a Google Sheet or Google Contacts from a contact group in GMail, the repeat block allows you to execute a sequence of building blocks for each item in the list.
0 variables
3 variables
§{rowNumber}
§{rowIndex}
§{date}
Possible use cases
- Send out a mailing to all contacts in a group
- Generate a report for each row of a worksheet
- Share and send all files in a Google Drive folder
Configuration
Click on the bold part in the title of the building block to configure the number of blocks to be repeated for each item of the selected list. Please note that you'll have to adjust the number of blocks to be repeated whenever you insert or remove some of the repeated blocks.
Reload
If the structure of the list that you are loading has changed (e.g. if you are loading a worksheet and you have added or removed columns) you can hit the reload button to update the variables.
As you repeat the nested blocks for each of the items in the list, the variables of your list will become available as simple variables.
Example: If you have a variable in your list called $[mysheet[].name] you can then use the simple ${name} variable in the nested blocks.
Useful combinations
Send emails to reach row (e.g. customer) of a worksheet
By using the Load worksheet building block you will load a worksheet containing all customers. The variables are available within the referring list - here for example recipients.email.
The Repeat building block applies each step contained under the repeat block to all parsed items of the list. Within the repeat block the variables are converted to simple variables (e.g. email).
RECIPIENTS SHEET
recipients.name
recipients.email
recipients.name
name
recipients.email
email
For each item a personalized HTML document is generated from a template.
The generated document is then sent to the recipient as body of the HTML email.
name
HTML Doc
HTML Doc
HTML Email
email
Copy the Mail Merge To Contcat List app to see this building block in action
Questions and Feedback
If you have any comments on this guide, feel free to add them 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:
