# 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:

| Column | Type | What it does |
|--------|------|-------------|
| LinkedIn URL | Data | Starting input |
| Profile Data | Action | Enrich Contact (B2B Enrichment) |
| Work Email | Action | Find Work Email by LinkedIn URL (BetterEnrich) |
| Mobile Number | Action | Find Mobile Number by LinkedIn URL (BetterEnrich) |
| Email Fallback | Action | Find Email using LinkedIn URL (Apollo) |

---

## 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.