Find and return the first location of a specified value within a Google Sheets spreadsheet.
Application
Google Sheets
Inputs (what you have)
Name | Description | Data Type | Required? | Example |
Google Sheets connected account | Connected Account | No | ||
Spreadsheet link | Link | Yes | ||
Sheet name | First tab will be used by default. Sheet name is case sensitive | Text (Short) | No | |
Search value | The value to be found in the spreadsheet | Text (Long) | Yes | |
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' | Text (Short) | Yes | |
Enable case sensitivity | True/False | Yes | ||
Search using regex? | Select this to search your Google Sheet using regex instead of a full match of the cell | True/False | No |
Outputs (what you get)
Name | Description | Data Type | Required? | Example |
Row of the first result | Number | No |
Outcomes
Name | Description |
Success | This status is selected if the job has successfully completed. |
No result | This status is selected if the job has successfully completed but no result was produced. |
Requirements
N/A