Add your SIRET or SIREN numbers to Google Sheets.
Create a column with your SIRET (14 digits) or SIREN (9 digits) numbers. Derrick accepts both formats.
Free
🇫🇷 SIRET/SIREN Enrichment
Enrich French companies via SIRET/SIREN with identity, activity, directors and legal data.
Used by 31,000+ French SDRs Updated
Try it for free →
How to use this feature
Get started in 3 simple steps.
Select SIRET/SIREN Enrichment
Open the Derrick add-on, choose SIRET/SIREN Enrichment, and select the column to enrich.
Get French company data instantly
Your sheet fills with company name, directors, revenue, headcount, address, and 30+ legal data points.
All the data you can extract
Enrich companies and leads with 17+ data points each.
| Field Name | Description | Example |
|---|---|---|
| 🇫🇷 nom (siret siren) | Company name | DERRICK |
| 🇫🇷 siren (siret siren) | SIREN number (9 digits) | 533060372 |
| 🇫🇷 siret_siege (siret siren) | SIRET number of the registered office (14 digits) | 53306037200026 |
| 🇫🇷 date_creation (siret siren) | Company creation date | 2011-06-01 |
| 🇫🇷 naf (siret siren) | NAF/APE activity code | 43.99C |
| 🇫🇷 tranche_effectif (siret siren) | Employee headcount range code | 01 |
| 🇫🇷 tranche_effectif_annee (siret siren) | Year of the headcount data | 2023 |
| 🇫🇷 nb_etablissements (siret siren) | Total number of establishments | 2 |
| 🇫🇷 nb_etablissements_ouverts (siret siren) | Number of currently open establishments | 1 |
| 🇫🇷 adresse_complete (siret siren) | Full postal address of the registered office | 11 RUE CHARLES CORDIER 77164 FERRIERES-EN-BRIE |
| 🇫🇷 code_postal (siret siren) | Postal code | 77164 |
| 🇫🇷 ville (siret siren) | City of the registered office | FERRIERES-EN-BRIE |
| 🇫🇷 departement (siret siren) | Department code | 77 |
| 🇫🇷 region (siret siren) | Region code | 11 |
| 🇫🇷 opco (siret siren) | OPCO (operator of skills) the company belongs to | [TO COME] |
| 🇫🇷 dirigeant_principal (siret siren) | Main executive with name and role | DERRICK TRAN (TRAN) (Président de SAS) |
| 🇫🇷 dirigeants_liste (siret siren) | Full list of executives separated by | | DERRICK TRAN | EXI CONSEILS ET AUDIT | LK EXPERTISE |
When to reach for it
🇫🇷 SIRET/SIREN Enrichment use cases
Enrich French companies from a SIRET or SIREN number with directors, revenue, headcount, address, legal status and 30+ registry fields - direct from the official French government data sources.
- French market expansion: enrich a 1,000-row French TAL with full registry data before launching outbound.
- KYC / compliance: backfill SIRET-derived legal data on existing customers for procurement / contract workflows.
- Regional segmentation: enrich French SMBs with NAF code + region + revenue band for targeted campaigns.
- Lead qualification: validate that a French inbound is a real registered company (vs. a freelancer).
Loved by sales teams worldwide
See what our customers say about Derrick.
"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
French B2B prospecting requires SIRET / SIREN enrichment — the legal company identifiers that unlock director names, revenue, headcount, sector code, and registered address (data that's public via INSEE but never bundled into the international enrichment tools like Apollo or ZoomInfo). Most French sales teams scrape Pappers or Societe.com manually, or pay for the Pappers API at €0.10-0.30 per request.
Derrick reads a column of SIRET or SIREN numbers directly from Google Sheets and returns 30+ legal data points — current directors, declared revenue, employee headcount, NAF sector, registered address, last balance-sheet date — in the next cells. Free up to 100 lookups/month, no card. The data comes from the official INSEE + Pappers feeds, refreshed weekly. Per-call cost on the Derrick pricing page.
Related : LinkedIn-based company enrichment for non-French targets, the full data-enrichment recipe hub for adjacent workflows.
Frequently asked questions
Do I need to install anything to use 🇫🇷 SIRET/SIREN Enrichment?
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, 🇫🇷 SIRET/SIREN Enrichment 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 🇫🇷 SIRET/SIREN Enrichment on a list of 1,000+ rows?
Yes - 🇫🇷 SIRET/SIREN Enrichment 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 🇫🇷 SIRET/SIREN Enrichment come from?
Derrick aggregates 10+ public-data sources (LinkedIn graph, company websites, registry data, web crawl, third-party providers) and runs them in a waterfall for 🇫🇷 SIRET/SIREN Enrichment. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.
Is 🇫🇷 SIRET/SIREN Enrichment 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 🇫🇷 SIRET/SIREN Enrichment 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 🇫🇷 SIRET/SIREN Enrichment into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.
Start enriching French companies today
SIRET/SIREN Enrichment is completely free. Get 100 credits per month to enrich your French leads.
Try it for free → 1 Credit per company
100 credits free every month
No credit card required Try it, add more credits only if needed