Yep, that’s one of the key use-cases. You can choose one of the tables in your base/sheet and that’s the users who can log in.
Not a pre-defined set of logins.
The Airbnb/ecommerce usecase - where a logged in user "books" something would be simply awesome