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.