Create a column with SIRET (14 digits), SIREN (9 digits), or plain company names. Derrick accepts all three - add an optional département to disambiguate a name.
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, 30+ legal fields, plus matched_name and a confidence score when you searched by name.
All the data you can extract
Enrich companies and leads with 19+ data points each.
Field Name
Description
Example
🏢 matched_name (siret-siren-enrichment)
The company that was matched (echoes the input for a number; the resolved company for a name)
DOCTOLIB
📊 confidence (siret-siren-enrichment)
Match confidence 0-100 (100 for an exact SIRET/SIREN, 0-99 for a name search)
100
🇫🇷 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/Name Enrichment use cases
Enrich French companies from a SIRET, a SIREN, or just a company name, with directors, revenue, headcount, address, legal status and 30+ registry fields - direct from the official French government data sources. A number resolves exactly; a name is matched to the closest company with a confidence score and the matched name, so you can trust or filter each row.
1Resolve names to SIREN: turn a column of French company names into their official SIREN/SIRET, ready to enrich further.
2French market expansion: enrich a 1,000-row French TAL with full registry data before launching outbound.
3KYC / compliance: backfill SIRET-derived legal data on existing customers for procurement / contract workflows.
4Lead qualification: validate that a French inbound is a real registered company (vs. a freelancer).
🇫🇷 SIRET/SIREN/Name Enrichment 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
French B2B prospecting runs on SIRET / SIREN - 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 international tools like Apollo or ZoomInfo). The catch: most of the time you don't have the number, you have a company name. Teams then look it up by hand on Societe.com, one company at a time.
Derrick reads a column of SIRET, SIREN or plain company names from Google Sheets and returns 30+ official legal data points in the next cells - current directors, declared revenue, employee headcount, NAF sector, registered address, last balance-sheet date. A number resolves exactly; a name is matched to the closest company and comes back with the matched name and a confidence score, so you trust the sure rows and filter the rest. Add an optional département to disambiguate common names. Free up to 100 lookups/month, no card. Data from the official recherche-entreprises.api.gouv.fr registry. Per-call cost on the Derrick pricing page.
Do I need to install anything to use 🇫🇷 SIRET/SIREN/Name Enrichment?
+
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, 🇫🇷 SIRET/SIREN/Name 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/Name Enrichment on a list of 1,000+ rows?
+
Yes - 🇫🇷 SIRET/SIREN/Name 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/Name Enrichment 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 🇫🇷 SIRET/SIREN/Name 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/Name 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/Name 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/Name 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.
