[PAID] SpreadSheets Extension - Read, write & modify data from sheets 🔥

SpreadSheets Extension - Read, write & modify data from sheets

An awesome extension to work with google spreadsheet. You can read, write and modify data from your sheets.


Google Spreadsheets Extension - Free & Fastest Database - Scriptless extension. It’s 5x Faster Than Airtable. It also give you offline support once data is loaded. It’s very secure to protect your data from hackers. It can load huge amount of data. It’s very simple and easy to integrate this extension into your application.

Extension Properties


Total Functions & Events

Totally 30 functions and 22 events are available now.

Requirements



Get All Rows


Using this blocks you can get all rows from your sheet. This method is mandatory before using any other blocks. You can use it in your splash screen then enjoy it’s features. No more need to use it again.

totalRow - It's return the total number of rows.

totalColumn - It’s return the total number of columns.

loadTime - It’s return the milliseconds of loading time.

responseContent - It’s return the json string.

contentSize - It’s return the size of your data.

Get Cell


Using this blocks you can get single cell from your sheet.

column - It's return the name of column.

row - It’s return the number of row.

value - It’s return the value of given cell.

Get Column


Using this blocks you can get any column from your sheet. Set 0 on max to get all values from column.

column - It's return the name of column.

values - It’s return the list of values.

length - It’s return the length of given column.

Searching List


Using this blocks you can get single column by filtering.

column - It's return the name of column.

search - It’s return the search text.

values - It’s return the list of matching value.

length - It’s return the length of filtered list.

Get Row


Using this blocks you can get values of any row.

row - It's return the number of row.

values - It’s return the list of values.

columns - It’s return the list of columns.

Get Sheet Names


Using this blocks you can get list of your sheets.

sheetNames - It's return the list of sheet names.

gridIds - It’s return the list of gid ids.

length - It’s return the length of sheet list.

Get Column Names


Using this blocks you can get names of all columns.

columns - It's return the list of names.

length - It’s return the length of list.

Get Spreadsheet Name


Using this blocks you can get your spreadsheet project name.

name - It's return the name of your spreadsheet project.

Total Rows


Using this block you can get total number of all rows.

It's return the total number of loaded row.

Create Column


Using this blocks you can create new column in your sheet.

columnName - It's return the name of column.

columnPosition - It’s return the position of new column.

Create Row


Using this blocks you can create single cell in you sheet.

row - It's return the number of row.

column - It’s return the name of column.

value - It’s return the value.

Create Rows


Using this blocks you can create new row with multiple cells.

response - It's return the response string.

Update Cell


Using this blocks you can update any cell.

column - It's return the name of column.

row - It’s return the row number.

value - It’s return the value.

Update Rows


Using this blocks you can update any row values.

row - It's return the number of row.

Delete Row


Using this blocks you can delete any row by row number.

row - It's return the number of row.

Delete Column


Using this blocks you can delete any column from your sheet.

column - It's return the name of column.

position - It’s return the position of column.

Create Sheet


Using this blocks you can create new sheet in your spreadsheet project.

sheetName - It's return the name of sheet.

Delete Sheet


Using this blocks you can delete any sheet from your spreadsheet project.

sheetName - It's return the name of sheet.

Rename Sheet


Using this blocks you can rename any sheet from your project.

newName - It's return the new name of sheet.

Rename Spreadsheet


Using this blocks you can rename your project name.

name - It's return the new name of your project.

Refresh Data


Using this blocks you can refresh data manually if you disabled Auto Refresh. Otherwise no need to refresh data manually.

functionName - It's return the function name, which is performed before data refreshed.

totalRow - It’s return the total number of rows.

totalColumn - It’s return the total number of columns.

loadTime - It’s return the milliseconds of loading time.

responseContent - It’s return the json string.

contentSize - It’s return the size of your data.

Failed


It’s rises when this extension got or faced any error!

functionName - It's return the function name which function got or faced error.

error - It’s return the error string.

Encode Decode


Using this blocks you can protect your sheet ids and sheet name etc. Set level (1-100) and password length must be 5 or more.

Github Repository



Built using Rush. Used Java 8 features in source code.

Extension specifications:


Version: 8.0.1
Last amendment: 28 August 2022


4 Likes

looks cool…

1 Like

Best alternative of firestore and sql database.
Its very cheap one time payment.

I tested these features successfully

  • I have loaded from Google sheets almost 1,00000 row + 11 column its take load very fast.
  • After loading everything works offline with encryption liken search,coloum,row,cell etc
  • Search large database very quickly.
    Its fixed all database issue your facing currently.
2 Likes

Awsome , keep on :heart:

1 Like

Hey buddy… Though multiple free extensions available this one seems to be unique it seems. You have added more functions… Good work man…

:heart: :heart:

1 Like

This extension provide you very fast data loading experience. And give you offline support once data is loaded. Also it’s script-less!

2 Likes

Amazing… Keep rocking…

2 Likes

Nice extension!!! Too faster, complete blocks and more easier than other similar extensions!!!

2 Likes

Can you show error log?

Where can i find instruction for complete proprerties
property-1

This post was flagged by the community and is temporarily hidden.

This error is not from this extension, see the error snack bar!

And you’re not paid user of this extension

price of this ?

1 Like