sheets_analyze
Analyze a spreadsheet range or table to get column types, counts, blanks, distinct values, numeric statistics, and optional group-by summaries for quick data profiling.
Instructions
Analyze a table in a range (first row = headers): per-column type, count, blanks, distinct values, and for numeric columns sum/mean/median/min/max/stdev; top values for text columns. Optional group-by summary.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheetId": "<spreadsheetId>",
"range": "<range>"
},
"name": "sheets_analyze"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | e.g. 'Sales' or 'Sales!A1:H500' | |
| groupBy | No | Header name to group by | |
| spreadsheetId | Yes | ||
| aggregateColumns | No | Numeric headers to sum/average per group |