Log new French company registrations from BODACC to Google Sheets

Quick overview This workflow runs every morning, pulls newly published company creation announcements from the BODACC open data API for a chosen French department, filters and deduplicates the results, and appends the new companies to a Google Sheets spreadsheet.

How it works Runs every morning on a schedule. Queries the BODACC (DataDila / Opendatasoft) API for “creation” announcements in your selected department from the last N days. Extracts and normalizes key fields (for example SIREN, company name, legal form, activity, address, registration date, and BODACC URL) and optionally filters by entity type and activity keywords. Skips any companies whose SIREN was already processed in previous workflow executions to avoid duplicates. Appends the remaining new company rows to Google Sheets.

Setup Update the department code, look-back window (daysBack), optional activity keywords, and whether to include only legal entities in the filter configuration. Create a Google Sheet with columns matching the workflow output fields (for example siren, company_name, trade_name, entity_type, legal_form, share_capital_eur, activity, street, postal_code, city, department, registration_date, publication_date, bodacc_url). Connect Google Sheets credentials and set the target spreadsheet URL/ID and sheet tab for the append step.

0
Downloads
0
Views
8.46
Quality Score
beginner
Complexity
Created:11/18/2026
Updated:11/18/2026

🔒 Please log in to import templates to n8n and favorite templates

Workflow Visualization

Loading...

Preparing workflow renderer

Comments (0)

Login to post comments