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

Matthew R. · 2025-02-21T21:38:57.922598+00:00

2 questions: 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. 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?

Matthew R.

2 questions:

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.
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