Before User Created Hook works only manually

DECLARE
  user_email text;
  allowed int;
BEGIN
  user_email := (event -> 'user' ->> 'email');

  -- if no email provided, deny
  IF user_email IS NULL THEN
    RETURN jsonb_build_object(
      'error', jsonb_build_object(
        'message', 'No email provided in signup event.',
        'http_code', 400
      )
    );
  END IF;

  SELECT COUNT(*) INTO allowed
  FROM public.allowed_users au
  WHERE lower(au.email) = lower(user_email);

  IF allowed > 0 THEN
    -- empty object indicates success for Supabase Auth hook
    RETURN '{}'::jsonb;
  END IF;

  RETURN jsonb_build_object(
    'error', jsonb_build_object(
      'message', format('Signups from this email (%s) are not allowed.', user_email),
      'http_code', 403
    )
  );
END;