Google Spreadsheet Extension
A Non-Visible component that helps you to perform CRUD operation on your Google Spreadsheet.
Documentation of Extension:
Note:
The extension is free but you have to buy Google Apps Script.
You have to pay 25$ for the Apps Script.
After buying the Apps Script you need to deploy on your Google Account.(If you are not able to do that I will help you.)
In future if I will add new methods then you also get free upgrade.
Download Link:
com.preet.spreadsheet.aix (18.1 KB)
If you are interested to buy then please DM me on community.
7 Likes
Awesome work @preetvadaliya sir
Great extension, but I wonder if there is already free alternatives (including Apps Script).
With reference to this previous guide:
I have now written an extension to compliment the google apps script, therefore no need to write any complicated block structures. The extension follows the original blocks provided by Tommy Heng, but updates and improves on them. It has not yet been aligned with the latest version of the Google Sheets component currently available for testing (as of writing this), although it appears to be much the same.
Google Sheets for AppInventor
Latest Version: …
Also here is a guide for reading cell, column, sheet and number of columns/sheets with 0 Apps Script and 0 extensions.
In this guide, you will learn how to read a specific column/row from Google Sheets, and also how to get the number of columns or rows in a Google Sheet. You can also get the data of a specific cell.
This is a demo to let you know that you do NOT need...
@gordonlu310 , Yes you are right but this extension have extra methods also. you can create new spreadsheet also. CRUD on sheet itself and CRUD on data also.
3 Likes