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.
- 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: 26 March 2022
- Last Updated: 26 March 2022
- Built: Using the Rush Extension Builder by @Shreyash
Extension (you will need to setup the google apps script for this to work, therefore follow the links to ensure you have everything you need):
Google Sheets for AppInventor V1.0:
uk.co.metricrat.gsai2V1.0.aix (13.3 KB)
GSAI2.java.txt (11.0 KB)
Enjoy , and all feedback and comments welcome.
Available for use in any MIT AppInventor projects or competitions