Find and Enrich Leads from LinkedIn

This tutorial walks through building a table that takes LinkedIn profile URLs and returns enriched contact data including work email, phone number, job title, and company details.

Before you begin

• You need a LinkedIn profile URL column in your table. You can source these from Apify LinkedIn scrapers or import a CSV.
• Connect these integrations in Settings > Integrations before starting:
  • BetterEnrich (for email and phone)
  • Apollo (optional, as a fallback email source)

What you will build

A table with these columns:

Step 1: Start your table

1. Click New Table from the dashboard.
2. Name it LinkedIn Lead Enrichment.
3. Import your LinkedIn URL list as a CSV or paste URLs directly into the first column.
4. Name the first column LinkedIn URL.

Step 2: Add contact data enrichment

1. Click Add Column.
2. Select Action Column.
3. Search for and select Enrich Contact (B2B Enrichment).
4. Map the LinkedIn URL column to the LinkedIn Profile URL input.
5. Select these output fields: First Name, Last Name, Current Job Title, Current Company Name, Location Country, Open to Work.
6. Click Save.

This action costs 2 credits per row.

Step 3: Add work email finding

1. Click Add Column.
2. Select Action Column.
3. Search for and select Find Work Email by LinkedIn URL (BetterEnrich).
4. Map the LinkedIn URL column to the LinkedIn Profile URL input.
5. Select Email as the output field.
6. Click Save.

This action costs 2 credits per row.

Step 4: Add mobile number finding

1. Click Add Column.
2. Select Action Column.
3. Search for and select Find Mobile Number by LinkedIn URL (BetterEnrich).
4. Map the LinkedIn URL column to the LinkedIn Profile URL input.
5. Select Phone Number as the output field.
6. Click Save.

This action costs 10 credits per row.

Step 5: Add an email fallback

Some contacts will not have a BetterEnrich email. Add Apollo as a fallback source.

1. Click Add Column.
2. Select Action Column.
3. Search for and select Find Email using LinkedIn URL (Apollo).
4. Map the LinkedIn URL column to the LinkedIn URL input.
5. Select Email as the output.
6. Click Save.

This action costs 2 credits per row.

To use the Apollo result only when BetterEnrich failed, add a formula column:

IF(work_email != "", work_email, apollo_email)

Name this column Final Email.

Step 6: Run the table

1. Click Run All Rows in the toolbar.
2. Monitor the progress bar.
3. When complete, review the results.

Filter the table to show only rows where Final Email is not empty. These are your enriched and contactable leads.

Expected results

For a list of 100 LinkedIn URLs:

• Profile data (Job Title, Company): typically 85-95% fill rate
• Work email (BetterEnrich): varies by list quality, typically 40-70%
• Mobile (BetterEnrich): typically 20-50%
• Combined email reach (BetterEnrich + Apollo): typically 60-80%

Troubleshooting

LinkedIn URLs are returning no data. Verify the URLs are full profile URLs starting with https://linkedin.com/in/. URLs with /pub/ format or company page URLs will not work with contact enrichment actions.

Email hit rate is low. BetterEnrich coverage varies by job function and geography. Tech roles and North American contacts tend to have higher coverage. For lower coverage segments, add FullEnrich or Prospeo as additional fallback columns.

Mobile columns are mostly empty. Mobile number availability is generally lower than email. Mobile numbers are most commonly found for senior executives and sales-facing roles. For other roles, focus on work email for outreach.