is it possible to create an action or a bot that opens a site and log ins the person in said site using the information from the app.
for example let’s say i have a sheet with user, email and password, and i want it to open gmail.com and log in the user
is it possible?
No. You would need to have an Appscript script, which Appsheet can trigger, but this requires the script to reside on their account (Installable Addon).They also have to run the script on their account to access their gmail which requires authorization. Google does this to prevent maliciuos apps from accessing things like gmail,docs, etc without authorization.
Maybe the best question here is what are you trying to accomplish? There may be a solution available for what you are trying to achieve.
Well, that’s just ripe for abuse!