GOOGLE.SHEETS.SPREADSHEET.LIST
Premium
Experimental
Get a list of all available spreadsheets.
Syntax
=GOOGLE.SHEETS.SPREADSHEET.LIST([ResponseTarget])
Arguments
| Name | Type | Description |
|---|---|---|
| ResponseTarget (optional) | Target | Specify inbox, outbox, cell or cell-range to write any response to. |
Return
| Type | Description |
|---|---|
| JSON | A list with names and ids of all spreadsheets currently available. |
Examples
| Formula | Result | Comment |
|---|---|---|
| JSON | Lists names and ids of all currently available spreadsheets. |