Consolidating and Enriching Company Data from Multiple Workbooks

Tarun M. · 2025-03-01T10:01:42.965115+00:00

i have 3 different workbooks containing data for 3 different countries. Each workbook contains company data like company name and website. Now i wish to enrich the company data and then want to find contacts for each workbook and move it to one single workbook

To enrich company data, find contacts, and consolidate into a single workbook, follow these steps: 1. Import your company data into Clay tables, one for each country. 2. Use the "Find Company Domains" feature to enrich company data. 3. Run a "Find Contacts" search in the enrichment tab. Select the option to save results into the company table. 4. Set a limit for contacts per company (e.g., 1 result each). 5. The contacts will be automatically linked to their respective companies in the same workbook. 6. Use the "write to table" feature to consolidate data from all three tables into a single workbook. This process will enrich your company data, find contacts, and combine everything into one workbook for easy management.

Source: Find People [Clay 101] - Clay University

2 comments