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.
rangesarrayOptional list of A1 ranges to scan. If omitted, the entire sheet(s) will be scanned. WARNING: Scanning entire large sheets may be slow.
sheetIdintegerOptional sheet ID to filter by. If omitted, all sheets will be scanned.
sheetTitlestringOptional sheet title to filter by. If omitted, all sheets will be scanned.
includeEmptybooleanIf true, include cells without validation rules in the output. Default is false.
spreadsheetIdRequiredstringThe ID of the spreadsheet to request.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.