Clay Icon
Join the Community
02 Support

De-duplication and Value Check in Integrations: Your Questions Answered

Avatar of Matthew R.Matthew R.
·
·

2 questions:

  1. 1.

    Is there a way to de-dupe on the fly when adding rows? If I use the YouTube "add row" integration, it limits me to 300 rows. When I run a 2nd time, I want to make sure only new rows get added.

  2. 2.

    Is there a way to check an API / Spreadsheet (either Clay or Google Sheet) to see if a value is present before running a column? For example, if I have an exclusion list of emails I don't want to email again (i.e. because I've reached out recently via a different non-clay integration), how would I do that?

3 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, we have solutions for both of your questions: 1. To de-duplicate rows when adding them, you can use our Auto-dedupe feature. Enable it by clicking the Auto-dedupe icon at the bottom right of your table, then select "Enable automatic deduplication" and choose the column to dedupe on. 2. To check if a value exists before running a column, you can use our "Lookup, Add, or Update Row with Google Sheets" action. This allows you to search for a specific row in a Google Sheet using a column and value. If no match is found, you can add a new row, or update an existing one if a match exists. These features should help you manage duplicates and check for existing values efficiently.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Did that answer your question?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Matthew R.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: