Is there a way to access the email confirmation URL?
What I want to achieve
When a user has signed up for my SaaS but has not confirmed their email, I would like to remind them to confirm it via my newsletter tool. So the flow would be like:
1. User signed up
2. Has not confirmed their email link
3. I'd like to remind him after a couple days with my email newsletter tool and would like to add a button with the confirmation link–but I would need to know the URL generated by Supabase
1) Is there a way how I can access the generated Supabase confirmation link directly?
2) Is there a way how my newsletter tool (GetResponse) can send the confirmation URLs instead of Supabase?
Thanks in advance!
4 Replies
You can use sql to see if the auth.users confirmed_at column (check the name) is not set. This could be done in a cron task that then calls an edge function. That function would use the auth.admin.generateLink() call to get the info you need to format a link in an email and send with your provider.
Thanks @garyaustin ! I appreciate it. This sounds like a technical/complicated approach. Is there a plug&play alternative? Because letting a third party email provider handle the emails seems like a common use case to me
Nothing from Supabase.
The generateLink is the tool Supabase provides for doing your own.
There is a nice cron UI in the dashboard now to call edge functions.
I just looked up the cron UI (extension), this is nice! Thanks for pointing me in the right direction 👍