You can connect your Supabase DB with a read-only login and sync your users (you can also join another table to pull in more columns like from public.profiles).
Comes with a self-hostable companion to handle bounces and unsubscribes.
A user shared a desktop app that connects to Supabase to send marketing emails using a read-only login. Another user raised concerns about GDPR compliance, highlighting that using auth.users for marketing without explicit consent is problematic.
Resend already plugs into Supabase Auth and the Supabase docs have the Edge Function for sending. Pulling auth.users out through a read-only role to send marketing mail is a consent problem under GDPR, signing up for your app isnt consent to promo emails.