How to Extract Multiple Contacts as Separate Rows from Find People Enrichment | Clay

How to Extract Multiple Contacts as Separate Rows from Find People Enrichment | Clay

Intercom
APP
·
·
Clay Support is sharing a file with you.
You need to use "Send row for each item in a list" instead of regular "Send table data" to properly unpack your contacts. [1]
When you have multiple people from Find People enrichment, each person is an item in a list. The "Send row for each item in a list" option creates a separate row for each contact instead of duplicating the first one. [2]
You can also access this from the cell details - hover over your Find People results and look for "Turn items into rows" which does the same thing. [3] This will move each person into their own row in your destination table. [4]
No need to switch to Actions - your current Find People enrichment is fine, you just need the right send method.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with extracting multiple contacts correctly, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any issues you’re encountering?
pradip k.
·
·
hey thanks for the reaply but still when i send it like Send row for each item in a list it still creates duplicates but when i click on raw i can see the second conatct but i have option to add new colum not new raw also my enrichment flow how to send data for each providers can just 1 send the data i can use for all the providers ??
Intercom
APP
·
·
Clay Support is sharing a file with you.
I see the issue! You're getting duplicates because the data needs to be mapped properly in the destination table. After using "Send row for each item in a list", you need to map the individual contact fields to separate columns. [1]
In your destination table, click into the source cell, hover over each contact field (like first name, last name, etc.), then click "Add to column" to create separate columns for each field. This will properly separate each contact into its own row with the correct data.
For your enrichment flow question - yes, you can set up one "Send table data" action that works for all providers. The key is mapping the common fields (name, email, etc.) that all providers return. [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with mapping your contacts correctly or setting up your enrichment flow, I’m here to assist. Would you like to share more details about what you’re trying to resolve or any specific challenges you’re facing?
pradip k.
·
·
yes but the issue is it does not let me map any data here in flow
Intercom
APP
·
·
Clay Support is sharing a file with you.
You need to use the "+ Add nested data" button in that panel! Click it, then select your "Find people at company" column as the source. This will let you map the individual contact fields (first name, last name, etc.) from within the people list. [1]
The regular checkboxes above are for basic table fields, but nested data is where you access the individual items from your people enrichment results. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with mapping your nested data or setting up your enrichment flow, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or any specific challenges you’re facing?
pradip k.
·
·
so you see this is mapping the data correctly but not maping it right in that raw i dont know why
Clay Support
APP
·
·
I see the issue - the nested data mapping isn't working correctly. The first person's data (Cati Caruthers) is being duplicated instead of mapping each person's individual fields.
Try this fix: In your destination table, click into the source cell for the second row (Patricia M. Lynch). Then hover over the individual fields within that specific row's data and click "Add to column" for each field (first name, last name, etc.). [1]
The mapping needs to happen per row in the destination table, not just once. Each row should pull from its corresponding person's data in the source. [2]
If that doesn't work, try using "Turn items into rows" from the cell details panel instead - hover over your Find People results and look for that option. [3]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help with correctly mapping your nested data or resolving the duplication issue, I’m here to assist. Would you like to share more details about what you’re trying to achieve or any specific challenges you’re facing?