Update Data

This action updates data in a variable or table to a new value.

New data can be empty - this will clear the existing data and set it to an empty value.

Example 1: Mark leads as qualified if their description contains certain keywords

Imagine you saved profiles from, for example, LinkedIn to a table called "Linkedin profiles". Now you want to mark all those leads which have keywords "senior", "vp", "director" in their job title as qualified. For this, you can create a column which you can call, for example, "Status" and use this action to update rows with the word "qualified" in the cases where your condition is fulfilled.

This is the workflow set-up:

Loop is set up to iterate over profiles in your table:

Start Condition is pointing to the column "Job position".

Set Condition is checking for the aforementioned keywords.

Now the column "Status" will be set equal to "qualified" as long as the condition above is met.

Later, when you continue working with this table, you can set up your TaskBot to only send connection requests to those contacts who have the word "qualified" in the column "Status" or you can delete all disqualified leads (see example here: Example: Remove disqualified leads if lead qualification status does not equal "qualified").

Example 2: Mark leads who received an outreach message with "Message sent"

A similar popular use case is to mark a message status as processed. Imagine your TaskBot will be sending out automated messages to a list of profiles. You can create a column called, for example, "Status message" and let your TaskBot update it with "sent" every time a DM is sent. Then by adding a condition to skip sending DMs on profiles who have a record "sent" in their "Status message" column, you can make sure that you never send repeated DMs to the same leads.

Example 3: Set profile visit status to "visited" to avoid visiting same profiles

Here is a an example of a workflow set-up that checks for status of profile being visited: Avoid visiting same profiles (link includes a video tutorial).

FAQ

When I use a table reference, no data is updated, although there is data in the table.

This happens when no dynamic loop is set up to pull rows from the table. Please see the solution here: When I Use Data from Table, No Data is Being Pulled.

Video Tutorial 1: Qualify Profiles in a Table or Google Sheet

Video Tutorial 2: Use Update Data to Transfer Data from One Table to Another