How to call api when new user is created

I use magic link sign in with Supabase, so no sign up needed. I want to send a transactional email when new users are created but I'm not sure the best way to approach it. I can make an API endpoint that does it but I'll need to call it somewhere.

I have a stored procedure that runs when a user is added to the auth.users. So maybe I could call my api from there?

Since supabase sends a confirmation email instead of a sign in email on a user creation (even when using signIn()), could I do something with that?
Was this page helpful?