Delete rows in Google Sheets
Deletes a range of rows from a sheet of a Google Sheets spreadsheet.
Common use cases
- Data and Content Manipulation
Application
- Google Sheets
Inputs (what you have)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Spreadsheet link | The link to the Google spreadsheet | URL | Yes | https://drive.google.com/drive/folders/1Fy55AyJu9vqJ |
| Range start | The row number at the beginning of the range to be deleted | Integer | Yes | 1 |
| Range end | The row number at the end of the range to be deleted. If desired to delete a single row enter the same number from the 'Range start row number' input | Integer | Yes | 4 |
| Sheet Name | The name of the sheet that contains the data | Text | No | Sheet1 |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data Library. These variables in the Data Library are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
- N/A
Outcomes
| NAME | DESCRIPTION |
|---|---|
| Success | This status is selected if the row was successfully deleted in the specified Google Sheets spreadsheet |
| Unsuccessful | This status is selected in the event of the following scenarios:- The spreadsheet url is not provided or is invalid- The spreadsheet is not accessible (no access allowed)- The index of the row to be deleted is not a valid number |
Requirements
- The provided Link to the Sheet must have editing permissions.
- All Drives and Sheets need to be shared with:
googlewrkbots@wrk.com