To update a specific row in a spreadsheet, you should use Lookup Action to search for a column value in the data, which will return the corresponding row. Once you have located the desired row, you can then use the "Update sheet using Lookup" Action to modify the data within that row.
Note: If you want to use the "Update using lookup" action, it is necessary to first use the "Lookup" action to search for a specific row in your spreadsheet based on a particular value. Once you have found the desired row using lookup, you can then use the "Update using lookup" action to modify the data within that row.
Therefore, using the lookup action prior to updating using lookup is a
necessary step in this process.
Select Lookup Action
This action will only display the Lookup actions that have been added above it for selection.
To update the desired columns, select the starting and ending columns.
If you do not wish to update a particular column, you can leave it blank.
Reach out to us!