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

Retrieves data from a Google Sheet 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.
โ€‹

This Wrk Action divides. For more information on divides please visit our article explaining Divides.

Common use cases

  • Data Manipulation

Application

  • Google Sheets

Inputs (what you have)

NAME

DESCRIPTION

TYPE

REQUIRED

EXAMPLE

Spreadsheet link

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

URL

Yes

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

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 theData Library are the outputs of previous Wrk Actions in the Wrkflow.

Outputs (what you get)

NAME

DESCRIPTION

TYPE

REQUIRED

EXAMPLE

Row number

Row number associated with the results retrieved.

Integers

Yes

1

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

15

Outcomes

NAME

DESCRIPTION

Success

This status is selected if the data was successfully retrieved from the Google Sheets sheet.

Information missing

This status is selected if the information that has to be retrieved is missing.

Unsuccessful

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

- If the Google Sheet link is missing or incorrect

- If the access to the Google sheet is denied

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?