Get the number of rows Version 4 (Net)

Action group: Google services

Description

The action returns the number of rows. Rows within the context range used are counted. If you enter a column outside this range, the action will return an empty result. 

Action icon


Settings of parameters 

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextIdentifier of the session to which the action will be applied.Robin.SpreadShee tsSpreadSheets contextYes
Document IDIdentifier of the document to apply the action to.Robin.String
Yes
SheetName of working sheet. By default, the first sheet of the document.Robin.String
No
ColumnColumn of the cell in which the absence of values will be checked.Robin.String
Yes
Skip hidden cellsCount only visible lines.Robin.BooleantrueNo
Skip emptyCount only filled lines.Robin.BooleantrueNo
Results
ResultVariable in which the number of rows will be written.Robin.Numeric

Special conditions of use

The Google Sheets API has a limit of up to 60 read-requests per user per minute. To ensure that the action does not immediately generate an error when the limit on the number of requests is reached, the action includes a loop operation that will resend requests within a minute.

Example of use

Task

There is a table with values:

image2024-1-24_14-22-19.png

Get the number of filled rows in column "A" into a numeric variable. 

Solution

Use the "Context Google tables", "Get the number of rows" actions.

Implementation

  1. Assemble a robot scheme with the actions:
  2. Set the "Context Google tables" action parameters.

    Fill in the "The file path" and "Application name" fields (more about filling in these fields in section Instructions for setting up a connection to Google Sheets/Docs/Drive).
  3. Set the "Get the number of rows" action parameters.

    In the ID field specify the part of the table's link.
  4. Click "Start" in the top panel to start the robot.

Result

The program robot completed successfully. The number of filled rows in the table of column "A" is obtained.