Limit Email Sends to Three HR Contacts per Company Using Apollo | Clay

Limit Email Sends to Three HR Contacts per Company Using Apollo

Hi, I've scraped the HR contacts of a list of companies using Apollo. As a result, I now have more than 3 HR contacts per company. However, I'd like to limit email sending to only 3 people per company. How can I do that?

2 comments

Channeled
APP
·
·
To limit email sending to only 3 HR contacts per company after scraping more than 3 contacts using Apollo, you can follow these steps: 1. Use Apollo's "Find People at Company By Job Title" function to search for HR contacts at each company. 2. Use the "write to table" feature in Clay to extract all the results into a new table. 3. In the new table, use the "Enrich Person From Apollo" function to get complete contact information, including email addresses. 4. Finally, use Clay's table features to filter or limit the results to only 3 HR contacts per company. You can do this by grouping by company and selecting the top 3 contacts for each. This approach allows you to gather all contacts first, then narrow down to your desired limit for email sending.
Sources: Apollo.io integration overview | Documentation | Clay University Find People at Company By Job Title with Apollo.io [FAQ: Why am I seeing email_not_unlocked@domain.com in Apollo?](https://docs.clay.com/en/articles/9757360-faq-why-am-i-seeing-email%5Fnot%5Funlocked-domain-com-in-apollo)
Smit V.
·
·
Hi Alexandre, Thanks for reaching out! I’d be happy to help with this. While there’s no built-in one-click solution, here’s a workaround that should do the trick: 1. Create a formula column to generate a unique random number for each row. 2. Use a Lookup to find all rows in your table that match the company domain. 3. Add another formula column to number the entries (1, 2, 3, etc.) for each company. 4. Set up conditional logic when sending data to your email sequencer or for when running further enrichments on those 3 people, to only run for entries numbered 1, 2, or 3. This ensures a maximum of 3 leads per company. I know this sounds a bit involved, so here's a quick walkthrough video to guide you through the first three steps! Let me know if you’d like me to clarify anything :)