Put the LinkedIn company URLs of the accounts you want to break into in a column.
Add your Sales Navigator criteria
Paste a Sales Navigator people search describing the roles you want: seniority, function, geography.
Get the right people per account
A new sheet fills with the matching people at each company: name, title, company, location and LinkedIn URL.
All the data you can extract
Enrich companies and leads with 8+ data points each.
Field Name
Description
Example
🙋 fullName
Full name of the person
Álvaro Ruiz
💼 title
Current job title
Chief Revenue Officer
🏢 companyName
Target company the person works at
Sentinel Networks
🏷️ companyIndustry
Industry of that company
Computer & Network Security
📍 geoRegion
Where the person is based
Greater Paris Region
⏳ tenureAtCompany
How long the person has been at the company
3 years 1 month
🔗 linkedinUrl
Link to the LinkedIn profile
https://www.linkedin.com/in/alvaro-ruiz
📝 summary
About section, useful for personalisation
Revenue leader scaling B2B SaaS across EMEA.
When to reach for it
Import Leads from Target Companies use cases
Cross a list of target accounts with your Sales Navigator criteria and Derrick imports the matching people at each company into Google Sheets - name, title, company, location and LinkedIn URL. Built for account-based outbound.
1ABM outbound: reach the right roles inside the accounts you already target.
2Buying committee mapping: pull every relevant contact per account, not just one.
3Territory plans: work a named account list with a single Sales Navigator search.
4Expansion: find the champions and decision makers across your target logos.
Use Import Leads from Target Companies via the API
Import Leads from Target Companies isn't tied to the Google Sheets sidebar. Every Derrick enrichment - this one included - is also exposed through the REST API and the MCP server, so you can run it from your CRM, your data pipeline, an AI assistant, or any no-code tool (Zapier, Make, n8n). Same credit cost as the add-on, same data. API access is included from the Standard plan up.
"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
Account-based outbound starts with a named list of accounts, then the hard part: reaching the right people inside each one. Derrick does both halves in Google Sheets. Put the LinkedIn company URLs of your target accounts in a column, add a Sales Navigator people search that describes the roles you want, and Derrick pulls the matching people at every company into a new tab. Name, title, company, industry, location, tenure and LinkedIn URL, one person per row.
This is the ABM workflow specialists sell as a whole product: cross your account list with a persona and get the buying committee, per account, not one contact per company. A connected LinkedIn account with a Sales Navigator seat is required. 1 credit per lead, and the free plan gives you 100 credits every month, no card. See the Derrick pricing page.
Do I need to install anything to use Import Leads from Target Companies?
+
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Import Leads from Target Companies 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 Import Leads from Target Companies on a list of 1,000+ rows?
+
Yes - Import Leads from Target Companies 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 Import Leads from Target Companies come from?
+
Derrick aggregates 10+ public-data sources (LinkedIn graph, company websites, registry data, web crawl, third-party providers) and runs a multi-source lookup for Import Leads from Target Companies. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.
Is Import Leads from Target Companies 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 Import Leads from Target Companies 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 Import Leads from Target Companies into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
Reach the right people at every target account
Combine your account list with a Sales Navigator search and let Derrick pull the contacts. Free to start, 100 credits every month.
