Finding a Way to Extract Results from Clay's People Search

Petar R. · 2025-11-06 03:20:52.696159+00

I figured out one limitation in Clay. I can't pull the number of results from find people source using formulas or AI. If I could pull this number into a column in this table, I'd be able to build a sequential workflow dependent on this result. Is there a way to pull this result somehow?

Finding a Way to Extract Results from Clay's People Search | Clay

Clay Support
APP
·
·
You can extract the number of people found using the "Add as column" feature:
1.
Click on the cell showing "2 people found at this company" to open the Cell details panel [1]
2.
Hover over the text containing the number and click "Add as column" [2]
3.
This creates a new column with that specific value
Alternatively, use a Formula column with the "Extract Values from Data" integration to pull specific numbers from your People Search results [3]. You can reference the People Search column using "/" and ask the AI formula generator to extract just the numeric count [4].
This extracted number can then be used in sequential workflows and conditional logic.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with extracting or using the number of people found in your People Search results, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Petar R.
·
·
it is not possible to do this for find people source column
Clay Support
APP
·
·
I understand this limitation can be frustrating. I’ll connect you with a human agent who can assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
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!
Loading attachments
Nicole G.
·
·
Hi Petar,
Thanks for reaching out to support. Would you be able to provide a bit more context on what you're hoping to do and what your ideal workflow would look like? Would love to investigate how we can make this happen.
Petar R.
·
·
Hey Nicole G. I'd love to map the number of records found to my current table. Then use it as conditional formula for other enrichments afterwards. Makes sense?
Nicole G.
·
·
Yep! Sounds like a great plan. Have you try using lookup multiple rows. This will scan your table and let you know how many records are coming up of the value that you're comparing. Then, after that, you can place conditional runs on enrichments and reference this column and say something like, "Only run if this value is greater than two," or whatever you want it to be.
Petar R.
·
·
Lookup is not allowing me to automate the whole workflow
Petar R.
·
·
I want to automate the whole workflow sequentially. Which is not possible with current limitations.
Nicole G.
·
·
Could you walk me through the flow that you want to automate and what your current flow is? Having a bit more context will help me understand how to advise you best.
Petar R.
·
·
-Company table has 10,000 records. Then I use Find People source and push to People table 1 (lets say it finds 2000 people. - In People table 1 there is an email waterfall (lets say it finds 500 emails from 2000 people) - Then I need to find the rest of the companies that Find People source and email waterfall didn't find But automatically. Not to run 3 lookups manually.
Petar R.
·
·
I tried everything. It is not possible to automate this type of workflow unfortunately.
Nicole G.
·
·
so this biggest concern is that we want to find the emails of users who we aren't finding, are you using a waterfall to find email? Feel free to send over your table URL so I can take a closer look at your table and see if we can create a fallback in case emails aren't found in that first cycle.

18 comments