[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 | Script-less 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. Read release notes for knowing about new features.

Extension Properties



Total Blocks
Totally 23 functions and 21 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.

Search In Column


Using this blocks you can get single column by filtering.

columnName - Column name to search data.

keyword - The search text to filter data.

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

positions - It’s return the positions of filtered data.

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

Advance Search


Using this blocks you can get filtered data by search from two columns.

byColumn - In which column you need to search.

keyword - It’s return the search text.

fromColumn - Data will be get from this column.

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

positions - It’s return the positions of filtered data.

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.


➤ Release Notes ↷


  • 9.5.3: Now you can get positions of filtered data.
  • 9.5.2: Crash issue fixed for Android 8 & lower version.
  • 9.5.1: Fixed an issue & optimize offline / online mode.
  • 9.4.0: Removed NameSpace from designer section.
  • 9.3.0: Bugs fix for offline mode turn off/on option .
  • 9.2.0: Now you can turn off/on offline mode manually.
  • 9.1.2: Support automatically data loading feature.
  • 9.1.0: Smooth experience for loading huge data.
  • 9.0.0: Extension size compressed to 106 KB.

    Testing Video ↓



    :github: GitHub Repository ↓



    Tutorial Videos ↓


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

    Extension specifications:


    Size: 110 KB
    Version: 9.5.3
    Last amendment: 18 January 2023


  • 6 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:

    2 Likes

    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

    I have interest, how i get this? How many i will pay?

    I’ve knocked you in dm, please reply there ←

    Hello i have inerest, let me know please hw many cost this extension, thank you

    :loudspeaker: Launched V9.0.0 and extension size compressed to 97.9 KB only!

    2 Likes

    Please knock me in Telegram to get the latest version (9.0.0)

    Great extention…

    Airtable and Fierbase Database have limitations. So Google Spreadsheet is the only Databse where there is no limitaion completely free…

    I have used this extension. Big data is fetched in a very short time…

    Keep it up… :+1:

    I can know the price, I would like to buy.
    Thank you