Googlesheets Create Spreadsheet Column

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_idinteger
  The 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_namestring
  The 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_indexinteger
  The 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_idstring

  必填
  The unique identifier of the Google Spreadsheet where the column will be created.
• response_rangesarray
  Limits the ranges of the spreadsheet to include in the response. Only used if includeSpreadsheetInResponse is true.
• inherit_from_beforeboolean
  If 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_databoolean
  If true, grid data will be included in the response (only used if includeSpreadsheetInResponse is true).
• include_spreadsheet_in_responseboolean
  If true, the updated spreadsheet will be included in the response. Defaults to true if not specified.

• data

  必填
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  必填
  Whether or not the action execution was successful or not

尚未关联经过验证的相关使用场景。