How to Build a Data Enrichment Dashboard in Google Sheets (Step-by-Step)

You’re enriching leads in Google Sheets, but you can’t tell at a glance how many contacts actually have a valid email, a phone number, or a complete LinkedIn profile? Without visibility into your data quality, you’re running your prospecting blind.

A data enrichment dashboard solves exactly that. It turns your spreadsheet into a visual command center: completion rates per attribute, real-time quality indicators, alerts for missing data. The result? You know immediately which leads are ready to contact — and which ones still need more enrichment work.

In this guide, you’ll learn how to build a complete B2B enrichment dashboard in Google Sheets from scratch, no technical skills required.

Enrich your leads directly in Google Sheets

Derrick finds emails, phone numbers and LinkedIn data for your prospects in a few clicks, right inside your spreadsheet.

Try for free →

What you’ll learn (and the expected results)

• Structure a Google Sheet optimized for B2B data enrichment
• Automatically calculate completion rates per attribute (email, phone, LinkedIn…)
• Build visual indicators and charts — no code needed
• Automate data enrichment with Derrick to feed your dashboard
• Monitor your data quality over time

Estimated time: 45 to 60 minutes for a first working version.

Prerequisites

Before you start, make sure you have:

• A Google Sheets account (free)
• A B2B contact list with at least 50–100 rows (CRM export, LinkedIn, Sales Navigator…)
• Basic columns already filled in: first name, last name, company, job title
• Optional but recommended: Derrick App installed to automate enrichment

Step 1: Structure your Google Sheet with the right columns

The quality of your enrichment dashboard depends directly on your file structure. A poorly organized spreadsheet makes analysis impossible — let’s start with a solid foundation.

The essential columns

Create a tab named “Leads” and add the following columns in this order:

Creating the “Enrichment status” column with data validation

This column is the backbone of your dashboard. It summarizes the enrichment state of each contact in a single field.

To create a dropdown: select the column → Data menu → Data validation → choose “List of items” → enter: Enriched,Partial,To enrich.

Expected result: Your “Leads” tab is structured with all columns, and the “Status” column shows a dropdown for each contact.

With the structure in place, you can move on to automatically calculating your data quality indicators.

Step 2: Calculate your enrichment KPIs with formulas

This is where Google Sheets really earns its keep. A few simple formulas are enough to calculate your data enrichment completion rates in real time.

Create a dedicated “Dashboard” tab

Create a new tab named “Dashboard”. This is where you’ll build your monitoring view, separate from your raw data.

The 5 KPI formulas you need

1. Total number of leads

=COUNTA(Leads!A2:A)

This counts all non-empty rows in your First name column — your total contact count.

2. Email completion rate

=COUNTIF(Leads!F2:F,"?*")/COUNTA(Leads!A2:A)

COUNTIF with the "?*" criterion counts cells containing at least one character. Divided by the total, you get the percentage of leads with an email. Apply the “%” format to the cell to display it correctly.

3. Phone completion rate

=COUNTIF(Leads!G2:G,"?*")/COUNTA(Leads!A2:A)

Same logic applied to the phone column.

4. LinkedIn completion rate

=COUNTIF(Leads!E2:E,"*linkedin*")/COUNTA(Leads!A2:A)

This checks that the cell actually contains “linkedin” — a simple way to confirm a real URL is present rather than a placeholder.

5. Lead count by enrichment status

=COUNTIF(Leads!K2:K,"Enriched")
=COUNTIF(Leads!K2:K,"Partial")
=COUNTIF(Leads!K2:K,"To enrich")

Expected result: Your Dashboard tab now displays percentages and counts that update automatically whenever a lead is modified in the Leads tab.

These indicators form the core of your dashboard. Let’s now make them visually actionable.

Step 3: Create visual indicators and charts

Numbers alone aren’t enough. The real value of a data enrichment dashboard is instant readability. Here’s how to make your data speak for itself in a few minutes.

Conditional formatting on lead status

In the Leads tab, select the “Enrichment status” column → Format → Conditional formatting.

Add 3 rules:

• “Enriched” → green background (#b7e1cd)
• “Partial” → orange background (#fce8b2)
• “To enrich” → red background (#f4c7c3)

At a glance, you can see exactly which contacts are ready for outreach and which still need enrichment work.

Build a KPI table with alert indicators

In your Dashboard tab, create this summary table:

The =IF() formula automatically shows ✅ when a target is hit, or ⚠️ when there’s still work to do.

Create a status breakdown chart

Select your status distribution data (the 3 statuses with their counts) → Insert → Chart → choose a Donut chart.

Set the colors to match your conditional formatting: green for “Enriched”, orange for “Partial”, red for “To enrich”. This chart becomes the centerpiece of your dashboard.

Expected result: Your dashboard shows a color-coded donut chart, a KPI table with alert indicators, and your Leads tab rows are colored by status.

With the visual framework ready, it’s time to feed the dashboard with actual enriched data.

Step 4: Automate data enrichment with Derrick

An empty dashboard is useless. The real challenge is enriching your leads fast enough to push your completion rates toward their targets. That’s where a native Google Sheets tool like Derrick makes the difference.

Why automate B2B data enrichment in Google Sheets?

Manually enriching 500 leads takes an average of 20 to 30 hours of research. With an automated enrichment tool, the same work takes minutes. According to HubSpot, sales teams lose 27% of their time on data management tasks that could be automated — that’s more than a full workday per week.

Derrick runs directly inside Google Sheets — no export, no CSV to import manually. You start from your existing data and the tool fills in the missing columns one by one.

The 4 Derrick workflows that feed your dashboard

To find professional emails: The Lead Email Finder searches for professional emails using first name, last name, and company domain. Results land directly in your “Professional email” column with real-time validation. Your email completion rate updates instantly in the dashboard.

To find phone numbers: The Phone Finder retrieves phone numbers from LinkedIn profile URLs. Within seconds, your phone column starts filling up — and that ⚠️ indicator can flip to ✅.

To enrich LinkedIn profiles: The LinkedIn Profile Scraper completes 50+ attributes from a LinkedIn URL: current role, company, industry, team size, location. It feeds multiple dashboard columns in a single operation.

To verify email validity: The Email Verifier validates each email address in real time to reduce bounce rates. Add a “Valid email (Y/N)” column to your dashboard to distinguish emails that are present from emails that are actually active.

Automatically update enrichment status after running Derrick

Once your columns are enriched, automate the “Enrichment status” update with this formula (placed in each row of the status column):

=IF(AND(F2<>"",G2<>""),"Enriched",IF(OR(F2<>"",G2<>""),"Partial","To enrich"))

The logic: if email AND phone are filled → “Enriched”. If only one of the two → “Partial”. Neither → “To enrich”. Your dashboard then recalculates automatically with every enrichment run.

Expected result: After a first enrichment pass with Derrick, your donut chart shows a growing share of “Enriched” contacts. On a fresh LinkedIn export, email completion rates typically reach 70–80%.

Step 5: Monitor and maintain your dashboard over time

An enrichment dashboard is only useful if it stays current. Here’s how to turn it into a lasting operational tool rather than a one-time snapshot.

Set data quality targets per attribute

Before launching any outbound campaign, establish minimum quality thresholds:

When an attribute drops below its threshold, that’s your signal to run another enrichment batch on the affected contacts.

Add a “History” tab to track trends

Create a third tab named “History” with these columns: Date, Total leads, Email rate, Phone rate, LinkedIn rate, Full enrichment rate.

Each week, manually paste the values (not the formulas) from your dashboard. This lets you track data quality trends over time and spot degradation — for example, if a data source starts returning fewer results.

For advanced teams: connect Derrick to your CRM

For teams using a CRM like HubSpot, Salesforce, or Pipedrive, Derrick integrates with Zapier, Make, and n8n to automatically sync enriched data. Your Google Sheets dashboard becomes a live mirror of your CRM pipeline quality.

Expected result: A History tab that tracks your weekly KPI trends, and immediate visual alerts whenever a metric drops below its target.

The final result: your enrichment dashboard in action

Here’s what you’ve built in under an hour:

“Leads” tab: your contact database with all enrichment columns and color-coded statuses (green/orange/red) automatically updated by formula.

“Dashboard” tab: a KPI table with completion rates per attribute, a donut chart showing status distribution, and ✅/⚠️ indicators benchmarked against your targets.

“History” tab: a weekly record of your B2B data quality trends over time.

In practice, an SDR prospecting 200 leads per month can use this system to see in 30 seconds how many contacts are ready to reach out to — and how many still need enrichment. That typically translates to 3 to 5 hours saved per week on data management tasks.

Common mistakes (and how to fix them)

Problem 1: The dashboard doesn’t update automatically

Symptom: You enrich contacts in the Leads tab, but the Dashboard numbers stay frozen.

Impact: You’re making decisions based on stale data.

Solution: Make sure your Dashboard formulas reference open-ended ranges (Leads!F2:F instead of Leads!F2:F501). An open range automatically expands when new rows are added.

Problem 2: COUNTIF formulas overstate the email rate

Symptom: The email rate shows 95% but clearly incorrect placeholders like “email@domain.com” are being counted.

Impact: You overestimate your data quality and launch campaigns with a high bounce rate.

Solution: Add a “Valid email (Y/N)” column fed by Derrick’s Email Verifier. Base your email KPI on validated emails rather than simply filled cells. The distinction between “email present” and “email deliverable” is what actually matters for cold outreach.

Problem 3: The file slows down with large datasets

Symptom: Google Sheets lags when scrolling or editing any cell.

Impact: Daily productivity loss and frustration.

Solution: Limit your COUNTIF and COUNTA ranges to 2,000–3,000 rows maximum. Beyond that, use QUERY to analyze only a specific time period or segment. For databases over 5,000 contacts, archive older leads in a separate tab.

Problem 4: Conditional formatting doesn’t apply to new rows

Symptom: Newly added contacts don’t get the status color-coding.

Impact: You have to manually reapply formatting after every import.

Solution: When setting up conditional formatting, apply it to the entire column (K:K) rather than a fixed range (K2:K500). Google Sheets will then apply the rule automatically to all new entries.

Problem 5: Phone completion rate stays very low

Symptom: After enrichment, less than 20% of your leads have a phone number.

Impact: Your dashboard shows a permanent ⚠️ alert on that attribute.

Solution: Derrick’s Phone Finder needs a LinkedIn profile URL to retrieve phone numbers. Make sure you’ve enriched the LinkedIn column first, then run the Phone Finder. On a list with 85%+ LinkedIn URLs, you should reach 40–60% phone completion depending on the industry.

Going further: enrich your dashboard with AI

For teams that want to push further, several Derrick features can add even more signal to your dashboard:

Automatic lead scoring: Ask Claude directly in Google Sheets lets you score each lead against your ICP automatically. Add an “ICP Score” column to your dashboard and track lead quality distribution at a glance.

Company intelligence: SimilarWeb Insights enriches your data with each prospect’s web traffic — useful for sizing a company beyond what their LinkedIn page declares.

Duplicate removal: Before calculating your completion rates, run Derrick’s Remove Duplicates function to ensure every contact is unique. A duplicate contact mechanically inflates all your KPIs.

Key takeaways

• An effective enrichment dashboard uses 3 tabs: Leads (raw data), Dashboard (visual KPIs), History (trend tracking)
• The core formulas: COUNTA for totals, COUNTIF with "?*" for completion rates, IF for automated statuses
• Set target thresholds per attribute (75% valid email, 40% phone, 85% LinkedIn) and use ✅/⚠️ indicators for instant monitoring
• Derrick automatically feeds this dashboard from Google Sheets: Lead Email Finder, Phone Finder, LinkedIn Profile Scraper, and Email Verifier
• Always distinguish “email present” from “email valid” — that gap is what separates a flattering completion rate from actual deliverability

Conclusion: build it once, use it for months

Building a B2B data enrichment dashboard in Google Sheets requires no technical skills and no expensive software. With Sheets’ native formulas and Derrick to automate the data filling, you can have a complete monitoring system running in under an hour.

The real payoff? You go from “I assume my data is good” to “I know exactly that 78% of my leads have a valid email and 45% have a phone number.” That visibility directly improves the performance of your outbound campaigns and your B2B lead generation as a whole.

Ready to feed your dashboard with enriched data?

Derrick installs in 2 minutes inside Google Sheets and automatically enriches your leads: verified emails, phone numbers, LinkedIn data, and firmographic attributes.

Try for free →

FAQ

Can I build a data enrichment dashboard in Google Sheets without coding?

Yes, completely. The formulas COUNTIF, COUNTA, and IF are enough to calculate all your enrichment KPIs. Google Sheets’ native conditional formatting and chart tools handle the visuals without a single line of code.

What’s the difference between a completion rate and a data quality rate?

Completion rate measures how many fields are filled in (an email exists in the cell). Data quality goes further: it checks whether the data is actually valid and usable (the email is active and deliverable). For B2B prospecting, you need both metrics in your dashboard — that’s why Derrick’s Email Verifier complements the Lead Email Finder.

How many contacts can this system handle in Google Sheets?

Google Sheets handles up to 5,000–10,000 rows comfortably with dynamic formulas. Beyond that, performance starts to degrade. Segment your base by campaign or quarter in separate tabs to keep things fast.

How do I automatically update the enrichment status after running Derrick?

Use the formula =IF(AND(email<>"",phone<>""),"Enriched",IF(OR(email<>"",phone<>""),"Partial","To enrich")). When Derrick fills in the email and phone columns, the status recalculates instantly across your entire dashboard.

Does the dashboard work with data imported from a CRM?

Yes. Export your CRM contacts as a CSV, import them into your “Leads” tab, and the dashboard immediately calculates completion rates. For real-time sync between Derrick, Google Sheets, and your CRM, connect the tools via Zapier or Make.