Update row
Purpose of this building block
With this building block you can update rows of an existing worksheet.
2 variables
0 variables
${fileId}
${rowNumber}
Possible use cases
- Track subscription state (Example Newsletter)
- Update multiple rows at once
- Update data in a customer sheet
Configuration
Click on the bold text in the title of the building block to open the configuration dialog.
Edit
Click on the edit icon to edit the selected Google Sheet in a new browser tab or window.
Reload
Click on the reload icon to scan the sheet again to track down added or removed worksheets or columns.
When dragging this block into the flow you can either select an existing spreadsheet from Google Drive or you can create a new one. If you choose to select an existing sheet, a file picker dialog will help you to find the sheet on your Google Drive. Creating a new spreadsheet will open the new sheet in a new browser tab.
After selecting the Google Sheet a dialog will allows you to select the columns to be updated and to specify the values for each column.
You can update individual cells of an existing row with a simple fixed strings or with the content of a variable. As in most of the text boxes in Ultradox you can leverage the full feature set of Ultradox templating. This makes it easy to format dates, numbers, currencies etc. according to your needs.
As you are updating an existing row you will have to specify the row number to be updated. This can either be done by providing a fixed number or a variable containing the row number to be updated.
When running a batch job Ultradox will hold the row that is being processed in a variable called . Using this variable will allow you to update the row that Ultradox is processing. This makes it very simple to add a link to the generated document into each row of the spreadsheet when running a batch job.
You can even update multiple rows at once. If you for example use the Load worksheet building block you will find the loaded row numbers in a variable called $[worksheetname.rowNumber]. The square brackets indicate that this variable contains multiple values. Use this variable as the row to be updated and all loaded rows will get updated with the provided values.
Useful combinations
Update delivery status of an email campaign
Subscriber sheet
name
email
name
Newsletter
email
resumeDelivered
resumeBounced
Subscriber sheet
status
resumeDelivered
status
Subscriber sheet
resumeBounced
status
Subscriber sheet
In this example an newsletter is send to all contacts listed in a Subscribers sheet. The flow is executed in batch, so all building blocks are executed for each row of the Subscribers sheet.
After the newsletter is sent to a subscriber its corresponding row in the subscriber sheet is updates. First the status is set to "open". The execution is stopped after the email was sent and the status got updated.
When sending emails via Amazon Web Services you can automatically receive an email status. So in the tracking settings of the Plain text email building block you can enter a URL that is called in case the email is delivered or bounced. Here you can enter the URL of an Update row building block.
In case for example the email bounces, AWS calls the bounce URL which represents the update row building block to set the status to "bounced". As of the batch execution each picked row is unique, so calling the bounce URL will automatically update the row that represents the subscriber who was supposed to receive the bounced email.
You can maintain tracking URLs for "open", "delivered", "bounced", and "complain" allowing you to keep detailed track of you email campaign.
Copy the Email Tracking app to see this building block in action
You can also use Send personalized Emails wizard with tracking activated
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:
