GOOGLE.SHEETS.SHEET.LIST
Premium
Experimental
List all sheets of specified spreadsheet.
Syntax
=GOOGLE.SHEETS.SHEET.LIST(Spreadsheet-Id, [ResponseTarget])
Arguments
| Name | Type | Description |
|---|---|---|
| Spreadsheet-Id | Text | The id of the spreadsheet to get sheets from. |
| ResponseTarget (optional) | Target | Specify inbox, outbox, cell or cell-range to write any response to. |
Return
| Type | Description |
|---|---|
| JSON | A JSON containing name and id of each sheet within specified spreadsheet. |
Examples
| Formula | Result | Comment |
|---|---|---|
| JSON | Lists all sheets of spreadsheet with ID given in B2. |