ReadSheet
Reads data from a specified range in a Google Sheets spreadsheet.
Last updated
Was this helpful?
Reads data from a specified range in a Google Sheets spreadsheet.
Task version: 1.0.0
Required Frends version: 5.7+
Required .NET version: 8.0
Compatible Agents: Crossplatform
Source code: https://github.com/FrendsPlatform/Frends.GoogleSheets/tree/main/Frends.GoogleSheets.ReadSheet
SpreadsheetId : String
The ID of the spreadsheet.
Default: -
Example: abcdef12345...98765ABC
Range : String
The range of cells to read from the sheet, in A1 notation.
Default: Sheet1!A1:C10
Example: Sheet1!A1:C10
🗝ServiceAccountJson : String
JSON string containing service account credentials.
Default: -
Example: { "type": "service_account", "project_id": ..., "private_key_id": ... }
ThrowErrorOnFailure : Boolean
Whether to throw an error on failure.
Default: True
Example: false
ErrorMessageOnFailure : String
Overrides the error message on failure.
Default: -
Example: Custom error message
Success : Boolean
Indicates if the task completed successfully.
Example: true
Data : Object
Sheet cell data read from the specified range.
Range : String
Range that was read from the sheet.
MajorDimension : String
Major dimension of the returned data (ROWS or COLUMNS).
ETag : String
ETag of the response.
Error : Error
Error that occurred during task execution.
Example: object { string Message, Exception AdditionalInfo }
Changelog for Task Frends.GoogleSheets.ReadSheet.
Initial implementation
Last updated
Was this helpful?
Was this helpful?