Definition and Usage
Deletes a specified column in Google Sheets. This command allows you to remove an entire column from your Google spreadsheet by specifying either the column letter (e.g., A, B, C) or column number (e.g., 1, 2, 3).
Parameter Values
Input parameters
Parameter | Description | Required | Options / Notes |
Google Sheet | Select the Google sheet to read | Yes | Select a previously connected Google Sheet |
Column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) | Yes | You can use positive numbers (1, 2, 3...), negative numbers (-1, -2...), or column letters (A, B, C...) |
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
You can use variables in the Column parameter by clicking on the {x} icon, which allows you to insert previously defined variables. This is useful when you want to dynamically specify which column to delete based on calculations or user input from earlier steps in your workflow.
Notes
Before using this command, ensure that you have properly connected to the Google Sheet.
Make sure you have the necessary permissions to modify the Google Sheet.
Deleting a column is irreversible; consider backing up your data before performing this operation.
When using column numbers, 1 refers to the first column (A), 2 refers to the second column (B), and so on.
Using -1 refers to the last column in the sheet, -2 refers to the second-to-last column, etc.
This action will delete the entire column including all data in that column across all rows.