This is how I managed this without code. I wouldn’t recommend it without a huge Zapier plan or only a handful of leads because it uses a lot of Zaps. Hopefully if gets you on the right track and you can make it more efficient for your use case.
Looking forward to hearing how others have achieved this also.