[PAID] Spreadsheets Extension : Read, write & modify data from sheets 🔥

Spreadsheets Extension - Read, write & modify data from sheets :zap:

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.

:arrow_down: Extension Properties


Requirements

:arrow_down: Get All Rows


Using this blocks you can get all rows from your sheet.

image

image

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.
response Content - It’s return the Json string.

:arrow_down: Get Column


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

image

column Name - Enter column name.
max - Enter limit to get values.

image

column Name - It’s return the name of column.
values - It’s return the list of values.
length - It’s return the length of given column.

:arrow_down: Get Cell


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

image

columnName - Enter column name.
row Number - Enter row number.

image

column Name - It’s return given column name.
row Number - It’s return given row number.
value - It’s return cell value.

:mag_right: Search


Using this blocks you can get single column by filtering.

image

column Name - Enter Column name to search data.
keyword - Enter search text to filter data.

image

column Name - It’s return the given column name.
keyword - It’s return the given keyword.
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.

:mag_right: Advance Search


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

image

byColumn - Enter column name to search.
keyword - Enter search text.
fromColumn - Enter column name to fetch data.

image

byColumn - It’s return byColumn name.
keyword - It’s return search text.
fromColumn - It’s return fromColumn name.
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.

:arrow_down: Get Row


Using this blocks you can get values of any row.

image

row Number - Enter row number to get values.

image

row Number - It’s return the row number.
values - It’s return the list of values.
column Names - It’s return the list of column names.

:arrow_down: Get Sheet Names


Using this blocks you can get list of your sheets.

image

image

sheetNames - It’s return the list of sheet names.
gidIds - It’s return the list of gid ids.
length - It’s return the length of sheet list.

:arrow_down: Get Column Names


Using this blocks you can get names of all columns.

image

image

column Names - It’s return the list of column names.
length - It’s return the length of list.

:arrow_down: Get Spreadsheet Name


Using this blocks you can get your spreadsheet project name.

image

image

spreadsheetName - It’s return the name of your spreadsheet project.

:arrow_down: Total Rows


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

:heavy_plus_sign: Create Column With


Using this blocks you can create new column with new values.

image

column Name - Enter column name to create a new column into sheet.
values - Enter column values as list.

image

image

column Name - It’s return the column name.

:heavy_plus_sign: Create Multiple Column With


Using this blocks you can create multiple column in single request with new values for every column. Watch tutorial :video_camera: videos for better understanding.

image

column Names - Enter multiple column names as list.
values - Enter values as nested list for every column.

image

image

column Names - It’s return the names or columns as list.

:heavy_plus_sign: Create Column


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

image

column Name - Enter new name to create column.

image

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

:heavy_plus_sign: Add Values To Column


Using this blocks you can add new values to exciting column.

image

column Name - Enter column name as string.
values - Enter values as list.

image

column Name - It’s return the name of column.

:heavy_plus_sign: Create Row


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

image

column Name - Enter the column name where need to create row.
value - Enter cell value to create row.

image

row Number - It’s return the number of row.
column Name - It’s return the name of column.
value - It’s return the value.

:heavy_plus_sign: Create Rows


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

image

values - Enter values as list to create new row.

image

response - It’s return the response string.

:heavy_plus_sign: Create Multiple Rows


Using this blocks you can create multiple new rows in a single request.

image

values - Enter new values as nested list for every single row.

image

response - It’s return the response message as string.

:heavy_plus_sign: Create Sheet


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

image

sheetName - Enter new sheet name.

image

sheetName - It’s return the name of sheet.

:arrow_heading_up: Update Cell


Using this blocks you can update any cell.

image

column Name - Enter column name.
row Number - Enter row number.
value - Enter new value.

image

column Name - It’s return the name of column.
row Number - It’s return the row number.
value - It’s return the value.

:arrow_heading_up: Update Rows


Using this blocks you can update any row values.

image

row Number - Enter row number.
column Names - Enter column names as list…
values - Enter values as list.

image

row Number - It’s return the number of row.

:scissors: Delete Row


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

image

row Number - Enter row number.

image

row Number - It’s return the number of row.

:scissors: Delete Column


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

image

column Name - Enter column name to delete.

image

column Name - It’s return the name of column.
position - It’s return the position of column.

:scissors: Delete Sheet


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

image

sheetName - Enter sheet name to delete.

image

sheetName - It’s return the name of sheet.

:writing_hand: Rename Sheet


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

image

oldName - Enter old name of sheet.
new Name - Enter new name to rename sheet.

image

new Name - It’s return the new name of sheet.
oldName - It’s return the old name.

:writing_hand: Rename Spreadsheet


Using this blocks you can rename your project name.

image

name - Enter new name to rename spreadsheet project name.

image

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

:repeat: Replace All


Using this function you can replace all matching text from active sheet with new value.

image

text - Enter text to replace with new value.
replaceWith - Enter new value to replace with old value.

image

text - It’s return the old value.
replaceWith - It’s return the new value.

:repeat: Replace By Column

Using this function you can replace all matching text from column with new value.

image

columnName - Enter column name where you want to replace values.
text - Enter text to replace with new value.
replaceWith - Enter new value to replace with old value.

image

columnName - It’s return the column name.
text - It’s return the old value.
replaceWith - It’s return the new value.

:repeat: Replace By Row

Using this function you can replace all matching text from row with new value.

image

rowNumber - Enter row number where you want to replace values.
text - Enter text to replace with new value.
replaceWith - Enter new value to replace with old value.

image

rowNumber - It’s return the row number.
text - It’s return the old value.
replaceWith - It’s return the new value.

:repeat: Replace For All Sheets

Using this function you can replace all matching text from all sheets with new value.

image

text - Enter text to replace with new value.
replaceWith - Enter new value to replace with old value.

image

text - It’s return the old value.
replaceWith - It’s return the new value.

:arrows_clockwise: Refresh Data


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

image

image

function Name - It’s return the function name which function refresh data automatically.
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.
response Content - It’s return the Json string.

:warning: Failed


It’s rises when the extension got any error.

image

function Name - It’s return the function name which function got error.
error Message - It’s return the error message as string.

:closed_lock_with_key: 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.

image

image


:memo: Release Notes ↷


  • 11.0.0: Added some 💪 powerful features.
    (CreateColumnWith, CreateMultipleColumnWith, AddValuesToColumn, CreateMultipleRows)
  • 10.0.1: Changed some blocks names.
  • 10.0.0: Added 3 new functions (ReplaceByColumn, ReplaceByRow, ReplaceForAllSheets).
  • 9.6.0: Added new ReplaceAll function.
  • 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.

    :tv: Testing Video ↓



    :github: GitHub Repository ↓



    :tv: Tutorial Videos ↓


    :receipt: Extension Specifications:


    image

    :information_source: Size: 135 KB
    :gear: Version: 11.0.0 (Latest)
    :earth_americas: Released On: 26 February 2021 (GMT+06:00)
    :earth_americas: Updated On: 18 February 2023 (GMT+06:00)
    :github: GitHub Repository: SpreadSheets
    :credit_card: Payment methods: Binance | Skrill | Wise | Pyypl | Xoom | Pay2Me | Paypal


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