Delete conditional format rule
The Google Sheets Delete Conditional Format Rule tool enables users to efficiently remove specific conditional formatting rules from their spreadsheets by index. It integrates seamlessly with Google Sheets via Pipedream, simplifying spreadsheet management and customization.
Features
- Remove conditional formatting rules by specifying the rule index for precise control.
- Supports selection of spreadsheets from My Drive or Shared Drives.
- Allows specification of worksheet by ID for targeted rule deletion.
- Built on Google Sheets API for reliable and fast operation.
- Includes detailed documentation and integration capabilities via Pipedream.
Benefits
- Streamlines spreadsheet formatting management by removing unwanted conditional rules.
- Improves data visibility and presentation by clearing outdated or incorrect formats.
- Saves time and reduces manual errors compared to manual rule deletion.
- Enhances automation workflows when managing large or multiple spreadsheets.
- Offers flexibility with support for shared drives and direct spreadsheet ID inputs.
Description
Remove conditional formatting rule by index. See the documentation
Parameters
4 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-delete-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-delete-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-delete-conditional-format-rule, propName: worksheetId. |
| indexrequired | integer | The zero-based index of the rule |