Google SpreadSheets Extension - Free and Fastest Database [Updated-v5] [Extension] [PAID] [Demo Apk Added]

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

Offline Supported and Demo Apk Added!

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

  • $31.99 - Platinum Edition

  • $41.99 - Flash Edition

  • $52.99 - Speedster Edition

    TransferWise, 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! (Tested with 30K rows.)
  5. Speedster Edition - Best speed experience, how fast can possible with google spreadsheet without limitations with lifetime support! (Tested with 1M rows.)

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.



Demo Application -

Now you can try this extension with your sheet id before paid. Just you need to publish your sheet to web for try with this demo apk.

This demo application has api limit, if api limit finished and you want to try this after limit finished, just knock me. I’ll give you free trial to test this application with your sheet id.

You need to set Sheet Id, Sheet Name and Column Name for testing.

This application also show you the loading time.


Enjoy The Demo Application -

Spreadsheet-Demo_v2.apk (2.6 MB)

Download this application and try this with your sheet id. It’s free but it has api limitations. (I've build this application only for testing purpose.)


Extension Name and Size:

Google Spreadsheets.aix (104.1 KB)
Version: 4.3.6


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

20 Likes

amazing @JEWEL!!!

Thanks a lot dear @luv.ak.tech

2 Likes

your welcome @JEWEL!! and again amazing!!

marvelous job

100


100

1 Like

thanks a lot dear @Ekansh_Pandit

2 Likes

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

3 Likes

Nice!

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

1 Like

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

2 Likes

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

2 Likes

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.

1 Like

A video of comparison is enough :blush:

I understood. But other people might not.

2 Likes

Hi,

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

1 Like

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

2 Likes

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.

1 Like

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.

2 Likes

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

4 Likes

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

3 Likes

Nice :thumbsup:

1 Like

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:

4 Likes