Get row data Version 3 (Net)

Action group: Google services

Description

The action gets data from the specified table row.

Action icon

Settings of parameters 

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextIndentifier of session for actionRobin.SpreadShee tsSpreadSheets contextYes
Document IDIndentifier of document for actionRobin.String
Yes
SheetName of working sheet. By default, the first sheet of the document.Robin.String
No
Row indexIndex of row to get dataRobin.Numeric
Yes
Results
ResultThe collection in which the received data will be stored.Robin.Collection

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_16-59-14.png

Take the data from row "3" and get the value at index "2" from the collection. Output the result to the dialog box.

Solution

Use the "Context Google tables", "Get row data", "Get value by index", "Show message" 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 row data" action parameters.

    In the ID field specify the part of the table's link.

  4. Set the "Get value by index" action parameters.
  5. Set the "Show message" action parameters.

  6. Click "Start" in the top panel.

Result

The program robot completed successfully. The row data was obtained.

The value at index "2" is displayed in the dialog box.