Google Sheets
GOOGLESHEETS_SHEET_FROM_JSON
Creates a new Google Spreadsheet and populates its first worksheet from `sheet_json`, which must be non-empty as its first item's keys establish the headers.
Remote googlesheets
Other tools also called GOOGLESHEETS_SHEET_FROM_JSON?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"title": {
"type": "string",
"description": "The desired title for the new Google Spreadsheet.\nExamples:\n \"Q3 Sales Report\"\n \"Project Plan Alpha\""
},
"sheet_json": {
"type": "array",
"items": {
"type": "object",
"properties": {},
"additionalProperties": true
},
"description": "A list of dictionaries representing the rows of the sheet. Each dictionary must have the same set of keys, which will form the header row. Values can be strings, numbers, booleans, or null (represented as empty cells).\nExamples:\n \"[{\\\"Name\\\": \\\"Alice\\\", \\\"Age\\\": 30, \\\"City\\\": \\\"New York\\\"}, {\\\"Name\\\": \\\"Bob\\\", \\\"Age\\\": 24, \\\"City\\\": \\\"London\\\"}]\"\n \"[{\\\"Product ID\\\": \\\"A123\\\", \\\"Quantity\\\": 10, \\\"Price\\\": 25.50}, {\\\"Product ID\\\": \\\"B456\\\", \\\"Quantity\\\": 5, \\\"Price\\\": 100.00}]\""
},
"sheet_name": {
"type": "string",
"description": "The name for the first worksheet within the newly created spreadsheet. This name will appear as a tab at the bottom of the sheet.\nExamples:\n \"Sheet1\"\n \"Data Summary\"\n \"October Metrics\""
}
}
}