[Paid] Google Spreadsheets Extension - Free & Fastest Database {Script-Less} (7.0.1)

Google SpreadSheets Extension - 5x Faster Than Airtable

Free & Fastest Database - Version: 7.0.1

Hello guys, I've built this awesome extension for you to work with google sheet. Using this extension you can write and read data from your sheets.

Total Blocks

Now 30 functions, 4 properties and 22 events available!.



Extension Properties

Designer Property
image

Block Properties
image


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

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

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

Get Max Column
Using this blocks you can get column by limited length.
image

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

Get Filter List
Using this blocks you can get single column by filtering.
image

  • column --> It's return the name of column.
  • searchText --> It's return the search text.
  • matches --> It's return the list of matching value.
  • matchesLength --> It's return the length of filtered list.
  • nonMatches --> It's return the list of non matching value.
  • nonMatchesLength --> It's return the length of non matching list.

Get Row
Using this blocks you can get values of any row.
image

  • 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 List
Using this blocks you can get list of your sheets.
image

  • 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 Columns Name
Using this blocks you can get names of all columns.
image

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

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

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


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

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

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

  • response --> It's return the response string.

Update Cell
Using this blocks you can update any cell.
image

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

  • row --> It's return the number of row.

Delete Row
Using this blocks you can delete any row by row number.
image

  • row --> It's return the number of row.

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

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

  • sheetName --> It's return the name of sheet.

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

  • sheetName --> It's return the name of sheet.

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

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

Rename Spreadsheet
Using this blocks you can rename your project name.
image

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

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

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


    Price Plan -

  • $5 USD - Standard Edition

  • $10 USD - Premium Edition

  • $15 USD - Platinum Edition

  • $20 USD - Flash Edition

  • $25 USD - Speedster Edition


Plan Explain
  1. Standard Edition - Speed, validity and some functions are limited. Also you'll not get any future updates for free.
  2. Premium Edition - Speed and validity is encreased. Unlocked all of functions but plan upgrade limitation remain. Recommend for mid budget users.
  3. Platinum Edition - Speed and validity is more extended. Remain upgrade limitation. Recommend for all.
  4. Flash Edition - More validity and no speed limitations & updates are totally free! Tested with 1M rows! Recommend for higher end budget only.
  5. Speedster Edition - Everything is unlocked and premium. No limitations & lifetime support! Tested with 2M rows! Recommend for higher end budget only.

Testing Video ↓



GitHub Repository ↓


Extension Specifications:

[mod edit: removed misleading download link]

Version: 7.0.1
Last amendment: 06 Jan 2022


4 Likes

All comment merged

Some bugs fixed

(added to FAQ)

1 Like

Wow, that is the Best Extension @JEWEL

1 Like

thanks dear @Salman_Dev

1 Like

Unlisted, should be using App Inventor blocks to demonstrate that it works with App Inventor.

1 Like

Pardon me for a dumb question ...

Does this work in AI2?

Yes, it'll be working with app inventor

Dear @TIMAI2, now I have added App Inventor blocks, please return it into list. :pray:

Different purchase plans need a better explanation.

  • Is the "Lite" plan for one project at a time or just one project total?
  • What are the "limitations?"
  • How are the "speeds" of different editions controlled?
2 Likes

Dear @Harry_Mangurian, I have explained every plan in main topic.

Lite Edition - Premium speed but You can use this only in one of your project. (Recommend for lower end budget users)

Please look at my questions on your definitions. Limitations ???, how is speed throttled ???,

1 Like

All that this extension does can be done with google script and blocks as well. See @TIMAI2 tutorials.

4 Likes

Yea I have the same question. Every time most of the extensions to request to any servers/scripts which could be done without any extension. Also how do you calculate the speed in you're extension? Is it like made slower to low-end versions? And what does alternative database mean?

Dear @Kumaraswamy, I know that some extension doing just api call and it's can be done without extension. But this extension just not like api call, many other thinks done here, what you can't do without coding. And I have manage speed by my hosting. This is my business.

If you think, it can be done without extension, but you can't. And I'm not forcing anyone to buy it.

But I thought about our users and make different price plan with different qualities.

(Thank you)

Dear @Jewel,

The extension will help those who don't work scripts and all things. I know some features in extension cannot be done from Ai2 or blocks but most of the functionality is possible. If I send a request to the script, the time it takes sometimes depend on the network too. But how is the speed determined in you're extension? I really want to know :slightly_frowning_face:.

This extension is script-less to provide your faster experience.

(Thanks)