Google SpreadSheets Extension - Free and Fastest Database [Updated-v4] [Extension] [PAID]

Google SpreadSheets Extension - 5x Faster Than Airtable [Extension] [PAID]

Offline Supported!

Hey Guys!

I have built This Awesome And Useful Extensions For You.

Now You can use Google SpreadSheets as a database of your app using this Extension.
This is the very first release, I’ll add more features as soon as possible.

Super Faster Extension.

Now It's Support Asynchronous Data Loading and Offline For Better Use.

Just use GetAllRows Block on Screen1 and then use it anywhere or on any Screen multiple times, as you want. This extension makes your app more smooth and crashless. It works asynchronously to load huge amount of data.


  • Let’s See Total Block
    This Extension have 26 Functions and 21 Events and 4 Properties Available On This Time.



  • Changes Of Designer Section
    You need to have changes SheetID with your Google Spreadsheets SheetID and Sheet Name with your Spreadsheet Sheet name. You can set SheetID, Sheet Name and APIKey Dynamically from block section.

image


  • Sheet Name & SheetID
    You can change your Sheet Name and SheetId dynamically from block section.

image


  • Where Can You Get SheetID and Sheet Name
    Example Of SheetID


Example Of Sheet Name


  • Requirement

  • For Read Data From Sheet
    File - Publish to the web

  • For Write Data To Sheet
    You need to share your Sheets Anyone with the link with Editor access.


  • Get All Rows
    Example Of Get All Rows. It’s Async. Get All Rows method is required to use any other get method.

  • totalRow: It’s return the total number of rows.

  • Get Column
    Two Different Example of Get Single Column. Async Method is For Load Huge Amount of Data With Lag Free UI.

image

  • column: It’s return the column name.
  • values: It’s return the values of column.
  • length: It’s return the length of column.

  • Get Max Column
    Two Different Example of Get Single Column With Max Record. Use Async Method To Load Huge Amount of Data With Lag Free UI.

image

  • column: It’s return the column name.
  • values: It’s return the values of column.
  • length: It’s return the length of column.

  • Get Cell
    Two Different Example of Get Single Cell. Async Method is For To Get Lag Free UI.

image

  • column: It’s return the column name of cell.
  • row: It’s return the row of cell.
  • value: It’s return the value of cell.

  • Get Filtered List
    Two Different Example of Get Filtered Column. This is an advance features. Use Async Method To Search On Huge Amount of Data With Lag Free UI.

  • column: It’s return the column name.
  • searchText: It’s return the given search text.
  • matches: It’s return list with matches by search.
  • matchesLength: It’s return the length of matches list.
  • nonMatches: It’s return list with non matches by search.
  • nonMatchesLength: It’s return the length of non matches list.

  • Failed
    Rises when got any error with function name.

image

  • functionName: It’s return the name of function which function got the error. It’s return as string.
  • error: It’s return the error string.

  • TotalRows
    It’s returns the total number of rows.

image


  • Update Cell
    Now You Can Update Cell Using This Block.

image

  • column: It’s return the column name.
  • row: It’s return the row number as Integer.
  • value: It’s return the given value as string.
  • response: It’s return the response as string.

  • Get Row
    Get Row values using row number. It also works asynchronously.

image

  • row: It’s return the row number as integer.
  • values: It’s return list of values.
  • columns: It’s return list of column names.

  • CreateRows
    Using this block you can create new row or rows with multiple values. You can use list of values, just maintain column names serial.

image

  • response: It’s return the response as string.

  • DeleteRow
    Using this block you can delete any row by using row number.

image

  • response: It’s return the response as string.
  • row: It’s return the deleted row number.

  • UpdateRows
    Using this block you can update your row values by using row number and column names with new values. You can use make a list to update multiple rows.

image

  • row: It’s return the given row number.
  • response: It’s return the response as string.

  • GetSheetList
    Using this block you can get your sheet name list.

image

  • values: It’s return list of sheet names.
  • length: It’s return the length of list.

  • GetColumnNames
    Using this block you can get column names from your sheet.

image

  • columns: It’s return list of column names.
  • length: It’s return the length of column names list.

  • CreateRow
    Using this block you can create new row by Column Name.

image

  • row: It’s return the new row.
  • column: It’s return the given column name.
  • value: It’s return the given value as string.

  • DeleteColumn
    Using this block you can delete any specific column from your sheet.

image

  • column: It’s return the deleted column name.

  • CreateSheet
    Using this block you can create new sheet in your spreadsheet.

image

  • sheetName: It’s return the new created sheet name.

  • DeleteSheet
    Using this block you can delete any specific sheet by sheet name.

image

  • sheetName: It’s return the deleted sheet name.

  • GetSpreadsheetName
    Using this block you can get the name of your spreadsheet project.

image

  • name: It’s return the name of spreadsheet project.

  • RenameSpreadsheet
    Using this block you can rename your spreadsheet project name.

image

  • name: It’s return the new name of spreadsheet project.

  • RenameSheet
    Using this block you can rename your specific sheet by sheet name.

image

  • new Name: It’s return the new name of given sheet.

  • DataRefreshed
    Rises when data refreshed automatically after using any data write functions. Handle users activity using function name.

image

  • function Name: It’s return the function name which used before data refreshed.

  • Let’s See Some Demo
  • Synchronous Method

  • Asynchronous Method


I hope you’ll enjoy this extension.

    Price Plan -

  • $10.98 - Standard Edition

  • $25.99 - Premium Edition

  • $35.99 - Platinum Edition

  • $52.99 - Flash Edition

    PAYPAL, PAYTM, UPI Accepted!


Plan Explain
  1. Standard Edition - Normal speed and You are available to use all of functions of this extension but you have some limitations. (Recommend for mid budget users)
  2. Premium Edition - Premium speed and You are available to use all of functions of this extension with api limitations. (Recommend for all)
  3. Platinum Edition - Fastest and no limitations & lifetime support! (Recommend for higher end budget only)
  4. Flash Edition - Ultra fast, speed like paid hosting and no limitations with lifetime support! (Money refund guaranteed if data loading speed is not fast enough.)

Updates Logs
  • Flash Edition is looking same with other version, but speed is awesome and money refund guaranteed if data loading speed not fast enough.

  • Added Create Row Method To Create New Row Using Column Name.

  • Added Update Rows Method To Update Your Row With New Values By Using Row Number & Column Names.

  • Added Get Sheet List Method To Get The List Of Your Sheets.

  • Added Create Rows Method To Create New Row Or Rows In Your Sheet.

  • Added Delete Row Method To Delete Any Row Using Row Number.

  • Added Get Row Method To Get Single Row Values Using Row Number.

  • Added Set Cell Blocks To Set Cell Using Column and Row Number.

  • Added Offline Support

  • Added Asynchronous Method to load huge amount of data.

  • Now it’s more faster, load data from Screen1 and use anywhere or any Screen without data calling. This features is unique and it’s make this extension Super Fast. (Updated On: 16 Dec 2020)

  • Just One Call To Load All Items.

  • You don’t need to call more time in one page.

  • Very Fast and Easy To Use.

  • You Can get Column By Filter.



Extension Name and Size:

Google Spreadsheets.aix (104.1 KB)
Version: 4.3.2


NOTICE:-
Set Cell Method is not working on Version 2 or in lower version. Please knock me who are using old version to get latest version.


Message Me To Buy To get my social contact information, click on my name or profile avatar. @JEWEL

If you need the source code, you can contact with me.

  • Watch The Test Video

Load Data From Screen1 and Use it Anywhere Or Any Screen


My Another Extension

19 Likes

amazing @JEWEL!!!

Thanks a lot dear @luv.ak.tech

1 Like

your welcome @JEWEL!! and again amazing!!

marvelous job

100


100

1 Like

thanks a lot dear @Ekansh_Pandit

1 Like

As you are claiming that is faster, do you have any performance test that proves that…

2 Likes

Nice!

I have changed to “An Alternative For Airtable” at the moment until he gives some reference.

I have uploaded a test video. And I can explain that, it’s faster. It’s faster because it’s data processing system.

1 Like

Provide some benchmark result and a short comparison would be the best.

1 Like

In this condition I can’t share any test Apk, so how can I prove that is faster?

You can see block of this extension. No need to call data again again. Only one call that use many times as you want. No need more time to load data. It’s store all data to local storage and then get from there.

I have explained it’s data processing system, I hope you are understand what I’m trying to explain.

A video of comparison is enough :blush:

I understood. But other people might not.

1 Like

Hi,

There are no methods in your extension to create row, column or cell, why?

This is the very first version, I’ll update it as soon as possible and I declared that, every next update will be free for paid users.

Thanks @The_K_Studio

1 Like

I am interested, but if you add all methods that are available in airtable spreadsheet blocks.

Also, in your extension blocks, you have directly returned get column, get cell, instead of that It should return in respective event block.

I have tested that, this direct method is more time faster and you don’t have to wait for an event. And If you buy it, you will get all updates free. I have already working on it. And one more thing, this is lifetime free after you buy from me. No yearly or monthly charge needed.

1 Like

Nice extension!

But I didn’t like the idea of providing different prices for different versions, as already there are free extensions available but the users who want to buy this would not buy seeing this :sweat_smile: :sweat:
So you should keep the same price which once paid the purchaser could get all future updates as well

3 Likes

@Soham_Shah thanks for your advice, I have updated the price plan. If you interested, you can message me.

2 Likes

Nice :thumbsup:

Nice extension, but we can only request data. I think, it will be far better if we can also edit our data. Which I think you will add in upcoming updates :ok_hand:

3 Likes