Webviewer component giving results as undefined

[TIMAI2]

It would probably be much easier to write a simple google apps script web app to get the data back from the spreadsheet than doing it your way....

Use gviz to get and query google sheet data

[gvizscreen1] Guide on how to use the google visualization API to get and query "public" google sheet data Use gviz to get and query google sheet data Note: this approach has been knocking around for years, e.g. https://puravidaapps.com/spreadsheet.php, but I have never seen it "properly" explained like this...

or if a private sheet

Use gviz to get or query PRIVATE google sheet data

[restricted] This guide demonstrates how to use the gviz query language on a private google sheet, with use of an intermediary web app. Use gviz to get or query PRIVATE google sheet data Note: this guide comes with a health warning for developers. It is strongly recommended that developers DO NOT provide users with the option to add a spreadsheet ID in their apps. Spreadsheet IDs should be hard coded into the web app. Failure to do so may provide others with access to your private google she…

or make something up from here:

Google Sheets For AppInventor (replicant!)

Based on the work of Tommy Heng, a google apps script version of the proposed built-in MIT Google Sheets component. Can be considered as a primer on how to use google apps script to do all (?) the things people want to do with google sheets....Includes a barebones aia project (with script file) for developers. [GSFA2] [GSFA1] [image] Google Sheets for AppInventor