Deleting a spreadsheet row using Lookup involves searching for a specific row in your spreadsheet based on a particular value using Lookup and then deleting all the values in that row.
To delete 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 "Delete Spreadsheet Row using Lookup" Action to clear the data in the row.
Note: If you want to use the "Delete 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 "Delete using lookup" action to clear the row data. Therefore, using the lookup action before delete using lookup is a necessary step in this process.
Select Lookup Action
Only the Lookup Actions added above this action will be listed for selection.
If a row is returned during a lookup, all the values associated with that row will be cleared.
Notes:
When you use the "Delete Spreadsheet Row" action, the row's contents are cleared, but the row itself is not permanently removed.
If the Lookup Action does not return any rows, the workflow skips this step and proceeds to the next one.
FAQ
How do I delete a specific row in a spreadsheet using Lookup?
First, use the "Lookup" action to search for the row based on a particular column value. After locating the desired row, use the "Delete Spreadsheet Row using Lookup" action to clear the data in that row.
What happens if the Lookup Action does not return any rows?
If the Lookup Action does not return any rows, the workflow will skip the delete step and proceed to the next action. Ensure your lookup criteria are correct and the data exists in the specified column.
Does the "Delete Spreadsheet Row" action remove the row entirely from the spreadsheet?
No, the "Delete Spreadsheet Row" action clears the row's contents but does not permanently remove the row itself. The row remains in the spreadsheet, but its data is deleted.