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 |
|
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