Importing Company Info into People at Companies Table

Josh C. · 2025-04-04T21:11:06.934328+00:00

When I find companies and then I find people at those companies, How Do I import company info into the "people at companies" table?

To import company information into your "people at companies" table, you can use the "write to table" feature or a lookup column. Here's how: 1. First, find companies and people using the "Find Companies" and "Find People at These Companies" actions. 2. Clay automatically links your Find Companies table to your Find People table. 3. To bring company data into your people table, add a lookup column in your people table that references the company data. 4. Alternatively, use the "Lookup Multiple Rows" enrichment in your company table to pull specific fields from the people table into your company table. 5. If you want both company and people data in one table, you can use the find contacts search option in the enrichment tab and save the results into the company table. This way, you can view and use company information alongside your people data efficiently.

Sources: Find People [Clay 101] - Clay University Assistance Needed for People and Company Table Lookup in Clay | Clay

4 comments