Google Sheet line reader

Read a Google Sheet line by line. Each line is emitted as one object whose keys are the spreadsheet column letters (A, B, C…). For example:

A Google Sheet
  |    A    |    B    |    C    |
  |-----------------------------|
1 | header1 | header2 | header3 |
2 | data1A  | data1B  | data1C  |
3 | data2A  | data2B  | data2C  |
4 | data3A  | data3B  | data3C  |
  |-----------------------------|
  | SHEET_1 | SHEET_2 |

Reader configuration
Sheet name: SHEET_1
Start line: 2 (starting reading from line 2)

Parameters

Sheet namerequired

The name of the sheet to read. The name must match exactly: if no sheet with that name exists in the document, the run fails with a "sheet not found" error.

Start linerequired

The line number to start reading from, counted from 1. Both 0 and 1 read the whole sheet; 2 skips the first line (typically the header row).

Output

GSheet Row

The current row being read from the Google Sheet, as an object keyed by column letter (A, B, C…).

Parameters​

Output​

Parameters

Output