sheets_get_conditional_formatting
Read conditional formatting rules and alternating row/column colors from a Google Sheet. Formulas are normalized to English locale by default, with an option to retrieve raw formulas as returned by the API.
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. |