Skip to main content
Go to the Studio
Google Sheets

Set visibility

Set visibility

Hides or shows a tab, or a range of rows/columns.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Tab name or ID​

Enter the tab name (e.g. Página1) or, using the number type, the numeric ID of the tab.

What to hide/show​

Select the target of the action: The whole tab, Rows or Columns. Default: The whole tab.

Hide (instead of show)​

Select Yes to hide the selected target, or No to show it (make it visible). Default: Yes (hide).

Start position (1 = first)​

Visible only when What to hide/show is Rows or Columns. Enter the start position of the row or column whose visibility changes, counting 1 as the tab's first row (or column).

Advanced options​

Visible only when What to hide/show is Rows or Columns.

How many (default: 1)​

Optional. Enter how many rows or columns, starting from the start position, will have their visibility changed. When not given, the default is 1.

Returns​

This action has no returns.

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID and Tab name or ID fields are required.
  • When What to hide/show is Rows or Columns, the Start position field is required too.
  • When What to hide/show is The whole tab, the start position and amount fields do not apply.
  • The Start position is given 1-based (1 = first row or column); internally the action converts that value to the 0-based index the Google Sheets API uses.
  • How many is optional and, when not given, takes the default value of 1 (that is, it only changes the visibility of the row/column at the start position).
  • If the given tab is not found in the spreadsheet, the robot stops with an error.