---
title: "Import Companies by NAF Code"
description: "Paste a NAF/APE activity code, get every matching French company from the SIRENE registry in Google Sheets - name, SIREN/SIRET, directors, headcount, address. Filter by département."
canonical: "https://derrick-app.com/features/import-companies-by-naf"
category: "Feature"
runs_on: "Google Sheets, MCP (AI agents), REST API"
---

# Import Companies by NAF Code

> Paste a NAF/APE activity code, get every matching French company from the SIRENE registry in Google Sheets - name, SIREN/SIRET, directors, headcount, address. Filter by département.

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

---

## 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: Start from a NAF code
Put one or more NAF/APE activity codes in a column - 10.71C for bakeries, 88.91A for daycare. 1071C works too.

### Step 2: Derrick queries SIRENE
It pages through the official public French company registry and returns every matching company, optionally narrowed to one département.

### Step 3: Get a full company list
Legal name, SIREN/SIRET, open establishments, activity, headcount band, creation date, address and director land in a new tab, one company per row.

## Use it from an AI agent (MCP)

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

**Example prompt**: "Import French companies with NAF code 88.91A in Hauts-de-Seine"

**Result**: Every matching company from the SIRENE registry.

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

## Use it from the REST API

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

- Docs: https://app1.derrick-app.com/api/v1/docs/
- Auth: Bearer API key (Google Sheets add-on -> Settings -> API access)
- Machine-readable pricing: /pricing.md

## Build a French company list from an activity code
No scraping, no Pappers export. One NAF code in, the whole matching SIRENE population out, ready to enrich and prospect.