.png){kind=logo}
Finding People Using Apollo with Clay and Excluding Lists
Hello Team, I'm trying to find people using Apollo with Clay, and any way I can exclude different lists (our past clients and our block list)
The way i'm thinking right now is adding the 2 list as 2 seperate columns, and have a run condition be: only run if not contain domain from /blocklist and /pastclients
also anyway to change the store leads filter at the start of the table as the source? or would you have to do a whole new table?
The best way to exclude certain leads if you already have a list of the ones you don't wish to include is by creating a separate clay table/google sheet containing those leads and running the Lookup Record function to find matches between your work table and your "do not contact" list. I'm attaching a helpful video for implementing that here: https://www.loom.com/share/80d613c10d5248f6bfc662cc95c8023d
And here's further insight on the Lookup Record function: https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=0194f8b1-d773-4aaf-a40b-dbb34c279656
Unfortunately you can't "rerun" your original search but it is possible to run another store leads search within the same table by navigating to 'Import' in the bottom left corner and then choosing which search you would like to run (which can be the store leads one) and it will check for duplicates on your table before adding the new finds onto the same table
8c6ff6d4-cb1d-449f-97a0-f6ade4bc5088.png(382 kB)