{"id":5505,"date":"2024-12-31T17:15:51","date_gmt":"2024-12-31T17:15:51","guid":{"rendered":"https:\/\/obsidiansofteducation.com\/?page_id=5505"},"modified":"2025-01-10T15:01:11","modified_gmt":"2025-01-10T15:01:11","slug":"send-data-to-google-sheet-from-mit-app-inventor","status":"publish","type":"page","link":"https:\/\/obsidiansofteducation.com\/index.php\/send-data-to-google-sheet-from-mit-app-inventor\/","title":{"rendered":"Send Data to Google Sheet from MIT App Inventor"},"content":{"rendered":"\n

Hello friends and welcome to Obsidian Soft,<\/p>\n\n\n\n

In today\u2019s MIT App Inventor tutorial, I will teach you a simple and easy way of writing to a Google sheet from<\/strong> an MIT App Inventor App. <\/p>\n\n\n\n

Some apps require data to be written to a spreadsheet instead of a database like CloudDB. Take the example of a quiz app that you have developed for your students (I have already taught you how to make quiz apps<\/a>). Now, you may want to know how your students are performing in the quiz so you can write code in your quiz app that whenever a person takes the quiz, the score is written to a Google sheet which you can view at any time to look at the scores of the students.<\/p>\n\n\n\n

So, today, I will teach you how your app can easily write to a Google sheet.<\/p>\n\n\n\n

First of all, we need a Google sheet so create one by going to:<\/p>\n\n\n\n

https:\/\/docs.google.com\/spreadsheets\/u\/0<\/a><\/p>\n\n\n\n

Click on the big + and create a blank Google sheet. A new spreadsheet will open. Change the name from \u201cUntitled Spreadsheet\u201d on top to \u201cStudents\u201d. Now go to the menu. You will find Tools there. Click on it and choose the \u201cCreate a new form\u201d option.<\/p>\n\n\n\n

We need to change the questions to the kind of data coming in from the MIT App Inventor app. In this tutorial, I will be sending students\u2019 names and ages. If you have an email address in it by default chosen in it, you need to remove that question by going to settings ->defaults ->form defaults ->Do not collect email address<\/p>\n\n\n\n

Look below at the screenshot<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now, go back to questions and add questions for name and age.<\/p>\n\n\n\n

For both questions, choose a short answer as the answer type. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click on the Publish button on the top and choose manage option from the dialog that opens up.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The share permissions dialog will open up where you have to change General access to “Anyone with link”. Click on Done button.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After this, click on the publish button on the dialog.<\/p>\n\n\n\n

At any time, if you accidentally close the form, you can open it again for editing by going to Tools in your \u201cStudents\u201d spreadsheet menu<\/p>\n\n\n\n

Tools -> Manage Form -> Edit form<\/p>\n\n\n\n

Now, create a new project in MIT App Inventor. Call it StudentData.<\/p>\n\n\n\n

Drag and drop a horizontal arrangement<\/strong> from Layouts<\/strong> onto the Viewer.  Make align horizontal and align vertical center. Make height 10% and width fill parent. Put a label<\/strong> and textBox<\/strong> from User Interface<\/strong> inside it. This is for the student\u2019s name so name them appropriately: nameLbl and nameTxt. Duplicate the horizontal arrangement by pressing Ctrl  + C and Ctrl + V<\/strong> for Windows<\/strong> OR Command + C and Command +  V<\/strong> for MacOS<\/strong>. Make changes for Age.<\/p>\n\n\n\n

Add a button<\/strong> for submit from User Interface<\/strong>.<\/p>\n\n\n\n

From Connectivity<\/strong>, drag and drop a Web<\/strong> component onto the viewer.<\/p>\n\n\n\n

Our basic screen design is done so go to the blocks section.<\/p>\n\n\n\n

When submitBtn is clicked, we want to send the user-entered data to the Google sheet so get the click event.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Get web1\u2019s seturl block. And put a join in it. Add three more slots in it.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Now, follow me very carefully.<\/p>\n\n\n\n

Go back to the form that you created using Spreadsheet. If you accidentally closed it, you can open it again by going to Tools in your spreadsheet<\/p>\n\n\n\n

Tools -> Manage Form -> Edit form<\/p>\n\n\n\n

Inside your form, you will have those 3 dots next to send button. Click on those dots and choose Get prefilled link.<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Another browser window will open up. Copy the link from the browser window.<\/p>\n\n\n\n

Paste this link in the set Web1.url block in submitBtn click event.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Replace the word prefill<\/strong> with the word formResponse<\/strong>. Type it exactly in this way:<\/p>\n\n\n\n

formResponse<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

<\/a><\/strong><\/p>\n\n\n\n

Now, we need something more from the form.<\/p>\n\n\n\n

Go back to the form and provide some values for name and age and press getlink<\/strong> button.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Copy and paste the new link in some text file as we need the two entry codes for both inputs i.e. name and age.<\/p>\n\n\n\n

We will get something like this (I have deleted some letters from this address as this points to a Google Sheet on my account: you will have to use your own Google Sheet for your project)<\/em><\/p>\n\n\n\n

https:\/\/docs.google.com\/forms\/d\/e\/1FAGycfw\/viewform?usp=pp_url&entry.1932012884=obsidian&entry.1402638227=100<\/a><\/p>\n\n\n\n

Copy and paste the first information about entry &entry.1932012884=<\/strong> in the second slot<\/p>\n\n\n\n

<\/a>Replace &<\/strong> by ?:<\/strong><\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

This replacement only has to be done for the first entry and not for subsequent entries. (Your code will be different. This is just for example<\/em>)<\/p>\n\n\n\n

In the third slot, get the nameTxtBox.text block (whatever user has entered as the name)<\/p>\n\n\n\n

In the fourth slot, copy and paste the information about second entry i.e. &entry ( numbers from link)=<\/strong><\/p>\n\n\n\n

In the fifth slot, get the ageTxtBox.text block (whatever user has entered as the age)<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

<\/a><\/p>\n\n\n\n

At the end, call web\u2019s get procedure.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Try the app, and you will see that data is added in the spreadsheet in a sheet called form responses 1<\/strong> inside your main spreadsheet Students.<\/p>\n\n\n\n

I hope you liked this class and found this method of writing data to a Google Sheet super easy. <\/p>\n\n\n\n

If you like my tutorials, consider supporting me:<\/p>\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n\n\n

You can have a look at the video here:<\/p>\n\n\n\n

\n