MCP Tools Reference: sheetsmcp.googleapis.com

Tool: update_spreadsheet

Applies one or more updates to the spreadsheet.

Corresponds to spreadsheets.batchUpdate in the REST API: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/batchUpdate

The list of possible updates is:

• updateSpreadsheetProperties: Updates the spreadsheet's properties.
• updateSheetProperties: Updates a sheet's properties.
• updateDimensionProperties: Updates dimensions' properties.
• updateNamedRange: Updates a named range.
• repeatCell: Repeats a single cell across a range.
• addNamedRange: Adds a named range.
• deleteNamedRange: Deletes a named range.
• addSheet: Adds a sheet.
• deleteSheet: Deletes a sheet.
• autoFill: Automatically fills in more data based on existing data.
• cutPaste: Cuts data from one area and pastes it to another.
• copyPaste: Copies data from one area and pastes it to another.
• mergeCells: Merges cells together.
• unmergeCells: Unmerges merged cells.
• updateBorders: Updates the borders in a range of cells.
• updateCells: Updates many cells at once.
• addFilterView: Adds a filter view.
• appendCells: Appends cells after the last row with data in a sheet.
• clearBasicFilter: Clears the basic filter on a sheet.
• deleteDimension: Deletes rows or columns in a sheet.
• deleteEmbeddedObject: Deletes an embedded object (e.g, chart, image) in a sheet.
• deleteFilterView: Deletes a filter view from a sheet.
• duplicateFilterView: Duplicates a filter view.
• duplicateSheet: Duplicates a sheet.
• findReplace: Finds and replaces occurrences of some text with other text.
• insertDimension: Inserts new rows or columns in a sheet.
• insertRange: Inserts new cells in a sheet, shifting the existing cells.
• moveDimension: Moves rows or columns to another location in a sheet.
• updateEmbeddedObjectPosition: Updates an embedded object's (e.g. chart, image) position.
• pasteData: Pastes data (HTML or delimited) into a sheet.
• textToColumns: Converts a column of text into many columns of text.
• updateFilterView: Updates the properties of a filter view.
• deleteRange: Deletes a range of cells from a sheet, shifting the remaining cells.
• appendDimension: Appends dimensions to the end of a sheet.
• addConditionalFormatRule: Adds a new conditional format rule.
• updateConditionalFormatRule: Updates an existing conditional format rule.
• deleteConditionalFormatRule: Deletes an existing conditional format rule.
• sortRange: Sorts data in a range.
• setDataValidation: Sets data validation for one or more cells.
• setBasicFilter: Sets the basic filter on a sheet.
• addProtectedRange: Adds a protected range.
• updateProtectedRange: Updates a protected range.
• deleteProtectedRange: Deletes a protected range.
• autoResizeDimensions: Automatically resizes one or more dimensions based on the contents of the cells in that dimension.
• addChart: Adds a chart.
• updateChartSpec: Updates a chart's specifications.
• updateBanding: Updates a banded range
• addBanding: Adds a new banded range
• deleteBanding: Removes a banded range
• createDeveloperMetadata: Creates new developer metadata
• updateDeveloperMetadata: Updates an existing developer metadata entry
• deleteDeveloperMetadata: Deletes developer metadata
• randomizeRange: Randomizes the order of the rows in a range.
• addDimensionGroup: Creates a group over the specified range.
• deleteDimensionGroup: Deletes a group over the specified range.
• updateDimensionGroup: Updates the state of the specified group.
• trimWhitespace: Trims cells of whitespace (such as spaces, tabs, or new lines).
• deleteDuplicates: Removes rows containing duplicate values in specified columns of a cell range.
• updateEmbeddedObjectBorder: Updates an embedded object's border.
• addSlicer: Adds a slicer.
• updateSlicerSpec: Updates a slicer's specifications.
• addDataSource: Adds a data source.
• updateDataSource: Updates a data source.
• deleteDataSource: Deletes a data source.
• refreshDataSource: Refreshes one or multiple data sources and associated dbobjects.
• cancelDataSourceRefresh: Cancels refreshes of one or multiple data sources and associated dbobjects.
• addTable: Adds a table.
• updateTable: Updates a table.
• deleteTable: A request for deleting a table.

The following sample demonstrate how to use curl to invoke the update_spreadsheet MCP tool.

Input Schema

{
  "spreadsheetId": string,
  "requests": [
    {
      object
    }
  ]
}

{
  "fields": {
    string: value,
    ...
  }
}

{
  "key": string,
  "value": value
}

{

  "nullValue": null,
  "numberValue": number,
  "stringValue": string,
  "boolValue": boolean,
  "structValue": {
    object
  },
  "listValue": array
}

{
  "values": [
    value
  ]
}

Output Schema

{
  "fields": {
    string: value,
    ...
  }
}

{
  "key": string,
  "value": value
}

{

  "nullValue": null,
  "numberValue": number,
  "stringValue": string,
  "boolValue": boolean,
  "structValue": {
    object
  },
  "listValue": array
}

{
  "values": [
    value
  ]
}

Tool Annotations

Destructive Hint: ❌ | Idempotent Hint: ❌ | Read Only Hint: ❌ | Open World Hint: ✅