What Cloud Auth does, and what happens between somebody pressing sign in and your service trusting them.
Cloud Auth handles signing people in, and answers — for your own server — whether a given token still belongs to a real, current session. Accounts belong to tenants, a tenant is an organisation or a team, and the role somebody holds belongs to that membership rather than to the account.
Your users sign in with Google or Apple. There is no password to store, to leak, or to reset — the password step, where it exists at all, belongs to Google or Apple. The operator accounts that run the service do use a password, on a separate screen, and always with an authenticator app.