This query reads 50 rows of a worksheet, starting at the row you choose, and returns the ones with data. Use it to read a table, header row included, in one run instead of one row at a time. To read on, add 50 to the start row.
Format: folders separated by "/" like "Recipes/Vegetables". Leave blank for the top level of My Drive
Slug
path
Required
false
Can have default value
true
Filename Text input > File name
Label
Spreadsheet name
Helper text
E.g. Vegetable Recipes. To update a row you find, give "Update row in spreadsheet" its SpreadsheetUrl, WorksheetName and RowIndex
Slug
filename
Required
false
Can have default value
true
Spreadsheet url Text input > Other
Label
Or copy and paste the spreadsheet URL
Helper text
Used instead of the folder path and name when set. A URL with #gid= reads that tab
Slug
spreadsheet_url
Required
false
Can have default value
true
Worksheet Text input > Other
Label
Worksheet name
Helper text
Leave blank for the first worksheet, or the tab in a pasted URL
Slug
worksheet
Required
false
Can have default value
true
Start row Text input > Other
Label
Start at row
Helper text
Defaults to 1, the header row. 50 rows are read from here, so to read on, add 50
Slug
start_row
Required
false
Can have default value
true
End row Text input > Other
Label
End at row
Helper text
Optional. At most 50 rows are read at a time
Slug
end_row
Required
false
Can have default value
true
Ingredients
Row index
The row number. To update this row, give "Update row in spreadsheet" this RowIndex with SpreadsheetUrl and WorksheetName.
Slug
row_index
Filter
GoogleSheets.getRowsInSpreadsheet.RowIndex
Type
String
Example
4
Column a
Value in column A
Slug
column_a
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnA
Type
String
Example
Jane Doe
Column b
Value in column B
Slug
column_b
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnB
Type
String
Example
jane@example.com
Column c
Value in column C
Slug
column_c
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnC
Type
String
Example
Done
Column d
Value in column D
Slug
column_d
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnD
Type
String
Example
$120.00
Column e
Value in column E
Slug
column_e
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnE
Type
String
Example
$120.00
Column f
Value in column F
Slug
column_f
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnF
Type
String
Example
$120.00
Column g
Value in column G
Slug
column_g
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnG
Type
String
Example
$120.00
Column h
Value in column H
Slug
column_h
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnH
Type
String
Example
$120.00
Column i
Value in column I
Slug
column_i
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnI
Type
String
Example
$120.00
Column j
Value in column J
Slug
column_j
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnJ
Type
String
Example
$120.00
Column k
Value in column K
Slug
column_k
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnK
Type
String
Example
$120.00
Column l
Value in column L
Slug
column_l
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnL
Type
String
Example
$120.00
Column m
Value in column M
Slug
column_m
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnM
Type
String
Example
$120.00
Column n
Value in column N
Slug
column_n
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnN
Type
String
Example
$120.00
Column o
Value in column O
Slug
column_o
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnO
Type
String
Example
$120.00
Column p
Value in column P
Slug
column_p
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnP
Type
String
Example
$120.00
Column q
Value in column Q
Slug
column_q
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnQ
Type
String
Example
$120.00
Column r
Value in column R
Slug
column_r
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnR
Type
String
Example
$120.00
Column s
Value in column S
Slug
column_s
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnS
Type
String
Example
$120.00
Column t
Value in column T
Slug
column_t
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnT
Type
String
Example
$120.00
Column u
Value in column U
Slug
column_u
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnU
Type
String
Example
$120.00
Column v
Value in column V
Slug
column_v
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnV
Type
String
Example
$120.00
Column w
Value in column W
Slug
column_w
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnW
Type
String
Example
$120.00
Column x
Value in column X
Slug
column_x
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnX
Type
String
Example
$120.00
Column y
Value in column Y
Slug
column_y
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnY
Type
String
Example
$120.00
Column z
Value in column Z
Slug
column_z
Filter
GoogleSheets.getRowsInSpreadsheet.ColumnZ
Type
String
Example
$120.00
Row values
All values in the row as shown in the sheet, separated by "|||". Formulas aren't included.
Slug
row_values
Filter
GoogleSheets.getRowsInSpreadsheet.RowValues
Type
String
Example
Jane Doe ||| jane@example.com ||| Done
Worksheet name
The name of the worksheet the row is in.
Slug
worksheet_name
Filter
GoogleSheets.getRowsInSpreadsheet.WorksheetName
Type
String
Example
Sheet1
Spreadsheet name
The name of the spreadsheet.
Slug
spreadsheet_name
Filter
GoogleSheets.getRowsInSpreadsheet.SpreadsheetName
Type
String
Example
Leads
Path
The folder path the spreadsheet was found in. "/" is the top level of My Drive. Blank when found by URL. "Update row in spreadsheet" reads a blank or "/" path as "IFTTT", so update rows with SpreadsheetUrl instead.
Slug
path
Filter
GoogleSheets.getRowsInSpreadsheet.Path
Type
String
Example
/IFTTT/Sales
Spreadsheet url
The URL of the spreadsheet, opened at the row's worksheet. "Update row in spreadsheet" writes to that worksheet when given this URL.
This query reads 50 rows of a worksheet, starting at the row you choose, and returns the ones with data. Use it to read a table, header row included, in one run instead of one row at a time. To read on, add 50 to the start row.