Sending data to Google Spreadsheet

MIT App Inventor Help
1

Hello everyone !

I’m creating an app and I need to send data written by the user to a Google Sheet. I followed this tutorial :
https://www.youtube.com/watch?v=SUFxL1awjO8

But in the end, my code doesn’t seem to work, the data isn’t sent to the sheet.

Here’s my code

I suspect that I’m using the Web component wrong, but I don’t see where the error would be, the idea is that google forms have a URL format for sending the answers to a Google Sheets, which is what the code should be doing, joining the different parts of the URL (first is the link to the form, second is the first answer, third is the second answer) and applying the URL (which is where I believe I might have missed something).

If anybody has an idea of what I might be doing wrong, thanks a lot in advance for the help.

Have a nice day and stay hydrated ! :sunny:

2

A guess, because you only shared part of your code: did you make the GoogleSpreadsheet you created shareable? YOUR app uses Dictionaries… the youtube tutorial you referenced does not. It appears you modified the tutorial. What happens if you follow the tutorial?

3

Same approach, different (better?) method:

https://ai2.metricrat.co.uk/guides/use-ai2-to-directly-submit-google-form-data

another way of doing the same thing:

https://puravidaapps.com/spreadsheet.php

4

remove the open another screen “Screen1” block and check the result in the Web.GotText event

Taifun

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

5

Hi, having exactly the same issue, i have even posted the URL from a different machine using the same string, it worked but only after verifying that It was a "real" account, i assume this must be a permissions thing

6