My idea is I will use “email whitelist” for sign-in
And I will add a column “Category” in the google sheet which have the email list (email whitelist).
And my want is when a row of info with the same category (column) as the signed-in user, then will display.
For example: I have two users which I set their category as “Male”
If only when the row of info is target “Male” then the user can see.
How can I make this happen? Thank you!