CRM Enrichment: How to Enrich Your HubSpot or Salesforce Data (Complete Guide)

Your CRM is supposed to be the backbone of your sales operation. But according to Gartner, B2B data decays at a rate of 25 to 30% per year — contacts change jobs, emails bounce, phone numbers go missing. The result? Your team is prospecting on incomplete, outdated information and wasting hours chasing bad data.

CRM enrichment is the fix. It means automatically completing your contact and account records in HubSpot, Salesforce, or Pipedrive with fresh, reliable data: verified emails, direct phone numbers, job titles, company size, tech stack, and more.

In this guide, you’ll learn exactly how to enrich your CRM data, which methods work best depending on your setup, and how to automate the whole process so your team always prospects with accurate information.

Enrich your CRM contacts directly in Google Sheets

Derrick completes your HubSpot and Salesforce records with verified emails, phone numbers, and LinkedIn data — no complex setup required.

Try for free →

Why your CRM data degrades (and what it actually costs you)

Before talking solutions, it’s worth understanding the scale of the problem. A neglected CRM isn’t just an operational headache — it’s a direct drag on revenue.

According to HubSpot, sales reps spend an average of 27% of their time on data entry and searching for missing information. That’s more than a quarter of the workday spent not selling, just compensating for bad data quality.

Here’s what happens to a CRM left without regular enrichment:

• Emails bounce because contacts have changed companies or addresses
• Calls go nowhere without direct dial numbers
• Outreach misses the mark because job titles are outdated
• Lead scoring becomes inaccurate when firmographic fields are empty
• Duplicate records distort reports and skew forecasts

Mike, a Sales Ops manager at a B2B SaaS company, put it plainly: “We had 12,000 contacts in HubSpot. After an audit, 40% had an invalid or missing email, and fewer than 20% had a phone number. Our reps were essentially prospecting blind.”

CRM enrichment is how you fix this at scale — systematically, not one contact at a time.

What is CRM enrichment? Definition and scope

CRM enrichment is the process of completing, correcting, and updating the information stored in your CRM with data pulled from external sources.

It operates at two levels:

1. Contact-level enrichment (individual)

• Verified professional email
• Direct or mobile phone number
• Current job title
• LinkedIn profile URL
• Geographic location
• Tenure in current role

2. Account-level enrichment (company)

• Company size (headcount)
• Industry and vertical
• Tech stack (technologies in use)
• Approximate revenue range
• Social media presence
• Web traffic and audience data

The distinction between enrichment and data cleaning matters: data cleaning removes or corrects what’s wrong, enrichment adds what’s missing. Both are necessary — but enrichment delivers the most immediate impact on prospecting outcomes.

3 methods to enrich your CRM data

There’s no single right approach to CRM enrichment. The best method depends on your data volume, budget, and technical resources.

Method 1: Native enrichment via CRM integrations

HubSpot and Salesforce both support native integrations with certain data providers. The idea: connect your CRM to a data vendor that automatically completes records in real time as new contacts are added.

Upside: Real-time, zero-friction enrichment. Downside: These integrations are often expensive, gated behind Enterprise plans, and limited to specific data sources.

Method 2: Batch enrichment via export/import

The most universal and flexible approach: export your contacts from the CRM as a CSV, enrich them with a dedicated tool, then re-import the completed data.

This is the workflow Derrick is built for: your HubSpot or Salesforce contacts land in Google Sheets, Derrick enriches them with verified emails, phone numbers, and LinkedIn data, then you re-import the updated file into your CRM.

Upside: Full control over the data, works with any CRM, predictable cost. Downside: Requires a manual step at each enrichment cycle.

Method 3: Automated enrichment via Zapier, Make, or n8n

The most advanced approach: build an automated workflow that detects each new contact added to your CRM and triggers real-time enrichment via an API or connected tool.

Upside: Zero friction once the workflow is live, enrichment happens instantly. Downside: Requires initial setup and some comfort with no-code automation tools.

Let’s walk through each method in practice.

How to enrich HubSpot contacts: step-by-step

Step 1: Export your contacts from HubSpot

In HubSpot, go to Contacts > Contacts. Apply filters to isolate the segment you want to enrich (e.g., contacts with no email, or no phone number). Click Actions > Export. Choose CSV format and select the properties you want to include.

You’ll get a CSV with your raw contact data.

Expected result: A clean CSV file with columns for first name, last name, company, domain, and LinkedIn URL where available.

Step 2: Import into Google Sheets and run enrichment with Derrick

Open your file in Google Sheets. Install Derrick from the Google Workspace Marketplace. From the Derrick menu, select the function that matches your available data:

• You have name + domain → Lead Email Finder
• You have a LinkedIn URL → LinkedIn Profile Scraper (retrieves email, phone, job title, company)
• You have existing emails → Email Verifier to validate what you already have

Derrick automatically fills in the missing columns for each contact.

Expected result: Your 500 contacts go from 30% completion to 70–85%, with verified emails and direct phone numbers.

Step 3: Clean and normalize your enriched data

Before re-importing, spend 5 minutes normalizing your data. Derrick includes a Data Normalization feature that automatically cleans formats (name extraction, inconsistency detection) and a Remove Duplicates function to eliminate redundant records.

Expected result: A clean, consistent file ready for import — no duplicates, no formatting issues.

Step 4: Re-import into HubSpot

In HubSpot, go to Contacts > Import. Select your enriched file. Map columns to the corresponding HubSpot properties. Enable the Update existing contacts option to avoid creating duplicates.

Expected result: Your HubSpot contact records are updated with fresh enriched data.

How to enrich Salesforce contacts

The workflow is essentially the same, with a few Salesforce-specific steps.

In Salesforce, go to Contacts or Leads > List View. Create a filtered view (e.g., contacts without an email or phone). Click Export — if this isn’t available in your edition, use Reports to extract the data instead.

Once the file is enriched with Derrick in Google Sheets, re-import via Setup > Data Import Wizard or Salesforce’s native import tool. Map fields carefully to avoid overwriting existing data with blank values.

Pro tip: Test with a sample of 50 contacts first to validate your field mapping before running a full import.

Automating CRM enrichment with Zapier or Make

To eliminate manual steps entirely, you can build an automated enrichment workflow. Here’s the general logic:

Trigger: A new contact is created in HubSpot (or Salesforce).

Action 1: The contact is sent to Google Sheets via Zapier or Make.

Action 2: Derrick automatically enriches the contact (via its API or integrations).

Action 3: The enriched data is sent back to HubSpot/Salesforce to update the record.

This type of workflow is especially valuable for teams that receive new leads regularly through web forms, events, or recurring CSV imports.

Emma, a Growth Manager at a lead gen agency, set this up last quarter: “Every new lead that enters HubSpot is fully enriched within 2 minutes. My SDRs get complete records from the first touchpoint — no more dead ends.”

Which data to enrich first, based on your goal

Not all fields are equally valuable. Here’s how to prioritize based on your use case:

Focusing enrichment on the fields that matter most for your workflow helps you get the most out of your credit budget and keeps the process lean.

Best practices for sustainable CRM enrichment

1. Enrich by segment, not all at once

Rather than enriching your entire database in one go, prioritize by business impact: target accounts for the quarter, inbound leads from the past 30 days, active pipeline contacts. This keeps quality high where it matters most.

2. Schedule regular enrichment cycles

Given the 30% annual decay rate (roughly 2.5% per month), plan a minimum quarterly enrichment cycle. Teams with high outbound volume typically run monthly enrichment on active contacts.

3. Always verify emails before sending

Even if an email was enriched three months ago, verify it before any outreach campaign. Derrick’s Email Verifier validates deliverability in real time, keeping your hard bounce rate well below the 2% threshold that triggers sender reputation issues.

4. Handle data conflicts carefully

When re-importing into your CRM, pay close attention to merge rules: don’t overwrite a manually entered field with an automatically enriched value that may be less accurate. General rule: data entered by a rep takes precedence over automatically enriched data.

5. Track your data source

Add a custom property in your CRM to log the enrichment source and date for each record. This makes audits easier and lets you measure data freshness over time.

CRM enrichment and GDPR: what you need to know

Enriching professional contact data raises legitimate compliance questions. Here are the key points.

What’s allowed: Enriching B2B contact data for sales prospecting purposes is permitted under the legitimate interest legal basis, provided the outreach is relevant to the contact’s professional role.

What’s required:

• Inform contacts that their data is being processed (include a disclosure in your outreach emails)
• Honor opt-out requests promptly
• Limit data retention to what’s necessary for your stated purpose

What’s not allowed: Using enriched professional data for purposes unrelated to the contact’s professional context, or combining it with sensitive personal data.

For UK-based teams, the ICO provides specific guidance on B2B marketing that’s worth reviewing. US-based teams should also be aware of applicable state-level regulations where they apply.

Common CRM enrichment mistakes (and how to avoid them)

Problem 1: Enriching before cleaning

Impact: You enrich duplicate records, merged contacts, or corrupted entries — leaving your database harder to manage after enrichment than before.

Solution: Always run deduplication and normalization before enriching. Derrick’s Remove Duplicates and Data Normalization features are designed to run upstream of the enrichment process.

Problem 2: Overwriting correct data

Impact: A rep manually entered the direct dial for a key account. The automated enrichment replaces it with a main switchboard number. The relationship takes a hit.

Solution: Configure your CRM import in “fill empty fields only” mode — never “replace all.”

Problem 3: Enriching contacts that are too old

Impact: You enrich contacts who left their company 18 months ago. You retrieve their former work emails — syntactically valid, but functionally useless.

Solution: Apply a recency filter. Only enrich contacts created or modified within the past 12 months, or those with a recent interaction logged.

Problem 4: Ignoring match rate

Impact: You run enrichment on 10,000 contacts and Derrick finds data for 6,000. You assume the remaining 4,000 are fine — but they simply have insufficient source data to match against.

Solution: Review match rate after every enrichment run. For unmatched contacts, investigate the root cause (missing LinkedIn URL, incorrect domain) rather than assuming the record is complete.

Key takeaways

• B2B data decays at 25–30% per year — without regular enrichment, your CRM becomes unreliable fast
• CRM enrichment covers two levels: contacts (email, phone, title) and accounts (size, industry, tech stack)
• The most flexible method: export from CRM → enrich in Google Sheets with Derrick → re-import
• Always enrich in “fill empty fields” mode to avoid overwriting manually entered data
• GDPR compliance is achievable for B2B enrichment under the legitimate interest basis, with proper disclosure and opt-out handling
• Plan a quarterly enrichment cycle at minimum — monthly for high-volume outbound teams

Conclusion: where to start with CRM enrichment

CRM enrichment isn’t a one-time project — it’s an ongoing process that should be baked into your sales operations. The good news: you don’t need a complex infrastructure to get started.

The simplest path today: export your HubSpot or Salesforce contacts, enrich them in Google Sheets with Derrick, and re-import. You can start on a free plan, test on a priority segment, and expand from there.

Once you’ve validated the workflow, automate it via Zapier or Make so every new incoming lead gets enriched automatically — no manual steps, no delays.

The outcome: your reps prospect on reliable data, your emails land instead of bounce, and your CRM finally reflects the reality of your market.

Start enriching your CRM contacts for free

Install Derrick on Google Sheets and complete your HubSpot or Salesforce records in minutes.

Try for free →

FAQ

How long does it take to enrich a CRM database of 5,000 contacts? With a tool like Derrick, batch enrichment of 5,000 contacts typically takes 30 minutes to 2 hours, depending on the source data available (LinkedIn URL, domain, existing email). The export and re-import into HubSpot or Salesforce adds another 15–30 minutes.

Does CRM enrichment work if I only have a name and company? Yes, but with a lower match rate. The best starting points are a LinkedIn URL or a company domain. With just a name and company, Derrick can use the LinkedIn Profile Finder to locate the right profile, then enrich from there.

What’s the difference between CRM enrichment and CRM sync? CRM enrichment means adding missing data from external sources (LinkedIn, web databases). CRM sync is real-time data synchronization between two tools (e.g., HubSpot and Salesforce). They’re distinct processes — and both can be part of a healthy data stack.

Is CRM data enrichment GDPR-compliant? Yes, when handled correctly. B2B prospecting is permitted under the legitimate interest legal basis, as long as you inform contacts how their data is used and respect opt-out requests. The ICO (UK) and individual EU supervisory authorities provide specific guidance on B2B marketing compliance.

Can I automate enrichment for every new contact that enters my CRM? Yes. Derrick integrates with Zapier, Make, and n8n. You can build a workflow that automatically triggers enrichment the moment a new contact is created in HubSpot or Salesforce, updating the record within minutes.