Premium Triggers and Actions - Google Sheets - Update Spreadsheet Row using Lookup

Updating a spreadsheet row using Lookup involves searching for a specific row in your spreadsheet based on a particular value using Lookup and then updating the values in that row with new data.

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 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 use the "Update using lookup" action to modify the data within that row. Therefore, using the lookup action before 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.

Selecting a Starting Column and End Column

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.

Notes:

• You can select only one Lookup Action at a time in the "Update Specific Sheet Row" action.
• If you do not wish to update a particular column, you can leave it blank.
• If the Lookup Action does not return any rows, the workflow skips this step and proceeds to the next one.

FAQ

1. How do I update a specific row in a spreadsheet using Lookup?

• First, use the "Lookup" action to search for the row based on a particular column value. Once you have identified the desired row, use the "Update sheet using Lookup" action to modify the data in that row with the new information.

2. What should I do if the Lookup Action does not return any rows?

• If the Lookup Action does not return any rows, the workflow will skip the update step and proceed to the next action. Ensure your lookup criteria are correct and that the data exists in the specified column.

3. Can I update multiple columns at once when using the "Update sheet using Lookup" action?

• Yes, you can update multiple columns by selecting the starting and ending columns you wish to update. If you do not want to update a particular column, simply leave it blank.

Updated on: 11/21/2025