Are you using new or old editor ? Also each time you make changes you have to save a new version of script and change url in app
1 Like
i was using new editor i will try to use old one
Pls follow any one guide… i have advised you to copy , paste from this guide, and i have showed in the gif also the same
that is what i have done
if anyone knows to send data please give a try
avoid this error… just deploy with new number and go on… even if i do it will show, just skip and continue
You did not publish/deploy your web app.
You cannot just run doGet(e) in the script editor, it requires parameters (from your app or in a browser url)
But you need to give this access when using the legacy editor:
1 Like
Once you have done that, you can test your web app in your browser:
<YOUR SCRIPT URL>?FN=readSheet&ID=<YOUR SPREADSHEETID>&SH=<YOUR SHEET NAME>
Looks like this:
https://script.google.com/macros/s/AKfycbyNECxxxCzY0HXXXa8W49LEJHGQ1MeuWeqRqhYmag6BMtINYkkI/exec?FN=readSheet&ID=1O1tRBxxxjs1MiFvVs0VCXXXJYTc4g_GB8wfVO3A9Es&SH=Sheet1
This should return all the data on your sheet
Ah, are you working inside a domain (what used to be called G-Suite) ?
If so, you will need an Admin for Google Workspace in your institution to give you permissions to set your script to Anyone,even anonymous
I think i don’t know that
but still it is not solved