Custom code can do this for you! It’s kind of complicated but not impossible.
I’ve made something quite similar for an enterprise marketing automation platform. This would be a decent amount of time to develop (40+ hours) so I haven’t had the chance to do it for a small business. 