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