I want to find people in a company And want my output to be list of people so that I can enrich them in another table But I don't see any way of configuring that If I select URl them only 1 person url is found, what about others. I tried sculptor but it keeps making the same error Also I don't see where to configure data type to Jason or array
To find multiple people at companies and create a list for enrichment:
Go to Actions → Find people at these companies
Select your company table and choose the domain or company URL column
Set search parameters and click Preview People, then Import and Save to new table
To get the list format you need, use write to table to map each person from your results into individual rows in another table [1]. This automatically handles the array/list conversion - select the column with your people data and map the properties to your destination table .
The write to table feature flattens lists so each person becomes a separate row for enrichment [2].
Was that helpful?
I am using a waterfall to find people in those companies
Since you're using a waterfall to find people at companies, you can use "write to table" to convert your results into individual rows for enrichment. [1]
Select the column containing your people results from the waterfall, then use write to table to map each person to separate rows in a destination table. [2] This automatically handles converting the list format into individual rows that you can then enrich.
Was that helpful?
What's the data type I should select
You don't need to select a specific data type when using write to table with your waterfall results. Write to table automatically handles lists and converts them into individual rows. [1]
Lists are optional - you can write individual values or entire lists depending on your column setup. [2] The system will automatically flatten your people list from the waterfall so each person becomes a separate row for enrichment.
Did that answer your question?
Can you please raise this to a human?
I understand, I’ll connect you to one of our human agents who can assist you further.
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!

Hi Noor, thank you so much for reaching out. Find people waterfall enrichment returns the results as an array in a json format. If you only see one URL in the sidebar when you click the cell, it usually means the enrichment was only able to find one person.
Could you please share your Clay table URL? I would be happy to take a closer look for you.
Here is a quick video that walks through how to view the full list of people returned by Find people and how to write that list into another table as needed. https://www.loom.com/share/319b7182bbaf4f5790fc5fa4a9ddc878
Hi Mayato (. thanks for replying Here's the scenario You have 5 rows For row 1,2 First step of the waterfall was able to find people. So I did exactly as you showed me on loom What if for row 3,4 second data provider was able to find people And for row 5, third data provider. In that case do we map out 3 rows separately and send to table Or is there any way we can send all of them together I am doing it now separately, as that's the only workaround I thought of Let me know if there's a better one shot way Link to Clay workbook
