First create a sheet call it home
create 5 columns in home and call them
Access, description, icon, refrence, menu
Create items in home that represent all the areas/sheet in your app that needs to be accessed whether by regular user or admin.
Example you could have one item called Finance with a description an icon and the reference to the Finance sheet
Note for each additional item listed in home you will need an additional reference column to that respective sheet.
Now for the users.
You will need to add an extra column for your users to decide whether or not they get to see the home ( that’s a presuming you already have a column that indicates your users level)
Name that column home=home:menu:multiple
And in the second line, add a conditional array formula that checks the user level and if it’s a level you want to see the home sheet then display “home” if not “nohome”.
In the home sheet under the menu column you can add keyword “home” for each item
So your sheet privacy will need to be set to public email or whitelist.
Ad a glide tab that has the list of all your users and set the layout to detail. This way the person logs in they will only see the list item that matches their email and only one item will show.
In your glide layout you can add an inline reference that detail layout for that shows yhe home reference column.
So if the users level triggered a “home” then they would see the reference to the home sheet and if they triggered a nohome the reference would be invisible because of the mismatch reference keyword.
Best to do this using the glide menu feature which allows a hamburger menu in the upper left corner. Then just add your user sheet as a tab in that menu with detailed view, and only show the reference to home.
If their level triggers home then it will be in the menu, if not the menu will be empty.
Hope this helps.
This is a simple way but there are more complex access variations that is just too much to explain here. But ultimately you’re able to let whomever se whatever you want them to see based on the level or group you assigned to them.