Need exact cell value from spreadsheet

[Kandasamy_Vaiyapuri]

Please kindly support to extract the spreadsheet cell data individually

[Taifun]

one possibility is to use the spreadsheet component

Spreadsheet component. Example. Google Sheets

In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API. How to create the Service Account, here: http://ai2.appinventor.mit.edu/reference/other/googlesheets-api-setup.html At the end of the whole process we will obtain a file of the form: app-inventor-338017-8c72fd465555.json We must upload…

Taifun

[ABG]

FAQ Section: Google Sheets

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 Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - …