Definition and Usage
This command inserts blank column(s) at a specified position in a Google Sheets document. You can choose to insert columns to the right or left of a specified column position and determine the number of blank columns to insert.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Google Sheet | Select the Google sheet to read |
| Yes | Must be a valid Google Sheet connection |
Insert position | Select the direction to insert columns | Right, Left | Yes | Determines whether columns are inserted to the right or left of the specified column |
Column | Enter the column number (starting from 1 or A) where the blank column(s) will be inserted |
| Yes | Can be specified as a number (1, 2, 3) or letter (A, B, C) |
Number of columns | Specify how many columns to insert |
| Yes | Must be a positive integer |
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
Parameters marked with {x} icon support the use of variables. You can insert previously defined variables into these fields by clicking the {x} icon and selecting the desired variable from the dropdown menu. This is particularly useful when you need to dynamically determine column positions or the number of columns to insert based on values calculated earlier in your workflow.
Notes
Before using this command, ensure that you have established a valid connection to a Google Sheet.
The specified column must exist in the Google Sheet; otherwise, the command will result in an error.
If you're inserting multiple columns, make sure there is enough space in your sheet to accommodate them.
Column references in your sheet may change after inserting columns, which could affect other commands that reference specific columns.