Insert row in Google Sheets
Adds a row into a given row index in a Google Sheets spreadsheet
Common use cases
- Data Manipulation
Application
- Google Sheets
Inputs (what you have)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Google Sheets spreadsheet URL | The link (URL) to the Google spreadsheet | URL | Yes | https://docs.google.com/spreadsheets/d/1eit |
| Row Index | The new row will be inserted above this index | Integer | Yes | 2 |
| Sheet Name | The name of the sheet that contains the data | Text | No | Sheet_Name |
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 added onto the specified Google Sheets spreadsheet, and the provided link can be used to directly access the file |
| Unsuccessful | This status is selected in the event of the following scenarios: - The spreadsheet URL was not provided or is invalid- The spreadsheet is not accessible- The index of the row to be added 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