Read/Get Data from Google Sheet in MIT App Inventor [Google Sheet Database] || EASIEST METHOD 2023!

This video is about how to read/get data from Google Sheet to MIT App Inventor. This uses the Web Component in MIT App Inventor. Google Sheet can be used as a database for storing data in MIT App Inventor.
Create Chat App in MIT App Inventor: • How To Create Chat(Mes...
Create an Voice Assistant in MIT App Inventor: • Create a Voice Assista...
SUBSCRIBE NOW: bit.ly/YTclickhere
#mitappinventor
#mitappinventor2
#appinventor
#appinventor2
#krishnaraghavendran
Please Subscribe, like and share this video.
⏱️⏱️TIMECODES⏱️⏱️
0:00 - Intro - Get Data for Google Sheet - MIT App Inventor
1:06 - Modify Google Sheet Link - Get Data for Google Sheet - MIT App Inventor
2:47 - UI Design - Get Data for Google Sheet - MIT App Inventor
4:07 - Blocks Section - Get Data for Google Sheet - MIT App Inventor
6:18 - Testing The App [Demo] - Get Data for Google Sheet - MIT App Inventor
7:10 - More about Web Component - Get Data for Google Sheet - MIT App Inventor

[@anindg]

I am learning MIT app inventor. Your tutorials are helping me a lot. I learnt the usage of few blocks. Thank you so much.

[@KrishnaRaghavendran]

You are welcome!

[@user-tj7zh9ph8t]

Thank you for this helpful information! I am developing an app that displays a message based on the day that the app is opened. Example: User downloads app, and the first time the app is opened, they get Day 1 message. They open it the next day, they get Day 2 message, etc. How would I direct the blocks to do this? I have the messages listed in google sheets. How should I format the time to display the message accordingly? Thank you!!

[@wesber80]

Hello dear Krishna, you helped me a lot, I had a problem and I solved it with your tutorial... Thank you very much... I wanted to ask you a question, if I have two sheets in google sheets, in the first I save the data and in the second I update the data, but I can't find the way to call the second sheet from app inventor, I don't know if I make myself understand...

[@johnytsekieng]

Wow!!! easy and clear. Congratulations from Mexico

[@KrishnaRaghavendran]

Thanks!

[@diadokmai]

Thank you bro. Keep it up👌

[@KrishnaRaghavendran]

Welcome 👍

[@ThomasSStarok]

Hi, I enjoy watching your videos about MIT app inventor and have already utilized some to create my own apps. I am currently working on a language app in which I have flashcards with audio, sentences with audio and a short dialogue with audio too. I want to update the content once or twice a week using my google drive. I was wondering if you could share your thoughts on that or maybe create an instructional video on that topic. I am sure there are many people with similar ideas as mine. Thanks a lot in advance. Tom

[@KrishnaRaghavendran]

Thanks! Sure, I will try to create a video on that. This video might be helpful for you (about getting files from Google Drive to App Inventor): kzbin.info/www/bejne/nJyleWh4iZp6ipI

[@ThomasSStarok]

@@KrishnaRaghavendran much obliged

[@LyricalOnYt]

Hey I am making an app and stuck on the execution part, can you help me please? The design is finished, there are three boxes Name, Cadre & District, with a button Search The contacts are stored in a Google sheet with Column A having Names, Column B having Cadre, Column C having Districts and Column D and E having Phone Numbers I want the App to do following Upon entering text in Name, Cadre & District text Boxes and pressing the search button the app shall perform search in the relevant columns of Google sheet and show the result with Name, Cadre, District and Phone Numbers I've seen tutorial but got more confused, please help

[@ThalaMSD07781]

Nice

[@KrishnaRaghavendran]

Thank You so much!

[@dienau6313]

This is great, may you show me how to create an account and log in by using google sheet database? I'm struggle in distinguishing which account is registered and how to confirm the account when forgot the password

[@edudiy9438]

Nice!

[@KrishnaRaghavendran]

Thanks!

[@eSchoolApp]

Hey, Lil Kid. You are doing a great job, I a happy to learn from a young techwiz

[@KrishnaRaghavendran]

Awesome, thank you!

[@GoodGaming003]

nice tutor we love it💓

[@KrishnaRaghavendran]

Thank you 🤗

[@user-bt6fl4lo1g]

why does it show this in mit app inventor "Cannot parse text argument to "list from csv table" as a CSV-formatted table" ?

[@watchriyansworld1641]

Plz help me, I have put url address of sheet , but when I click on button , error: user can not accept values( *nothing*) is coming. what is this type of error , how can I make it correct

[@WeAreICT]

How we get a drop down list in google sheet to mit app

[@kingsken7336]

is it possible to get data from only one "Cell" to a Label instead of listview.

[@gpatni2009]

will it work on multiple columns for data retrieval ?

[@jagdambtutorials1779]

I am a teacher and made an app for my students. but unable to make a multiple login with google sheet. Can you help me? Please.

[@johannardox]

what would happen if the excel file or sheet has different sheet tabs?

[@noblemathew4662]

How to get only 3 rows data with only certain columns when someone inputs a query?

[@bestdealjor2211]

Can u help me on how to get and display one cell only ?

[@tobuyquailmeat]

hey, brother can you explain about 'activity starter'.

[@rockstarprattyaksh5070]

Always First

[@KrishnaRaghavendran]

Thanks!

[@VoidWasHere._.]

We both are always first

[@muhammadev3424]

Can we upload image to Google sheet?

[@azwabintiahmadanuar3749]

help...in mit there is no /get for webviewer block

[@tobuyquailmeat]

Why you made google sheet settings as public - any one can see data. ? It affects the privacy of app-user-data know? Any one can steal user data know? am i right? help me.

[@ThalaMSD07781]

Please make games Tomarrow

[@KrishnaRaghavendran]

Will Try!

[@harishgunasekera]

Like can you use normal list instead of csv because csv has [" and "] in it.

[@KrishnaRaghavendran]

As google sheet is a table, You can only use CSV list.

[@harishgunasekera]

Is there anyway to convert the csv format to something that can be displayed in a label rather than having to use listviewer?

[@KrishnaRaghavendran]

Yes, but it will be shown in csv form with ",".

[@ajabjankari3926]

Hi Dear, I am using list picker to show google sheet data on it, but sometimes it show the list blank and sometimes it shows the list, pls give the solution for this problem i m facing.

[@KrishnaRaghavendran]

You need WiFi for getting data from Google Sheet, so make sure you are connected.

[@rockstarprattyaksh5070]

First Like First View First comment

[@KrishnaRaghavendran]

🎉

[@VictorHernandez-vq5hx]

Hacerlo con la row2 columna2 b

[@snehalgundecha8197]

First comment And now make second video of how to send data to google sheets means we'll type in our app and it will be visible in google sheets Thank you

[@KrishnaRaghavendran]

Sure, I will try to find an easy method for that and I will do it!

[@snehalgundecha8197]

@@KrishnaRaghavendran thank for it also Love from Baramati, Pune

[@housemd4752]

I'm looking for part of send data. Can you make it?

[@KrishnaRaghavendran]

Sure...working on it.

[@housemd4752]

@@KrishnaRaghavendran i'm waiting for you

[@Kedi318]

How to make no internet warning in the application?

[@KrishnaRaghavendran]

There is an extension for that: puravidaapps.com/wifi.php I will create a video for that!

[@video_max4204]

can you make an app to send images and videos in app inventor?

[@KrishnaRaghavendran]

Yes, I will try.

[@video_max4204]

@@KrishnaRaghavendran you inform me when you do

[@harishgunasekera]

Does this work with normal arrays?

[@KrishnaRaghavendran]

What do you mean by "normal arrays"?

[@KrishnaRaghavendran]

As google sheet is a table, You can only use CSV list.

[@johannardox]

IS THERE ANYWAY TO GET RID OF THE PARENTHESIS?

[@slogantagszindia9811]

Please share the link of App

[@KrishnaRaghavendran]

I currently don't have the project file...but you can follow the video and create the app.

[@slogantagszindia9811]

@@KrishnaRaghavendran can you make app to scan barcode and then redirect that barcode to specific url... customised...with open url in native only not to leave app...

[@KrishnaRaghavendran]

Watch this: kzbin.info/www/bejne/hovFm56gZZaLlcU

[@AGMixArnavGupta]

Windows 11!! 😃😃

[@KrishnaRaghavendran]

Yes!

[@ThalaMSD07781]

Please make ludo game in mit app inventor Please I need it 😔😔

[@ThalaMSD07781]

Make it tomarrow please please........🙏🙏🙏

[@KrishnaRaghavendran]

Creating Ludo Game in MIT App Inventor has many algorithms and it will take a long time to do it. I will try my best to create the tutorial. Thanks for your idea!

[@ThalaMSD07781]

@@KrishnaRaghavendran then please make cricket animated game

[@KrishnaRaghavendran]

Sure! I will make more games in MIT App Inventor like ludo and cricket game

[@ThalaMSD07781]

@@KrishnaRaghavendran ok

[@watchriyansworld1641]

Can not accept arguments(* nothing*)