Google Sheets

Google Sheets MCP Server for Cloudflare Workers

Available Tools

67 tools available in the Google Sheets MCP server. Each tool can be called by AI assistants to perform specific actions.

googlesheets_add_basic_chart

Add a basic chart (bar, line, area, column, scatter, combo, stepped area).

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: Sheet to place the chart on (required)
chartType: Type of chart (required)
title: Chart title
domainRange: Range for X-axis data (required)
seriesRanges: Array of ranges for Y-axis data (required)
legendPosition: Position of the legend
anchorRowIndex: Row to anchor the chart
anchorColumnIndex: Column to anchor the chart

Returns: The chart ID.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId"
  ],
  "properties": {
    "title": {
      "type": "string",
      "description": "Chart title"
    },
    "sheetId": {
      "type": "number",
      "description": "Sheet ID for the chart"
    },
    "headerCount": {
      "type": "number",
      "default": 1,
      "description": "Number of header rows"
    },
    "widthPixels": {
      "type": "number",
      "default": 600
    },
    "heightPixels": {
      "type": "number",
      "default": 400
    },
    "seriesRanges": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "default": "BOTTOM_LEGEND",
      "description": "Ranges for Y-axis series"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "anchorRowIndex": {
      "type": "number",
      "default": 0
    },
    "anchorColumnIndex": {
      "type": "number",
      "default": 0
    }
  }
}

googlesheets_add_pie_chart

Add a pie chart.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: Sheet to place the chart on (required)
title: Chart title
domainRange: Range for labels (required)
seriesRange: Range for values (required)
legendPosition: Position of the legend
threeDimensional: Show as 3D
pieHole: Size of the hole (0-1) for donut chart

Returns: The chart ID.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId"
  ],
  "properties": {
    "title": {
      "type": "string",
      "default": "RIGHT_LEGEND",
      "description": "Chart title"
    },
    "pieHole": {
      "type": "number",
      "maximum": 1,
      "minimum": 0,
      "description": "Hole size for donut chart"
    },
    "sheetId": {
      "type": "number",
      "description": "Sheet ID for the chart"
    },
    "widthPixels": {
      "type": "number",
      "default": 600
    },
    "heightPixels": {
      "type": "number"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "anchorRowIndex": {
      "type": "number",
      "default": 0
    },
    "threeDimensional": {
      "type": "boolean",
      "default": false
    },
    "anchorColumnIndex": {
      "type": "number",
      "default": 0
    }
  }
}

googlesheets_delete_chart

Delete a chart.

Args:

spreadsheetId: The spreadsheet ID (required)
chartId: The chart ID (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "chartId"
  ],
  "properties": {
    "chartId": {
      "type": "number",
      "description": "Chart ID to delete"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_sort_range

Sort a range of cells.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range to sort (required)
sortSpecs: Array of sort specifications (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_set_basic_filter

Add a basic filter to a sheet.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range for the filter (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_clear_basic_filter

Remove the basic filter from a sheet.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_add_filter_view

Create a filter view.

Args:

spreadsheetId: The spreadsheet ID (required)
title: Title for the filter view (required)
range: Grid range (required)
sortSpecs: Optional sort specifications
criteria: Optional filter criteria by column

Returns: The filter view ID.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "title": {
      "type": "string",
      "description": "Filter view title"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_delete_filter_view

Delete a filter view.

Args:

spreadsheetId: The spreadsheet ID (required)
filterViewId: The filter view ID (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "filterViewId"
  ],
  "properties": {
    "filterViewId": {
      "type": "number",
      "description": "Filter view ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_set_data_validation

Set data validation rules for a range.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range (required)
conditionType: Validation condition type (required)
conditionValues: Values for the condition
inputMessage: Help message shown when cell is selected
strict: Whether to reject invalid input

Returns: Confirmation.

{
  "type": "object",
  "properties": {
    "strict": {
      "type": "boolean",
      "default": true,
      "description": "Reject invalid input"
    },
    "inputMessage": {
      "type": "string",
      "description": "Help message"
    },
    "showCustomUi": {
      "type": "boolean",
      "default": true,
      "description": "Show dropdown for ONE_OF_LIST"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_delete_dimension_group

Delete row/column grouping (outline).

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
dimension: ROWS or COLUMNS (required)
startIndex: Start index (required)
endIndex: End index (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dimension",
    "startIndex",
    "endIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End index"
    },
    "dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "ROWS or COLUMNS"
    },
    "startIndex": {
      "type": "number",
      "description": "Start index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_insert_dimension

Insert rows or columns.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
dimension: ROWS or COLUMNS (required)
startIndex: Start index (0-indexed) (required)
endIndex: End index (exclusive) (required)
inheritFromBefore: Inherit formatting from before (default: false)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dimension",
    "startIndex",
    "endIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End index (exclusive)"
    },
    "dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "ROWS or COLUMNS"
    },
    "startIndex": {
      "type": "number",
      "description": "Start index (0-indexed)"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "inheritFromBefore": {
      "type": "boolean"
    }
  }
}

googlesheets_find_replace

Find and replace text in a spreadsheet.

Args:

spreadsheetId: The spreadsheet ID (required)
find: Text to find (required)
replacement: Replacement text (required)
matchCase: Case-sensitive search
matchEntireCell: Match entire cell contents
searchByRegex: Use regular expressions
includeFormulas: Search in formulas
range: Limit to specific range
sheetId: Limit to specific sheet
allSheets: Search all sheets

Returns: Statistics on changes made.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "find",
    "replacement"
  ],
  "properties": {
    "find": {
      "type": "string",
      "description": "Text to find"
    },
    "sheetId": {
      "type": "number"
    },
    "allSheets": {
      "type": "boolean"
    },
    "matchCase": {
      "type": "boolean",
      "default": false
    },
    "replacement": {
      "type": "string",
      "description": "Replacement text"
    },
    "searchByRegex": {
      "type": "boolean",
      "default": false
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "includeFormulas": {
      "type": "boolean",
      "default": "false), range: z }) .optional("
    },
    "matchEntireCell": {
      "type": "boolean",
      "default": false
    }
  }
}

googlesheets_copy_paste

Copy and paste data from one range to another.

Args:

spreadsheetId: The spreadsheet ID (required)
source: Source range (required)
destination: Destination range (required)
pasteType: What to paste
pasteOrientation: NORMAL or TRANSPOSE

Returns: Confirmation.

{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "default": "PASTE_NORMAL",
      "description": "The spreadsheet ID"
    },
    "pasteOrientation": {
      "enum": [
        "NORMAL",
        "TRANSPOSE"
      ],
      "type": "string"
    }
  }
}

googlesheets_cut_paste

Cut and paste data from one range to another.

Args:

spreadsheetId: The spreadsheet ID (required)
source: Source range (required)
destination: Destination cell (sheetId, rowIndex, columnIndex) (required)
pasteType: What to paste

Returns: Confirmation.

{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_delete_duplicates

Delete duplicate rows in a range.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range (required)
comparisonColumns: Columns to compare for duplicates (optional, all if not specified)

Returns: Number of duplicates removed.

{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_randomize_range

Randomize the order of rows in a range.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_text_to_columns

Split text in cells into multiple columns.

Args:

spreadsheetId: The spreadsheet ID (required)
source: Source range (required)
delimiterType: Type of delimiter (required)
delimiter: Custom delimiter (if delimiterType is CUSTOM)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "delimiter": {
      "type": "string",
      "description": "Custom delimiter"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_get_developer_metadata

Get developer metadata by ID.

Args:

spreadsheetId: The spreadsheet ID (required)
metadataId: The metadata ID (required)

Returns: The developer metadata.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "metadataId"
  ],
  "properties": {
    "metadataId": {
      "type": "number",
      "description": "Metadata ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_search_developer_metadata

Search for developer metadata.

Args:

spreadsheetId: The spreadsheet ID (required)
metadataKey: Key to search for
metadataValue: Value to search for
locationType: ROW, COLUMN, SHEET, or SPREADSHEET
visibility: DOCUMENT or PROJECT

Returns: Matching metadata entries.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "metadataId": {
      "type": "number",
      "description": "Specific metadata ID"
    },
    "visibility": {
      "enum": [
        "DOCUMENT",
        "PROJECT"
      ],
      "type": "string"
    },
    "metadataKey": {
      "type": "string",
      "description": "Key to search"
    },
    "locationType": {
      "enum": [
        "ROW",
        "COLUMN",
        "SHEET",
        "SPREADSHEET"
      ],
      "type": "string"
    },
    "metadataValue": {
      "type": "string",
      "description": "Value to search"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_format_cells

Apply formatting to cells in a range.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range with sheetId and optional row/column indices (required)
backgroundColor: RGB color object for background
textFormat: Text formatting options (foregroundColor, fontFamily, fontSize, bold, italic, etc.)
horizontalAlignment: LEFT, CENTER, or RIGHT
verticalAlignment: TOP, MIDDLE, or BOTTOM
wrapStrategy: OVERFLOW_CELL, CLIP, or WRAP
numberFormat: Number format type and pattern

Returns: Confirmation of formatting applied.

{
  "type": "object",
  "properties": {
    "wrapStrategy": {
      "enum": [
        "OVERFLOW_CELL",
        "CLIP",
        "WRAP"
      ],
      "type": "string"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "verticalAlignment": {
      "enum": [
        "TOP",
        "MIDDLE",
        "BOTTOM"
      ],
      "type": "string"
    },
    "horizontalAlignment": {
      "enum": [
        "LEFT",
        "CENTER",
        "RIGHT"
      ],
      "type": "string"
    }
  }
}

googlesheets_merge_cells

Merge cells in a range.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range to merge (required)
mergeType: MERGE_ALL, MERGE_COLUMNS, or MERGE_ROWS (default: MERGE_ALL)

Returns: Confirmation of merge.

{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_create_developer_metadata

Create developer metadata.

Args:

spreadsheetId: The spreadsheet ID (required)
metadataKey: Key for the metadata (required)
metadataValue: Value for the metadata
locationType: ROW, COLUMN, SHEET, or SPREADSHEET (required)
visibility: DOCUMENT or PROJECT (default: DOCUMENT)
sheetId: Sheet ID (for SHEET location)
dimensionRange: Range for ROW/COLUMN locations

Returns: The created metadata.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "metadataKey",
    "locationType"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "Sheet ID for SHEET location"
    },
    "visibility": {
      "enum": [
        "DOCUMENT",
        "PROJECT"
      ],
      "type": "string",
      "default": "DOCUMENT"
    },
    "metadataKey": {
      "type": "string",
      "description": "Metadata key"
    },
    "locationType": {
      "enum": [
        "ROW",
        "COLUMN",
        "SHEET",
        "SPREADSHEET"
      ],
      "type": "string",
      "description": "Location type"
    },
    "dimensionType": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "Dimension type"
    },
    "metadataValue": {
      "type": "string",
      "description": "Metadata value"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "dimensionSheetId": {
      "type": "number",
      "description": "Sheet ID for dimension range"
    },
    "dimensionEndIndex": {
      "type": "number",
      "description": "End index"
    },
    "dimensionStartIndex": {
      "type": "number",
      "description": "Start index"
    }
  }
}

googlesheets_delete_developer_metadata

Delete developer metadata.

Args:

spreadsheetId: The spreadsheet ID (required)
metadataKey: Key to delete
metadataValue: Value to match
metadataId: Specific metadata ID to delete
visibility: DOCUMENT or PROJECT

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "metadataId": {
      "type": "number",
      "description": "Specific metadata ID"
    },
    "visibility": {
      "enum": [
        "DOCUMENT",
        "PROJECT"
      ],
      "type": "string"
    },
    "metadataKey": {
      "type": "string",
      "description": "Key to delete"
    },
    "metadataValue": {
      "type": "string",
      "description": "Value to match"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_delete_dimension

Delete rows or columns.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
dimension: ROWS or COLUMNS (required)
startIndex: Start index (0-indexed) (required)
endIndex: End index (exclusive) (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dimension",
    "startIndex",
    "endIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End index"
    },
    "dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "ROWS or COLUMNS"
    },
    "startIndex": {
      "type": "number",
      "description": "Start index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_move_dimension

Move rows or columns to a new position.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
dimension: ROWS or COLUMNS (required)
startIndex: Start index of source (required)
endIndex: End index of source (required)
destinationIndex: Destination index (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dimension",
    "startIndex",
    "endIndex",
    "destinationIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End index"
    },
    "dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "ROWS or COLUMNS"
    },
    "startIndex": {
      "type": "number",
      "description": "Start index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "destinationIndex": {
      "type": "number",
      "description": "Destination index"
    }
  }
}

googlesheets_append_dimension

Append rows or columns to the end of a sheet.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
dimension: ROWS or COLUMNS (required)
length: Number of rows/columns to append (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dimension",
    "length"
  ],
  "properties": {
    "length": {
      "type": "number",
      "description": "Number to append"
    },
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "ROWS or COLUMNS"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_hide_dimension

Hide rows or columns.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
dimension: ROWS or COLUMNS (required)
startIndex: Start index (required)
endIndex: End index (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dimension",
    "startIndex",
    "endIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End index"
    },
    "dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "ROWS or COLUMNS"
    },
    "startIndex": {
      "type": "number",
      "description": "Start index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_show_dimension

Show (unhide) rows or columns.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
dimension: ROWS or COLUMNS (required)
startIndex: Start index (required)
endIndex: End index (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dimension",
    "startIndex",
    "endIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End index"
    },
    "dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "ROWS or COLUMNS"
    },
    "startIndex": {
      "type": "number",
      "description": "Start index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_add_dimension_group

Add row/column grouping (outline).

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
dimension: ROWS or COLUMNS (required)
startIndex: Start index (required)
endIndex: End index (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dimension",
    "startIndex",
    "endIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End index"
    },
    "dimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "ROWS or COLUMNS"
    },
    "startIndex": {
      "type": "number",
      "description": "Start index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_unmerge_cells

Unmerge previously merged cells in a range.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range to unmerge (required)

Returns: Confirmation of unmerge.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_update_borders

Update borders for a range.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range (required)
top/bottom/left/right/innerHorizontal/innerVertical: Border objects with style and color

Returns: Confirmation of border update.

{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_auto_resize_columns

Auto-resize columns to fit content.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
startIndex: Start column index (0-indexed) (required)
endIndex: End column index (exclusive) (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "startIndex",
    "endIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End column index"
    },
    "startIndex": {
      "type": "number",
      "description": "Start column index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_auto_resize_rows

Auto-resize rows to fit content.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
startIndex: Start row index (0-indexed) (required)
endIndex: End row index (exclusive) (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "startIndex",
    "endIndex"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End row index"
    },
    "startIndex": {
      "type": "number",
      "description": "Start row index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_set_column_width

Set a specific width for columns.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
startIndex: Start column index (required)
endIndex: End column index (required)
pixelSize: Width in pixels (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "startIndex",
    "endIndex",
    "pixelSize"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End column index"
    },
    "pixelSize": {
      "type": "number",
      "description": "Width in pixels"
    },
    "startIndex": {
      "type": "number",
      "description": "Start column index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_set_row_height

Set a specific height for rows.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
startIndex: Start row index (required)
endIndex: End row index (required)
pixelSize: Height in pixels (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "startIndex",
    "endIndex",
    "pixelSize"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "endIndex": {
      "type": "number",
      "description": "End row index"
    },
    "pixelSize": {
      "type": "number",
      "description": "Height in pixels"
    },
    "startIndex": {
      "type": "number",
      "description": "Start row index"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_add_banded_range

Add alternating colors (banding) to a range.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range (required)
headerColor: Color for header row
firstBandColor: Color for odd rows
secondBandColor: Color for even rows
footerColor: Color for footer row

Returns: The banded range ID.

{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_delete_banded_range

Remove alternating colors (banding) from a range.

Args:

spreadsheetId: The spreadsheet ID (required)
bandedRangeId: The banded range ID (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "bandedRangeId"
  ],
  "properties": {
    "bandedRangeId": {
      "type": "number",
      "description": "The banded range ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_add_conditional_format

Add a conditional formatting rule.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
ranges: Array of grid ranges to apply the rule (required)
ruleType: 'boolean' or 'gradient' (required)
For boolean rules: condition type, values, and format
For gradient rules: minpoint, midpoint, maxpoint with colors and types

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "ranges",
    "ruleType"
  ],
  "properties": {
    "index": {
      "type": "number",
      "description": "Position to insert the rule"
    },
    "ranges": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Ranges to apply rule"
    },
    "maxType": {
      "enum": [
        "MAX",
        "NUMBER",
        "PERCENT",
        "PERCENTILE"
      ],
      "type": "string"
    },
    "midType": {
      "enum": [
        "NUMBER",
        "PERCENT",
        "PERCENTILE"
      ],
      "type": "string"
    },
    "minType": {
      "enum": [
        "MIN",
        "NUMBER",
        "PERCENT",
        "PERCENTILE"
      ],
      "type": "string"
    },
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "maxValue": {
      "type": "string"
    },
    "midValue": {
      "type": "string"
    },
    "minValue": {
      "type": "string"
    },
    "ruleType": {
      "enum": [
        "boolean",
        "gradient"
      ],
      "type": "string",
      "description": "Rule type"
    },
    "formatBold": {
      "type": "boolean"
    },
    "formatItalic": {
      "type": "boolean"
    },
    "conditionType": {
      "type": "string",
      "description": "Condition type (e.g., NUMBER_GREATER, TEXT_CONTAINS)"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_delete_conditional_format

Delete a conditional formatting rule.

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: The sheet ID (required)
index: The index of the rule to delete (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "index"
  ],
  "properties": {
    "index": {
      "type": "number",
      "description": "Rule index to delete"
    },
    "sheetId": {
      "type": "number",
      "description": "The sheet ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_trim_whitespace

Trim leading and trailing whitespace from cells.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range (required)

Returns: Number of cells changed.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_add_named_range

Create a named range.

Args:

spreadsheetId: The spreadsheet ID (required)
name: Name for the range (required)
range: Grid range (required)

Returns: The named range ID.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "name"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "Name for the range"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_update_named_range

Update an existing named range.

Args:

spreadsheetId: The spreadsheet ID (required)
namedRangeId: The named range ID (required)
name: New name for the range
range: New grid range

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "namedRangeId"
  ],
  "properties": {
    "name": {
      "type": "string",
      "description": "New name"
    },
    "namedRangeId": {
      "type": "string",
      "description": "Named range ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_delete_named_range

Delete a named range.

Args:

spreadsheetId: The spreadsheet ID (required)
namedRangeId: The named range ID (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "namedRangeId"
  ],
  "properties": {
    "namedRangeId": {
      "type": "string",
      "description": "Named range ID"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_batch_clear_values

Clear values from multiple ranges.

Args:

spreadsheetId: The ID of the spreadsheet (required)
ranges: Array of A1 notation ranges to clear (required)

Returns: The cleared ranges.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "ranges"
  ],
  "properties": {
    "ranges": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Array of ranges to clear"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_add_protected_range

Protect a range from editing.

Args:

spreadsheetId: The spreadsheet ID (required)
range: Grid range to protect (required)
description: Description of the protection
warningOnly: Show warning but allow edits
users: Array of user emails who can edit
groups: Array of group emails who can edit
domainUsersCanEdit: Allow domain users to edit

Returns: The protected range ID.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "users": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "User emails who can edit"
    },
    "groups": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Group emails who can edit"
    },
    "description": {
      "type": "string"
    },
    "warningOnly": {
      "type": "boolean",
      "default": false
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "domainUsersCanEdit": {
      "type": "boolean"
    }
  }
}

googlesheets_delete_protected_range

Remove protection from a range.

Args:

spreadsheetId: The spreadsheet ID (required)
protectedRangeId: The protected range ID (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "protectedRangeId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "protectedRangeId": {
      "type": "number",
      "description": "Protected range ID"
    }
  }
}

googlesheets_add_sheet

Add a new sheet to a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
title: Title of the new sheet (required)
rowCount: Number of rows (default: 1000)
columnCount: Number of columns (default: 26)
index: Position to insert the sheet
tabColorRed: Red component of tab color (0-1)
tabColorGreen: Green component of tab color (0-1)
tabColorBlue: Blue component of tab color (0-1)

Returns: The created sheet properties including sheetId.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "title"
  ],
  "properties": {
    "index": {
      "type": "number",
      "description": "Position to insert the sheet"
    },
    "title": {
      "type": "string",
      "description": "Title of the new sheet"
    },
    "rowCount": {
      "type": "number",
      "description": "Number of rows"
    },
    "columnCount": {
      "type": "number",
      "description": "Number of columns"
    },
    "tabColorRed": {
      "type": "number",
      "maximum": 1,
      "minimum": 0,
      "description": "Red component (0-1)"
    },
    "tabColorBlue": {
      "type": "number",
      "maximum": 1,
      "minimum": 0,
      "description": "Blue component (0-1)"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "tabColorGreen": {
      "type": "number",
      "maximum": 1,
      "minimum": 0,
      "description": "Green component (0-1)"
    }
  }
}

googlesheets_delete_sheet

Delete a sheet from a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
sheetId: The ID of the sheet to delete (required)

Returns: Confirmation of deletion.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID to delete"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_rename_sheet

Rename a sheet in a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
sheetId: The ID of the sheet to rename (required)
newTitle: The new title for the sheet (required)

Returns: Confirmation of the rename.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "newTitle"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID to rename"
    },
    "newTitle": {
      "type": "string",
      "description": "New title for the sheet"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_duplicate_sheet

Duplicate a sheet within the same spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
sheetId: The ID of the sheet to duplicate (required)
newSheetName: Name for the duplicated sheet
insertSheetIndex: Position to insert the new sheet

Returns: The duplicated sheet properties.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "The sheet ID to duplicate"
    },
    "newSheetName": {
      "type": "string",
      "description": "Name for the duplicated sheet"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "insertSheetIndex": {
      "type": "number",
      "description": "Position to insert"
    }
  }
}

googlesheets_copy_sheet_to_spreadsheet

Copy a sheet to another spreadsheet.

Args:

sourceSpreadsheetId: The ID of the source spreadsheet (required)
sheetId: The ID of the sheet to copy (required)
destinationSpreadsheetId: The ID of the destination spreadsheet (required)

Returns: The copied sheet properties in the destination spreadsheet.

{
  "type": "object",
  "required": [
    "sourceSpreadsheetId",
    "sheetId",
    "destinationSpreadsheetId"
  ],
  "properties": {
    "sheetId": {
      "type": "number",
      "description": "Sheet ID to copy"
    },
    "sourceSpreadsheetId": {
      "type": "string",
      "description": "Source spreadsheet ID"
    },
    "destinationSpreadsheetId": {
      "type": "string",
      "description": "Destination spreadsheet ID"
    }
  }
}

googlesheets_update_sheet_properties

Update sheet properties (title, position, visibility, frozen rows/columns, etc.).

Args:

spreadsheetId: The ID of the spreadsheet (required)
sheetId: The ID of the sheet to update (required)
title: New title for the sheet
index: New position for the sheet
hidden: Whether to hide the sheet
frozenRowCount: Number of frozen rows
frozenColumnCount: Number of frozen columns
hideGridlines: Whether to hide gridlines
rightToLeft: Whether the sheet is right-to-left
tabColorRed/Green/Blue: Tab color components (0-1)

Returns: Confirmation of the update.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId"
  ],
  "properties": {
    "index": {
      "type": "number",
      "description": "New position"
    },
    "title": {
      "type": "string",
      "description": "New title"
    },
    "hidden": {
      "type": "boolean",
      "description": "Hide the sheet"
    },
    "sheetId": {
      "type": "number",
      "description": "The sheet ID to update"
    },
    "rowCount": {
      "type": "number",
      "description": "Total row count"
    },
    "columnCount": {
      "type": "number",
      "description": "Total column count"
    },
    "rightToLeft": {
      "type": "boolean",
      "description": "Right-to-left sheet"
    },
    "tabColorRed": {
      "type": "number",
      "maximum": 1,
      "minimum": 0
    },
    "tabColorBlue": {
      "type": "number",
      "maximum": 1,
      "minimum": 0
    },
    "hideGridlines": {
      "type": "boolean",
      "description": "Hide gridlines"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "tabColorGreen": {
      "type": "number",
      "maximum": 1,
      "minimum": 0
    },
    "frozenRowCount": {
      "type": "number",
      "description": "Number of frozen rows"
    },
    "frozenColumnCount": {
      "type": "number",
      "description": "Number of frozen columns"
    }
  }
}

googlesheets_append_values

Append values to the end of a table in a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
range: A1 notation range that defines the table (required)
values: 2D array of values to append (required)
valueInputOption: RAW or USER_ENTERED
insertDataOption: OVERWRITE or INSERT_ROWS

Returns: The updated range and statistics.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "range"
  ],
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range defining the table"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "valueInputOption": {
      "enum": [
        "RAW",
        "USER_ENTERED"
      ],
      "type": "string",
      "description": "OVERWRITE existing or INSERT_ROWS"
    }
  }
}

googlesheets_add_slicer

Add a slicer (interactive filter control).

Args:

spreadsheetId: The spreadsheet ID (required)
sheetId: Sheet to place the slicer on (required)
dataSheetId: Sheet ID containing the data (required)
columnIndex: Column index to filter (0-indexed) (required)
title: Title for the slicer
anchorRowIndex: Row to anchor the slicer
anchorColumnIndex: Column to anchor the slicer
dataStartRowIndex: Start row of data
dataEndRowIndex: End row of data
dataStartColumnIndex: Start column of data
dataEndColumnIndex: End column of data

Returns: The slicer ID.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "sheetId",
    "dataSheetId",
    "columnIndex"
  ],
  "properties": {
    "title": {
      "type": "string",
      "description": "Slicer title"
    },
    "sheetId": {
      "type": "number",
      "description": "Sheet ID for the slicer"
    },
    "columnIndex": {
      "type": "number",
      "description": "Column index to filter (0-indexed)"
    },
    "dataSheetId": {
      "type": "number",
      "description": "Sheet ID containing the data"
    },
    "widthPixels": {
      "type": "number",
      "default": 200
    },
    "heightPixels": {
      "type": "number"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "anchorRowIndex": {
      "type": "number",
      "default": 0
    },
    "dataEndRowIndex": {
      "type": "number"
    },
    "anchorColumnIndex": {
      "type": "number",
      "default": 0
    },
    "dataStartRowIndex": {
      "type": "number"
    },
    "dataEndColumnIndex": {
      "type": "number"
    },
    "dataStartColumnIndex": {
      "type": "number"
    }
  }
}

googlesheets_delete_slicer

Delete a slicer.

Args:

spreadsheetId: The spreadsheet ID (required)
slicerId: The slicer ID (required)

Returns: Confirmation.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "slicerId"
  ],
  "properties": {
    "slicerId": {
      "type": "number",
      "description": "Slicer ID to delete"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_create_spreadsheet

Create a new Google Sheets spreadsheet.

Args:

title: The title of the new spreadsheet (required)
sheets: Optional array of sheet names to create

Returns: The created spreadsheet metadata including spreadsheetId and URL.

{
  "type": "object",
  "properties": {
    "title": {
      "type": "string",
      "description": "Title of the new spreadsheet"
    }
  }
}

googlesheets_get_spreadsheet

Get metadata and optionally data for a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
includeGridData: Whether to include cell data (default: false)
ranges: Optional array of A1 ranges to include

Returns: Spreadsheet metadata including properties, sheets, and optionally cell data.

{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_update_spreadsheet_properties

Update spreadsheet-level properties.

Args:

spreadsheetId: The ID of the spreadsheet (required)
title: New title for the spreadsheet
locale: Locale for the spreadsheet (e.g., en_US)
timeZone: Time zone (e.g., America/New_York)
autoRecalc: Recalculation interval (ON_CHANGE, MINUTE, HOUR)

Returns: Confirmation of the update.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "title": {
      "type": "string",
      "description": "New title"
    },
    "locale": {
      "type": "string",
      "description": "Locale (e.g., en_US)"
    },
    "timeZone": {
      "type": "string",
      "description": "Time zone"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_get_by_data_filter

Get spreadsheet data matching specific data filters (by range, metadata, etc.).

Args:

spreadsheetId: The ID of the spreadsheet (required)
dataFilters: Array of filters specifying which data to retrieve
includeGridData: Whether to include cell data

Returns: Filtered spreadsheet data.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "includeGridData": {
      "type": "boolean"
    }
  }
}

googlesheets_read_values

Read values from a range in a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
range: A1 notation range (e.g., Sheet1!A1:D10) (required)
majorDimension: ROWS or COLUMNS (default: ROWS)
valueRenderOption: How to render values (FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA)
dateTimeRenderOption: How to render dates (SERIAL_NUMBER, FORMATTED_STRING)

Returns: The values in the specified range.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "range"
  ],
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range (e.g., Sheet1!A1:D10)"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "majorDimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string",
      "description": "Data orientation"
    }
  }
}

googlesheets_batch_read_values

Read values from multiple ranges in a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
ranges: Array of A1 notation ranges (required)
majorDimension: ROWS or COLUMNS
valueRenderOption: How to render values
dateTimeRenderOption: How to render dates

Returns: The values for each specified range.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "ranges"
  ],
  "properties": {
    "ranges": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Array of A1 notation ranges"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "majorDimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string"
    },
    "dateTimeRenderOption": {
      "enum": [
        "SERIAL_NUMBER",
        "FORMATTED_STRING"
      ],
      "type": "string"
    }
  }
}

googlesheets_write_values

Write values to a range in a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
range: A1 notation range (required)
values: 2D array of values to write (required)
valueInputOption: RAW or USER_ENTERED (default: USER_ENTERED)
includeValuesInResponse: Include written values in response

Returns: Update statistics (rows, columns, cells updated).

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "range": {
      "type": "string",
      "default": "USER_ENTERED') .describe('RAW (literal) or USER_ENTERED (parsed like UI)",
      "description": "A1 notation range"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "includeValuesInResponse": {
      "type": "boolean"
    }
  }
}

googlesheets_batch_write_values

Write values to multiple ranges in a spreadsheet.

Args:

spreadsheetId: The ID of the spreadsheet (required)
data: Array of {range, values} objects (required)
valueInputOption: RAW or USER_ENTERED
includeValuesInResponse: Include written values in response

Returns: Total update statistics.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "valueInputOption": {
      "enum": [
        "RAW",
        "USER_ENTERED"
      ],
      "type": "string",
      "default": "USER_ENTERED"
    },
    "includeValuesInResponse": {
      "type": "boolean"
    }
  }
}

googlesheets_clear_values

Clear values from a range (keeps formatting).

Args:

spreadsheetId: The ID of the spreadsheet (required)
range: A1 notation range to clear (required)

Returns: The cleared range.

{
  "type": "object",
  "required": [
    "spreadsheetId",
    "range"
  ],
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range to clear"
    },
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}

googlesheets_batch_read_by_data_filter

Read values matching data filters (by range, grid range, or metadata).

Args:

spreadsheetId: The ID of the spreadsheet (required)
dataFilters: Array of data filters (required)
majorDimension: ROWS or COLUMNS
valueRenderOption: How to render values

Returns: Values matching the filters.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "majorDimension": {
      "enum": [
        "ROWS",
        "COLUMNS"
      ],
      "type": "string"
    }
  }
}

googlesheets_batch_write_by_data_filter

Write values to ranges matching data filters.

Args:

spreadsheetId: The ID of the spreadsheet (required)
data: Array of {dataFilter, values} objects (required)
valueInputOption: RAW or USER_ENTERED

Returns: Update statistics.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "valueInputOption": {
      "enum": [
        "RAW",
        "USER_ENTERED"
      ],
      "type": "string"
    }
  }
}

googlesheets_batch_clear_by_data_filter

Clear values from ranges matching data filters.

Args:

spreadsheetId: The ID of the spreadsheet (required)
dataFilters: Array of data filters (required)

Returns: The cleared ranges.

{
  "type": "object",
  "required": [
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The spreadsheet ID"
    }
  }
}