Find a work email for every new lead in Airtable

Every 15 minutes, finds a work email for each new lead in your Airtable table, trying Apollo then Hunter, and writes it on the row.

EZEric Zeng · 1 workflow · Updated Nov 13, 2026

UsesAirtableApolloHunter

Find a work email for every new lead in Airtable

Run every 15 minutes.Run every 15 minutes.

Set baseId to blank.Set baseId to blank.

Set tableName to Leads.Set tableName to Leads.

Set minScore to 90.Set minScore to 90.

AirtableList records in tableName. Save it as leadsResult.List records in tableName. Save it as leadsResult.

Set records to leadsResult.records.Set records to leadsResult.records.

For each record in records:For each record in records:

Set recStatus to record.fields["Enrichment Status"].Set recStatus to record.fields["Enrichment Status"].

If recStatus is not enriched and recStatus is not needs_reviewIf recStatus is not enriched and recStatus is not needs_review

Yes

Set recId to record.id.Set recId to record.id.

Set firstName to record.fields["First Name"].Set firstName to record.fields["First Name"].

Set lastName to record.fields["Last Name"].Set lastName to record.fields["Last Name"].

Set companyName to record.fields.Company.Set companyName to record.fields.Company.

Set companyDomain to record.fields.Domain.Set companyDomain to record.fields.Domain.

Set resolvedEmail to blank.Set resolvedEmail to blank.

Set emailStatus to not_found.Set emailStatus to not_found.

Set emailSource to none.Set emailSource to none.

Set apollo to an empty record.Set apollo to an empty record.

If firstName is yes and lastName is yes and companyDomain is yesIf firstName is yes and lastName is yes and companyDomain is yes

Yes

ApolloEnrich person firstName lastName. Save it as apollo.Enrich person firstName lastName. Save it as apollo.

Set apolloEmail to apollo.person.email.Set apolloEmail to apollo.person.email.

Set apolloStatus to apollo.person.email_status.Set apolloStatus to apollo.person.email_status.

If apolloEmail isn't blank and apolloEmail is not email_not_unlocked@domain.com…If apolloEmail isn't blank and apolloEmail is not email_not_unlocked@domain.com…

Yes

Change resolvedEmail to apolloEmail.Change resolvedEmail to apolloEmail.

Change emailStatus to apolloStatus.Change emailStatus to apolloStatus.

Change emailSource to apollo.Change emailSource to apollo.

No steps

If resolvedEmail is blankIf resolvedEmail is blank

Yes

HunterFind companyDomain lastNames email at firstName. Save it as hunter.Find companyDomain lastNames email at firstName. Save it as hunter.

Set hunterEmail to hunter.email.Set hunterEmail to hunter.email.

Set hunterScore to hunter.score.Set hunterScore to hunter.score.

Set hunterAcceptAll to hunter.accept_all.Set hunterAcceptAll to hunter.accept_all.

If hunterEmail isn't blank and hunterScore is greater than or equal to minScore…If hunterEmail isn't blank and hunterScore is greater than or equal to minScore…

Yes

Change resolvedEmail to hunterEmail.Change resolvedEmail to hunterEmail.

Change emailStatus to valid.Change emailStatus to valid.

Change emailSource to hunter.Change emailSource to hunter.

No steps

Change emailStatus to missing_input.Change emailStatus to missing_input.

Set finalStatus to needs_review.Set finalStatus to needs_review.

If resolvedEmail isn't blankIf resolvedEmail isn't blank

Yes

Change finalStatus to enriched.Change finalStatus to enriched.

No steps

Use resolvedEmail, or record.fields.Email if it is empty and save it as email.Use resolvedEmail, or record.fields.Email if it is empty and save it as email.

Use apollo.person.title, or record.fields.Title if it is empty and save it as title.Use apollo.person.title, or record.fields.Title if it is empty and save it as title.

Use apollo.person.seniority, or record.fields.Seniority if it is empty and save it as seniority.Use apollo.person.seniority, or record.fields.Seniority if it is empty and save it as seniority.

Use apollo.person.linkedin_url, or record.fields.LinkedIn if it is empty and save it as linkedin.Use apollo.person.linkedin_url, or record.fields.LinkedIn if it is empty and save it as linkedin.

Use apollo.person.organization.industry, or record.fields.Industry if it is empty and save it as industry.Use apollo.person.organization.industry, or record.fields.Industry if it is empty and save it as industry.

Use apollo.person.organization.estimated_num_employees, or record.fields.Employees if it is empty and save it as employees.Use apollo.person.organization.estimated_num_employees, or record.fields.Employees if it is empty and save it as employees.

AirtableUpdate recId in tableName.Update recId in tableName.

Wait for 2 seconds.Wait for 2 seconds.

No steps