GOOGLE.SHEETS.SHEET.ADD
Premium
Experimental
Add a new empty sheet to specified spreadsheet.
Syntax
=GOOGLE.SHEETS.SHEET.ADD(Spreadsheet-Id, Name, [ResponseTarget])
Arguments
| Name | Type | Description |
|---|---|---|
| Spreadsheet-Id | Text | The id of the spreadsheet to add sheet to. |
| Name | Text | Name of the sheet to add |
| ResponseTarget (optional) | Target | Specify inbox, outbox, cell or cell-range to write any response to. |
Return
| Type | Description |
|---|---|
| JSON | On success the name, id, columns and rows of new sheet are returned. |
Examples
| Formula | Result | Comment |
|---|---|---|
| JSON | Adds a new sheet to spreadsheet with ID given in B2. |