The "Delete Specific Spreadsheet Row" action enables us to delete the contents of a specific row by specifying its row number. This action will clear the values in all of the columns of that row.
Navigation
Choose a worksheet:
Select a worksheet within your spreadsheet that you wish to delete a row of.
Insert Row Number:
Specify the row number that you wish to delete in the spreadsheet.
You may also provide the Row Number using the Custom Variable Picker to use dynamic values.
Note: When you use the "Delete Specific Spreadsheet" action, it clears the contents of the row, but it does not permanently remove the row itself. You may also provide the Row Number using the Custom Variable Picker to use dynamic values.
FAQ’s
1. What does the "Delete Specific Spreadsheet Row" action do?
This action clears the values in all columns of a specified row in a worksheet. It allows you to delete the contents of a row based on its row number without removing the row entirely.
2. How do I select which worksheet to delete a row from?
You can select the desired worksheet within your spreadsheet using the dropdown menu during the setup of this action. Ensure that you choose the correct worksheet before specifying the row number to avoid unintentional data deletion.
3. How do I specify which row to delete?
You need to enter the row number manually where the action should take place. Additionally, you can use the Custom Variable Picker to dynamically determine the row number, allowing for more flexibility in automated workflows.
4. What happens to the row after the "Delete Specific Spreadsheet Row" action is performed?
The contents of the row are cleared, but the row itself remains in the spreadsheet. This means that while the data is deleted, the row remains empty and will still occupy its position within the worksheet.
5. Can I use dynamic values to delete a specific row?
Yes, you can use the Custom Variable Picker to input a dynamic value for the row number. This is useful when the row number may vary depending on the conditions set in your workflow.
6. Does this action permanently delete the row from the spreadsheet?
No, the action only clears the contents of the row; it does not remove the row itself. The row remains empty and in place.