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

Retrieves the number of the last row containing data from a sheet in Google Sheets.

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

Link of the Google 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/1eQ

Sheet name

The name of the Google Sheets tab that contains data. 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 section. 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 number

Number of the last row containing data from the provided sheet

Integer

Yes

5

Outcomes

NAME

DESCRIPTION

Success

This status is selected if the row count of the Google Sheets sheet was successfully retrieved.

Unsuccessful

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

- If the spreadsheet link is missing or incorrect

- If the access to the spreadsheet is denied

- If there are no rows with values

Requirements

  • The provided Google Sheets spreadsheet link to the document must have editing permissions.

  • All drives and sheets need to be shared with: googlewrkbots@wrk.com

Did this answer your question?