Hey Guys,
We’re a lead generation company using Clay to enrich company data from Google Maps. For each company, we try to find up to three valid emails of people with titles like Owner, CEO, or Director.
Here’s the issue:
I want to automatically stop enrichment once three valid emails are found. But I can’t find a way to count the total number of valid emails per company. Clay seems to only allow lookups across rows, not within a whole table or columns.
I tried two approaches:
- 1.
Sending each person (Names) to a second table (each with a different row) for email enrichment — but then I can’t count valid emails per company as Clay only seems to count in rows.
- 2.
Keeping all enrichments (per company) in one row — which would solve it, but Clay’s 40-column limit blocks further enrichment.
Is there a recommended way to count valid emails per company or trigger enrichments conditionally based on that count?
