Login spreadsheet by webviewer

[Oktovianus_Masrikat]

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?

[Salman_Dev]

Check this :
https://groups.google.com/g/mitappinventortest/c/OCEevyI5XV0

Webviewer Website Login PHP

Hey guys, I'm not sure if anyone can help me, I am an infrastructure engineer by trade, so apologies for the gaps in my knowledge. I am attempting to simply login to a website form through the app. I have used WireShark to get a better understanding of how the website login would normally work. I seem to be heading in the right direction, but I still can't seem to login. Button is clicked Take all the returned content and strip out the token POST back to website with headers, userid, passw…

[Oktovianus_Masrikat]

sorry maybe what i described before be confused, so I've to edit my problem specified

[Salman_Dev]

Query Any Google Sheet with a Web App

Post Data to a Google Sheet

Get or Download a Private Image from Google Drive

How to use a Google Drive Google Spreadsheet as Database

CRUD with Google Sheets, Web App and AI2

Built In Google Sheets Component for App Inventor

I finished the code for my sample Sheets app, a Pizza Shop. It turned out to be more than I bargained for, in scope. Here's the source, and some screen shots ... APizzaSheet.aia (37.7 KB) [Capture New Order Entry start] Initial order entry requires a name, and logs the time. [Capture New Order Item selected but not yet added] A List Picker lets you pick from the Menu, without duplication. [Menu Sheet] An Item level Add button completes the Add operation. [Capture Order Item Data] Or…

FAQ Section: Google Sheets

AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - TimAI2 Google Sheets Create/Read/Update/Delete(CRUD…

[TIMAI2]

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:

1. Setting the access to the sheet to anyone with the link (to read)
2. 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

[Oktovianus_Masrikat]

ok thanks y

[TIMAI2]

Plenty of links to examples in this and your previous topic

[Oktovianus_Masrikat]

i trying to find it