Skip to content
Zoan Docs

Google Sheets — Read sheet

Google Sheets — Read sheet

Section titled “Google Sheets — Read sheet”

Type: googlesheets-read-sheet  ·  Package: Google Sheets Activities v1.0.0  ·  Output: DataTable

Reads all data from a sheet and always returns it as a DataTable. It is the most common reading: bring the complete content to process it.

How it works

Section titled “How it works”

Reads the entire indicated sheet (the first one if you omit sheet) and always returns a DataTable: with has-headers = true the first row is used as column names; otherwise columns are named Column1, Column2, … 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.
sheetexpressionSheet name. By default, the first.
has-headersbooleanTreat first row as column names. By default false (columns Column1, Column2, …).

Output

Section titled “Output”

Always a DataTable. With has-headers = true the first row is the headers; otherwise columns are named Column1, Column2, …

Example

Section titled “Example”
Google Sheets — Read sheet   session = = hoja   sheet = "Citas"   has-headers = true   → output: citas
For Each   items = = citas   itemVariable = fila
 └─ activities:
      Log   message = = str(row["Paciente"]) + " — " + str(row["Fecha"])
Section titled “Related activities”