Insert Column

insert data into a column

Insert column data into the specified column of the sheet in the google sheets.

This activity can only be used after the Create GSuite Connection Activity

Input

• Credential: Object Variable A variable name that references the user credential to access the resources.
• SpreadSheet Id: String Argument The Id of the spreadsheet in which column data is to be inserted.
• Sheet Name: String Argument The name of the sheet in which column data is to be inserted.
• Starting Cell : String Argument The starting cell in which column data is to be inserted.
• Column Data: List of Object Variable The column data is to be inserted.

Options

• Insert Method: The method for inserting column values.

  • SHIFT - shift column after inserting the column data when the column to be inserted contain values.

  • REPLACE - replace the column values with the column data if the specified column contains values.