Finds a work email for each new lead in your Airtable table, trying Prospeo then Hunter, and writes it onto the row.
Uses
Airtable
Hunter
Prospeo
Find work emails for new Airtable leads with Prospeo and Hunter
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_reviewYes
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 title to record.fields.Title.Set title to record.fields.Title.Set linkedin to record.fields.LinkedIn.Set linkedin to record.fields.LinkedIn.If firstName is yes and lastName is yes and companyDomain is yesIf firstName is yes and lastName is yes and companyDomain is yesYes
ProspeoEnrich a person. Save it as prospeo.Enrich a person. Save it as prospeo.Set prospeoFound to prospeo.found.Set prospeoFound to prospeo.found.Set prospeoEmail to prospeo.email.Set prospeoEmail to prospeo.email.Set prospeoStatus to prospeo.email_status.Set prospeoStatus to prospeo.email_status.If prospeoFound is yes and prospeoEmail isn't blank and prospeoStatus is…If prospeoFound is yes and prospeoEmail isn't blank and prospeoStatus is…Yes
Change resolvedEmail to prospeoEmail.Change resolvedEmail to prospeoEmail.Change emailStatus to prospeoStatus.Change emailStatus to prospeoStatus.Change emailSource to prospeo.Change emailSource to prospeo.
Use prospeo.job_title, or title if it is empty and save it as title.Use prospeo.job_title, or title if it is empty and save it as title.Use prospeo.linkedin_url, or linkedin if it is empty and save it as linkedin.Use prospeo.linkedin_url, or linkedin if it is empty and save it as linkedin.No
No steps
If resolvedEmail is blankIf resolvedEmail is blankYes
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
No steps
No
No steps
No
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 blankYes
Change finalStatus to enriched.Change finalStatus to enriched.No
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.AirtableUpdate recId in tableName.Update recId in tableName.
Wait for 2 seconds.Wait for 2 seconds.No
No steps