Automate French Company Data Enrichment with INSEE API and Agile CRM
detail.loadingPreview
Seamlessly enrich your Agile CRM company data with official French business information from the INSEE OpenData API. This workflow automates the process of adding vital company details like official addresses and SIREN numbers, ensuring your CRM is always up-to-date.
About This Workflow
This n8n workflow is designed to automate the enrichment of your Agile CRM company records using the comprehensive French INSEE OpenData API. It retrieves all companies from your Agile CRM, filters out any entries marked as read-only, and then queries the INSEE database using the company's legal name. For each matching company, it fetches detailed information, including its official headquarters address and its unique SIREN number. Finally, it updates the Agile CRM record with this verified data, adding the SIREN to a custom field and updating the office address. This ensures your CRM data is accurate, official, and valuable for your business operations.
Key Features
- Automated Data Enrichment: Automatically pull official French company data into Agile CRM.
- Accurate Address Updates: Update company addresses with verified headquarters information from INSEE.
- SIREN Number Integration: Add the official French SIREN number to a dedicated custom field in Agile CRM.
- Data Integrity: Filter out entries marked as read-only to prevent unwanted updates.
- Customizable Scheduling: Run the enrichment process automatically on your preferred schedule.
How To Use
- Connect Agile CRM: Authenticate your Agile CRM account within n8n by adding your credentials.
- Configure INSEE API Key: In the 'Set Insee API Key' node, replace 'put-your-insee-api-key-here' with your actual INSEE API key.
- Set Custom Fields in Agile CRM: Ensure you have created the following custom fields in your Agile CRM:
- 'SIREN' (Text Field)
- 'RO' (Number Field, used to mark entries that should not be updated).
- Map Node Outputs: Verify that the output from the 'Find Company in SIREN database' and 'Request all data from SIREN database' nodes are correctly mapped to the 'Enrich CRM with INSEE Data' node, particularly for
companyId,etablissement.siren, and address details. - Test the Workflow: Click the 'Test workflow' button to execute the automation and confirm it pulls and updates data correctly.
- Activate and Schedule: Once tested, set the workflow status to 'Active' and configure the 'Schedule Trigger' to run the enrichment process at your desired frequency.
Apps Used
Workflow JSON
{
"id": "62f55332-cdd6-460b-9541-12da99e1ff8a",
"name": "Automate French Company Data Enrichment with INSEE API and Agile CRM",
"nodes": 7,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 62f55332-cdd6...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.