Combining Sheets and Managing Duplicates in Data Enrichment

Aviral Bhutani · 2025-02-19 13:45:48.636042+00

Hey there, so I have extract 2000 lookalike companies. Out of these two lookalike companies I have extracted 1000 data once on one sheet and another time I extracted 3580 leads onto another new sheet. On the first sheet I have enriched the data for some of the leads. Now I want to combine these sheet and get the duplicates merged and get the remaining data enriched. 1. How do I merger the contacts on a same sheet and remove the duplicates? 2. By mistake I have deleted the waterfall for the personal email column can you add that back or if I again use enrichment for getting the personal email will I be charged for the credits again? for the same contacts or how does that work?

Combining Sheets and Managing Duplicates in Data Enrichment | Clay

7 comments

· Sorted by Oldest

Channeled
APP
·
·
For merging and deduplicating contacts: 1. You can use the "Write to table" integration to combine data from both sheets into one table. For the personal email waterfall: 1. You can restore the personal email waterfall by: • Right-clicking "Add Column" > "Add Enrichment" • Searching for "Waterfall" • Selecting the personal email data point • Clicking "Save" and running the waterfall Good news about credits - you won't be charged again for the same contacts when re-running the waterfall. Waterfalls only charge credits for the provider that successfully finds the data. To save credits, before running new enrichments, check if the data already exists in another Clay table. You can use a Lookup column to pull existing data into your current table.
Sources: Waterfall Custom Waterfall Hide, Re-order, Sort, Filter, Merge Columns Guide: Ways to save Clay credits | Documentation | Clay University
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
Hi Aviral Bhutani! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Aviral Bhutani
·
·
Just to confirm even if I enrich the same data on the different table I won't be charged credits for that right?
Aviral Bhutani
·
·
Hi you there?
Channeled
APP
·
·
To merge contacts and remove duplicates, you can use the "Write to table" integration to combine data from both sheets into one table. To restore the personal email waterfall: 1. Right-click "Add Column" > "Add Enrichment" 2. Search for "Waterfall" 3. Select the personal email data point 4. Click "Save" and run the waterfall Good news: You won't be charged again for the same contacts when re-running the waterfall. Waterfalls only charge credits for the provider that successfully finds the data. To save credits, before running new enrichments, check if the data already exists in another Clay table. You can use a Lookup column to pull existing data into your current table.
Sources: Waterfall Guide: Ways to save Clay credits | Documentation | Clay University
Channeled
APP
·
·
Did that answer your question?

Channeled
APP
·
·
For merging and deduplicating contacts: 1. You can use the "Write to table" integration to combine data from both sheets into one table. For the personal email waterfall: 1. You can restore the personal email waterfall by: • Right-clicking "Add Column" > "Add Enrichment" • Searching for "Waterfall" • Selecting the personal email data point • Clicking "Save" and running the waterfall Good news about credits - you won't be charged again for the same contacts when re-running the waterfall. Waterfalls only charge credits for the provider that successfully finds the data. To save credits, before running new enrichments, check if the data already exists in another Clay table. You can use a Lookup column to pull existing data into your current table.
Sources: Waterfall Custom Waterfall Hide, Re-order, Sort, Filter, Merge Columns Guide: Ways to save Clay credits | Documentation | Clay University
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
Hi Aviral Bhutani! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Aviral Bhutani
·
·
Just to confirm even if I enrich the same data on the different table I won't be charged credits for that right?
Aviral Bhutani
·
·
Hi you there?
Channeled
APP
·
·
To merge contacts and remove duplicates, you can use the "Write to table" integration to combine data from both sheets into one table. To restore the personal email waterfall: 1. Right-click "Add Column" > "Add Enrichment" 2. Search for "Waterfall" 3. Select the personal email data point 4. Click "Save" and run the waterfall Good news: You won't be charged again for the same contacts when re-running the waterfall. Waterfalls only charge credits for the provider that successfully finds the data. To save credits, before running new enrichments, check if the data already exists in another Clay table. You can use a Lookup column to pull existing data into your current table.
Sources: Waterfall Guide: Ways to save Clay credits | Documentation | Clay University
Channeled
APP
·
·
Did that answer your question?