Google sheet data read

[Rafik30905]

How to read google sheet data, or how to read google sheet Single cell data on appinventor apps?

[GuiM_Haes]

see

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

[TIMAI2]

Get a Single Cell from a Google Sheet

[Patryk_F]

Have you visited the frequently asked questions section?

FAQ Section: Google Sheets

AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT 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 Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - TimAI2 Google Sheets Create/Read/Update/Delete(CRUD…

[TIMAI2]

Also

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...