Multi-Level Login with Role Dashboards – Google Apps Script

One login page, three different applications behind it. The same email box serves a user, a manager and an admin — and which dashboard opens is decided by the account, not by three separate web apps you have to maintain.

The role lives in the sheet

Each account row holds the email, the password and a type: user, manager or admin. Sign in and you land on the dashboard for that type, with a greeting naming the role. Change the type in the sheet and that person's next login opens a different dashboard — promoting someone is editing a cell.

An access switch that actually blocks

Beside the role sits an access column. Set it to disallowed and the login is refused with an access-denied message, even though the password is correct. That is the difference between a login system and a real one: staff leave, accounts need suspending, and deleting the row loses the history. Switch access off and the account is shut without being erased.

Three dashboards to fill

The code carries a clearly marked block for each role — admin, manager and user — where your own screens go, plus an editable footer for each. The structure is done; what each role sees is yours to write. One web app, one URL, three audiences.

What it does not include

There is no self-signup and no forgot-password flow — deliberately. Accounts are issued by the admin in the sheet, which is how schools hand out generated logins to students. If you need registration or password reset, the Apps Script login system with OTP reset covers that ground instead.