drive_create_spreadsheet
Create a new Google Sheet in a Drive folder and fill up to 20 tabs with data in one call. Fails if the name exists, so it never overwrites existing files.
Instructions
Create a new Google Sheet in a Drive folder (My Drive or a shared drive) and fill its tabs in one call: name, folderId, and sheets as [{title, rows: string[][]}], up to 20 tabs and 20 000 cells. Refuses when a file with that name already exists in the folder; never writes into an existing spreadsheet, never shares. Values are written as USER_ENTERED by default (numbers and dates are parsed as a person typing them would get); pass valueInput: "RAW" to store every cell as literal text.
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": {
"account": "<account>",
"name": "<name>",
"folderId": "<folderId>",
"sheets": "<sheets>"
},
"name": "drive_create_spreadsheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Spreadsheet name. | |
| sheets | Yes | Tabs in order; the first replaces the default tab. | |
| account | Yes | Configured Gmail account alias, e.g. work, personal, support. | |
| folderId | Yes | Target folder id (My Drive or a shared drive). | |
| valueInput | No | How cell text is interpreted. Default USER_ENTERED. |