Creating new rows for multiple contacts at a company while maintaining consistent data for other columns.

if you find contacts at company and it returns more than one profile is there a way to create new rows for each person while keeping the rest of the company data consistent for the other columns for the new rows?

✅1

4 comments

Clay Team
APP
·over 1 year ago·
Hey Dean, thanks for reaching out! Yeah, you can use our Write to table integration to extract a list of results into their own rows in a new table, here's a quick video: https://www.loom.com/share/841cc9c009194f1688bbd134b3e4f388
Clay Team
APP
·over 1 year ago·
Let me know if you run into any issues!
Dean F.
·over 1 year ago·
hey Arturo O. this is helpful. how can i bring over all the relevant column data into the new table also so that a row for google.com person might retain all the old columns also
Clay Team
APP
·over 1 year ago·
Sorry for the delay, Dean, just catching up! For that second part, we have the Lookup Record integration. Here's a video and our docs page for Lookup Record!Hope this helps!

Creating new rows for multiple contacts at a company while maintaining consistent data for other columns. | Clay