Creates a new column in a Google Spreadsheet. Specify the target sheet using sheet_id (numeric) or sheet_name (text). If neither is provided, defaults to the first sheet (sheet_id=0).
sheet_idintegerThe numeric identifier of the specific sheet (tab) within the spreadsheet. Defaults to 0 (the first sheet) if neither sheet_id nor sheet_name is provided. Use GOOGLESHEETS_GET_SHEET_NAMES or GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE to obtain the sheet_id from a sheet name.
sheet_namestringThe name (title) of the sheet/tab where the column will be added. If provided, the action will look up the sheet_id automatically. If both sheet_id and sheet_name are provided, sheet_id takes precedence.
insert_indexintegerThe 0-based index at which the new column will be inserted. For example, an index of 0 inserts the column before the current first column (A), and an index of 1 inserts it between the current columns A and B.
spreadsheet_idRequiredstringThe unique identifier of the Google Spreadsheet where the column will be created.
response_rangesarrayLimits the ranges of the spreadsheet to include in the response. Only used if includeSpreadsheetInResponse is true.
inherit_from_beforebooleanIf true, the new column inherits properties (e.g., formatting, width) from the column immediately to its left (the preceding column). If false (default), it inherits from the column immediately to its right (the succeeding column). This is ignored if there is no respective prece…
response_include_grid_databooleanIf true, grid data will be included in the response (only used if includeSpreadsheetInResponse is true).
include_spreadsheet_in_responsebooleanIf true, the updated spreadsheet will be included in the response. Defaults to true if not specified.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.