Editing Google Sheet

Hi, I am trying to send data to google sheet. The weblink gets my data but it does not change the sheet. I am totally new here and know too little about app development. Can anyone help me to fix the issue?

Capture

The web link here is the link of an AppScript file. The Appscript Code is..

image

Show your responseContent please

My Response content is too big
image
it is not showing the whole text in one screen. I have collected those texts here.

You are getting the standard google login page returned (as html). This means there is something wrong with your script, and/or how you have published it.

The apps script must be published as Me - your google account and to be accessible to Anyone (new script editor) or Anyone, even anonymous (legacy editor). Then publish the script to a new version. Check the script url matches the one you have in your app, if not replace it.

Some links to help you

2 Likes

I had made it accessible to "anyone with google account" but had not seen that there is another option that is just "anyone". I deleted the whole script and made a new one. My app is now working fantastically. Thanks a lot @TIMAI2 for helping me to find the mistake :heart::heart::heart:.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.