mcp-gsheets

MIT License

Overview InspectNew Schema Related Servers Reviews Score

sheets_add_conditional_formatting

Apply conditional formatting rules to a Google Sheet to automatically highlight cells based on specified criteria, enhancing data readability and analysis.

Instructions

Add conditional formatting rules to a Google Sheet

Input Schema

Name	Required	Description	Default
`rules`	Yes
`spreadsheetId`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "rules": {
      "_def": {
        "exactLength": null,
        "maxLength": null,
        "minLength": null,
        "type": {
          "_cached": null,
          "_def": {
            "catchall": {
              "_def": {
                "typeName": "ZodNever"
              },
              "~standard": {
                "vendor": "zod",
                "version": 1
              }
            },
            "typeName": "ZodObject",
            "unknownKeys": "strip"
          },
          "~standard": {
            "vendor": "zod",
            "version": 1
          }
        },
        "typeName": "ZodArray"
      },
      "~standard": {
        "vendor": "zod",
        "version": 1
      }
    },
    "spreadsheetId": {
      "_def": {
        "checks": [],
        "coerce": false,
        "typeName": "ZodString"
      },
      "~standard": {
        "vendor": "zod",
        "version": 1
      }
    }
  },
  "required": [
    "spreadsheetId",
    "rules"
  ],
  "type": "object"
}

You must be authenticated.

Other Tools from mcp-gsheets

Related Tools

sheets_format_cells
@freema/mcp-gsheets
smartsheet_bulk_update
@terilios/smartsheet-server
sheets_update_borders
@freema/mcp-gsheets
format_range
@haris-musa/excel-mcp-server
sheets_update_sheet_properties
@freema/mcp-gsheets
read_sheet_values
@taylorwilsdon/google_workspace_mcp

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/freema/mcp-gsheets'

If you have feedback or need assistance with the MCP directory API, please join our Discord server