It is an extremely frustrating practice (emailing you the password). I find that I have to go through this every few days for whatever reason and I've had cases where the email from Notion took five minutes to arrive.