Skip to main content

Google Sheet line reader

Read a Google Sheet line by line. 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)
Preload lines: 1 (load the first line to use it on line 2, 3 & 4)

Parameters​

Sheet name—REQUIRED
The name of the Google Sheet to read.
Start line—REQUIRED
The line number to start reading from.
Preload lines

The lines to load and keep in memory to be used on each line read. (For example, you can load the first line and use it on line 2, 3, 4, etc.)

Output​

Row

The current row being read from the Google Sheet.