sheets_get_sheet_formatting
Retrieve cell formatting (background, text color, font, alignment, wrap, rotation, number format) for a specified range in Google Sheets. Optionally get effective (inherited) or user-entered format.
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). |