Update row

Update rows of an existing worksheet

Update 2 columns in row ${rowNumber} of worksheet My Worksheet in spreadsheet My Sheet

fileId
rowNumber

Use cases

  • Tracking subscription state (Example Newsletter)
  • Updating form responses
  • Update data in a customer sheet

Configuration

Click on the bold text in the title of the building block to open the configuration dialog.

 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 open and edit the Google Sheet in a new browser tab.

Usage

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 pops up that allows you to select the columns to be updated and to specify the values for each column.

You can update cells of an existing row with a simple fixed strings or with the content of a variable.

As you are updating an existing row you will have to specify the row number to be updated. This can either be done by entering a number or by entering a variable that contains the row number to be updated.

Updating multiple rows at once

You can even update multiple rows at once if you separate the row numbers by comma.

You can for example enter 2,5,8 to update the second, fifth and eighth row at once.

Useful combinations

Update delivery status of an email campaign

Load row from Subscriber sheet

Subscriber sheet
name
email

Send newsletter

name
Newsletter
email
resumeDelivered
resumeBounced

Set email status of contact to "open"

Subscriber sheet
status

Stop execution

Update email status to "delivered"

resumeDelivered
status
Subscriber sheet

Stop execution

Update email status to "bounced"

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 App

Learn more

You can also use Send personalized Emails wizard with tracking activated.

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: 1/6/18