Supabase new user notifications on your phone.

Three steps to your first push

How to set up the Supabase insert on auth.users webhook

1. Click Install in Studio and sign in. The recipe is added to your account and you get a personal webhook URL.
2. In the Supabase dashboard, open Integrations > Database Webhooks (enable it if asked) and click Create a new hook.
3. Pick the table and the Insert on auth.users event, and choose HTTP Request with method POST.
4. Paste your webhook URL as the URL, adding any options from the setup notes below, and create the webhook.https://••••••••/•••••••• your personal URL, shown after install
5. New Supabase Auth users are rows in the `auth.users` table. Instead of the dashboard form (which would send the whole row, password hash and tokens included), run this once in the **SQL Editor**. It posts the same payload as a Database Webhook, but only with the columns the push needs:
6. ```sql
7. create extension if not exists pg_net with schema extensions;
8. create or replace function public.justpush_new_user()
9. returns trigger
10. language plpgsql
11. security definer
12. set search_path = ''
13. as $$
14. begin
15. perform net.http_post(
16. url := 'your webhook URL',
17. body := jsonb_build_object(
18. 'type', tg_op,
19. 'table', tg_table_name,
20. 'schema', tg_table_schema,
21. 'record', jsonb_build_object(
22. 'id', new.id,
23. 'email', new.email,
24. 'phone', new.phone,
25. 'created_at', new.created_at,
26. 'raw_app_meta_data', new.raw_app_meta_data,
27. 'raw_user_meta_data', new.raw_user_meta_data
28. ),
29. 'old_record', null
30. ),
31. headers := '{"Content-Type": "application/json"}'::jsonb,
32. timeout_milliseconds := 5000
33. );
34. return new;
35. exception when others then
36. -- Never block a signup because the notification couldn't be queued.
37. return new;
38. end;
39. $$;
40. create trigger justpush_new_user
41. after insert on auth.users
42. for each row execute function public.justpush_new_user();
43. ```
44. `pg_net` sends the request in the background after the signup commits, so it doesn't slow sign-ups down.
45. To name your app in the title ("👤 New Acme user"), end the URL in the SQL with `?app=Acme`.
46. To remove it:
47. ```sql
48. drop trigger if exists justpush_new_user on auth.users;
49. drop function if exists public.justpush_new_user();
50. ```
51. The request isn't signed, so keep your endpoint URL private.

What runs when the webhook arrives

Studio calls handleRequest(request) with the incoming webhook and sends the message it returns. It's yours after install; change anything.

The Supabase INSERT webhook

This is what Supabase sends to your URL for insert on auth.users. It is a sample, trimmed to the fields recipes use.

Supabase new user notifications: questions