Good morning,
I created an application for my company for connection management I use a Google sheet with the columns: name, email, photo and role
in private I put private access and in user I put user table
when connecting with my email address it works but if the email is not in the project team access is refused
I tried several things,
connection via gmail and via direct email
put access in public and required sign-in and in users & authentication I put the google sheet in user table there is a small blue icon on the google sheet logo but it does not always work access refused
put access to public and optional sign-in the application launches without asking for an email but logically no user is connected since I use filters to display the pages for the different roles this is not what I am looking for
I’m lost I don’t understand why it doesn’t work I watched YouTube tutorials the glide documentation I don’t know what to do
