unpivot_range
Unpivot wide spreadsheet data into normalized rows, converting column headers into variable-value pairs for analysis.
Instructions
Convert a wide range into normalized rows and write the result.
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": {
"spreadsheet_id": "<spreadsheet_id>",
"source_range": "<source_range>",
"target_range": "<target_range>",
"id_columns": "<id_columns>"
},
"name": "unpivot_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id_columns | Yes | ||
| source_range | Yes | ||
| target_range | Yes | ||
| spreadsheet_id | Yes | ||
| skip_empty_values | No | ||
| value_column_name | No | value | |
| variable_column_name | No | variable |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||