Activity «Read a cell range» can be found in section «Google Sheets».
The activity allows to get a table of values for the specified range of sheet cells.
Important! To work with the Google Sheets service, you need to connect by following the Instructions for configuring Google Sheets.
Property; Class; Type; Description
Sheet; In; String; Name of the sheet to read data from.
Range; In; String; Range of cells to read. If no range is specified, the entire available table is read.
With headers; In; Boolean; Read the first row as column headers of a DataTable?
Result; Out; DataTable; The table of values of cell range.
Service; In; Activities.GoogleSheets.Core. GoogleSheetsService; A service that allows to work with Google Tables.