How to Send Data to a Google Sheet with MIT App Inventor 

I really liked the way you explained things. I followed you step by step and finally got it after several failed attempts. Thanks a lot.

Amazing! This is what I needed! Thanks a lot!

This was a fantastic tutorial. Very clear and well explained. Thank you!

Thank you! I am very grateful for this! Perfect clear explanation :-)

Thank you, Allison. Very clear and easy to follow, and awesome.

Thank you.... your application works... it is a short and precise training video. Wonderful!

Worked perfectly first time. Big thanks for showing this technique. Opens up lots of possibilities.

Thank you so much, I have finally finished my project, it's now working perfectly

Thanks a lot, really useful!

Thanks for sharing your amazing knowledge!!

Hi ! Nice video easy to reproduce on my example ! THANK YOU ! :) I just need now to find how to copy the contents of the answer sheet to a new one and to clear the answers' sheet ! !

Great work ...Please make more videos 👍

Thanks for sharing this.

Thank you so much! This worked like charm. This solved a big headache for me since I wanted to collect GPS and Accelerometer data in large volumes with data just 1 second apart. Did not observe any performance issues inspite of this.

This what I was looking for, thanks 😍😍 Keep sharing and helping 😉

Merci beaucoup pour ce tutoriel très clair.

Thanks for ur video

Thank you so much！ I could do it!

How can I add more than one row at once? with a key perhaps? Your way of explaining is really great. I'll wait for more videos from you :)

thank you - I was able to follow alone and got my app working just fine. I was able to take info and use it as a guide to complete a custom app for tracking information I gather while driving UBER and Lyft.

I've tried it and it works!!! I'm looking for the second part of the video (for several users) but i didn't find it....

To work with Date Picker, you should create a variable (date) in the format year-month-day. And the month and day should have 2 digits to be accepted on google forms using the method of video. So, you should use a IF Month

EXATAMENTE O QUE EU PRECISAVA! SIMPLES E DIRETO! MUITÍSSIMO OBRIGADO!!!

This is exactly what I wanted to do! Thank you!

Awesome work, only one question, what emutor you use for run de app?

Haii John by the way I am Neela and I wish you to make more vedios which are helpfull to us.

Muito bom. Me ajudou muito.

Thanks, this week I have homework to make a fill-in-the-blank quiz on app inventor with Google sheet, but how can I make the questions show up randomly in one label.

I liked this video

I have 2 questions. At first if I delete the data from whole file and add a new value it comes as the next available and not at line 2 again, how can I fix it. And also how can I delete a line from the app

Boa tarde muito, seu tutorial e Excepcional. Grande abraço, Bruno Fernandes. Good afternoon, your tutorial and Exceptional. Big hug, Bruno Fernandes

Quem for trabalhar com data, sugiro criar uma variável de texto no formato ano-mês-dia. Importante salientar que o mês e dia tem que ter 2 dígitos para ser aceito no google forms. Ou seja, colocar um "if" (Se) o mês do selecionador de data for menor que 10, adicionar um zero antes do mês na variável da data que você criar (ano-0mês-dia), senão data=(ano-mês-dia). O mesmo teste tem que ser feito para o dia.

Getting this "Cannot parse text argument to "list from csv table" as a CSV-formatted table"

I tried the exercise from your adorable video but received this error message: "error 1109 the specified URL is not valid" Incidentally despite the message the data was posted on the spreadsheets, Could you please tell me what I did wrong?

Do you have any tutorial for updating the data from MIT to google sheet?

how to validate user. can we use this for User Authentication.

thanks a lot

hello i have 2 questions 1st how can i read the latest order first? and 2nd how can i "clean" the submit button from the last order? thanks alot nice video !!

thank you, how can i read the device on which this app is installed & add it to a data cell to google sheet ?

hi tanks for your course . plz can i change my sheeet to register data (can i change responsefilename) into one database

Question: in the link, you add formResponse after which / slash / ?? and isn't the sheet called form responses 1 ???

Hi. I followed your tutorial and it work. But can it be done sending data to two different excel and we can choose which excel to be send?

Nice and unique ideas I have a question ? How do I send a sender's email compulsory in the application page?

Terimakasih, sangat menolong...

Theoretically I can make a simple shared ledger system in google sheets with this method correct?

I am a begginer and I just wanted to know: why your commands are different from mine? // I cannot use set __ .url nor call__.get // Please help me I would love to complete this tutorial

thank you

woow i like this

Thanks you. I need it. Obrigado. Estava a procura por essa solução.

Got an error here. Please help me. Runtime Error - The operation Elements cannot accept the arguments: , ["Timestamp,ControlNumber, ...."]

Sir, how to include Date filed at the time of join. (Because join is using for TXT button)

Thanks for your work..... i want to know if is there posibility of send to app ipertestual text .... new hanks

Thank😊😊

Very useful, but i have a small problem: I've used the app a lot and now have to really scroll down the google document to see the new restaurants I've rated, how can i refresh the document page so that the new restaurants will start reappearing from the top?

in Initialize Global ____ to ; how to find the name of blank? How do you get "restaurantList" as for typing

Hi i really like the tutorial, could you do a tutorial where you can show us how to add in one screen and see the list on another screen Thank you !

Hi, great tutorial! Is possible to update the insered data from app?

Señorita buenas tardes, que tendria que hacer para modificar un registro ya grabado, siguiendo la misma tematica que implemento usted. Gracias de antemano y saludos desde Los Mochis, Sinaloa, México.

I'm really like your video. After I follow your step on your video I have some problem I got some runtime error about "list from csv table". Can you help me about this runtime error?

how can I create a user and that each user has its independent database list ... likewise exporting in excel

Grande aula, parabens , informação seria possivel ao gerar um arquivo .csv enviar para uma pasta no google drive?

Nice that's job

how to search by date in the list and display the result.

makasih sudah membantu

I had a doubt reagarding this...i am creating a app in which i am trying to fugure out what free database i can use.My question is how much simultaneous connections can this method showed in ur video handle

How do you have a variable for only one cell in google sheets?

Hi! How to notify successful shipment?

Nice

I can create a Google form that send data to Google sheets.. So what's the addition?

Than You....

How to combine mit with barcode scanner with spreadsheet output??

Dear madame, thanks a lot for your great tutorials, you mentioned that this tutorial is part 1 of a 2 parts series, unfortunately I can't find part 2, can you please post it? Thanks again

this probably wont get answered, but is there a way to remove the timestamp on the list view?

Hi there Allison, first thank you for this tutorial. I followed it to the letter. but I have one problem with it. Once I finished putting it all together and try to run it i get the following error, "cannot parse text argument to "list from csv table" as csv formatted table. i assume the returned text is not a csv table so that the block cat read it. But how or what do i need to do to get the right return from the sheet. thank you in advance. never mind :) i found in one of your previous videos that i needed to make the google sheet available to everyone with the link.

I have a problem. I Downloaded and runned this application, programming it exactly as in the video, but it don't let me use it because a error message appears "Syntax Error: quote in unquoted cell Cannot parse text argument to "list from csv table" as a CSV-formatted table" Can you solve this problem?

This video is very helpful, I already make apk for my home task, but I have problem. can you help me? How to minus the data from airtable and show the data after we minus or update data after minus(like I have 10 stock of medicine and take 2 medicine and the the data will show 8) I hope you will help me and thanks for the best tutorial

It doesn't work. I press the submit button and nothing happens. I also get this error: "cannot parse text argument to list from csv table as a csv-formatted table"

Hola Excelente tutorial vengo realizando una App en APP Inventor que me permita copiar datos de la tabla inicial en una segunda tabla pero ciertos datos filtrados y que los muestre en un mapa , para esto vengo trabajando con fusion tables y estoy tratando con la siguiente sintaxis : INSERT INTO tabla2 SELECT Fecha, Nombre, Apellidos, DNI, Celular, NumeroPedido, Latitud, Longitud, AgenteComercial FROM tabla1 WHERE DNI = '12345' . Quiero insertar en la tabla 2 todas las columnas en la tabla 1 donde el DNI sea igual a 12345. Me aparece error, he probado con encerrar en parentesis los nombres de las columnas de la tabla1 igual aparece error: Error 2601: Fusion tables returned an error... The response was: 400 bad request invalid query: Parse error near 'SELECT' (line 1, position 54). Por favor su apoyo cual seria la sintaxis correcta u otras acciones para que funcione. Gracias por su Respuesta. Saludos

Thank you for information. If I put a picture on form, how can I get to entry?

Do you have part II?

Hi, am getting response code 400. Could you help me with it

how can you upload images to google sheet or google drive, using appinventor

How to code( MIT APP INVENTOR), if i wish to save an image to the spreadsheet from the uploaded image on the app screen?

I've done exactly as you did but it's not working, it sends error message that it can not accept the argument to csv list, pls help

Hallo Allison, thanks a lot for the tutorial, it is explained perfectly. I am receiving an error though, "Cannot parse text argument to "list from csv table" as a CSV-formatted table". I checked three times and followed all your steps, what am I doing wrong? thanks!!

for me dont work. When push the button nothing happen. But when i simulate a link in web browser, app receive entry in a list. an anyone help me please?

We tried and have her this to work. We triple checked.

**** Português Brasil **** It could make a video like make a app of command, waiter who takes request of a pizzeria, would have to contain, values ​​of the pizzas, size of the pizzas, if it is two dabores or one, had to have a screen of servings and drinks. you would have to print an order coupon on the thermal printer. Thank you!

please make video how to update that...

Hello! I tried to this tutorial but its not working for me. Plz help

How do we update existing data?

what are url 4 web1forreading and web2foradding tq

Hi Allison! I'm creating an app and I can't do a thing. Could you try to help me?

Hello, i get an error stated "Cannot parse text argument to "list from csv table" as a csv-formatted table" can you help me with this?

i love you

can we use more than 2 column on Sheet/Form/appinventori

Cannot parse text argument to" list from csv table "as a CSV-formatted table. I'm facing this error mam, please guide to overcome this error, thank you

Para ir a una determinada hoja poner /export?gid=xxxxxxxx&format=csv

i cannot understand the last how to export app

great Video... thanks… helped me alot… but how can i retrieve the data without the time? thank you very much