Skip to main content
All CollectionsWrk Action LibraryGoogle Sheets
Retrieve data from a row in Google Sheets
Retrieve data from a row in Google Sheets
Wrk Product avatar
Written by Wrk Product
Updated over a week ago

Retrieves one or more fields from a row in a Google Sheets spreadsheet. Data should be organized as a table with column headers in the first row. Every row other than the headers represents a set of data to be captured.

Common use cases

  • Data Manipulation

Category

  • Google Sheets

Inputs (what you have)

NAME

DESCRIPTION

TYPE

REQUIRED

EXAMPLE

Spreadsheet link

Link of the Google Sheets spreadsheet.

Note: Spreadsheet should provide view access to anyone accessing the spreadsheet via the URL (i.e. Anyone with the link).

Link

Yes

https://docs.google.com/spreadsheets/d/1-/edit

Row number

Row where the values reside

Number

Yes

2

Fields to capture

Add all headers where the data should be retrieved from. Headers must have the exact names as seen in the sheet and the correct data type.

Note: Headers defined here will also act as outputs to the Wrk Action

Any of the following:

  • Text

  • Decimals

  • Integers

  • True/False

  • Website Link

Yes

2

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

To be defined

The outputs will be defined by the user within the Fields to capture section.

Any of the following:

  • Text

  • Decimals

  • Integers

  • True/False

  • Website Link

Yes

Outcomes

NAME

DESCRIPTION

Success

This status is selected if the value from specified fields was successfully retrieved from the specified row in a Google Sheets.

Missing Info

This status is selected in the event of the following scenarios:

- If the first row does not contain the titles of the columns

Unsuccessful

This status is selected in the event of the following scenarios:

- If the Google Sheets spreadsheet link is missing or incorrect

- If the access to the Google sheet is denied

Requirements

  • The data within the spreadsheet should be formatted as a table, with header names located in Row 1 of the sheet

  • All Drives and Sheets need to be shared with: googlewrkbots@wrk.com

Did this answer your question?