Skip to main content
All CollectionsWrk Action LibraryGoogle Sheets
Search value location in Google Sheets
Search value location in Google Sheets
Wrk Product avatar
Written by Wrk Product
Updated over a week ago

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

Did this answer your question?