Read Data from Google Sheet in MIT App Inventor (SUPER EASY) | Get Google Sheet Data in App Inventor
Hello friends,
In this tutorial, I am showing you how we can read data from a Google sheet and display it in an MIT App Inventor App.
Written tutorial:
https://obsidiansofteducation.blogspot.com/p/get-or-read-data-from-google-sheet-in.html
For writing to a Google Sheet or sending app data to Google Sheet, check out this tutorial:
https://youtu.be/JQzDKuzyUoQ
To create a Google Sheet, go to the following link:
https://docs.google.com/spreadsheets/u/0/
What is Google Sheets?
Google Sheets is a web-based application that enables users to create, update and modify spreadsheets and share data online in real-time.
If you are used to Microsoft Excel, then Google sheet will be a piece of cake for you as it is almost identical to Microsoft Excel but it is online so you can use it anywhere and it is not dependent on operating systems so you can use on Windows, Android, MacOS, etc.
Best of all: it is FREE
Please like my Facebook page and Instagram page for more FREE educational resources.
Facebook: https://www.facebook.com/ObsidianSoft/
Instagram: https://www.instagram.com/obsidiansoftapps/
For questions: contact me at obsidiansoftc@gmail.com
π£ π£ π£ π£ π£ π£ π£ π£ π£ π£ π£ π£
Other MIT App Inventor Tutorials:
π’ Calculator App:
https://youtu.be/DM_KJbit0mM
π©π©π©β¬β¬ HealthBar/progress bar in MIT App Inventor:
https://youtu.be/rMyHKpQu7d8
π€ Chatbot powered by GPT 3 (upgrade available below)
https://youtu.be/rFUSqn1uzWA
π€ Chatbot powered by GPT 3.5 Turbo (Latest)
https://youtu.be/aMQ35-A0Hto
πΌοΈπΌοΈFrame Animation in MIT App Inventor:
https://youtu.be/nPWTCR_DygQ
Customer Record App
https://youtu.be/EVRoyvyloUU
πͺ² Debugging and Coding Tips for MIT App Inventor:
https://youtu.be/SYd_Dg6DS8k
ποΈ βMovie Quiz App:
https://youtu.be/QRNrtZG_5zY
π€π¦ Voice-operated flashlight (Hands Free)
https://youtu.be/24JG5_DmHxQ
β Countdown Timer App:
https://youtu.be/v454FvH7gNw
πΈ Space Invader Game:
https://youtu.be/mPPQVnLJS7U
βMultiple Choice Quiz App:
https://youtu.be/5e4WwpheM8c
π¨ Basic Paint App:
https://youtu.be/prmTeD0cacw
π¦ Strobe Light App:
https://youtu.be/34VrKj0pYag
π§ Compass App:
https://youtu.be/_5bXiZXjLqI
π Qibla app:
https://youtu.be/eVXTmzrBNuQ
β° Alarm Clock App:
https://youtu.be/txrjTCUbFmI
π» π¨ Smash the Ghost Game:
https://youtu.be/w9pY619xAVU
π€ Voice Changing App:
https://youtu.be/Ko1H_NxtOLk
πΉ Piano App with Record Music feature:
https://youtu.be/pCgBwwSiJaI
π Shopping List App:
https://youtu.be/kBt2fzEba1c
Reverse Shopping List App:
https://youtu.be/4vDj3q16L1Y
π Noise Pollution App - Sound Pressure Sensor:
https://youtu.be/_M40XWcqMH4
ππ Custom Radio Buttons in MIT App Inventor:
https://youtu.be/Fcu8Dm9bFoE
π¬ Chat App (Messenger App) With Topic-Specific Rooms:
https://youtu.be/ywuKZuA2csc
β Virtual Snow Globe:
https://youtu.be/jqVF0ZnbV7A
Free REDIS Cloud Account for custom CloudDB and using same CloudDB for multiple apps:
https://youtu.be/OoTNCQ_32C0
Create Quiz App linked to custom CloudDB:
https://youtu.be/J4ksXNTlq3g
Take Quiz App linked to custom CloudDB:
https://youtu.be/iOEe8iaMrX8
π€ Basic Login/Sign up Screen App:
https://youtu.be/nW_nfbSPDj8
Login/Sign up Screen App with Duplicate User check:
https://youtu.be/Cmy0VueB1zc
Read JSON file and make Dictionary:
https://youtu.be/UDTfAiNaoko
Special Thanks to Filmora for Intro Music
Chapters:
00:00 Introduction - Read Google Sheet in App Inventor
00:10 Demo - Read Google Sheet in App Inventor
00:20 Project Creation - Read Google Sheet in App Inventor
00:33 UX Design - Read Google Sheet in App Inventor
01:35 Create Google Sheet - Read Google Sheet in App Inventor
01:52 Get Link - Read Google Sheet in App Inventor
02:11 Update Link for Exporting - Read Google Sheet in App Inventor
02:55 Update Link For Web - Read Google Sheet in App Inventor
03:16 Code - Read Google Sheet in App Inventor
04:03 List from CSV Table Block - Read Google Sheet in App Inventor
04:43 Remove Column Titles - Read Google Sheet in App Inventor
05:25 Create Local Variable - Read Google Sheet in App Inventor
08:15 Why Using Local Variable - Read Google Sheet in App Inventor
#appinventortutorial #googlesheets #mitappinventor #androidappdevelopment #appinventor2 #mitappinventortutorial #appinventor #googlesheetstutorial #codingforbeginners #coding #codinglife #blockbasedcoding #programmingforbeginners #mobileappdevelopment
Tags:
read data from Google sheet in mit app inventor,
get data from google sheet in app inventor,
Google sheet,
mit app inventor google sheet,
get data from google sheet mit app inventor,
get data from google sheet app inventor,
google sheet app inventor,
google sheet mit app inventor,
app inventor google sheet,
app inventor read from google sheet,
mit app inventor read from google sheet,
mit app inventor read google sheet,
app inventor read google sheet,
app inventor 2 google sheet,
Mit app inventor,
App inventor,
Mit app inventor tutorial,
App inventor tutorial,
App inventor 2,
App inventor 2 tutorial,
App inventor projects,
Mit app inventor projects,