import_json
Imports JSON data into a Google Sheet, auto-creating headers from object keys for initial setup.
Instructions
Import JSON data to a Google Sheet (creates headers and data). Use for empty sheets or first-time setup.
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": {
"endpoint": "<endpoint>",
"data": "<data>"
},
"name": "import_json"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Array of objects to import. Headers created from object keys. | |
| endpoint | Yes | The SheetsDB API endpoint |