Automate French Company Data Enrichment in Agile CRM
detail.loadingPreview
This n8n workflow automatically enriches your Agile CRM company records with official French company data from the INSEE OpenDatabase API. It updates company headquarters addresses and adds the government-issued SIREN identification number, ensuring your CRM always has accurate and up-to-date information.
About This Workflow
This powerful n8n workflow streamlines data management for businesses operating with French companies in Agile CRM. It systematically retrieves all company entries from your CRM, intelligently filtering out any entries marked as 'Read Only'. For each eligible company, the workflow queries the official French INSEE OpenDatabase API using the company's legal denomination (name) to fetch its unique SIREN identifier and comprehensive establishment details. Finally, it seamlessly updates your Agile CRM, populating the official company headquarters address and adding the critical SIREN number into a dedicated custom field. This automation ensures your sales, marketing, and operations teams always have access to precise and verified company information, enhancing data quality and compliance.
Key Features
- Automated Company Data Retrieval: Automatically fetches all company records from Agile CRM for enrichment.
- Intelligent Data Filtering: Skips 'Read Only' CRM entries to prevent unintended updates.
- INSEE API Integration: Seamlessly connects to the official French INSEE OpenDatabase API to retrieve comprehensive company information.
- CRM Data Enrichment: Updates company addresses and adds the official SIREN government ID directly into Agile CRM custom fields.
- Scheduled or Manual Execution: Run the workflow on a schedule or trigger it manually for on-demand data updates.
How To Use
- Agile CRM Credentials: Add your Agile CRM credentials to n8n and link them to the 'Get all Companies from Agile CRM' and 'Enrich CRM with INSEE Data' nodes.
- INSEE API Key: Replace 'put-your-insee-api-key-here' in the 'Set Insee API Key' node with your actual INSEE API Key.
- Agile CRM Custom Fields: Ensure your Agile CRM (Admin Settings) has the following custom fields for companies:
- Label: 'SIREN', Type: 'Text Field', Description: 'N° de SIREN'
- Label: 'RO', Type: 'Number', Description: 'Locks entry from update'
- Test Workflow: Click 'Test workflow' to verify all connections and data flow are working correctly.
- Activate: Set the workflow status to 'Active' and configure a schedule using the 'Schedule Trigger' node for automated execution, if desired.
Apps Used
Workflow JSON
{
"id": "e602233e-bb56-4e98-81d6-af2d8605f64b",
"name": "Automate French Company Data Enrichment in Agile CRM",
"nodes": 10,
"category": "Sales",
"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: e602233e-bb56...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
AI-Powered Upwork Proposal Automation Suite
This n8n workflow leverages AI to automate the entire freelance proposal process, from crafting personalized application text to generating professional Google Doc proposals and visual workflow diagrams. It significantly reduces manual effort, allowing freelancers to scale their client acquisition rapidly and effectively.
AI-Powered Stack Overflow Lead Generation
Unleash the power of AI to automatically scrape valuable lead data from Stack Overflow user profiles. This workflow intelligently identifies and extracts key information like names, locations, skills, and reputation, then seamlessly organizes it into your Google Sheet for effortless lead management.
Typeform to HubSpot Lead Qualification & Gmail Follow-up
Streamline your lead capture process by automatically syncing Typeform submissions to HubSpot. Qualify leads based on their interest and send personalized follow-up emails instantly. This workflow ensures no lead is missed and interested prospects receive immediate attention.