---
title: "Import Companies from a Prompt"
description: "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."
canonical: "https://derrick-app.com/features/import-companies-by-prompt"
category: "Feature"
runs_on: "Google Sheets, MCP (AI agents), REST API"
---

# Import Companies from a Prompt

> 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.

*Canonical: https://derrick-app.com/features/import-companies-by-prompt*

---

## Where it runs

- **Google Sheets add-on** - run it from the Derrick sidebar, results written to your sheet.
- **MCP server (AI agents)** - call it from Claude, Cursor, or any MCP client. See /mcp.
- **REST API** - call it from your own code (Standard plan and up). Docs: https://app1.derrick-app.com/api/v1/docs/

## How to use it in Google Sheets

### Step 1: Describe the companies you want
Write it in one sentence, for example: Series A fintech startups in Germany.

### Step 2: Click Import companies
Derrick turns your description into a company search and runs it for you.

### Step 3: Get the list instantly
A new sheet fills with each company: name, industry, country, city, website and LinkedIn URL.

## Use it from an AI agent (MCP)

Exposed as the `derrick_import_companies_from_prompt` tool on the Derrick MCP server.

**Example prompt**: "Import Series A fintech startups in Germany"

**Result**: Matching companies, no filter menus needed.

Install: `claude mcp add derrick -- npx -y derrick-mcp`. Full catalog at /mcp.md.

## Use it from the REST API

Action: `import_companies_from_prompt`. Available from the STANDARD plan upward, same credit cost as the add-on.

- Docs: https://app1.derrick-app.com/api/v1/docs/
- Auth: pass your key in the `x-api-key` header (get it in the Google Sheets add-on -> menu -> API)
- Machine-readable pricing: /pricing.md

## 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.