Create a column with company names.
Search Companies
Find a company’s LinkedIn URL using its name.
How to use this feature
Get started in 3 simple steps.
Open the Derrick add-on, choose Search Companies, and select the columns to search.
Your sheet fills with company LinkedIn URLs.
All the data you can extract
Enrich companies and leads with 4+ data points each.
| Field Name | Description | Example |
|---|---|---|
| 📝 companyName (linkedin) | Company name from search results | DataTech Solutions |
| 🔗 companyUrl (linkedin) | LinkedIn company page URL from search | https://www.linkedin.com/company/datatech/ |
| 🏭 activityArea (linkedin) | Primary business activity area | Data Analytics & Business Intelligence |
| 📊 confidence (linkedin) | Confidence score from 0 to 1 for the match | 0.88 |
Search Companies
Combine this feature with others to create powerful automation workflows.
Search Companies use cases
Search the Derrick company database from Google Sheets - by industry, headcount, country, tech stack or keyword - and write the results back into your sheet with full firmographics.
- ICP-driven prospecting: query for SaaS companies with 50-200 employees in France running HubSpot - get 200 results.
- Look-alike account building: enrich a list of best customers, then search for their look-alikes.
- Territory expansion: surface every company in a new region matching your ICP before sending the first SDR.
- Investor research: query funded companies in a specific stage + industry for your sales motion.
Search Companies - measured hit rate
ICP query → matching company in the result set. Higher is better. Reference points from public benchmarks + internal A/B tests.
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 Companies 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."
"Working pretty nifty compared to Snov.Io. Price wise it does give a fair shake, and IMO better interface since it's google sheets."
"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."
"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."
"Amazing Tool, I would like to advocate this to my colleagues. So that you can get more users. Keep it Up. 5 Stars!"
"This app is fantastic. Brilliantly created to help small and mid sized businesses."
"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."
"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."
"Have tested over 10+ LI scraper apps, Derrick beats them all. Simple to use, accurate data, and affordable price."
Resolving a company name to its LinkedIn URL is the company-side equivalent of the lead-URL lookup : without it, none of the downstream LinkedIn-based enrichment (employee count, recent posts, funding signals) works. Most teams do this manually - Google the company name, click the LinkedIn result, copy the URL - or pay Clearbit ($200+/seat/month) for the same workflow.
Derrick reads a column of company names directly from Google Sheets and returns the matched LinkedIn company URL in the next cell. Match rate sits around 91 % on standard B2B companies - the 9 % miss is usually small businesses without a maintained LinkedIn page. Cost ~$0.007 per match on the Pro plan, free up to 100 lookups/month, no card. The bulk use case that drives adoption : turning a CSV of company names (event attendee list, conference roster, customer churn export) into a queryable enrichment-ready list. Higher volumes on the Derrick pricing page.
Frequently asked questions
Do I need to install anything to use Search Companies?
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Search 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 Search Companies on a list of 1,000+ rows?
Yes - Search 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 Search Companies 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 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 Search 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 Search 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 Search Companies into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
Search Companies is completely free. Get 100 credits per month to enrich linkedin profils.
Try it for free →