Google spreadsheet extension

Documentation https://github.com/doxuanhop/Spreadsheet

**Spreadsheet**

Last Updated On 2024-03-23

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 returns the last function that you called. 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 received column values ​​as list

**GotRow**

Triggered when received row values ​​as list

**GotSheet**

Triggered when receiving sheet data. Data type = JSON

**GotSpreadsheet**

Triggered when receiving spreadsheet data

### Apps Script

This script is designed to handle requests to interact with Google Sheets data. Here’s a breakdown of its key components:

1. **Normalization Function**: The `normalizeString()` function is used to normalize a string containing accented characters to ensure consistent handling.