I wanted an advice to how should I remove the google sheet from my app purely make It as glide table based application. I tried doing it by removing users table and write that to glide table, but it is not taking the users information while accessing the application.
Can you let us know what do you mean by recognizing? Can you check the link above to see if you have indeed marked that table as the User Profiles table?
I deleted the excel file and created users glide table, I have added 10 users in that with emails however, when I go to frontend it does not show the users it only shows anyone.