Using AI to Match Companies with Third Party References in Clay

Trying to do something in Clay that I think should be able to be done BUT I haven't seen it done. In Table A, I have a list of approved third party references. I have also added columns that include the locale, employee size and industries of these companies. Over in Table B, I have the companies we're going to contact - also including locale, employee size and industries. In Table B, I want it to look at Table A to find the third party reference that is most similar to the company I'm targeting. So I'm trying to accomplish a type of look up BUT it's not a pure lookup with Equals or Contains but a lookup that would use ChatGPT (or similar) to draw the reference between the two.