Aident logoAident logo centerAident Loadout
Use CasesPricingDocs
ENStart Now
AppsGoogle Sheets ToolsGooglesheets Set Data Validation Rule
Google Sheets Tools

Googlesheets Set Data Validation Rule

Tool to set or clear data validation rules (including dropdowns) on a range in Google Sheets. Use when you need to apply dropdown lists, range-based dropdowns, or custom formula validation to cells.

Write actionRisk level 2 of 5OAuth connection
Use Googlesheets Set Data Validation Rule

Pricing and limits

Aident logo

Product

Aident LoadoutAident Playbook EditorOpen-CUAK

About

AppsSkillsUse CasesDocsBlogPricingDownloadsPrivacy PolicyTerms of Service

Alternatives

vs Composiovs Zapier
llms.txtGet an AI summary of Aident LoadoutSummarize with ChatGPTSummarize with ClaudeSummarize with GeminiSummarize with Perplexity

© Aident Labs, 2024-2026

Pricing
Free
Unified payment
Not currently supported

Inputs

  • modestring
    Required
    Operation mode: 'SET' applies a validation rule to the range, 'CLEAR' removes any existing validation from the range.
  • strictboolean
    Whether to reject invalid data (true) or show a warning (false). Default is true.
  • valuesarray
    List of allowed values for dropdown. Required when validation_type='ONE_OF_LIST'. Each item becomes a dropdown option.
  • formulastring
    Custom formula for validation. Required when validation_type='CUSTOM_FORMULA'. Formula should evaluate to TRUE/FALSE. Example: '=A1>10'.
  • sheet_idinteger
    Required
    The unique sheet ID (numeric identifier) where the validation rule will be applied. The first sheet created in a spreadsheet typically has ID 0, while additional sheets get unique IDs (e.g., 1534097477). If a sheet is deleted, its ID is never reused - so if the original first sh…
  • end_row_indexinteger
    Required
    Ending row index (0-based, exclusive) for the validation range. To apply to row 1 only, use start_row_index=0 and end_row_index=1.
  • input_messagestring
    Optional message shown to the user when they select the cell. Helpful hint about what values are expected.
  • show_custom_uiboolean
    Whether to show a dropdown UI for list-based validation. Default is true. Set to true for dropdown lists.
  • spreadsheet_idstring
    Required
    The unique identifier of the Google Sheets spreadsheet. Can be found in the spreadsheet URL between '/d/' and '/edit'.
  • source_range_a1string
    Source range in A1 notation for dropdown values. Required when validation_type='ONE_OF_RANGE'. Example: 'Sheet1!A1:A10' or 'A1:A10'.
  • start_row_indexinteger
    Required
    Starting row index (0-based, inclusive) for the validation range. Row 1 is index 0.
  • validation_typestring
    Type of validation rule to apply. Required when mode='SET'. Dropdown types: 'ONE_OF_LIST' (dropdown from list), 'ONE_OF_RANGE' (dropdown from range). Number validations: 'NUMBER_GREATER', 'NUMBER_GREATER_THAN_EQ', 'NUMBER_LESS', 'NUMBER_LESS_THAN_EQ', 'NUMBER_EQ', 'NUMBER_NOT_EQ…

Observable output

  • data
    Required
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    Required
    Whether or not the action execution was successful or not

Skills that use this Action

Related use cases

No verified related use cases are linked yet.

Official source

Provider source

Skills that use this Action

No published Skills explicitly reference this Action yet.