Get or Read Data from Google Sheet in MIT App Inventor

Hello friends and welcome to Obsidian Soft,
In today’s MIT App Inventor tutorial, I will teach you a simple and easy way of reading data from a Google sheet and showing it in an MIT App Inventor App.


Create a new project in App Inventor and name it ReadStudentData.

Make align horizontal center for screen1.

Now, add Listview from the user interface. Make the width 90% and the text color yellow.

Add a Button from the user interface. Rename to loadDataBtn. Make the background color yellow. Font bold, font size 20, shape rounded and text color black.

Add a Web component from connectivity.

Now, either create a Google Sheet if you don’t have one already by clicking on the plus button and writing the data.

https://docs.google.com/spreadsheets/u/0/

I am going to use the same sheet that we used in a previous tutorial for sending data to a Google sheet from MIT App Inventor.

Click on the blue share button.


A dialog will open up. Choose “General access” and in the options, choose “Anyone with the link”.

Now, press copy link button and press the done button to close this dialog.


Paste the link in some text file. It will look something like this:

https://docs.google.com/spreadsheets/d/1tLlr0ps7-gxNV1-NCTMS4fYvynvUPu8Cxkz8/edit?usp=sharing

Replace edit?usp=sharing by export?format=cs

Make sure that it is exactly this: export?format=csv

Now copy this entire changed link (don’t use below link and use the one from your own google sheet):

https://docs.google.com/spreadsheets/d/1tLlr0ps7-gxNV1-NCTMS4fYvynvUPu8Cxkz8/export?format=csv

Go back to your app inventor project and its designer view, and choose web1 component in your project. In its properties, paste the entire link with the updated export part in its Url property.


Now, go to the blocks section.

Make a global variable.


Get the button click event for loadDataBtn and call the web component’s Get procedure.


Now, this procedure Get will trigger the GotText event of Web1 component. So get that event from Web1.

First of all set the sheetData variable to list from csv table block from the lists section: the text coming in from our google sheet is the responseContent.

Remove the first row from this sheetData as it will contain headings: timestamp, name, and age and we don’t want that to show. You don’t need to do this if your sheet doesn’t have column headings.

Next, make a local variable and assign it to an empty list. Now, we will go through our sheetdata which is actually in rows and columns form (table form) using a for loop from control. Each item in this sheetData is actually a row from our actual Google sheet so it has 3 pieces of info: timestamp, name, and age. Hence, it is actually a list too. So, for each item, we are going to get the value inside it for index/column 2 (name) and index/column 3 (age) and join them together and add it as an item to our local list: datatobeshown.

Once we are done, we will set our listview elements to our local list.


Think about why I am using a local variable and not a global variable for dataToBeShown list. I would love to hear your answers in the comments.
I hope you liked this tutorial and found this method of reading data from a Google Sheet super easy.

You can have a look at the video tutorial here:

Please like my videos and share it with your friends and family. Also, subscribe to my channel and press the bell icon so you don't miss any of the great projects I have planned for you.


Please like my Facebook page and Instagram page for more educational resources and tips.

Pinterest:
https://www.pinterest.co.uk/obsidiansoft/_created/
For links to free educational apps, have a look at the educational apps page

Comments

  1. Unknown4 October 2023 at 14:23

    it has a error
    get responsecontent has an error

    ReplyDelete
    Replies
    1. Obsidian Soft4 October 2023 at 22:21

      Use a notifier to show alert with responseContent as input. Do this as the first thing in Web1.GotText event.

      Delete

Post a Comment

Popular posts from this blog

Jolly Phonics Group 1

Image
Free Jolly Phonics Group 1 worksheets (s, a, t, i, p, n) According to Oxford Dictionary, phonics is a "method of teaching people to read by correlating sounds with symbols in an alphabetic writing system". In simple words, each letter of the alphabet has a sound. Instead of teaching young children the names of these alphabets, the sounds are taught. For example "a" makes the sound /a/...this is exactly the sound that comes from your mouth in the beginning when you say the word " apple " or " ant ". The letter "a" makes a different sound in words like " arm " and " ate " but these rules are taught later.  Jolly Phonics is a synthetic phonics system where all the letters of the alphabet have been split into seven groups. Each group contains 6 letters or their combinations so a total of 42 sounds are taught. What do I mean by a combination of letters? Remember that the combination of letters "s" and "h&
Read more

Jolly Phonics Group 2

Image
Free Jolly Phonics Group 2 worksheets (c/k, e, h, r, m, d) Hello Friends, I am back with another set of worksheets for helping children learn their phonics sounds. As you might already know, I am a strong proponent of the Jolly Phonics system of synthetic phonics sounds. Jolly Phonics system follows a particular order of teaching alphabet sounds in which there are seven groups. The following image shows the seven groups of Jolly Phonics along with an extra group taught by my Phonics app on Google Play Store. My app called  Phonics Fun  is 100% Free so you can download it and use it on all your Android devices.  It teaches all the letter sounds and different phonics rules and follows the pattern of Jolly Phonics but it is available for free. It is the perfect way to master phonics as you can hear phonics sounds and also test learning by playing many matching games. Coming back to printable Jolly phonics worksheets, I have already published worksheets for practicing Group 1 (s, a, t,
Read more

Jolly Phonics Flash Cards

Image
Gone are the days of A for apple, B for Ball...this is the time of synthetic phonics where each alphabet has a sound. Now, you don't teach children the name of the letter but the sound made by the letter. A has the sound that comes when we say the word apple, b has the sound that comes when we say bed, and so on and so forth. There are different systems of synthetic phonics but I have felt that Jolly Phonics is the best system. In fact, I made my first mobile app for my son based on the Jolly Phonics style of teaching. However, I know that many people want to limit screen exposure for their children so I decided to make these flashcards.  You can use these flashcards independently or you can use them along with my app called Phonics Fun , available on the Google Play Store. You can hear the sounds from my app. Practice using these flashcards and then, test learning using my app too...a win-win situation :) The Jolly Phonics flash cards are double-sided. I have told you in my previ
Read more