Add your data to Google Sheets.
Create a column with full name and optionally company name.
Premium
Search Leads
Find LinkedIn profiles of your leads using their first and last names.
Used by 31,000+ outbound SDRs Updated
Try it for free →
How to use this feature
Get started in 3 simple steps.
Select Search Leads
Open the Derrick add-on, choose Search Leads, and select the columns to search.
Get LinkedIn URLs instantly
Your sheet fills with LinkedIn profile URLs.
All the data you can extract
Enrich companies and leads with 4+ data points each.
| Field Name | Description | Example |
|---|---|---|
| 🔗 url | The URL of the LinkedIn profile found | https://www.linkedin.com/in/jeandupon/ |
| 📝 title | The title/headline displayed on the LinkedIn profile | Marketing Director at Acme Corp |
| 📝 description | The summary/about section of the LinkedIn profile | "Experienced marketing professional with 10+ years..." |
| 📊 confidence | Confidence score from 0 to 1 indicating match accuracy | 0.95 |
Workflow using
Search Leads
Combine this feature with others to create powerful automation workflows.
When to reach for it
Search Leads use cases
Search the Derrick lead database directly from Google Sheets - by company, role, location or keyword - and write the results back into your sheet. No external tool to learn, no CSV imports.
- ICP discovery: search for a job title + industry + headcount range and surface 100 fresh prospects in one call.
- Account expansion: search for all current employees at an existing customer to spot new buying committee members.
- Territory research: pull every VP-Marketing in a specific country before a regional sales push.
- Recruiter sourcing: build a candidate longlist by role + skills + location, all inside a Sheet.
Accuracy you can count on
Search Leads - measured hit rate
ICP query → matching lead in the result set. Higher is better. Reference points from public benchmarks + internal A/B tests.
Derrick Search Leads 91%
Apollo / ZoomInfo search 80%
Generic B2B database 65%
Open-data lead lists 42%
Hit rates depend on input geography (US/EU vs APAC), B2B vs B2C context, and input quality. Numbers above are typical mid-funnel results for B2B sales teams running Search Leads on enriched lead lists.
Loved by sales teams worldwide
See what our customers say about Derrick.
"This app saved me so much time and effort. Great for anyone looking to build a contact list or network at scale quickly. As a start-up it's been invaluable."
Alex Clark
Director | SaaS GTM Leader
"Working pretty nifty compared to Snov.Io. Price wise it does give a fair shake, and IMO better interface since it's google sheets."
David Sire
Mortgage Broker at Zero Point Mortgage
"Derrick is a very simple and user-friendly app to enrich your contacts database. Best thing: you can test it for free. And then the price is so low, it's a no brainer."
Etienne Grange
CEO Form'actions
"Super easy to enrich linkedin urls using this tool. Both personal and company url data can be easily enriched with a click of a button."
Zaid Bilal
RevOps Professional
"Amazing Tool, I would like to advocate this to my colleagues. So that you can get more users. Keep it Up. 5 Stars!"
Asif Hanzala
Lead Generation Specialist at IdeaPeel
"This app is fantastic. Brilliantly created to help small and mid sized businesses."
Dan Hughes
Founder/CEO, AlmanacIO
"I have been using other expensive apps or freemium like phantombuster, but Derrick has replaced them all. I love the simplicity of the Google sheet add-in, but what is best is the efficiency it delivers."
Julien Walon Cohen
CEO & Co-founder @ Diffly | B2B Sales Advisor
"The LinkedIn scraping and email finder combo is incredibly powerful. I can build a complete prospect list with contact info in under an hour. Absolute must-have for outbound."
Michael Kim
SDR Team Lead at CloudScale
"Have tested over 10+ LI scraper apps, Derrick beats them all. Simple to use, accurate data, and affordable price."
AJ Alexander
Opportunity Prospector
Finding the LinkedIn profile URL behind a name is the entry point for every modern B2B outbound : without it, none of the downstream enrichment (email, mobile, tech stack, intent signals) works. Most teams resolve this by hand or via Sales Navigator search — slow at scale, and the LinkedIn URL never lands cleanly in their CRM.
Derrick's Search Leads reads first-name + last-name + company columns directly from Google Sheets and returns the matched LinkedIn profile URL in the next cell. Match rate sits around 78 % on standard B2B contacts (Q1 2026 benchmark, 5K-row sample) — the 22 % miss is usually free-mail prospects with very common names where multiple candidates compete. Cost : ~$0.007 per profile on the Pro plan, free up to 100 lookups/month, no card. Per-plan cost on the Derrick pricing page.
Related : the find-LinkedIn-from-name recipe shows the exact Sheets workflow. Wider context : B2B sales tools reviewed in depth, top Apollo alternatives by use case.
Frequently asked questions
Do I need to install anything to use Search Leads?
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Search Leads is one of the workflows available from the Derrick sidebar inside any Sheet. The same feature is also available via REST API and via the Derrick MCP server for Claude / ChatGPT.
Can I use Search Leads on a list of 1,000+ rows?
Yes - Search Leads runs as a batch job inside Google Sheets, with progress tracking and per-row credit accounting. The workflow scales linearly: 10 rows or 10,000 rows, the steps are identical and you can step away while it runs.
Where does the data behind Search Leads come from?
Derrick aggregates 10+ public-data sources (LinkedIn graph, company websites, registry data, web crawl, third-party providers) and runs them in a waterfall for Search Leads. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.
Is Search Leads GDPR-compliant?
Yes. Derrick only enriches public data, doesn't store personal records beyond the duration of the lookup, and supports full deletion on request. The Sheets add-on runs inside Google's OAuth-protected environment so your data stays private to your account.
Can I trigger Search Leads automatically when I add a row?
Yes - set up a Google Sheets onEdit trigger (Apps Script, takes 2 minutes) so a new row in column A automatically runs Search Leads into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
Start finding LinkedIn profiles today
Access fast, reliable lead search directly inside Sheets.
Try it for free → 1 Credit per profile (starts at €0.0017)
Unused credits roll over Keep unused credits for next month
No learning curve Install, click, get results instantly