GOOGLE.SHEETS.SPREADSHEET.CREATE
Premium
Experimental
Creates a new spreadsheet with an empty sheet.
Syntax
=GOOGLE.SHEETS.SPREADSHEET.CREATE(Spreadsheet Name, [Sheet-Name], [ResponseTarget])
Arguments
| Name | Type | Description |
|---|---|---|
| Spreadsheet Name | Text | Name of the new spreadsheet |
| Sheet-Name (optional) | Text | Name of the sheet. Defaults to Sheet1 |
| ResponseTarget (optional) | Target | Specify inbox, outbox, cell or cell-range to write any response to. |
Return
| Type | Description |
|---|---|
| JSON | A JSON with spreadsheet title and id as well as name and id of its inner sheet. |
Examples
| Formula | Result | Comment |
|---|---|---|
| JSON | Creates a new spreadsheet titled "Calculations" with an empty sheet named "Quarter". |