MCP Google Workspace Server

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

NameRequiredDescriptionDefault
rangeYesA1 notation range
spreadsheet_idYesID of the spreadsheet
valuesYes2D 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

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/josedu90/mcp-suiteg'

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