How to send data to a google sheet with MIT app inventor [ Google Sheet Database ]

In this video, we will learn how to send data from the MIT app inventor app to google sheet using the app script.
How to Read Data from Google Sheet -: • How to Read Data from ...
...........................................................CODE............................................................................
function doGet(e) {
var ss = SpreadsheetApp.openByUrl("docs.google.co...");
var sheet = ss.getSheetByName("Sheet1");
addUser(e,sheet);
}
function doPost(e) {
var ss = SpreadsheetApp.openByUrl("docs.google.co...");
var sheet = ss.getSheetByName("Sheet1");
addUser(e,sheet);
}
function addUser(e,sheet) {
var name = e.parameter.name ;
var location = e.parameter.location ;
sheet.appendRow([name,location]);
}
.........................................................END............................................................................
....................................................................................................
New Method to Send App data to Google Sheet -: • How to send data to a ...
Follow Us On Social Media For More Updates -:
Facebook -: TheCodingBus/
Website-: thecodingbus.i...
Instagram-: / sourabhdubey007
Reddit-: / sourabhdubey007
Subscribe TCB -: bit.ly/TheCodin...
........................................................................................................
use google spreadsheet as database android
mit app inventor save data
google sheets
google sheets app
google sheets 2018
google sheets link
code mit app inventor
send data to google spreadsheet from android
app inventor web component
app inventor examples
taifun flashlight extension download
admob extension for kodular
app inventor tutorials
use google spreadsheet as database android app inventor game the coding bus thunkable firebase database thunkable thunkable tutorial #TheCodingBus
#TCB #unitedstates #us

[@mahdisaleh.learning]

Dear, It is worked, and for those who asked about the updated in the code, I did something and it works correctly, if you want to add another var or change the variables that mentioned in the original code, you must do these steps: 1- delete the app script. 2- create new one. 3- edit the code in a note file or in word file with your var. 4- copy the new code and complete it as shown in the video.

[@TheCodingBus]

Thanks...

[@RajeevKumar-yr5yi]

i have tried, it was working for more variable

[@xperimentsqf3823]

not working on me.. can u share your code?

[@poojap2604]

Bro it's not working for me ....

[@findthetruth3021]

1- How to download the App to mobile? 2- How to add drop down list 3- How to add chain or cascade drop down? Many thanks for this amazing video. Please answer us. Keep it up.

[@TheCodingBus]

1) In the top menu click on the Build option and download it in your laptop and transfer this app to your phone. OR generate the QR for apk 2) you can use list component for this 3) for that you have to use third party extension Thank You

[@Maham899]

Thanks a lot . Following these instructions I executed the code successfully.

[@TheCodingBus]

Most welcome 🙏

[@shaikaruna6967]

hlo i work with same steps that you are mentioned but the data is not updated in the google sheet

[@dominiccox6948]

Thanks for this. It didn't work to begin with, then I realised that because I had changed the column headings I had to change the app script. It worked fine then.

[@TheCodingBus]

Most Welcome 😊

[@VarunKumar-fu2jq]

i am not getting this one

[@realitydotsplus3917]

I tried it. It is working. I am happy. Thanks a lot for sharing such a useful tutorial .

[@TheCodingBus]

Welcome 😊

[@keans3386]

How did you do I am Curios, cause i spend almos 8 hrs but still is not working, like the link of my google spreedsheet is undifined :(

[@poojap2604]

@@keans3386 same prob I face .... Is there any library we have to install for Google scripts

[@shrutjain6032]

Thanks a lot your explaination is very good and its a very easy way. Thanks a lot again.

[@TheCodingBus]

You are most welcome

[@naman25sharma]

Hi, How to do so if i want to add one more row i.e. name, location and age?

[@dimitrispanagiotou7262]

HI GREAT JOB!How can i take data from from app inventor multiple screens and have them in the same row? Thank you!

[@HA_HA1990]

Thank you for your demo. I really appriciated that good and well done lesson. Allah bless you. Please make the same about MSSQL or MYSQL database instead of Google sheet.

[@joindevelopers_nationformo8702]

Hey Haidar, It is easy to do it using MYSQL. I can help you out for free if you want

[@TheCodingBus]

I will try my best

[@niceman567]

Thanks for the video! Love your channel, simple code that can lead to outcome and easy to digest, most importantly it works!

[@TheCodingBus]

Glad you enjoy it!

[@kaubrutv9864]

Plz make video on creating dictionary app using spreadsheet

[@TheCodingBus]

sure i'll

[@muhammadusmanhanif222]

hi, thanks for helpful video. Can you please guide me how many users can use such app at a time OR how many users can send data from by using single app???

[@nuraqilahazman5286]

Good and easy to follow . May I know how to retrieve timestamp as well? Because Im using IR sensors and need to modify a bit of your programming in mit app .

[@kuaytenghei9986]

Hi, thanks for this great video. Can you help me further on how to combine data inserts by users from multiple screen into the same google sheet? For example, data insert by the same user will appears in the same row in the sheet but actually those data of different column comes from different screen of the app.

[@TheCodingBus]

Hi, Nice question, But you don't need to do nothing for that... google automatically detect the who came first or who put the value first.

[@abhinav4638]

In the video you showed only how to send data but how can we read data from Google Api sheet in mit app inventor

[@TheCodingBus]

i'll make another video for that

[@paragmathur6016]

@@TheCodingBus pls make it this week need this urgently Thanks

[@Human-bx7od]

After the data gets saved can we use it again. ... ..... For example I will do an app for sign in and sign up after singing in, the data will be saved in the sheet. using the same data will it read and sign us in ??

[@TheCodingBus]

Here is the blog about that community.appinventor.mit.edu/t/google-sheets-read-add-sort-delete-select/2001

[@Human-bx7od]

@@TheCodingBus thanks

[@Human-bx7od]

And congratulations for 5k Subscribers 😁👌👌👍👍🍬🍫🍭🍰🎂

[@Human-bx7od]

Make a special video for that

[@TheCodingBus]

Thank you so much 😀

[@TheCodingBus]

sure... soon

[@Promonkey01]

Nice videos , how to add more collum?

[@nievesjoshua1238]

Thanks for the video... Do you have Image List picker to Google Sheet

[@GuttHacker]

em vez de texto queria salvar fotos, como faz?

[@kabirnehra]

Please. Make a video . How to make a Barcode Scaner. App. Video

[@TheCodingBus]

sure.... Soon

[@wierengajan]

thanks for the clear instruction

[@TheCodingBus]

You're welcome!

[@BeastGamer6969]

Awesome!

[@TheCodingBus]

Thanks!

[@sachinkumar8277]

@@TheCodingBus I try it but some reason it's not working help me!

[@SoulCast7]

I press submit and nothing happens. No data appears in my spreadsheet. I have two-step authentication on my gmail, could that interfere?

[@TheCodingBus]

no... try again.. may be some code problem.. make sure paste link as it is...

[@ChakaHamilton]

Were you able to figure it out, I too have two-step authentication active.

[@dietergasser5778]

Hi Sourabh Thanks a lot for this video, it helps me a lot. May i ask you a question? If i want to write only into one cell and i want to overwrite this cell each time, how would i adjust the code? Probably i only need to change the last line of your code (appendRow), but how? Thanks a lot...D. Gasser

[@TheCodingBus]

Yes, definitely

[@jiopydesign3055]

I have the same question. Is it only that one line of code that needs changed?

[@krizz5825]

Helpful,but i want to add an additional column whose value depends on formula,how to do that

[@TheCodingBus]

thanks. try to send formula with data.

[@STaSMn135]

Thanks for the tutorial. It worked perfectly but when I type Russian characters in my form it doesn't show up on the sheet. Can you tell me what is the problem?

[@TheCodingBus]

Let me check

[@ritikgoplani6215]

When I am running script it shows error in line number 20 Please help me Showing error message "Cannot read property'parameter' of underlined (line20,file"code")

[@karanpatel8267]

make sure first do as it is that shown in video, then change your variable name or add other fields, u will not get error, recheck your code

[@TheCodingBus]

Yes

[@olawale11954]

Good work i love it. How can i reset the form from the app after the user has click on send or submiy button and display successfully message, thank you

[@TheCodingBus]

yes possible. just hide the current layout and display the thank you test in another layout

[@Asifiqbal138]

how can i add time stamp, when data is send first colum should be time to add data on google sheet.?

[@TheCodingBus]

yes

[@Asifiqbal138]

Can you help me how to do that?

[@rajdeepjaiswal7370]

Can you make app like 2 phone will be connected through Bluetooth and if I play any music then in both mobile music will run AT same time Please try 🤗

[@TheCodingBus]

i'll try..

[@kabirnehra]

Yes

[@anmolwadali9227]

Really simple and nice project

[@TheCodingBus]

Thank you! Cheers!

[@housemd4752]

You're clever man bro. Thanks

[@TheCodingBus]

Glad to help

[@s.a.srinivasan9256]

Madam, I am an assistant professor. I want to know that,how to get all students details from all students mobile to my Google sheet

[@TheCodingBus]

Hello Tamil Tech, I'm Sourabh you can create an app where you have to put some fields like students name , number etc and then save send all details to google sheet...

[@rakeshbond009]

How can i send entry date also with this data to google sheet. i tried call clock but not working

[@dr.arvindgiram8460]

Hi Thanks for a nice video I tried to built an app for my surgical workdone but after clicking send data it is not getting uploded to spread sheet. I copied ur code and made some additions in variables only. Can send u to cheak it.

[@TheCodingBus]

Thank You.. Okay... make sure you have to update variable in 2 place

[@dr.arvindgiram8460]

@@TheCodingBus thanks for replying so quickly. Plz guide, as ur help is going to help me built an app for covid worriers & I'm one of them.

[@TheCodingBus]

I'll make a video on that...how we can add the more field's or how to modify app script...

[@dr.arvindgiram8460]

@@TheCodingBus thanks a lot. Plz share ur mail id so that it will be easy for me to share coding done by me if possible. This app is just a testing for a large data to be constructed with a lot of variables. Once again thank you !

[@TheCodingBus]

[e-mail]

[@sokunlyna]

it does not work, i followed all of the steps but my data does not go to the sheet. is there anything I can do to fix this?

[@protoback]

hi, do you know why the code is not working if I'm doing exactly the same steps.. says error in add user(e)

[@tedfun3681]

I tried this way.. But... The data isn't showing on google sheet

[@TheCodingBus]

recheck variable and code

[@rtrmohamedshinazi1232]

bhaiya i pasted the sheet url in the app script then the app script url in the mit appinventor block section then i tested the app -----the data is not saving in the sheet--pls kuch solution hoga to bataiye--

[@TheCodingBus]

make sure deploy the app... use code as it is.. like variable name.. make sure paste the corrent link... overall recheck this will work... if not let me know...

[@Targajens]

hy and reverse ? How to reciever data from a google sheet in MIT app inventor [ Google Sheet Database ]

[@TheCodingBus]

i'll create it soon

[@moayadsalih3563]

Hi, I followed this procedure but when I click "submit" button I get this error msg (Cannot parse text argument to "list from csv table" as a CSV-formatted table). Whta does it mean please?

[@TheCodingBus]

read this community.appybuilder.com/t/list-from-csv-table-text/1483

[@moayadsalih3563]

@@TheCodingBus Thank you very much. That's solved now. However, if I enter text in non-latin letters it doesn't appear in my google sheet. Anyway I can get around that? Thanks

[@fh3rslax293]

Great video,it is very helpful.Please could you help me with the script to remove and/or update a row by selecting it from the app using listview

[@TheCodingBus]

Thanks.. sure

[@sandeepa4116]

Hi Sourabh, really well explained. Keep it up:)

[@TheCodingBus]

Thank You 😊

[@siege26]

Is it possible to read the data from google sheets and display it on mit app?

[@saikatbasak2617]

Can you pls help me on .........i am making one app wherein i want to enter my ckecklist data in the app and automatically it will reflect in my digital checklist

[@TheCodingBus]

Yes.. you just need to code on checked box when checkbox will checked then save this data

[@michaelfranks2040]

How do I change the script if I want to send the data to start at a different column/row, say column 'D', row '4'?

[@vijaydevakonda1935]

how to clear input field after submit

[@John-qe3ky]

Can you explain how to read a few rows and columns of numbers in google worksheet and display the information. Then push a button to refresh (reload) the display to reflect new changes to google worksheet data.

[@TheCodingBus]

I'll publish the video soon on how to read data from google sheet

[@ferhattasci4650]

Hello. I am writing in Turkey. I need help. I can't send Turkish characters. Text like "warm" or "triangle" instead of example sangram. Text like "ılık" or "üçgen" instead of example sangram

[@FunZone01]

Sir please tell how to add more box ?

[@TheCodingBus]

u have to add variables in your app script

[@pentagonikonic946]

Thank you so so much

[@TheCodingBus]

Welcome 😊

[@Stuckathomemom]

You wouldn't happen to have a video that explains how to put in all the data types - like check boxes?

[@TheCodingBus]

i'll make a video on that

[@sergiomejia8837]

Excelente

[@TheCodingBus]

Thank You

[@gsvend2272]

It works! But how to add a third column?

[@TheCodingBus]

you have to add the variable

[@armul07]

thanks man.. that's worked

[@TheCodingBus]

Welcome 👍

[@piowar96]

Hi, I tried to repeat your example. Sorry but it is not working. The script is exactly the same. I have deployed it with success. I have checked the saveResponse property after calling the posttext , it is false but should be true. I do not know why. Please help.

[@TheCodingBus]

make sure work with same fields. if it's work then change the fields name

[@Stuckathomemom]

Brilliant!!

[@TheCodingBus]

Thanks

[@poojap2604]

Ma'am is there any library to be installed for Google scripts

[@tmaxil]

how i can make it support other lang? I write in Hebrew and its not get the Heb text

[@xperimentsqf3823]

is it still work? coz i try this but not work .. i rechecked the code, but no differents.. any solutions?

[@noutouyduangta4240]

Cool! Thanks for your sharing

[@TheCodingBus]

Welcome 😊

[@induarora4659]

Sir please make a app for father's day for father

[@TheCodingBus]

Sure....

[@ValkyriePyxl]

My Birthday is in fathers day

[@aabhatathed5437]

if we want to add date column in sheet then what changes are required in apps script?

[@TheCodingBus]

select any component then ctrl+c then ctrl+v

[@TN-kd8ju]

Thank you. It worked great :)

[@TheCodingBus]

You're welcome!

[@DTITSTUDIO]

How to user data store in WhatsApp aur telegram please. Tell me one video please sir

[@TheCodingBus]

okay i'll make a video for that

[@DTITSTUDIO]

Bro plz Google sheet data store system video please bro

[@ratheesh.r.svellanad2875]

Great I have a doubt how to make a simple attendance app

[@TheCodingBus]

How can I help you?

[@lukmannet]

Very good, how to add more cell?

[@TheCodingBus]

Thanks Will upload soon

[@juliorodrigotorres1912]

Great app! It worked the first time, but when I tried to do it again, the app script says "TypeError: Cannot read property 'parameter' of undefined (line 16, file "Code"). How can I fix it? Thank you

[@TheCodingBus]

Thank You, have you changed column value in app script or in design or have u added another column if Yes then you have to change it properly u should have a basic knowledge of JS

[@fakeekaf2346]

Your voice was like South Indian

[@TheCodingBus]

Ohk

[@nuruldesita8477]

sorry to ask, I sent the data to the Google sheet. But after sending, one column was missed. I tried to use Postman to check .. it said the script was complete but it didn't return anything. Please help. I have checked many times, everything is the same either in blocks or scripts. And there's no warning error showed up.

[@TheCodingBus]

First of all make sure you are using two column to send data.. and first make two column app

[@FASOYLAS]

excellent job, I try to send data with greek characters but it doesn't recognize them, with Uk characters works just fine . Is there any way to fix that, the problem is with the MIT app, or is it about the script function? Keep up the good work.

[@TheCodingBus]

Let me check

[@FASOYLAS]

@@TheCodingBus Hello again, did you find any solution?

[@crbcreation_pkd]

I want to add more data like more column and row data what to do (any more codes required) ?

[@TheCodingBus]

Yes.. you have change into script file

[@bubblebath2892]

Instead of AppScript can you please show using Google Forms or something , i want to have at least 20 inputs (where some of the will be numbers , some will be numbers plus text (e.g Rs.10/bag) ,etc )from my users at one go and don't know how to write AppScript on my own

[@TheCodingBus]

sure Bubble i'll try to make that video without appscript... if you want to add more value just go to the script and read it...and then increase the variable...

[@bubblebath2892]

@@TheCodingBus Thanks for the reply , Also , as there are 20 fields , they are on different screens , screen 1 , screen 2 . The Submit button is on screen 2 , so I added the Web component on Screen 2 - the problem is in Join statement in blocks , i cannot get the components from screen 1 , so should I put 1 Web component on screen 1 also ??

[@CodingHats]

I tried it but the problem is whenever I click on the button after entering name and location and check the spreadsheet I don't get the added data there. Please help me out coding bus.

[@TheCodingBus]

make sure you have to put your own sheet link... recheck your code

[@CodingHats]

Thank you

[@erikkpritchard]

location posts to Google Sheet but name does not. Where might the error be?

[@TheCodingBus]

error might be in your variable names

[@zayngrin4682]

how to put 3 items like name , id number and quantity at the same sheet ? just add the name of item?

[@TheCodingBus]

just add item and change on app script.. you have to make other varible for extra iteam..

[@sandip528]

How to get confirmation of every entry

[@TheCodingBus]

use notifier

[@poojandholakia3288]

Hello Saurabh Sir, Can you please guide on how to update the record in the google sheet using MIT App Inventor ? I have referred to your video for sending data and receiving data but now I want to update 1 record from this data? Can you please guide?

[@TheCodingBus]

you have to just remove that 1 parameter ... in the video we are storing the 2 values

[@poojandholakia3288]

@@TheCodingBus Thank you for the response, but I am not that great in the coding part. Can you please elaborate or post that line of code here ? Thanks

[@poojandholakia3288]

Hey, I basically want to edit the value on one of the row and column. Update from what value we have. Say some age is mentioned in the cell "25" and now want to replace with "34". How do we do m

[@MuhdAkmal18]

Is there a way to insert photo/image into the excel?

[@TheCodingBus]

use base64 to convert image to text and then store it

[@keshavmurthy6998]

Thank you Sir...

[@TheCodingBus]

Most Welcome

[@dass8193]

Hello! does this method still work? i've followed each step perfectly and it doesn't seem to do anything to the spreadsheet.

[@TheCodingBus]

Yes it does.. recheck ur code... may be u missed something

[@parthbetai4452]

@@TheCodingBus bro same thing happened with me its not working

[@virajm5247]

@@TheCodingBus yes same

[@xperimentsqf3823]

not working on me too.. is it still working..?

[@dass8193]

@@xperimentsqf3823 Hi, i found a solution elsewhere, you have to enable the google sheet API in googlescripts, you can research more about that online.

[@nuruldesita8477]

Can I send data from LABEL ?? I wanna send the result from my calculator that shows up on label

[@TheCodingBus]

Yes you can...

[@nuruldesita8477]

@@TheCodingBus can I use the same coding as what you made? and replace the textbox with label? Or I need another code or script? Please help me.

[@Manhans2731]

Hi I am trying but data not reaching to Google sheet please help me

[@TheCodingBus]

may i know the error please?

[@Asifiqbal138]

Great effort dear

[@TheCodingBus]

Thanks a lot 😊

[@FunZone01]

What is the code for it ?

[@TheCodingBus]

for send data

[@ddtdilireba]

Hi, when copy the sheet url to the google apps script, do i need to open the "write" permission for my google spreadsheet?

[@TheCodingBus]

Yes

[@serirasyidah2390]

i tried it but its not working :( there is empty on google sheet

[@TheCodingBus]

recheck you code.. and make sure you are using the same variable name or fields

[@teamsatyarthi4406]

can we also save images in google sheet?

[@TheCodingBus]

Yes

[@broplayers1567]

Can u please tell me how to add data in more than 2 column. Am not able to do so press please help me

[@TheCodingBus]

you have to change to code part.

[@broplayers1567]

@@TheCodingBus i tried adding the extra column names but the data isn't showing there

[@broplayers1567]

@@TheCodingBus can u please tell me how to change in a perfect way pls

[@thefinancemindsets1465]

Didn't work! I'm trying from 3days

[@matthewgalve137]

hello how can I reset spreadsheet? I want it to start in number 2 again.

[@TheCodingBus]

sorry i have to check this option

[@waqarghafoor6071]

Keep it up bro

[@TheCodingBus]

Thank You 😊..sure...

[@sonu3027]

doGet function not found.. what to do?

[@TheCodingBus]

recheck your code.. u will get it

[@jijeeshpadmanabhan350]

Can we connect MIT inventor with Air table?. please reply.

[@TheCodingBus]

no

[@jijeeshpadmanabhan350]

@@TheCodingBus ok

[@ChakaHamilton]

The code works, however. How do I get it to go into a specific cell I have a cell CaregiverName & CaregiverPhoneNumber in the app and in the sheet. However when I submit the data, it goes into the first 2 rows which are before the two i mentioned, not those with the cell names above. is there a way to set it to go to a cell with specific header titles?

[@TheCodingBus]

yes... you have to mention cell in the app script code

[@ChakaHamilton]

@@TheCodingBus can you provide an example of its usage then from there can figure it out. update: I figured out what you were saying. Tx!

[@andytan5513]

Hi, is the & and = sign necessary?

[@TheCodingBus]

Yes

[@anupludra]

I am unable to do a google script for UPDATE RECORD. Can u help?? I have a google sheet where 4 - 5 users are uploading data from mobile app. The app is working fine. My requirement is that when any user upload data, his previous data should get updated with the new data. So for every user, there should be only 1 record available on the google sheet (LAST SENT RECORD).

[@TheCodingBus]

Hi, this will work fine if you are uploading the data from different device. because we are using the same script

[@anupludra]

@@TheCodingBus I this it would be the other way around. If I am the user and I am uploading My data, Then My Data will get over written. I cannot OVERWRITE anyone else's data !!

[@anupludra]

@@TheCodingBus Tx for your response anyways .. I got it to work.

[@anupludra]

The data being uploaded is tagged with a unique identifier for the user. So to update a record, the unique identifier is compared. That way only I can update My record.

[@nthoang2698]

I need the code when i click "send data" button, then all datas in all labels deleted, thank u!

[@TheCodingBus]

Let me check