Joe, if you could share the table, that would help, but here’s a solution that could work for you:
You can use the “Enrich Person from Email” option in Clay. To do this, go to the enrichment panel, click the “add enrichment” button at the top right of the page, and choose this option to find their job title, company, and other details.
Additionally, you can extract the company domain from the email using this guide: Identify Email Type and Extract Company Domain from Email. Once you have the domain, you can use Claygent to find the person’s LinkedIn URL with a prompt like:
“Find this person /name who works at /domain and return their LinkedIn profile URL.”
Let me know if you need further assistance! 😊