How to Find Employee Names by Title and Company

Gabe L. · 2025-12-15T23:01:13.520Z

I have a clay table with Title and Company name. I want to find the persons name of that title at the company. How can I do this?

How to Find Employee Names by Title and Company | Clay

Clay Support
APP
·
·
Go to "Actions" and select "Find people at these companies."
In the menu:
• Select your table under "Companies"
• Choose the company name column under "Column"
• Use the "job title" function to specify the position you're looking for
• Click "Preview People" to see results
• If satisfied, click "Import" then "Save to new table"
Set a limit to control how many contacts you retrieve per company. [1] [2]
Clay Support
APP
·
·
Is that what you were looking for?
Gabe L.
·
·
no it needs to be dynamic. The title column I have is not uniform
Clay Support
APP
·
·
For non-uniform titles, use the "Formulas" enrichment to standardize them first:
1.
Add Column → Formulas
2.
In the prompt, describe how to normalize your titles (e.g., "extract job function from varied title formats")
3.
Use AI generator to create the formula
4.
Review results and finalize
Then use the standardized column in "Find people at these companies" with job title filters that include synonyms and similar titles automatically. [1] The search returns related titles even if not exact matches. [2]
Clay Support
APP
·
·
Did that answer your question?
Gabe L.
·
·
any other ways we can do it?
Clay Support
APP
·
·
Yes, here are other approaches:
Professional Profile enrichment: Use "Add Enrichment" → "Professional Profile" and map your existing title + company data to find matching people. [1]
Find Contacts at Company: Use the "Find Contacts at Company" enrichment with your company column and title as job title keywords - it handles variations automatically. [2]
Split then search: Use Formulas to extract key terms from your titles, then use those extracted terms in the people search filters.
Each method handles non-uniform titles differently, so you can pick what works best for your data structure.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with finding the right person names based on your titles and companies, I’m here to assist further. Would you like to provide more details about your data or the specific outcome you want to achieve?
Gabe L.
·
·
Its not being dynamic
Clay Support
APP
·
·
I understand this can be frustrating. I’ll connect you with one of our human agents who can assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Gabe L.
·
·
https://app.clay.com/workspaces/630325/workbooks/wb_0t7bf9z65b3bMHVjsSj/tables/t_0t7c2cguHQwPCPGeKN8/views/gv_0t7c2cgiaPW5wP323oJ
Ariana (.
·
·
Hi Gabe, thanks for reaching out. Taking a look now.
Ariana (.
·
·
Unfortunately you are not able to reference a Clay Table in a Find People source > job titles section. You can currently do this in the Find People source for Companies in a Clay Table, but not job titles. However, this is really valuable feedback and I've sent it over to the team for review! Right now I would suggest using a formula to normalize your job titles column, then setting up a Find people at these companies search using the standardized results you find. Unfortunately, this doesn't achieve the dynamic aspect you're looking for, but should lower the number of job title keywords you'll need to add to the search. Let me know if this helps or if you have any other questions!

17 comments