Data collection

[Allyson_Welborn]

Is there a way to link to google sheets?
For example.....if you're creating an app, that collects information such as student Id, grade level....can you export that to a google sheet?

Also, is there a way to convert your app to other languages by clicking a button? Say from English to Spanish?

[Ria_Das]

@Allyson_Welborn

Is there a way to link to google sheets?

See

METRIC RAT AI2 - CRUD with Google Sheets, Web App and AI2

METRIC RAT AI2 - Google Sheet CRUDQ II

@Allyson_Welborn

Also, is there a way to convert your app to other languages by clicking a button? Say from English to Spanish?

Yes there is see...

How do I create multiple language app?

Yes. You need a List of words for each language your app will know if you follow the example using lists. You can do something similar using Dictionaries (see How do I create multiple language app? - #14 by MauMau ). or [localizationDictionary] for English, German, Spanish. Add these Blocks to the List example plus three Buttons (7,8,9) to use a Dictionary as part of the same example.

[ABG]

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…