How to Automate B2B Data Enrichment with Zapier, Make and n8n

An SDR prospecting 200 leads a week spends between 30 and 40% of their time manually filling in contact records — hunting for an email, verifying a phone number, looking up company size. That’s time stolen from actual selling. Automating B2B data enrichment with tools like Zapier, Make or n8n changes everything. A new contact lands in your Google Sheets, and within seconds it’s enriched with a verified professional email, a direct phone number, and company details — with no action on your end.

In this guide, you’ll learn how to connect a data enrichment tool like Derrick to your stack via Zapier, Make or n8n, and build automated enrichment workflows that run on their own.

Enrich your leads automatically in Google Sheets

Connect Derrick to Zapier, Make or n8n and automate email finding, phone lookups, and B2B prospect enrichment.

Try for free →

Why automate your B2B data enrichment

Data enrichment means completing your prospect records with verified contact information — professional email, direct phone number, company data — starting from a basic input like a name or a LinkedIn URL. Done manually, it’s slow, repetitive, and error-prone.

According to a Forrester study (2024), B2B salespeople spend an average of 65% of their time on non-sales tasks, a significant chunk of which goes to searching for and entering contact data. Across a team of five reps, that’s the equivalent of three full-time positions absorbed by work that doesn’t move deals forward.

Automation via Zapier, Make or n8n flips this entirely: as soon as a new contact enters your pipeline — through a form submission, a LinkedIn import, or a CRM update — a workflow automatically triggers enrichment and pushes the complete data back into Google Sheets or directly into your CRM.

The result: your sales team always works with fresh, complete data without ever running a manual search. This is exactly what the Derrick + Zapier/Make/n8n combination delivers in an automated B2B data enrichment pipeline.

Zapier, Make and n8n: what role do they play in an enrichment workflow?

Before building your first workflow, it’s worth understanding what these three tools do and how they differ. All three serve the same core function: connecting apps together to trigger automatic actions. But their interface, pricing model, and ideal use cases are very different.

Zapier: the easiest entry point

Zapier is the most accessible automation platform on the market. Its linear interface — one trigger followed by one or more actions — lets you set up a first workflow in under an hour with zero technical skills.

For a simple enrichment workflow like “new contact in Google Sheets → enrich via Derrick → notify in Slack,” Zapier is the obvious choice. It offers over 6,000 native integrations and pre-built templates that dramatically cut setup time.

The main limitation is cost: Zapier charges per task. At high volumes (50,000+ monthly executions), the bill climbs fast compared to alternatives.

Make: the best balance of power and price

Make (formerly Integromat) features a visual canvas editor where you connect modules via drag and drop. It’s significantly more powerful than Zapier: you can build conditional branches, routers, iterators, and multi-step scenarios with far more sophistication.

For an enrichment workflow with conditions — for example, only enrich leads with a known email domain, then verify the email before pushing to HubSpot — Make is the most suitable platform for non-technical teams with advanced needs.

Its operations-based pricing (rather than per-task) makes it noticeably cheaper than Zapier at equivalent volumes. Make is also headquartered in Europe, which matters for GDPR compliance.

n8n: full control for technical teams

n8n is an open-source, self-hostable platform that offers total flexibility. Its node-based editor lets you build complex automations, call any external API, and inject JavaScript or Python code directly into a workflow.

For teams handling sensitive data or needing full infrastructure control (strict GDPR compliance, on-premise hosting), n8n is often the only viable option. In self-hosted mode, it’s free — making it the most cost-effective solution at high volumes.

The trade-off: its learning curve is steeper and initial setup requires technical skills.

Zapier vs Make vs n8n for B2B enrichment: a quick comparison

All three integrate natively with Derrick, Google Sheets, HubSpot, Salesforce, and Slack — the core building blocks of an automated B2B enrichment pipeline. Now let’s get practical.

How to connect Derrick to Zapier: step-by-step

Here’s how to set up your first automated enrichment workflow using Zapier and Derrick.

Step 1: Create a Zapier account and connect Google Sheets

Go to zapier.com and create an account (the free plan is fine for testing). Click “Create Zap”, then select Google Sheets as your trigger app.

Choose the “New Spreadsheet Row” trigger — this fires every time a new row is added to your sheet. Authenticate your Google account, then select the file and tab that contains your prospect list.

Expected result: Zapier is connected to your Google Sheets and will detect every new contact added.

Step 2: Install Derrick and grab your API key

In Google Sheets, install the Derrick add-on from the Google Workspace Marketplace. Once installed, go to Derrick settings to generate your API key — this is what Zapier will use to authenticate its requests.

Expected result: You have an active Derrick API key ready to enter in Zapier.

Step 3: Add the Derrick action to your Zap

In Zapier, add an action after your Google Sheets trigger. Search for “Webhooks by Zapier” (or the native Derrick integration if available) and configure the request to the Derrick endpoint matching the enrichment you want — for example, the Lead Email Finder.

Map the dynamic fields — first name, last name, company domain — from your Google Sheets columns.

Expected result: Zapier automatically sends each new contact’s data to Derrick to trigger enrichment.

Step 4: Write the enriched data back to Google Sheets (or your CRM)

Add a final action in Zapier: Google Sheets → Update Spreadsheet Row. Map Derrick’s response (found email, verification status) to the corresponding columns in your sheet.

If you want to push directly to HubSpot or Pipedrive instead, swap in the CRM action — or add it in parallel.

Expected result: Every new contact row is automatically completed with their verified email, with no manual intervention required.

4 automated enrichment workflows to deploy right now

These workflows cover the most common use cases for B2B sales and marketing teams. Each can be replicated on Zapier, Make or n8n depending on your technical level and monthly volume.

Workflow 1: New form lead → enrichment → CRM

Use case: Sarah, Growth Marketer at a SaaS startup, receives leads through a Typeform. She wants every lead automatically enriched with a professional email and phone number before they enter HubSpot.

Workflow logic:

1. Trigger: New Typeform submission
2. Action: Create a row in Google Sheets
3. Action: Derrick Lead Email Finder (first name + last name + domain)
4. Action: Derrick Phone Finder (LinkedIn URL if available)
5. Action: Create or update the contact in HubSpot with enriched data

Result: Every lead enters HubSpot with a verified email and direct number, ready to be contacted. Time saved: 3 to 5 minutes per lead.

Workflow 2: Sales Navigator import → bulk email enrichment

Use case: Mike, SDR at an industrial SMB, imports a weekly prospect list from LinkedIn Sales Navigator into Derrick. He wants each profile automatically enriched with a professional email.

Workflow logic:

1. Trigger: New row in Google Sheets (after Sales Navigator import via Derrick)
2. Action: Derrick Lead Email Finder on each row
3. Action: Derrick Email Verifier to filter invalid addresses
4. Action: Update the email and status columns in the sheet
5. Action (optional): Slack alert if email match rate drops below 70%

For more on email enrichment, check our guide on the best professional email enrichment tools.

Workflow 3: Automated CRM list cleaning and verification

Use case: Emma, Sales Ops at a software company, needs to regularly clean her HubSpot database — contacts go stale fast. She wants an automatic email verification run every month.

Workflow logic:

1. Trigger: Monthly schedule (first Monday of the month)
2. Action: Export HubSpot contacts to Google Sheets
3. Action: Derrick Email Verifier on each address
4. Action: Update the email_status field in HubSpot (valid / invalid / catch-all)
5. Action: Generate a summary report in Google Sheets

According to HubSpot (2024), sales professionals lose an average of 19% of their day to updating contact management tools. A workflow like this brings that figure to zero on the verification side. For a deeper dive on how email verification works, see our article on email verification and list cleaning.

Workflow 4: AI scoring + Slack alert for hot leads

Use case: Mark, founder of a B2B lead gen agency, wants to be notified instantly when a high-potential prospect enters his pipeline, so his team can prioritize outreach.

Workflow logic:

1. Trigger: New row in Google Sheets (after enrichment)
2. Action: Derrick AI Lead Scoring (scored against ICP: company size, industry, job title)
3. Condition: If score > 70/100
4. Action (if true): Send a Slack alert with lead info and score
5. Action (if true): Create a priority task in Pipedrive

This type of workflow — particularly powerful in Make or n8n thanks to conditional branching — lets you focus sales effort on the 20% of leads that represent 80% of conversion potential. You can also layer in Ask Claude directly inside Derrick to generate profile summaries or personalized outreach angles.

Which tool should you choose?

The right pick between Zapier, Make and n8n depends on your team’s technical level, monthly lead volume, and data compliance requirements.

Choose Zapier if:

• Your team has zero technical background
• You want to be up and running in under an hour
• Your monthly volume stays below 10,000 executions
• Breadth of integrations matters more than cost

Choose Make if:

• You need workflows with conditions, routers, or multiple branches
• You’re on a limited budget but processing significant volumes
• You want a powerful visual interface without writing code
• GDPR compliance with EU-hosted data is a requirement

Choose n8n if:

• Your team includes technical profiles (developers, ops, data engineers)
• You’re processing very high volumes and want to control costs
• You handle sensitive data requiring on-premise hosting
• You need complex business logic with custom code

Common mistakes to avoid in your enrichment workflows

Problem 1: Renaming columns after workflow setup

Impact: Zapier and Make use your Google Sheets column headers as field references. If you rename a column after configuring the workflow, the field mapping breaks silently — the workflow runs but writes nothing.

Solution: Lock your column names before configuring any workflow. Create a naming convention (e.g., pro_email, direct_phone, linkedin_url) and never change them after setup.

Problem 2: Not enough input data for enrichment

Impact: If you only provide a first name without a last name or company domain, the Lead Email Finder match rate drops significantly. The workflow runs but returns few usable results.

Solution: For the Lead Email Finder, always provide at minimum first name + last name + company domain. For the LinkedIn Profile Scraper, a valid LinkedIn URL is required. Add a data validation step (Zapier filter or Make router) before calling Derrick.

Problem 3: Infinite loop workflows

Impact: If your trigger is “new row in Google Sheets” and your action modifies that same row, you risk creating a loop — the row modification re-triggers the workflow, which modifies the row again, and so on. Result: thousands of credits consumed in minutes.

Solution: Use a status column (enriched: yes/no) as an entry filter. Only trigger enrichment when the value is “no”, and update it to “yes” at the end of each successful run.

Problem 4: No error handling when the API fails

Impact: If the Derrick API returns an error (quota exceeded, connection dropped), the workflow stops silently. Subsequent leads aren’t enriched and you don’t find out until it’s too late.

Solution: Set up error handlers in Make (the “Error handler” module) or conditional paths in n8n. Send a Slack or email alert on every error so you can intervene quickly.

GDPR and automated data enrichment

Automating B2B data enrichment raises legitimate compliance questions under GDPR. In the UK, the ICO (Information Commissioner’s Office) and across the EU, supervisory authorities consider that processing personal data — including professional emails and phone numbers — must rest on a valid legal basis.

For B2B prospecting, the most commonly relied-upon basis is legitimate interest: you have a genuine commercial interest in contacting professionals whose activity is likely to be relevant to your offer. This interest must be documented and must not override the rights of the individuals concerned.

Key practices to build into your automated workflows: always include an unsubscribe link in your outreach emails and ensure opt-outs are reflected in your database immediately. Collect only the data strictly necessary for your purpose (data minimisation). Document your processing activities in your Records of Processing Activities (RoPA) in line with Article 30 of GDPR.

Automation doesn’t change the rules — it just needs to be configured within them.

Key takeaways

• Zapier, Make and n8n all serve the same purpose in an enrichment pipeline: connecting Derrick to Google Sheets, your CRM, and your notification tools
• Zapier is best for getting started fast with no technical skills, Make for complex workflows on a moderate budget, n8n for technical teams at high volume
• A solid enrichment workflow always follows the same pattern: trigger → enrichment → condition → write to CRM or alert
• The most common failure modes are infinite loops and missing error handling — address both before going live
• Derrick integrates natively with all three platforms and automates email, phone, and full B2B data enrichment from a single trigger

Conclusion: your first workflow in under an hour

Automating data enrichment is no longer reserved for technical teams. With Zapier, Make or n8n connected to Derrick, any sales team can build a pipeline that automatically enriches every new lead — verified email, direct phone, company details — without ever touching it manually.

Start with the simplest workflow that delivers immediate value: a Google Sheets trigger + a Derrick Lead Email Finder call + a row update. You’ll see your first results in under an hour.

Automate your B2B enrichment with Derrick

Connect Derrick to Zapier, Make or n8n and launch your first automated enrichment workflow today. No technical skills required.

Try for free →

FAQ

Do I need technical skills to connect Derrick to Zapier? No. Zapier is a fully visual no-code platform. Following the steps in this guide, you can configure your first enrichment workflow in under an hour without writing a single line of code.

How many Derrick credits does an automated workflow use? Each enrichment action uses 1 Derrick credit. A workflow processing 500 new leads per month will use 500 credits. The Medium plan at $20/month includes 10,000 rollover credits — more than enough for most teams.

What’s the difference between Zapier, Make and n8n for B2B enrichment? Zapier is the simplest to set up, best suited for linear automations without complex conditions. Make offers more flexibility with its canvas editor and better value at higher volumes. n8n is the open-source, self-hostable option — ideal for technical teams that want full control over their data and infrastructure.

Is automated data enrichment GDPR-compliant? Yes, provided you comply with the applicable legal bases (legitimate interest for B2B prospecting) and include an unsubscribe link in your communications. Automation doesn’t exempt you from documenting your processing activities in your GDPR records.

Can I use these workflows to enrich an existing CRM list, not just new leads? Absolutely. You can set up a scheduled trigger (weekly or monthly) in Zapier or Make that exports your CRM contacts, enriches them via Derrick, and updates the records. That’s Workflow 3 in this article — perfect for cleaning and completing an existing database.