Skip to content
Zoan Docs

Google Sheets — Get sheet names

Google Sheets — Get sheet names

Section titled “Google Sheets — Get sheet names”

Type: googlesheets-get-sheet-names  ·  Package: Google Sheets Activities v1.0.0  ·  Output: List

Returns the list of sheet names of the document. Useful when you don’t know in advance what they are called, or to process all the sheets by going through them.

How it works

Section titled “How it works”

Returns the sheet names in order. Requires a Google Sheets — Open session.

Required parameters

Section titled “Required parameters”

None.

Optional parameters

Section titled “Optional parameters”
ParameterEditorDescription
sessionsessionGoogle Sheets — Open session. Optional: within a body it is inherited.

Output

Section titled “Output”

Returns a List of texts with the names of the sheets.

Example

Section titled “Example”
Google Sheets — Get sheet names   session = = hoja   → output: nombres
For Each   items = = nombres   itemVariable = h
 └─ activities:
      Google Sheets — Read sheet   session = = hoja   sheet = = h   has-headers = true   → output: datos
      ... procesar ...
Section titled “Related activities”