FAQ Section: Google Sheets

[Google SpreadSheets Extension - Fastest and Alternative Database [Updated-v2] [Extension] [PAID] - JEWEL](https://community.appinventor.mit.edu/t/google-spreadsheets-extension-fastest-and-alternative-database-updated-v2-extension-paid/27619?u=abg) Discontinued

Gviz Access

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

Populating Dependent Spinners from Google Sheets Using gviz - TimAI2

gviz requires type consistency by column - @TimAI2

Open Issues

AI2 Sheets component needs .json file for range queries, contrary to docs
@Diego_Lombardia

Solved issues in nb191

~~GotFilteredResult row numbers start at 0, should be 1 - @ABG~~

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

3 Likes

Google Sheets data to MIT App Inventor

Get a value in row, like vlookup

How to integrate data from CVS in the app

Qrcode scanning

Help with dictionary Bild

Send report of a list of checkboxes

Write Data to sheets

How to decide which column of the data as keyword to pair

Forum feature and external code

Book keeping application

Storing data offline for later transfer when online

Problema al descargar el archivo de google sheet

Open Google Sheets

Google sheet with 3 sheets. I want to view data from Sheet C coloumn wise by different buttons. Is it possible without coding in aapscript?

Display list from csv or excel file stored in google drive

Timer for recipe

Get the Nearest Hospital

RFID or NFC card number reader app

Issue in accessing mobile internal storage from MIT App build

How do you make a library management app?

Need help with app (similar to uber but for dog walking)

How do you make app to show specific data from spreadsheet

Update particular record in Google sheet

Why web viewer wont show google form links?

Clearing content from a table when using Screen1.BackPressed

Runtime Error : java.lang.OutOfMemoryError:

Need exact cell value from spreadsheet

About Airtable Extension

Air ticket booking app - importing data from Google sheet

Spreadsheet component. Example. Google Sheets

Please help, I need to export information

Respuesta de componente Web no encontrado

Look for an example With JsonTextDecode

Copiare dati da textbox screen 1 a lista screen 2

Open an excel sheet

Google Sheets API Setup

Comma issue in listview

Make an order menu for the restaurant?

How do I Select Data from Google Sheets?

How do I Display Online Users Without Firebase?

[Paid] Google Spreadsheets Extension - Free & Fastest Database {Script-Less} (7.0.1)

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?

How Can I Add A New Character to Beginning And End Of The Word After User Input

How do you read Google Sheets and create a dropdown menu?

Working with tables with tableview, where to store data in order to share data with a pc

WEB PUT for google sheet?

Componente de almacenamiento Spreadsheet

How search specific data in a excel column and row?

Is it possible to read partial data of a txt file?

'm consistently getting the "Error 4401: URI has a fragment component" in App Inventor. I suspect an issue with connecting to a spreadsheet.. How should I modify the blocks?

Trouble Compiling my first app

Ingreso y busqueda (Login and search)

Line graph that update live on MIT APP

Hi guys, how can i make the data (x) be showed by selecting the user of the City (x) and the data (y) be showed after selecting the city (y)

How to log and chart data

I want to filter how many data are in the spreadsheet

I need save in a Google Sheet a Spinner's selection

Datos incompletos al exportar de Google Sheet a CSV

Do not get response back from the web after the task is complete

Data collection

I cant Send Data to Goggle Sheet

How to send two or three data from app inventor to be stored in two or three variables on the ESP32 board?

Consultas y Busquedas

Geting user input and calling information based on it from google sheets

Setting Clock Block to open new screen each day

Error from Companion: error: undefined variable. (irritants: yail/com.google.appinventor.components.runtime.Spreadsheet)

Ayuda con una App

Mysql database access

My update my app is not working so do we have to coding in google sheet for that

When I send data with spreadsheet write cell, I get the error shown in the picture. why? What can I do? thanks

How do I make changes on live?

Mysql in MIT App Inventor

Ayuda con una app de subida de documentos de excel y compartir despues con otros usuarios

Update or Modify Entry

How do you open a csv file in excel or sheets app from my mit app?

outdated? /googlesheets-api-setup.html

Create calendar

Logging Marathon Runner Checkpoints in Google Sheets

Package tracking

Can't access to Google Sheet2 tab (sheetName)

How do you ensure google sheet receive data?

Sheets Write value on the corresponding line

Hi I need to know how can I connect my app in app inventor with Data Base in Excel, also with a loging in mi own app. Someone could help me?

Tengo problemas para enviar datos a una hoja de googlesheets (I'm having trouble sending data to a google sheets sheet)

Creating a simple inventory List and having the List with the qty shared via social

Select specific data from CSV file based on today's current date

How can I update listpicker elements in real time?

Can you write all the data in a ListView to a Google Sheet?

Wish to create an app that will open only if users enter 'unique code'?

I need to learn how to build normal apps

Spreadsheet Setup

Display images frome Google sheet

Send data to google sheets with empty columns

Add spreadsheet row data to labels

Using an inputted file (Excel help)

Which Database?

Perform a search from my app in a list of name in Excel and update

Envio de datos por medio de google forms

Collect and sort scores with the same email address in the list

Listview clicking

App Inventor Capabilities(Is it possible to make an app to find out if gas stations are open and have gas using App Iinventor?)

Please Help About Scan QR for Attendance

List that doesnt add any duplicate items

Please help with line chart

Logs directory, search and category

Google Sheet write cell with \n

Update news section without reinstall the app

Guys can you help me create a blocks to send the data from this boxes to spreadsheet(sorry for the design)

Simple update google sheet data

Automatic Timetable maker for school

Barcode reader with app inventor

HELP: Quiz with 3 possible answers using a csv document

How do you get the Java code of our projects?

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

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

Need to update, edit, delete google sheet record

Cloud dB limit and app inventor account after not using

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

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

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

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

: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

Spreadsheet Setup

App de asistencia no registra en la base de datos

Old data on new device

Barcode scanning

Help with dictionary Bild

Sign Out/In App

Using Date Pickers

Export json list on TinyDb

App does not read full range of an excel/google sheet

Affichage des informations pour chaque service

Data not saving

Planilha igual do excel

Listpicker can't show data while use 2 web component to edit spreadsheet

Listpicker from google sheet

Create graphs with input values from ESP32

Lines in .csv files in list

Loops of multiple variables?

AI2 companion for my apps stops suddenly without any error message

Download & Share file google sheet

Tres desplegables pero que se comuniquen entre si ( Three related ListPickers)

How do I use tinydb to fetch value in order to make a calculation?

get data by comparing the current time with data from a table

Google sheets from iOS

Get List From TinyWebDB

MIT-App-Inventor and Google-Sheets

Can't connect login page with google sheet

Lost google sheet in storage

Get Data from Google Spreadsheet on Android 13