Definition and Usage
Delete row from Google Sheet allows you to remove a specified row from a Google Sheets document. This command is useful when you need to clean up data or remove outdated information from your spreadsheets programmatically.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Google Sheet | Select the Google sheet to read |
| Yes | Must be a valid Google Sheet connection |
Row | Specify the row number. Use 1 for the first row, or -1 for the last row | Any integer | Yes | Positive numbers count from the top, negative numbers count from the bottom |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
The Row parameter supports variable insertion, as indicated by the {x} icon in the interface. You can use variables to dynamically determine which row to delete based on previous calculations or conditions in your workflow. For example, you might use a counter variable to delete rows in sequence, or use the result of a search operation to target specific rows.
Notes
Before using this command, ensure you have properly authenticated and connected to the Google Sheets API.
Make sure the specified row exists in the sheet; attempting to delete a non-existent row will result in an error.
Be careful when deleting rows as this action cannot be undone through the RPA workflow.
When using negative indices (like -1 for the last row), verify that your sheet contains data to avoid unexpected behavior.
This command will shift up all rows below the deleted row, changing their indices.