Integration with Email Octopus would be great! Right now I am copy pasting the emails manually...

I don't know Email Octopus, but did you take a look here? https://github.com/burggraf/supabase-mailer

I think you can create an edge function for this right? Or use the http plugin for postgres with a trigger

I guess. But I was looking for a more UI based solution. Doens't have to be EmailOctopus, just something to send an email everytime there is a new user in Auth