How can I find companies in the netherlands from a particular province with more than 25 employees?
I have no table yet
I do have a lead list of 2k scraped from apollo, which I have imported to lay
it is important to not find the same contacts we already scraped from apollo in order to save clay credits
after that , we want to scrape the particular executives and directors
Hi Angelo D., thanks for reaching out. For your requests, here are some steps I would follow: 1. Establish your list of companies using 'Find Local Businesses using Google Maps' (this is free of credits): https://www.clay.com/learn/scrape-google-maps2. Use the employee count enrichment to filter out companies with less than 25 employees. 3. Use the Lookup Record in Other Table enrichment to crosscheck the companies with those in your Apollo list and delete the ones that exist in both. Tutorial: https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=0194f8b1-d773-4aaf-a40b-dbb34c2796564. After these steps, you can use the 'Find People' enrichment to find a ton of information about employees at those companies (including executives and directors). Tutorial: https://www.clay.com/learn/find-multiple-people-at-a-company-with-clayHope this helps:)