Search value location in Google Sheets
Finds and returns all locations of a specified value within a Google Sheets spreadsheet.
Common use cases
- Data Manipulation
Category
- Google Sheets
Inputs (what you have)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Spreadsheet link | Link to the Google Sheets spreadsheet where the value should be found | Link | Yes | https://docs.google.com/spreadsheets/d/1eQ |
| Search value | The value to be found in the spreadsheet | Text | Yes | Doe |
| Column name | The name of the column to be searched, either the header name of table or the column letter. Example: 'A' or 'First Name'. Can not be used with 'Row number' | Text | Yes | Last_name |
| Sheet name | The name of the Google Sheets tab. First tab will be used by default. Sheet name is case sensitive | Text | No | REQ |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data library. These variables in the Data library section are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Row of the first result | The row number of a matching result | Number | Yes | 10 |
Outcomes
| NAME | DESCRIPTION |
|---|---|
| Success | This status is selected if the value was successfully found and returned in the specified Google Sheets spreadsheet. |
| No Result | This status is selected in the event of the following scenarios:- The search value could not be found |
| Unsuccessful | This status is selected in the event of the following scenarios:- Link of the Google Sheets spreadsheet is not provided- Value to search for is not provided- Column name to search value in is not provided |
Requirements
-
The data within the spreadsheet should be formatted in a table, ensuring that each column in the sheet has a specific header name in Row 1 of the sheet.
-
All Drives and Sheets need to be shared with:
googlewrkbots@wrk.com