Search value location in Google Sheets

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	Example: https://docs.google.com/spreadsheets/d/35ewEf	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