Get range from Google sheet to populate spinner elements

[TIMAI2]

Yes

You can use this:

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 Note: this approach has been knocking around for years, e.g. App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps, but I have never seen it "properly" explained like this...

or

HOWTO: Get A Range from a Google Sheet

Assumes your google sheet has permissions set to "anyone with the link" as a minimum BLOCKS [blocks (9)] SCREEN [image] AIA gsGetARange.aia (3.0 KB) URL https://docs.google.com/spreadsheets/d/\ 1pCRdJZSTFma8-RoXqHz6I5Z_xqcNAbi95r8cSGtZzyE\ /export?format=csv\ &gid=0\ &range=A1:A11 If you put this in a browser address bar it will download a csv file. If you want to keep your sheet private, then you will need a web app to help you, see here:

or this may give ideas

• Get a Single Cell from a Google Sheet

Also:

FAQ Section: Google Sheets

Starter Guides Download a Google Sheet as CSV for the Media Folder and load it at startup - ABG AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Creating a Credential for Google Sheets - @Gordon_Lu Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web…

and

Spinner Setup

The spinner component is an odd thing, and requires some rigour to get control of it. This is how I usually setup a spinner so that all the selections are available every time. I use a button to set the selection and call the spinner dropdown, and "hide" the spinner. by setting its height and width to 1 pixel each. If placed inside a centred horizontal arrangement, the spinner should be invisible in all themes. Note: something has recently changed with the spinner, it seems you can now set hei…