FAQ Section: Google Sheets

How To

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) version II - TimAI2

Long Polling / Data Changed Event for Google Sheets - TimAI2

Google SpreadSheets Extension - Fastest and Alternative Database [Updated-v2] [Extension] [PAID] - JEWEL

Gviz Access

Google Sheets SELECT with GViz, no JavaScript, CSV, JSON, HTML output - TimAI2

Populating Dependent Spinners from Google Sheets Using gviz - TimAI2

AI2 Google Sheets Component

AI2 Spreadsheet component help page - MIT

*Obsolete - Already in Production - Want to test the upcoming MIT Google Sheets Component? - Susan Lane et al

Open Issues
ClearRange does not call FinishedClearRange on completion - @bryon

WriteCell of text JOIN causes 400 Bad Request error - @Juan_Antonio, @ewpatton

AddRow to empty sheet: Attempt to invoke interface method int java.util.List.size() on a null object reference - @TimAI2

1 Like
Google Sheets data to MIT App Inventor
Get a value in row, like vlookup
Qrcode scanning
How to integrate data from CVS in the app
Send report of a list of checkboxes
[Paid] Google Spreadsheets Extension - Free & Fastest Database {Script-Less} (7.0.1)
How to decide which column of the data as keyword to pair
Forum feature and external code
How do I upload image to google drive then send link into the google sheet?
How can I save data from Arduino using Bluetooth directly to a database?
["<!DOCTYPE"] error shows when i run my application
Row and Columns
Cannot parse text argument to "list from csv table" as a CSV-formatted table
Get range from Google sheet to populate spinner elements
Cloud db probolem (using LocationService extension in the background)
Listpicker google sheets
List with Tags?
How can i list all files in google drive folder?
Connecting to google sheets
Built In Google Sheets Component for App Inventor
Button click to show sheet data
[Paid] Google Spreadsheets Extension - Free & Fastest Database {Script-Less} (7.0.1)
Need to update, edit, delete google sheet record
Cloud dB limit and app inventor account after not using
How do I Display Online Users Without Firebase?
Google sheet data read
:green_square: Long Polling / Data Changed Event for Google Sheets
:green_square: Use gviz to get and query google sheet data
Google sheets list
Need help with split items from list and merge them in another list
Issue with lists
How do I Select Data from Google Sheets?
Get a cell value from google sheet
Built In Google Sheets Component for App Inventor
:green_square: Google Sheet - CRUDQII - create/read/update/delete/query - using google web app
Built In Google Sheets Component for App Inventor
Help ! Tiny DB with Google sheet
How to use the built in spreadsheets component
Login spreadsheet by webviewer
Como puedo llamar datos(Folio) a un campo de texto en app inventor (How do I generate a folio number in the app and that it can be consecutive)
Google Sheets Components on Test Server
Working with tables with tableview, where to store data in order to share data with a pc
:green_square: HOWTO: Get A Range from a Google Sheet
Auto Increment numbers
Sqlite for multiple users app
How to use the same button several times
Need Help with a simple App
Convert list into multiple lists starting with letter
How to make an app in which if the user submits an task and if the task submitted is correct they will be rewarded with some coins in the app
Testers Wanted: Google Sheets component
Spreadsheet readrange than addrow
Testers Wanted: Google Sheets component
Cara input data dengan gviz
The new spreadsheet update on AI2 doesn't work for me
Google Sheets call back issue
Write Data to sheets
How can i get a Feedback from sheets
Spinner dependent dropdown list
Referral option
Error 400 usando formulario google con inventor 2
Cloud DB is not saving any info
Create shifts App
How do you make a record data app?
Built In Google Sheets Component for App Inventor
Writing to a Gsheet
Google sheet data sort
Dictionary error "not a well-formed list"
How do I save table to excel files?
Get Correct Index from Listview Selection after Filtering
How do I take data from Excel format (XLSX) but this XLSX is included in App(Apk). So when App is installed, the XLSX is automatically put in the storage phone too?