This query returns the rows of a worksheet with a cell that contains or matches a value, with each row's number for "Update row in spreadsheet". Use it to look up rows instead of reading them one at a time.

Developer info

API endpoint slug: google_sheets.find_rows_in_spreadsheet
Runtime method: performQuery("google_sheets.find_rows_in_spreadsheet"}

Query fields

Path Text input > Path to a folder

Label: Drive folder path
Helper text: 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

Search Text input > Other

Label: Value to find
Helper text: Not case-sensitive. Compared with the text as shown in the cell
Slug: search
Required: true
Can have default value: true

Column Text input > Other

Label: Which column?
Helper text: A column letter (e.g. B) or a header name from row 1 (e.g. Email). Leave blank to search every column from A to Z
Slug: column
Required: false
Can have default value: true

Match Dropdown list

Label: Match
Helper text: Whether the cell must contain the value or match it exactly
Slug: match
Required: true
Can have default value: true

Start row Text input > Other

Label: Start at row
Helper text: Defaults to 1. Searches up to 10,000 rows from here, or 100,000 when a column is set. For more matches, run again starting after the last RowIndex
Slug: start_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.findRowsInSpreadsheet.RowIndex
Type: String
Example: 4

Column a Value in column A

Slug: column_a
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnA
Type: String
Example: Jane Doe

Column b Value in column B

Slug: column_b
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnB
Type: String
Example: jane@example.com

Column c Value in column C

Slug: column_c
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnC
Type: String
Example: Done

Column d Value in column D

Slug: column_d
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnD
Type: String
Example: $120.00

Column e Value in column E

Slug: column_e
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnE
Type: String
Example: $120.00

Column f Value in column F

Slug: column_f
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnF
Type: String
Example: $120.00

Column g Value in column G

Slug: column_g
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnG
Type: String
Example: $120.00

Column h Value in column H

Slug: column_h
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnH
Type: String
Example: $120.00

Column i Value in column I

Slug: column_i
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnI
Type: String
Example: $120.00

Column j Value in column J

Slug: column_j
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnJ
Type: String
Example: $120.00

Column k Value in column K

Slug: column_k
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnK
Type: String
Example: $120.00

Column l Value in column L

Slug: column_l
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnL
Type: String
Example: $120.00

Column m Value in column M

Slug: column_m
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnM
Type: String
Example: $120.00

Column n Value in column N

Slug: column_n
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnN
Type: String
Example: $120.00

Column o Value in column O

Slug: column_o
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnO
Type: String
Example: $120.00

Column p Value in column P

Slug: column_p
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnP
Type: String
Example: $120.00

Column q Value in column Q

Slug: column_q
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnQ
Type: String
Example: $120.00

Column r Value in column R

Slug: column_r
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnR
Type: String
Example: $120.00

Column s Value in column S

Slug: column_s
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnS
Type: String
Example: $120.00

Column t Value in column T

Slug: column_t
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnT
Type: String
Example: $120.00

Column u Value in column U

Slug: column_u
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnU
Type: String
Example: $120.00

Column v Value in column V

Slug: column_v
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnV
Type: String
Example: $120.00

Column w Value in column W

Slug: column_w
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnW
Type: String
Example: $120.00

Column x Value in column X

Slug: column_x
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnX
Type: String
Example: $120.00

Column y Value in column Y

Slug: column_y
Filter: GoogleSheets.findRowsInSpreadsheet.ColumnY
Type: String
Example: $120.00

Column z Value in column Z

Slug: column_z
Filter: GoogleSheets.findRowsInSpreadsheet.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.findRowsInSpreadsheet.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.findRowsInSpreadsheet.WorksheetName
Type: String
Example: Sheet1

Spreadsheet name The name of the spreadsheet.

Slug: spreadsheet_name
Filter: GoogleSheets.findRowsInSpreadsheet.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.findRowsInSpreadsheet.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.

Slug: spreadsheet_url
Filter: GoogleSheets.findRowsInSpreadsheet.SpreadsheetUrl
Type: Web URL
Example: https://docs.google.com/spreadsheets/d/1cHROp05l1AvtsvKmfKhiyIl09FoxeZR2GGFtzI9fYcc/edit?gid=0#gid=0

Find rows in spreadsheet

This query returns the rows of a worksheet with a cell that contains or matches a value, with each row's number for "Update row in spreadsheet". Use it to look up rows instead of reading them one at a time.

Developer info

Query fields

Path Text input > Path to a folder

Filename Text input > File name

Spreadsheet url Text input > Other

Worksheet Text input > Other

Search Text input > Other

Column Text input > Other

Match Dropdown list

Start row Text input > Other

Ingredients

Row index The row number. To update this row, give "Update row in spreadsheet" this RowIndex with SpreadsheetUrl and WorksheetName.

Column a Value in column A

Column b Value in column B

Column c Value in column C

Column d Value in column D

Column e Value in column E

Column f Value in column F

Column g Value in column G

Column h Value in column H

Column i Value in column I

Column j Value in column J

Column k Value in column K

Column l Value in column L

Column m Value in column M

Column n Value in column N

Column o Value in column O

Column p Value in column P

Column q Value in column Q

Column r Value in column R

Column s Value in column S

Column t Value in column T

Column u Value in column U

Column v Value in column V

Column w Value in column W

Column x Value in column X

Column y Value in column Y

Column z Value in column Z

Row values All values in the row as shown in the sheet, separated by "|||". Formulas aren't included.

Worksheet name The name of the worksheet the row is in.

Spreadsheet name The name of the spreadsheet.

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.

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.