Describe the kind of company you are looking for and Derrick imports the matching companies into Google Sheets: name, industry, country, website and LinkedIn URL.
Write it in one sentence, for example: Series A fintech startups in Germany.
Click Import companies
Derrick turns your description into a company search and runs it for you.
Get the list instantly
A new sheet fills with each company: name, industry, country, city, website and LinkedIn URL.
All the data you can extract
Enrich companies and leads with 7+ data points each.
Field Name
Description
Example
🏢 name
Company name
Bananas Karla
🔗 linkedin_url
LinkedIn company profile URL
https://www.linkedin.com/company/bananas-karla
🏷️ industry
Industry of the company
Farming
🌍 country
Country of the company
Mexico
📍 city
City of the company
Guadalajara
🌐 website
Company website
http://www.bananaskarla.com.mx
🗺️ region
Region or state
Jalisco
When to reach for it
Import Companies from a Prompt use cases
Describe the kind of company you are looking for and Derrick imports the matching firms into Google Sheets - name, industry, country, city, website and LinkedIn URL. No filter menus, no manual list building.
1Build a target account list: turn your ICP into a real company list in seconds.
2Enter a new market: the same profile in a different country, in one edit.
3Feed an ABM motion: get the accounts, then pull the people who work there.
4Market research: size a segment by pulling every company that matches.
Import Companies from a Prompt 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
Building a target account list usually means an afternoon in filter menus, tab after tab, copy-pasting rows into a sheet. Derrick removes that: you describe the companies you want in one sentence, "Series A fintech startups in Germany", and it runs the search and writes every matching company into a new tab of your Google Sheet. Name, industry, country, city, website and LinkedIn company URL, one company per row.
Because the target is a sentence, iterating is free: rewrite it, run it again, compare the two lists. From there the account list feeds the rest of the motion, enrich each company with LinkedIn data, find the people who work there, then reach the right roles. 1 credit per company imported, 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 Companies from a Prompt?
+
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Import Companies from a Prompt 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 Companies from a Prompt on a list of 1,000+ rows?
+
Yes - Import Companies from a Prompt 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 Companies from a Prompt 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 Companies from a Prompt. 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 Companies from a Prompt 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 Companies from a Prompt 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 Companies from a Prompt into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
Stop building company lists by hand
Describe your target market once and let Derrick build the company list. Free to start, 100 credits every month.
