Get column data (Google services)

Get column data Version 3 (Net)

Action group: Google services

Description

the action gets data from the specified table column.

Action icon

Settings of parameters

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Indentifier of session for action	Robin.SpreadShee ts	SpreadSheets context	Yes
Document ID	Indentifier of document for action	Robin.String		Yes
Sheet	Name of working sheet. By default, the first sheet of the document.	Robin.String		No
Column	Name of column to get data	Robin.String		Yes
Results
Result	Collection of data	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.

If the request is completed in that time, the action will complete successfully.
If the request cannot be sent in this time, the robot will terminate with an error.

Example of use

Task

There is a Google sheet with values:

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

Solution

Use the "Context Google tables", "Get column data", "Get value by index", "Show message" actions.

Implementation

Assemble a robot scheme with the actions:
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)
Set the "Get column data" action parameters.

In the ID field specify the part of the table's link.
Set the "Get value by index" action parameters.
Set the "Show message" action parameters.
Click "Start" in the top panel.