Creating a Unified Table for Multiple Contacts from Different Providers

Kylian C. · 2025-11-05 13:16:58.921023+00

Hey, I run a waterfall to get people at specific domains. Sometimes I got multiple people per company. How do I create a new table with all the person? Cause each provider hasn't the same format.

Creating a Unified Table for Multiple Contacts from Different Providers | Clay

11 comments

· Sorted by Oldest

Kylian C.
·
·
https://app.clay.com/workspaces/236139/workbooks/wb_0t4xwvuoSoy87KmqpDa/tables/t_0t58wbb3CW875HhjEUC/views/gv_0t58wbb5qAVYHfZnuEt
Clay Support
APP
·
·
Use the "write to table" feature to create a new table with all people from your waterfall results. [1]
Steps:
1.
Add a column and select "Write to Other Table"
2.
Choose the column containing your people lists (with multiple people per company)
3.
Select "Create new table" as destination
4.
Map the person data fields you want (name, email, etc.) to the new table columns
This maps each person from your lists into individual rows in the new table, regardless of different provider formats. [2] You can also add additional data from your current table (like company info) to provide context for each person.
Clay Support
APP
·
·
Was that helpful?
Kylian C.
·
·
Loading attachments
Clay Support
APP
·
·
Use "write to table" to flatten your waterfall results into individual person rows. [1]
1.
Add a column and select "Write to Other Table"
2.
Choose your waterfall column containing the people lists
3.
Select "Create new table" as destination
4.
Map the person data fields (name, email, etc.) to new table columns
This maps each person from your lists into separate rows, regardless of different provider formats. [2] You can also include company data from your current table for context. [3]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with creating or managing your tables using the "write to table" feature, please let me know. Would you like to provide more details about what you're trying to achieve or any specific issues you're encountering?
Hasnain R.
·
·
Use a Send to Webhook or Send to Table action to push each person row into a new table standardizing fields as needed before sending.
Clay Support
APP
·
·
Use "Send table data" to push each person into a new table with standardized fields. [1]
1.
Click Actions → Send table data
2.
Select "Send row for each item in a list"
3.
Choose your waterfall column containing people lists
4.
Map person data fields to standardized columns in the destination table
This flattens your waterfall results into individual person rows regardless of provider format differences. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with pushing each person row into a new table or standardizing fields, I’m here to assist. Would you like to share more about the specific challenges you’re facing with this process?

Kylian C.
·
·
https://app.clay.com/workspaces/236139/workbooks/wb_0t4xwvuoSoy87KmqpDa/tables/t_0t58wbb3CW875HhjEUC/views/gv_0t58wbb5qAVYHfZnuEt
Clay Support
APP
·
·
Use the "write to table" feature to create a new table with all people from your waterfall results. [1]
Steps:
1.
Add a column and select "Write to Other Table"
2.
Choose the column containing your people lists (with multiple people per company)
3.
Select "Create new table" as destination
4.
Map the person data fields you want (name, email, etc.) to the new table columns
This maps each person from your lists into individual rows in the new table, regardless of different provider formats. [2] You can also add additional data from your current table (like company info) to provide context for each person.
Clay Support
APP
·
·
Was that helpful?
Kylian C.
·
·
Loading attachments
Clay Support
APP
·
·
Use "write to table" to flatten your waterfall results into individual person rows. [1]
1.
Add a column and select "Write to Other Table"
2.
Choose your waterfall column containing the people lists
3.
Select "Create new table" as destination
4.
Map the person data fields (name, email, etc.) to new table columns
This maps each person from your lists into separate rows, regardless of different provider formats. [2] You can also include company data from your current table for context. [3]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with creating or managing your tables using the "write to table" feature, please let me know. Would you like to provide more details about what you're trying to achieve or any specific issues you're encountering?
Hasnain R.
·
·
Use a Send to Webhook or Send to Table action to push each person row into a new table standardizing fields as needed before sending.
Clay Support
APP
·
·
Use "Send table data" to push each person into a new table with standardized fields. [1]
1.
Click Actions → Send table data
2.
Select "Send row for each item in a list"
3.
Choose your waterfall column containing people lists
4.
Map person data fields to standardized columns in the destination table
This flattens your waterfall results into individual person rows regardless of provider format differences. [2]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with pushing each person row into a new table or standardizing fields, I’m here to assist. Would you like to share more about the specific challenges you’re facing with this process?