Spreadsheet

Last Updated On 2021-07-16

Version 1MinSDK 7Tutorial Video

Non-visible component that provides access to the Google spreadsheet storage


Properties

You can set the below properties in the UI part of the builder.

  • APIEndpoint - it's a string value which is set to blank by default.
  • SheetName - it's a string value which is set to sheet1 by default.
  • UseSheetData - it's a boolean value which is set to false by default.

Block Properties

You can set the below blocks properties in the blocks section of the builder.

APIEndpoint

API endpoint is the access key that you'll get from us to read/write data on your Spreadsheet.


SheetName

Sheet Name.


UseSheetData

Use sheet data, if true then it'll include return value of sheet when you use offline get data blocks. else include spreadsheet data.



Methods

You can set the below method blocks in the blocks section of the builder.

Delete

Delete a row by number

GetCell

Get Cell Value

GetCellValue

Method for GetCellValue

GetColumn

Get Column

GetColumnList

Method for GetColumnList

GetRow

Get Row

GetRowList

Method for GetRowList

GetSheet

Performs an HTTPS POST request to read/get data from your spreadsheet

GetSheetList

Method for GetSheetList

GetSpreadsheet

Performs an HTTPS POST request to read/get data from your spreadsheet

UpdateData

Update Row by number and columns.

UploadData

Append row in your sheet


Events

You can set the below event blocks in the blocks section of the builder.

DataChange

Event indicating that a request has finished. Here function name return the last function that you call. Exmaple: 1. UPDATE : Update Data 2. UPLOAD : Upload data 3. DELETE : Delete Data

ErrorOccured

Event for error occured

GotCell

Triggered when Get Cell value. Data Type = String

GotColumn

Triggered when got column values as list

GotRow

Triggered when got row values as list

GotSheet

Triggered when got sheet data. Data type = JSON

GotSpreadsheet

Triggered when got spreadsheet data