sheets_get_conditional_formatting
Retrieve conditional formatting rules and banded ranges from a Google Sheet. Optionally normalize formula separators from semicolons to commas.
Instructions
Read conditional formatting rules and banded ranges (alternating row/column colors) for a sheet. CF formulas are normalized to English locale (semicolons → commas) by default. Each rule with a formula includes a "_formulaLocaleRaw" field with the original unmodified formula. Set normalizeFormulas:false to get raw formulas as returned by the API.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheetName | Yes | Name of the sheet (tab) to inspect | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| normalizeFormulas | No | Default: true. Normalize formula separators to English locale (semicolons → commas). Each normalized rule includes "_formulaLocaleRaw" with the original formula. Set to false to get formulas exactly as returned by the Google Sheets API. |