Add, update, delete, or reorder conditional format rules on a Google Sheet. Use when you need to create, modify, or remove conditional formatting without manually building batchUpdate requests. Supports four operations: ADD (create new rule), UPDATE (replace existing rule), DELE…
ruleobjectConditional format rule specification.
indexintegerZero-based index for the operation. Required for UPDATE, DELETE, MOVE. Optional for ADD (defaults to end of list).
sheet_idRequiredintegerThe unique numeric identifier of the sheet/tab to modify (NOT a zero-based index). This is a specific ID assigned by Google Sheets when the sheet is created, not the position of the sheet. You MUST first call GOOGLESHEETS_GET_SPREADSHEET_INFO to retrieve the actual sheetId value…
new_indexintegerDestination index for MOVE operation. Required when operation is MOVE.
operationRequiredstringOperation type: ADD (add new rule), UPDATE (replace rule), DELETE (remove rule), MOVE (change rule order/index).
spreadsheet_idRequiredstringThe ID of the spreadsheet containing the sheet to modify. Found in the Google Sheets URL between '/d/' and '/edit'.
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.