Googlesheets Get Data Validation Rules

Tool to extract data validation rules from a Google Sheets spreadsheet. Use when you need to understand dropdown lists, allowed values, custom formulas, or other validation constraints for cells.

价格

免费操作

统一支付

暂不支持

• rangesarray
  Optional list of A1 ranges to scan. If omitted, the entire sheet(s) will be scanned. WARNING: Scanning entire large sheets may be slow.
• sheetIdinteger
  Optional sheet ID to filter by. If omitted, all sheets will be scanned.
• sheetTitlestring
  Optional sheet title to filter by. If omitted, all sheets will be scanned.
• includeEmptyboolean
  If true, include cells without validation rules in the output. Default is false.
• spreadsheetIdstring

  必填
  The ID of the spreadsheet to request.

• data

  必填
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  必填
  Whether or not the action execution was successful or not

尚未关联经过验证的相关使用场景。