I have a problem to login directly in new spreadsheet (that I get the URL) without display verified email n password. I want to give email and password in blockcodes. how to solve this?
sorry maybe what i described before be confused, so I've to edit my problem specified
Query Any Google Sheet with a Web App
Get or Download a Private Image from Google Drive
Google expects a gui login to a google account. You can do this with a webview, but cannot authenticate in a webview (even if you fiddle with the user agent), you have to use a proper browser.
You are better off:
- Setting the access to the sheet to anyone with the link (to read)
- Using a google apps script web app owned by the spreadsheet owner (to read/write)
You could use an intermediary google form to write data
ok thanks y
Plenty of links to examples in this and your previous topic
i trying to find it