Add conditional format rule
The Google Sheets Add Conditional Format Rule tool allows users to create dynamic conditional formatting rules within their spreadsheets easily. It supports various conditions including color scales and custom formulas, enabling enhanced data visualization and analysis.
Features
- Supports multiple condition types like ONE_OF_LIST, NUMBER_GREATER, TEXT_CONTAINS, and more.
- Enables creation of boolean and gradient formatting rules for versatile styling.
- Offers customization of text formatting including bold, italic, and strikethrough.
- Allows precise specification of cell ranges, worksheets, and spreadsheet IDs for targeted formatting.
- Supports RGB color inputs and interpolation methods for detailed color scale control.
Benefits
- Improves data readability by visually highlighting important values or trends.
- Automates data analysis and visualization tasks, saving time and effort.
- Enhances decision making with clear, color-coded spreadsheet data.
- Customizable rules provide flexibility to meet various user needs and spreadsheet structures.
- Integrates seamlessly with Google Sheets via the Pipedream connector for efficient workflow automation.
Description
Create conditional formatting with color scales or custom formulas. See the documentation
IMPORTANT: The arguments have specific formats. Please follow the instructions below:
- conditionValues: Return JSON in this format: string[]
Parameters
14 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-conditional-format-rule, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-conditional-format-rule, 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-add-conditional-format-rule, propName: worksheetId. |
| rangerequired | string | The range of cells to format (e.g., |
| conditionTyperequired | enum | The type of data condition |
| conditionValuesrequired | string[] | Values for condition (e.g., color scales or custom formulas) |
| formattingTyperequired | enum | Choose between boolean condition or gradient color scale |
| rgbColor | object | The RGB color value (e.g., {"red": 1.0, "green": 0.5, "blue": 0.2}) |
| textFormat | object | The text format options |
| bold | boolean | Whether the text is bold |
| italic | boolean | Whether the text is italic |
| strikethrough | boolean | Whether the text is strikethrough |
| interpolationPointType | enum | The interpolation point type |
| indexrequired | integer | The zero-based index of the rule |