Delete column in Google Sheets
Delete a specific column in a sheet of a Google Sheets spreadsheet.
Common use cases
- Data Manipulation
Application
- Google Sheets
Inputs (what you have)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Spreadsheet link | The link (URL) to the Google spreadsheet | URL | Yes | https://drive.google.com/drive/folders/1Fy55AyJu9vqJ |
| Column name/letter Sheet name | Specify the name/letter of the column to be deleted (CASE sensitive) | Text | Yes | Column3 |
| Sheet name | Name of the sheet that contains the data | Text | No | Name_Sheet |
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
Statuses
| NAME | DESCRIPTION |
|---|---|
| Success | This status is selected if the column was successfully deleted on the specified Google Sheets spreadsheet |
| Unsuccessful | This status is selected in the event of the following scenarios: - The Google Sheets spreadsheet link does not exist - The Google Sheets spreadsheet cannot be edited - The column name/letter is not provided |
Requirements
- The provided Link to the Sheet must have editing permissions.
- All Drives and Sheets need to be shared with: googlewrkbots@wrk.com