sheets_get_sheet_formatting
Retrieve formatting details for a Google Sheets range, including colors, fonts, alignment, and number formats. Optionally use effective format to get resolved inherited styles for precise analysis or conditional logic.
Instructions
Read cell formatting (background color, text color, font family, font size, bold, italic, horizontal/vertical alignment, wrapStrategy, textRotation, numberFormat) for a range. Returns a 2D array matching the requested range rows/columns. Set useEffectiveFormat=true to get the resolved/inherited format instead of the user-entered one.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | Range in A1 notation, MUST include sheet name, e.g. "Dyspozycje!A1:Z85" | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| useEffectiveFormat | No | If true, returns effectiveFormat (includes inherited/default styles). Default: false (userEnteredFormat only). |