Search Column
Search one column in Google Sheets for a specific term. Be sure that the column you're searching against has a value in every cell (even if it's 0). The search stops if it encounters a blank cell.
Options
| Field | Definition | Type | Required |
|---|---|---|---|
| Use Spreadsheet ID? |
Option to specify a Google Sheets spreadsheet by ID.
If you select No, select a spreadsheet from the Spreadsheet dropdown menu and ignore the Spreadsheet ID field. If you select Yes, the list of spreadsheets from your account in the Spreadsheet dropdown menu is depopulated. Select -- Enter Spreadsheet ID -- from the Spreadsheet dropdown menu and enter the ID in the Spreadsheet ID field. The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0, the spreadsheet ID is 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps. |
Dropdown | TRUE |
| Spreadsheet |
List of spreadsheets in your Google Sheets account.
Due to an API limitation, there's a maximum of 100 spreadsheets returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option. |
Dropdown | TRUE |
| Spreadsheet ID | Unique identifier for your selected spreadsheet. | String | FALSE |
| Worksheets | List of worksheets in the spreadsheet. | Dropdown | TRUE |
| Column to Search | List of columns in the worksheet. | Dropdown | TRUE |
| Result Set | Choose First Matching Row or All Matching Rows. | Dropdown | TRUE |
Input
| Field | Definition | Type | Required |
|---|---|---|---|
| Search Term |
Value that you want to search for in the column.
This field is a string literal search using an exact string match. Null values aren't supported unless the string is null. |
String | FALSE |
Output
| Field | Definition | Type |
|---|---|---|
| Row Number | Location of the first row where the value was found (if the value isn't found in the column, this field returns null). Returned when you select First Matching Row for the Result Set option. | Number |
| Rows | A list containing the row numbers where the value was found. Returned when you select All Matching Rows for the Result Set option. | List |