Hide/Unhide Columns

Hide or Unhide the columns

Hide or Unhide specified columns in 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 columns are to be hidden or unhide.

• Sheet Name: String Argument The name of the sheet in which columns are to be hidden or unhide.

• Column Name: String Argument The name of the columns is to be hidden or unhide. If this property is set the Column Index property can be ignored.

• Column Index: Object Argument The index of the columns is to be hidden or unhide. If this property is set the Column Name property can be ignored.

• Number of Columns: Object Argument The number of columns is to be hidden or unhide.

• Hide:

  • True - columns are hidden

  • False - columns are visible