Redirect users at login to different apps?

you also may want to take a look at this thread A group of row owners - #6 by ThinhDinh

I had a similar situation and @ThinhDinh helped me out with a solution, you can access it on this sheet.

Good luck