Create Separate Rows for Key Contacts from Target Accounts Spreadsheet

Alexandre M. · 2025-11-01T16:30:38.375Z

Me again @Clay S. I created a column in my “target_accounts” spreadsheet, which list all key contacts from the target accounts. Is it possible to create separate rows in another spreadsheet for all these key contacts?

Create Separate Rows for Key Contacts from Target Accounts Spreadsheet | Clay

10 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! You can use Send table data to create separate rows for each contact in another table. [1]
Go to Actions → Send table data, select your destination table, then choose "Send row for each item in a list". This will flatten your contact list so each contact becomes its own row in the new table.
Alternatively, when viewing your contacts column, hover to the right of the list and select "Turn items into rows" to move each contact into its own row in another table. [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with creating separate rows for your key contacts, please let me know. Would you like to provide more details about what you're trying to achieve or any challenges you're facing?
Alexandre M.
·
·
Hum… It doesn’t work. My data structure looks like this
Loading attachments
Clay Support
APP
·
·
For complex object structures like yours with multiple fields per contact, use the Write to Table feature instead of Send table data. [1]
Go to Add Enrichment → Write to Other Table, select your destination table, then choose the column containing your Key Buyer Profiles list. You can then map each object property (Full Name, Position, Reasoning, URL) to separate columns in your new table.
This will create individual rows for each contact with all their details properly separated into columns.
Clay Support
APP
·
·
Did that answer your question?
Alexandre M.
·
·
I’d like to send all the “Key Buyer Profiles”
Clay Support
APP
·
·
Use Write to Table for your complex Key Buyer Profiles structure. [1]
Go to Add Enrichment → Write to Other Table, select your destination table, then choose the column containing your Key Buyer Profiles list. Map each object property (Full Name, Position, Reasoning, LinkedIn URL) to separate columns in your new table.
This creates individual rows for each contact with all details properly separated into columns.
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help with sending all your Key Buyer Profiles using Write to Table, I’m here to assist. Would you like to share more about what you’re trying to resolve or any specific issues you’re encountering?

Clay Support
APP
·
·
Yes! You can use Send table data to create separate rows for each contact in another table. [1]
Go to Actions → Send table data, select your destination table, then choose "Send row for each item in a list". This will flatten your contact list so each contact becomes its own row in the new table.
Alternatively, when viewing your contacts column, hover to the right of the list and select "Turn items into rows" to move each contact into its own row in another table. [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with creating separate rows for your key contacts, please let me know. Would you like to provide more details about what you're trying to achieve or any challenges you're facing?
Alexandre M.
·
·
Hum… It doesn’t work. My data structure looks like this
Loading attachments
Clay Support
APP
·
·
For complex object structures like yours with multiple fields per contact, use the Write to Table feature instead of Send table data. [1]
Go to Add Enrichment → Write to Other Table, select your destination table, then choose the column containing your Key Buyer Profiles list. You can then map each object property (Full Name, Position, Reasoning, URL) to separate columns in your new table.
This will create individual rows for each contact with all their details properly separated into columns.
Clay Support
APP
·
·
Did that answer your question?
Alexandre M.
·
·
I’d like to send all the “Key Buyer Profiles”
Clay Support
APP
·
·
Use Write to Table for your complex Key Buyer Profiles structure. [1]
Go to Add Enrichment → Write to Other Table, select your destination table, then choose the column containing your Key Buyer Profiles list. Map each object property (Full Name, Position, Reasoning, LinkedIn URL) to separate columns in your new table.
This creates individual rows for each contact with all details properly separated into columns.
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help with sending all your Key Buyer Profiles using Write to Table, I’m here to assist. Would you like to share more about what you’re trying to resolve or any specific issues you’re encountering?