DEV Community: Amaury

Enrich a list of French SIREN numbers with n8n or Make

Amaury — Sun, 08 Nov 2026 11:46:05 +0000

This tutorial shows how to take a list of SIREN or SIRET numbers from a spreadsheet, send them to an Apify actor, and write the company data back. It uses one HTTP call per batch, so it works the same in n8n and Make. You need an Apify token and about twenty minutes.

What you need

An Apify account and its API token (Apify Console → Settings → Integrations).
A table with one SIREN (9 digits) or SIRET (14 digits) per row. This tutorial reads it from Google Sheets, but any source works.
The actor: https://apify.com/amaury1729/france-company-enrichment

The actor takes one JSON field, items, a list of numbers or names:

{
  "items": ["110014016", "11001401600064", "794598813", { "query": "Doctolib", "postcode": "75011" }]
}

Each entry produces one output item, in the same order. Entries are SIRENs, SIRETs, or company names. A name can carry a postcode to narrow the search.

The endpoint

Apify's synchronous endpoint starts the actor, waits for it to finish, and returns the dataset items in one response:

POST https://api.apify.com/v2/acts/amaury1729~france-company-enrichment/run-sync-get-dataset-items?format=json&clean=true
Authorization: Bearer <your token>
Content-Type: application/json

{"items": ["110014016", "794598813"]}

The response is a JSON array with one object per input row. Send batches of a few hundred rows. The synchronous request is limited to about five minutes, so a longer list needs the asynchronous endpoint instead.

n8n

1. Read the numbers. Add a Google Sheets node set to Get rows, pointing at your sheet. Each row becomes an item with a column named SIREN.

2. Build the list. Add a Code node in Run once for all items mode:

const items = $input.all()
  .map(i => String(i.json.SIREN ?? '').trim())
  .filter(v => v !== '');
return [{ json: { items } }];

3. Call Apify. Add an HTTP Request node with these settings:

Method: POST
URL: https://api.apify.com/v2/acts/amaury1729~france-company-enrichment/run-sync-get-dataset-items
Query parameters: format = json, clean = true
Authentication: Generic Credential Type → Header Auth. Create a credential with the name Authorization and the value Bearer followed by your token. Store it in n8n's credential store, not in the node.
Send Body: on, Body Content Type JSON, Specify Body Using JSON, and this body:

{{ { "items": $json.items } }}

Because the response is a JSON array, n8n returns one item per company row. Test the node with the three sample numbers first: 110014016, 794598813, 356000000.

4. Write back. Add a Google Sheets node set to Append or Update and map the fields you need. The useful ones are input.query, status, company.legal_name, company.hq_siret, company.hq_address.line, company.naf.code, company.naf.label, company.status and company.creation_date. Rows that did not match have no company object, so map with a fallback or leave those cells empty.

Make

Make's module names change between versions, so check the labels on your screen. The steps are the same.

1. Read the numbers. Add a Google Sheets Search Rows module that returns every row.

2. Build the list. Add an Array aggregator after it, so all the SIREN values are collected into one array. Map the SIREN field of each bundle into the aggregator's Target structure.

3. Call Apify. Add an HTTP Make a request module:

URL: https://api.apify.com/v2/acts/amaury1729~france-company-enrichment/run-sync-get-dataset-items?format=json&clean=true
Method: POST
Headers: Authorization = Bearer <your token>, Content-Type = application/json
Body type: Raw, content type JSON (application/json), and the body:

{"items": [ <the aggregated SIREN array> ]}

Insert the aggregated array where the placeholder is, and serialise it as JSON (Make has a toJSON function for this; check the name in your version), so the body is valid JSON. Set Parse response to Yes, so the array is available to the next modules.

4. Split the results. Add an Iterator over the parsed response. Each iteration is one company row.

5. Write back. Add a Google Sheets Update a Row module, or Add a Row, and map the same fields as in the n8n section above. Use a filter before the write if you only want status = found rows in the sheet.

Handling the results

Each item has a status field:

found: one company matched; the company object is filled in.
ambiguous: a name matched several companies. The candidates list shows the top three, with a confidence for each. Pick one and run it again with its SIREN.
not_found: nothing matched. Check the number.
invalid_input: the number fails its check digit or has the wrong length. It was not sent to the source and not charged.
source_error: the public source did not answer. Retry the row later.

Failed rows never stop the batch. Every row comes back with its own status, so filter on status in your workflow rather than assuming every item has a company.

A duplicate number in one batch is looked up once and marked with duplicate_of, so you are not charged twice for it.

Keep it running

Schedule the workflow for the time you need. For a weekly refresh, run it on the same list each week: unchanged companies return the same data, and new closures show up as status = closed in the company fields.

Actor: https://apify.com/amaury1729/france-company-enrichment

Enrich a list of French SIREN numbers in Google Sheets

Amaury — Sun, 08 Nov 2026 11:46:01 +0000

You have a column of SIREN numbers and want the company name, headquarters address, activity code and status next to them. This tutorial does that with an Apify actor and a short Apps Script. It takes about fifteen minutes.

What you need

A Google Sheet with one SIREN (9 digits) or SIRET (14 digits) per row, in column A.
An Apify account and its API token (Apify Console → Settings → Integrations).
The actor: https://apify.com/amaury1729/france-company-enrichment

Format column A as plain text before pasting. Otherwise Sheets may treat a number as a number, which is harmless for most SIRENs but can drop a leading zero in the rare case one starts with 0.

Step 1: Store the token

In the spreadsheet, go to Extensions → Apps Script. In the editor, open Project Settings → Script Properties and add a property named APIFY_TOKEN with your token as the value. Keeping the token out of the code means you can share the sheet without sharing the token.

Step 2: Add the script

Replace the contents of Code.gs with this:

function enrichSirens() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const last = sheet.getLastRow();
  if (last < 2) return;

  const inputs = sheet.getRange(2, 1, last - 1, 1).getValues().flat()
    .map(v => String(v).trim())
    .filter(v => v !== '');

  const token = PropertiesService.getScriptProperties().getProperty('APIFY_TOKEN');
  const url = 'https://api.apify.com/v2/acts/amaury1729~france-company-enrichment/' +
              'run-sync-get-dataset-items?format=json&clean=true';

  const response = UrlFetchApp.fetch(url, {
    method: 'post',
    contentType: 'application/json',
    headers: { Authorization: 'Bearer ' + token },
    payload: JSON.stringify({ items: inputs }),
    muteHttpExceptions: true
  });
  if (response.getResponseCode() !== 200) {
    throw new Error('Apify returned HTTP ' + response.getResponseCode() + ': ' + response.getContentText());
  }

  const rows = JSON.parse(response.getContentText());
  const header = ['SIREN input', 'Status', 'Legal name', 'SIREN', 'HQ SIRET', 'HQ address',
                  'NAF code', 'NAF label', 'Active', 'Creation date', 'Headcount band'];
  const out = rows.map(r => {
    const c = r.company || {};
    return [
      r.input.query, r.status, c.legal_name || '', c.siren || '', c.hq_siret || '',
      c.hq_address ? c.hq_address.line : '',
      c.naf ? c.naf.code : '', c.naf ? c.naf.label : '',
      c.status === 'active' ? 'yes' : (c.status === 'closed' ? 'no' : ''),
      c.creation_date || '', c.headcount ? c.headcount.label : ''
    ];
  });

  // Clear the old output (columns C onward), then write the header and rows. Column A is never touched.
  sheet.getRange(1, 3, Math.max(last, out.length + 1), header.length).clearContent();
  sheet.getRange(1, 3, 1, header.length).setValues([header]);
  sheet.getRange(2, 3, out.length, header.length).setValues(out);
}

The script writes from column C onward and leaves your SIRENs in column A.

Step 3: Run it

Save, then choose Run → enrichSirens in the editor. The first run asks for permission to call an external service; allow it. Switch back to the sheet and the columns fill in.

The actor's synchronous endpoint waits for the run to finish and returns at most about five minutes. Keep each batch to a few hundred rows. A row with a bad number is not a failure of the whole batch: it comes back with its own status, and the rest still complete.

Step 4: Read the output

Each row has these columns, in this order:

Column	Example value
SIREN input	`110014016`
Status	`found`
Legal name	`MINISTERE DE L'INTERIEUR`
SIREN	`110014016`
HQ SIRET	`11001401600015`
HQ address	`PLACE BEAUVAU 75008 PARIS 08`
NAF code	`84.11Z`
NAF label	`Administration publique générale`
Active	`yes`
Creation date	`1983-03-01`
Headcount band	`2 000 à 4 999 salariés`

Possible Status values:

found: one company matched.
ambiguous: a name matched several companies. Enter the right SIREN in column A and run again.
not_found: no company matches. Check the number.
invalid_input: the number fails its check digit or has the wrong length. Nothing was looked up or charged.
source_error: the public source did not answer. Run the sheet again later.

Rows that did not match leave the company columns empty, so you can filter on Status to find them. A row marked establishment_not_confirmed keeps its company columns, because the company exists; check its SIRET before use.

Step 5: Re-run safely

Running the script again overwrites columns C to M and leaves column A alone. A duplicate SIREN in column A is looked up once and marked as a duplicate in the output, so you are not billed twice for it.

Ready-made input for a first test:

110014016
794598813
356000000

Start with that, then paste your own list.

Actor: https://apify.com/amaury1729/france-company-enrichment