Add/Delete Columns

Add or Delete the columns

Add or Delete the specified number of columns of the sheet from 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 is added or deleted.

• Sheet Name: String Argument The name of the sheet in which column is added or deleted.

• Column Name: String Argument The name of the column is to be added or deleted. If this property is set the Column Index property can be ignored.

• Column Index: Object Argument The name of the column is to be added or deleted. If this property is set the Column Name property can be ignored.

• Number of Columns: Object Argument The number of columns is to be added or deleted.

Options

• Mode: The mode for add delete column operation.

  • INSERT - Insert the columns into the google sheet.

  • DELETE - Delete the columns from the google sheet.