Retrieve row count from Google Sheets
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 spreadsheetNote: 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