With this extension, the blocks and the google apps script will only use the google drive and google sheets stored on the developers google drive - the one who sets up the apps script. This removes the need for any authentication, but does have privacy issues for users.
You will be able to perform some basic drive functions to create folders and sheets, and then a wide range of sheets functions to allow for full CRUD functionality (Create,Read,Update,Delete), and much more, on google sheets. By using a google apps script, you can work with private or public spreadsheets.
- Latest Version: 1.0
- Tested: This has been tested on App Inventor 2 using Android 10 and 12 devices, companion 2.62, and compiled apk. It may work on other derivatives....e.g. Kodular/Niotron/etc.
- Released: 28 March 2022
- Last Updated: 28 March 2022
- Built: Using the Rush Extension Builder by @Shreyash
BLOCKS & USAGE
When working with ranges, rows and columns, please pay particular attention to the list structure format requested for each type. This is shown in the bocks (selectionIndex 18 - for example). ensure you have
ShowListsAsJson ticked in your Screen1 Designer properties.
SCRIPT & SETUP
ScriptGSConnected.txt (13.4 KB)
Once you have created your new apps script, delete anything in Code.gs and paste everything in the above txt file. Save, then publish as a web app, with "Me - your google account" and access to Anyone/Anyone even anonymous. Get the script url for use in your app.
How to create a google apps script web app - you can use a bound or a standalone script for this.
The extension will only work once the google apps script is in place
uk.co.metricrat.gsconnectedV1.0.aix (15.2 KB)
Enjoy , and all feedback, comments and ideas for further development welcome.
Available for use in any MIT AppInventor projects or competitions