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.
Related Templates
AI Weather Forecasts with MCP Integration
Real-time Weather Forecasts with MCP Tools This n8n workflow demonstrates how to integrate real-time weather intelligen...
AI Agent: Scrape, Summarize & Save Articles to Notion (Gemini, Browserless)
This n8n workflow automates the process of saving web articles or links shared in a chat conversation directly into a No...
Extract Named Entities from Web Pages with Google Natural Language API
Who is this for? Content strategists analyzing web page semantic content SEO professionals conducting entity-based anal...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments