Description
Reads a content of a Google Sheets table in the specified range. To make the function work, you need to provide the platform access to the Google Services through Bot Runner or Studio Pro.
Bot Runner:
Right click on the 'ElectroNeek Bot Runner' in the bottom right tray → "Settings" → "Services".
Studio Pro:
Navigate to "Settings" → "Services Connection".
Parameters
-
Set a value: enables you to directly write the id.
-
Save the previous step result: chooses the previous activity result as the id.
-
Calculate a value: enables you to use available properties and methods to form the id.
To get the spreadsheet id open manually the document. The text between '/d/' and '/edit' is the spreadsheet id.
-
Set a value: enables you to directly set the desired range, for example,
A1:B3
or'Sheet3'!A1:C5
. -
Save the previous step result: chooses the previous activity result as the range.
-
Calculate a value: enables you to use available properties and methods to form the range.
Contains an annotation to the activity. The input text will be displayed above the activity name.
Result
To store the result in a variable, a user needs to add the 'Assign value to variable' activity after the 'Get Values' activity, specify the variable name and choose the 'Save the previous step result' activity.
The result is an array of rows. Each row represents an array of the cells values.
For example, this record
[
[
"Value A1",
"Value B1",
"Value C1"
],
[
"Value A2",
"Value B2",
"Value C2"
]
]
will represent the following table from the Google Sheets
A |
B |
C |
Value A1 |
Value B1 |
Value C1 |
Value A2 |
Value B2 |
Value C2 |
Usage Examples
This activity should be used to read a content of an online-table for further data manipulation.