INSEE Enrichment for Agile CRM
For Agile CRM, this automated workflow enriches company data by integrating with the French INSEE OpenDatabase API. It updates the official address of company headquarters and adds the government-issued SIREN number in a custom field, ensuring accurate and comprehensive CRM records. Scheduled to run automatically, it streamlines data management and enhances business insights.
View Large Image
Workflow Overview
For Agile CRM, this automated workflow enriches company data by integrating with the French INSEE OpenDatabase API. It updates the official address of company headquarters and adds the government-issued SIREN number in a custom field, ensuring accurate and comprehensive CRM records. Scheduled to run automatically, it streamlines data management and enhances business insights.
- Business Owners: Looking to enrich their company data for better decision-making.
- CRM Managers: Need to maintain accurate and up-to-date information about companies in Agile CRM.
- Data Analysts: Require enriched datasets for analysis and reporting.
- Developers: Interested in automating data integration processes between Agile CRM and external APIs.
- This workflow automates the process of enriching company data in Agile CRM with information from the French INSEE OpenDatabase API.
- It ensures that key company details, such as the official address and government ID number (SIREN), are updated without manual intervention, saving time and reducing errors.
- Trigger the Workflow: The workflow can be initiated either on a schedule or manually by clicking ‘Test workflow’.
- Set API Key: The INSEE API key is set to enable API calls.
- Fetch Companies: All companies from Agile CRM are retrieved.
- Filter Companies: Companies with a
ReadOnlykey set are filtered out to prevent updates on locked entries. - Find Company in SIREN Database: For each company, a request is made to the SIREN database to find matching records.
- Request Additional Data: Detailed information about the company is fetched from the SIREN database.
- Merge Data: The data from Agile CRM and the SIREN database is merged, enriching the CRM data with new information.
- Update CRM: The enriched data is then used to update the corresponding company records in Agile CRM.