Hi I'm in trouble. I need help and any extension for this:

MIT App Inventor Help
11

Have had a chance to look at things. Actually, there is not too much wrong with the google apps script, other than the naming of the sheet - it is not the spreadsheet name but the sheet name. This is why the script is failing.

Why have you put the spreadsheet in the bin ?

Most of the issues are with your blocks.

  1. You can use a web component to send values to the spreadsheet, not a webviewer. However, if you have a google apps script web app, why not use that to upload values to your spreadsheet?
  2. I cannot see your full script url, but you do not appear to be sending any of the parameters required?
  3. You also need to call the url in your web component with the Web1.GET block (another reason why it doesn't work)

You may want to look at this instead?