mcp-gsheetsTools Reference
sheets_update_values
Write data to a spreadsheet range
sheets_update_values
Write data to a specified range in a Google Sheets spreadsheet.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
range | string | Yes | A1 notation range |
values | array[][] | Yes | 2D array of values to write |
valueInputOption | string | No | RAW or USER_ENTERED (default) |
Example
{
"tool": "sheets_update_values",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1:C3",
"values": [
["Name", "Age", "City"],
["John", 30, "New York"],
["Jane", 25, "Los Angeles"]
]
}
}Value Input Options
USER_ENTERED- Parse values as if typed by user (formulas, dates work)RAW- Store values exactly as provided