This is an offshoot from my GDConnector extension, and could be considered to be the big brother of my Google Sheets for AppInventor extension.
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: 2.1
- Tested: This has been tested on App Inventor 2 using Android 10 and 13 devices, companion 2.65, and compiled apk. It may work on other derivatives....e.g. Kodular/Niotron/etc.
- Released: 28 March 2022
- Last Updated: 29 January 2023
- Built: Using the Rush Extension Builder by @Shreyash
- V2.1 Update: added two variants of the AppendRow block
BLOCKS & USAGE
V2.1 Added Blocks
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 blocks (selectionIndex 18 - for example). Ensure you have ShowListsAsJson
ticked in your Screen1 Designer properties. In general, the data returned from the script is a stringified JSON, you can use the parse block in the extension to convert this to an AI2 list.
SCRIPT & SETUP
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.
EXTENSION
The extension will only work once the google apps script is in place
GSConnected
Enjoy , and all feedback, comments and ideas for further development welcome.
Available for use in any MIT AppInventor projects or competitions
#####################################################################
This work by TIMAI2 is licensed under a
Creative Commons Attribution-ShareAlike 4.0 Unported License with attribution.
Please use name = TIMAI2 and link to this source page when giving credit.
#####################################################################