Home Use-Case Tutorials Enrich a CRM Export with Missing Contact Details

Enrich a CRM Export with Missing Contact Details

Last updated on Apr 06, 2026

Enrich a CRM Export with Missing Contact Details

This tutorial shows how to take a CRM export with incomplete contact records and fill in missing fields: job title, company, email, phone, and LinkedIn URL.

Before you begin

  • Export your contacts from your CRM as a CSV. Include all fields, even empty ones.
  • Connect these integrations in Settings > Integrations:
    • BetterEnrich (for LinkedIn-based enrichment)
    • Snov.io (for email-to-profile enrichment)
    • Apollo (for name + domain email finding)

What you will build

The strategy adapts based on what data each contact already has:

  • If you have a LinkedIn URL: use it for full profile and email enrichment.
  • If you have an Email but no LinkedIn URL: use Snov.io to get profile data, then use the LinkedIn URL Snov.io returns for further enrichment.
  • If you have Name + Company/Domain only: use Apollo or Hunter.io to find a work email by name and domain.

You will build one table with conditional columns that route each contact through the right path.

Step 1: Import your CRM export

  1. Click New Table and name it CRM Re-Enrichment.
  2. Click Import CSV.
  3. Upload your CRM export CSV.
  4. Map the columns. At minimum, ensure you have: First Name, Last Name, Email, Company Name, LinkedIn URL (even if mostly empty).

Step 2: Add LinkedIn-based profile enrichment

For contacts that already have a LinkedIn URL, enrich their profile data first.

  1. Click Add Column and select Action Column.
  2. Select Enrich Contact (B2B Enrichment).
  3. Map the LinkedIn URL column to the LinkedIn Profile URL input.
  4. Select outputs: Current Job Title, Current Company Name, Location Country, Current Company Domain.
  5. Click Save.

This column will return data only for rows where the LinkedIn URL is present. Rows without a LinkedIn URL will show empty output.

Step 3: Add email-to-profile enrichment for contacts with email only

For contacts that have an email address but no LinkedIn URL:

  1. Click Add Column and select Action Column.
  2. Select Enrich Contact (Snov.io).
  3. Map the Email column to the Email input.
  4. Select outputs: LinkedIn URL, Current Position, Current Company, Industry.
  5. Click Save.

This gives you a LinkedIn URL for contacts that previously had none. You can then use the returned LinkedIn URL in Step 2's action.

Step 4: Add email finding for contacts with name + domain only

For contacts with no email and no LinkedIn URL - just a name and company:

  1. Add a formula column to extract or format the company domain:
    • If you have a website column: EXTRACT_DOMAIN(website_column)
    • If you only have company name: you will need to manually find the domain or use SerpApi to find it.
  2. Click Add Column and select Action Column.
  3. Select Find Email using Name and Domain (Apollo).
  4. Map First Name, Last Name, and Domain to the inputs.
  5. Select Email as output.
  6. Click Save.

This action costs 2 credits per row.

Step 5: Build a merged columns formula

After enrichment, some fields may now come from multiple sources. Use formulas to consolidate:

For the email field:

IF(original_email != "", original_email, IF(snov_email != "", snov_email, apollo_email))

For the job title field:

IF(original_job_title != "", original_job_title, b2b_enrichment_job_title)

For the LinkedIn URL field:

IF(original_linkedin != "", original_linkedin, snov_linkedin_url)

Name each merged column with a Final_ prefix, e.g. Final_Email, Final_Job_Title.

Step 6: Run and export

  1. Click Run All Rows.
  2. After completion, filter to review enrichment coverage.
  3. Export as CSV and re-import into your CRM using your CRM's import or update tool.

Expected results

For a typical CRM export of 500 contacts with 30-40% missing data:

  • Email fill rate improves by 15-25% from the multi-source approach
  • Job title fill rate improves by 30-50% using B2B Enrichment
  • LinkedIn URL fill rate depends heavily on how well-known the contacts are

Troubleshooting

Snov.io returns data for some contacts but the LinkedIn URL field is empty. Not all Snov.io profiles include a LinkedIn URL. The field is populated only when Snov.io has observed the email-to-LinkedIn connection. Use BetterEnrich's LinkedIn URL finder as an additional step for contacts where Snov.io did not return a LinkedIn URL.

B2B Enrichment returns an outdated job title. Enrichment reflects the data available. If a contact recently changed jobs, the LinkedIn-sourced data may lag. Check the final result against the LinkedIn profile manually for high-value contacts.

Formula columns show errors after consolidation. Check that column names in your formula exactly match the column names in your table. Column names are case-sensitive in formulas. Use the column name as it appears in the table header.