The "Update Specific Spreadsheet Row" action enables us to modify the contents of a specific row by specifying its row number. This action updates the values in the corresponding columns of that row.
Choose a worksheet:
Select a worksheet within your spreadsheet that you wish to edit a row.
Insert Row Number:
Specify the row number that you wish to modify in the spreadsheet.
You may also provide the Row Number using the Custom Variable Picker to use dynamic values.
Select the Starting Column and ending column:
You will select the same starting and ending columns to update a specific row..
To update the desired columns, select the starting and ending columns.
You can leave it blank if you do not wish to update a particular column.
FAQ
Q: How do I choose which worksheet to update with the "Update Specific Spreadsheet Row" action?
A: In the action setup, select the desired worksheet from the list of available worksheets in your spreadsheet.
Q: Can I use dynamic values for the row number when updating a specific row?
A: Yes, you can use the Custom Variable Picker to specify the row number dynamically, allowing for flexible updates based on variable data.
Q: What should I do if I want to update only certain columns in a row?
A: Select the starting and ending columns you wish to update. If you do not want to update a specific column, leave the column field blank.
Q: What happens if the Lookup Action does not return any rows?
A: The workflow will skip this step and proceed to the next one.