- setup an smtp server in the dashboard which sends email to the void (e.g. Ethereral). That way, the emails sent by Supabase will NOT reach the user
- Define a trigger which listens for the addition of new users
- In the trigger, hand-craft the confirmation link. I say that you will need to hand craft it since you will NOT be able to call generate_link in the trigger - the problem is that the trigger fires BEFORE the transaction is complete and since the transaction is NOT complete, the GoTrue server does NOT see the new user and will tell you 400 or 404 since it thinks that the user does NOT exist. By hand-craft I mean to see what hte link looks like and just put it together with token for the new user (you have it in the NEW record in the trigger)