How to perform a Query on Google Sheets

How to query for a particular cell in row on Google Sheets and get back in the app a result of another cell attributed to that row

to make it more clear i've upload a picture
i want to type the customer id in my app and get back as a result the type that related to this customer id

If your google sheet is private then:

How to query any google sheet

otherwise use the gviz approach as found in this tutorial:

Google Query

1 Like

see also this solution, which uses the Google Visualization API App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

1 Like