Read Data from Google Sheet in MIT App Inventor (SUPER EASY) | Get Google Sheet Data in App Inventor

Channel:
Subscribers:
10,900
Published on ● Video Link: https://www.youtube.com/watch?v=7Erpfdpkuhg



Duration: 8:45
5,190 views
114


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,




Other Videos By Obsidian Soft


2023-10-31MIT App Inventor Pedometer | Accurate Step Counter | Step Tracker App Inventor #mitappinventor
2023-10-17MIT App Inventor Weather App | No Extension | Weather API #appinventor #mitappinventor #appinventor2
2023-10-08Read and Write about Space | Space Worksheets for Kids | Space facts for Kids
2023-10-03Scratch Card app in MIT App Inventor | App Inventor Scratch Card App #appinventor #mitappinventor
2023-09-19How to Publish App on Play Store 2023 | Google Play Console Tutorial | Tutorial for Publishing App
2023-09-05How to fix "To Upload an Android App Bundle you must be enrolled in Play App Signing" on Windows
2023-08-29Basketball Game in MIT App Inventor | App Inventor Basketball Game | #appinventor #mitappinventor
2023-08-22How to fix "To Upload an Android App Bundle you must be enrolled in Play App Signing" on MacOS
2023-08-15Share Doodle App Demo | App Inventor Doodle #appinventor2 #appinventortutorial #doodle
2023-08-15Share Doodle App Inventor | App Inventor Doodle App | Canvas App Inventor | MIT App Inventor
2023-08-08Read Data from Google Sheet in MIT App Inventor (SUPER EASY) | Get Google Sheet Data in App Inventor
2023-08-01Send data to Google Sheet in MIT App Inventor (SUPER EASY) | Send App Inventor data to Google Sheet
2023-07-25Animated videos using AI | Animated videos for children using AI | how to create animated videos
2023-07-11(EASY) Arduino With Ultrasonic Sensor and Scratch | Measuring Distance using Sound #arduino
2023-07-04App Inventor Qibla Finder | Location Finder | Qibla Finder App Inventor | Qibla Compass App Inventor
2023-06-20MIT App Inventor Camera | No Extension | MIT App Inventor Photo Viewer | View Camera Photos #camera
2023-06-18Reverse ListView in MIT App Inventor: Newest Item on Top of ListView
2023-06-13Read JSON in MIT App Inventor | How to Decode JSON File | MIT App Inventor File #json #appinventor
2023-06-06Calculator in MIT App Inventor | MIT App Inventor Calculator | #calculator #mitappinventor #shorts
2023-05-30Customer Record App - Part 2 | Dictionary blocks in MIT App Inventor
2023-05-23Dictionary blocks in MIT App Inventor | Customer Record App | Storing records in MIT App Inventor



Tags:
mit app inventor google sheet
google sheet app inventor
google sheet mit app inventor
app inventor google sheet
app inventor 2 google sheet
Mit app inventor
App inventor
Mit app inventor tutorial
App inventor tutorial
App inventor 2
App inventor projects
Mit app inventor projects
read google sheet data in mit app inventor
app inventor read google sheet
mit app inventor get google sheet
app inventor get google sheet
get google sheet data in app inventor