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.

Last updated