MCP Google Workspace Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

sheets_update_values

Modify or replace data in a specified range of a Google Sheet using a 2D array of values. Provide the spreadsheet ID, range, and values to update cells efficiently.

Instructions

Update values in a Google Sheet range

Input Schema

Name	Required	Description
`range`	Yes	A1 notation range
`spreadsheet_id`	Yes	ID of the spreadsheet
`values`	Yes	2D array of values

Input Schema (JSON Schema)

{
  "properties": {
    "range": {
      "description": "A1 notation range",
      "type": "string"
    },
    "spreadsheet_id": {
      "description": "ID of the spreadsheet",
      "type": "string"
    },
    "values": {
      "description": "2D array of values",
      "items": {
        "items": {
          "type": "string"
        },
        "type": "array"
      },
      "type": "array"
    }
  },
  "required": [
    "spreadsheet_id",
    "range",
    "values"
  ],
  "type": "object"
}

You must be authenticated.

Other Tools from MCP Google Workspace Server

Related Tools

smartsheet_update
@terilios/smartsheet-server
update_excel
@yzfly/mcp-excel-server
writeDataBySheetName
@zhiwei5576/excel-mcp-server
sheets_get_values
@josedu90/mcp-suiteg
update_file_content
@GongRzhe/terminal-controller-mcp

ID: 5gwgbgoe4i