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.
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.
1Build a French prospecting list for a whole sector without scraping Pappers or Societe.com.
2Map every company in a given activity code inside one département.
3Feed a TAM analysis with the real SIRENE population behind an activity.
4Seed an outbound list, then enrich it with emails and mobiles.
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 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 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.
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.
