16 fields, with a real example of each. You pay when the answer comes back, and never when it does not.
Field Name
Description
Example
naf_query
NAF/APE activity code queried
88.91A
nom_complet
Company legal name
EVANCIA (BABILOU)
siren
9-digit SIREN company identifier
447818600
siret
14-digit SIRET establishment identifier
44781860003410
nombre_etablissements_ouverts
Number of open establishments
484
activite_principale
Main declared activity (NAF label)
Accueil de jeunes enfants
tranche_effectif_salarie
Employee headcount band (INSEE code)
42
date_creation
Company creation date
2005-03-01
adresse
Registered address
2 RUE DE LA GARE
code_postal
Postal code
92270
commune
City
BOIS-COLOMBES
code_commune
INSEE commune code
92009
departement
Département code
92
dirigeant
Main director name
STÉPHANIE BARAGNON
dirigeant_qualite
Director role
Directeur Général
nombre_dirigeants
Number of listed directors
3
Step by step03 / 05
How to use this feature
Get started in 3 simple steps.
Google Sheetssidebar
Claude · MCPjust ask
REST APIPOST /v1/enrich
Same engine, same credits
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.
Import Companies by NAF Code
Full nameB ▾
Write toD ▾
1 credit / per company imported
Run
column C
Derrick queries SIRENE
It pages through the official public French company registry and returns every matching company, optionally narrowed to one département.
NamePhone
Camille Laurent+33 6 •• •• •• 41
Thomas Bernard+1 415 ••• ••32
Sophie Moreaufinding…
Inès Duboisno match
200 OK· or the same as JSON
247 rows
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.
When to reach for it04 / 05
Import Companies by NAF Code use cases
Turn a NAF/APE activity code into a full list of matching French companies, straight in Google Sheets. Put one or more codes in a column (10.71C for bakeries, 88.91A for daycare - 1071C works too), optionally narrow to one département, and Derrick pages through the official public SIRENE registry and returns every matching company - legal name, SIREN/SIRET, open establishments, activity, headcount band, creation date, address and director - one per row in a new tab. Free to start.
01
Build a French prospecting list for a whole sector without scraping Pappers or Societe.com.
02
Map every company in a given activity code inside one département.
03
Feed a TAM analysis with the real SIRENE population behind an activity.
04
Seed an outbound list, then enrich it with emails and mobiles.
Use Import Companies by NAF Code via the API and the MCP
Import Companies by NAF Code 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 PLUS 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
"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
"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
"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
"This app is fantastic. Brilliantly created to help small and mid sized businesses."
Dan Hughes
Founder/CEO, AlmanacIO
"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 French B2B prospecting list usually starts with an activity : every bakery, every daycare, every machine-shop in a region. The data is public - it lives in the SIRENE registry maintained by INSEE - but getting it out means an export from Pappers or Societe.com, a paid API, or copy-pasting page after page. None of that lands cleanly in the spreadsheet where the rest of your prospecting happens.
Derrick reads a column of NAF/APE activity codes directly from a Google Sheet (10.71C for bakeries, 88.91A for daycare - the dotless 1071C works too) and pages through the official public registry, writing every matching company into a new tab, one per row : legal name, SIREN and SIRET, number of open establishments, main activity, headcount band, creation date, registered address and director. Add an optional département to narrow a code to one zone. Free to start, then 1 credit per company. See the Derrick pricing grid.
Do I need to install anything to use Import Companies by NAF Code?
+
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Import Companies by NAF Code 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 by NAF Code on a list of 1,000+ rows?
+
Yes - Import Companies by NAF Code 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 by NAF Code 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 by NAF Code. 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 by NAF Code 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 by NAF Code 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 by NAF Code into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
