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.
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. |