mcp-gsheetsTools Reference
sheets_get_values
Read data from a spreadsheet range
sheets_get_values
Read data from 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 (e.g., "Sheet1!A1:D10") |
Example
{
"tool": "sheets_get_values",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1:D10"
}
}Response
Returns a 2D array of cell values.