I've self hosted appwrite and followed their instructions of changing the env variables, and as far as i know, the email should be sent automatically but it doesn't, i'm using resend btw for sending the email.
TL;DR
Developers configured SMTP for appwrite but confirmation emails are not being sent automatically using the resend feature.