Update formatting
The Google Sheets Update Formatting tool allows users to easily customize the appearance of cells in their spreadsheets by adjusting colors, font styles, alignment, and border styles. This powerful integration streamlines the process of formatting data directly within Google Sheets, enhancing readability and presentation.
Features
- Supports updating cell background and text colors with precise RGB values.
- Adjust text properties such as font size, bold, italic, and strikethrough.
- Control horizontal alignment of text, including left, center, and right options.
- Customize cell borders with multiple styles like dotted, dashed, solid, double, and more.
- Seamless integration with Google Drive and Shared Drives to update any worksheet within Google Sheets.
Benefits
- Enhances spreadsheet readability by enabling tailored cell formatting.
- Saves time by automating formatting tasks across multiple cells or ranges.
- Improves data presentation quality for reports and dashboards.
- Provides flexibility to match corporate branding or personal style guidelines.
- Reduces errors by allowing precise programmatic control over spreadsheet styling.
Description
Update the formatting of a cell in a spreadsheet. See the documentation
Parameters
21 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | The drive containing the worksheet to update. If you are connected with any Google Shared Drives, you can select it here. You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-formatting, propName: drive. |
| sheetIdrequired | string | The spreadsheet containing the worksheet to update You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-formatting, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-formatting, propName: worksheetId. |
| rangerequired | string | The range of cells to update. E.g., |
| backgroundColorRedValue | string | The amount of red in the color as a value in the interval [0, 1] |
| backgroundColorGreenValue | string | The amount of green in the color as a value in the interval [0, 1] |
| backgroundColorBlueValue | string | The amount of blue in the color as a value in the interval [0, 1] |
| textColorRedValue | string | The amount of red in the color as a value in the interval [0, 1] |
| textColorGreenValue | string | The amount of green in the color as a value in the interval [0, 1] |
| textColorBlueValue | string | The amount of blue in the color as a value in the interval [0, 1] |
| fontSize | integer | The size of the font |
| bold | boolean | Whether the font should be bold |
| italic | boolean | Whether the font should be italic |
| strikethrough | boolean | Whether the font should be strikethrough |
| horizontalAlignment | enum | The horizontal alignment of the text |
| topBorderStyle | enum | The style of the top border |
| bottomBorderStyle | enum | The style of the bottom border |
| leftBorderStyle | enum | The style of the left border |
| rightBorderStyle | enum | The style of the right border |
| innerHorizontalBorderStyle | enum | The style of the inner horizontal border |
| innerVerticalBorderStyle | enum | The style of the inner vertical border |