Delete Column
Deletes a specific column from a Google Spreadsheet.
Common Properties
- Name - The custom name of the node.
- Color - The custom color of the node.
- Delay Before (sec) - Waits in seconds before executing the node.
- Delay After (sec) - Waits in seconds after executing node.
- Continue On Error - Automation will continue regardless of any error. The default value is false.
info
If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.
Inputs
- Spread Sheet Id - The ID of the Google Spreadsheet from which to delete the column.
- Column - The column letter (e.g., "A", "B", "Z") to be deleted.
Options
No additional options available for this node.
Output
No output variables for this node.
How It Works
The Delete Column node removes a specific column from a Google Spreadsheet. When executed, the node:
- Validates the provided Spreadsheet Id and Column inputs
- Connects to the Google Spreadsheet using the provided ID
- Converts the column letter to a numeric index
- Constructs a delete dimension request for the specified column
- Sends the delete request to the Google Sheets API
- Returns any errors encountered during the process
Requirements
- A valid Google Spreadsheet ID
- A valid column letter reference
- Proper Google Sheets API authentication and permissions
Error Handling
The node will return specific errors in the following cases:
- Empty or invalid Spreadsheet Id
- Empty or invalid Column reference
- Google Sheets API authentication or permission errors
- Network or connectivity issues with Google Sheets API
Usage Notes
- The Spreadsheet Id can be obtained from the URL of your Google Spreadsheet
- Column references should be a single letter (e.g., "A", "B", "Z")
- Deleting a column will shift all columns to the right one position to the left
- This operation cannot be undone, so use with caution
- Ensure your Google account has proper permissions to modify the target spreadsheet