Skip to main content
Go to the Studio
Google Sheets

Create validation rule

Create validation rule

Creates a data validation rule (dropdown list or checkbox) on a cell range.


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.

Validation type​

Select the type of validation rule to create: Dropdown list (options) or Checkbox.

Enter the options that will be available in the dropdown list. This field is shown only when the Validation type is Dropdown list. Use the Add option button to include new items.

Advanced options​

Start row​

Enter the number of the first row of the range (optional).

Last row​

Enter the number of the last row of the range (optional, included in the range).

Start column​

Enter the number of the first column of the range (optional, 1 matches column A).

Last column​

Enter the number of the last column of the range (optional, included in the range).

Reject invalid entries​

Option to select Yes or No. When enabled, Google Sheets rejects values that do not meet the validation rule; when disabled, it only shows a warning but lets the value be saved. Default: No.

Show the dropdown arrow in the cells​

Option to select Yes or No to show the selection arrow in the range's cells. This field is shown only when the Validation type is Dropdown list. Default: Yes.

Returns​

This action has no returns.

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID and Tab name or ID fields are required.
  • When the Validation type is Dropdown list, at least one option must be given.
  • The Show the dropdown arrow in the cells field only applies when the Validation type is Dropdown list; for Checkbox, the rule is always created as a boolean condition.
  • When Start row, Last row, Start column and Last column are not given, the validation rule is applied to the whole tab.