Google Sheets

gs_add_protected_range

Protect a range of cells from editing. Optionally allow specific editors or show a warning instead of blocking.

Remote node2flow/google-sheets

Other tools also called gs_add_protected_range? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "editors": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Email addresses of users allowed to edit the protected range"
    },
    "sheet_id": {
      "type": "number",
      "description": "The numeric sheet ID"
    },
    "description": {
      "type": "string",
      "description": "Description explaining why the range is protected"
    },
    "warning_only": {
      "type": "boolean",
      "description": "If true, shows a warning but allows editing (default: false, blocks editing)"
    },
    "end_row_index": {
      "type": "number",
      "description": "End row (0-based exclusive)"
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "start_row_index": {
      "type": "number",
      "description": "Start row (0-based inclusive)"
    },
    "end_column_index": {
      "type": "number",
      "description": "End column (0-based exclusive)"
    },
    "start_column_index": {
      "type": "number",
      "description": "Start column (0-based inclusive)"
    }
  }
}