.png){kind=logo}
Handling Duplicate Leads in Clay During Upload
can i make when i upload to current table of leads in clay, if i upload new leads and there are duplicates, it will ignore them and add only new ones?
can i make when i upload to current table of leads in clay, if i upload new leads and there are duplicates, it will ignore them and add only new ones?
When uploading leads to your current table, you can use the Lookup feature to check for duplicates and only add new leads: 1. Use the "Lookup Single Row in Other Table" or "Lookup Multiple Rows in Other Table" integration to check if records already exist in your table. 2. Set up a column that flags duplicates by matching key fields like email or domain. 3. Create conditional formulas that only process new leads (those not identified as duplicates). This approach helps you save credits by avoiding duplicate enrichments while maintaining clean data. If you're trying to transfer data between tables without duplicates, you can use the "write to table" integration to map only the unique records.
can you explain it as simple as possible that 15years old person will understand
Think of your Clay table like a collection of baseball cards. When you want to add new cards, you don't want duplicates. Here's how to only add new leads: 1. Use the "Lookup" feature in Clay to check if a lead already exists in your table. This is like checking your collection before buying new cards. 2. Create a special column that says "Yes" if the lead already exists and "No" if it's new. 3. Use the "write to table" feature to only add leads marked as "No" (the new ones). This way, you'll save credits by not processing the same leads twice, and your table stays clean with no duplicates.
but i always want to uplaod new leads to the same table and same tab not atother one
To upload new leads to your table while automatically ignoring duplicates: 1. Use the "Lookup" feature to check if leads already exist in your table before adding new ones. 2. Set up a "Lookup Single Row in Other Table" or "Lookup Multiple Rows in Other Table" integration to identify existing records. 3. Create conditional runs using AI formulas that only process leads identified as new (not duplicates). 4. Use the "write to table" feature to only add the contacts that are confirmed as net new. This approach prevents duplicate data and saves credits by avoiding unnecessary enrichments of the same leads multiple times.
but lets say i have new list of leads where should i upload them
To upload new leads while avoiding duplicates in your existing table: 1. Upload your new leads to your current table. 2. Use the "Lookup" feature to check if these leads already exist in your table by comparing key fields like email or domain. 3. Create a column that flags duplicates (shows "Yes" for existing leads, "No" for new ones). 4. Use the "write to table" integration to only process the leads marked as new. This approach saves credits by preventing duplicate enrichments while keeping your data clean.