Agile CRMのINSEEデータリッチ化
中級
これはSales, Marketing分野の自動化ワークフローで、14個のノードを含みます。主にSet, Code, Merge, AgileCrm, HttpRequestなどのノードを使用。 Agile CRM向けINSEE企業データのリッチ化（フランス企業限定）
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "G0hO05fypS8n8uYu",
"meta": {
"instanceId": "8fb286e504ea5ce6aeb12bf5c0c97ce11908b5b1aaa495ddfa0ef349661b832e"
},
"name": "INSEE Enrichment for Agile CRM",
"tags": [],
"nodes": [
{
"id": "a45b34c1-514e-4221-b363-abf2d4de43c4",
"name": "「Test workflow」クリック時",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-3440,
-320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d406941b-80a1-43a3-ba19-2e29570192f2",
"name": "SIREN データベースで企業を検索",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
-2660,
-220
],
"parameters": {
"url": "=https://api.insee.fr/api-sirene/3.11/siren?q=periode(denominationUniteLegale:\"{{ $json.denominationUniteLegale }}\")",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
},
{
"name": "X-INSEE-Api-Key-Integration",
"value": "={{ $('Set Insee API Key').all()[0].json['X-INSEE-Api-Key-Integration'] }}"
}
]
}
},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "6ab3818b-2f09-44e2-874a-87c51478572b",
"name": "SIREN データベースから全データをリクエスト",
"type": "n8n-nodes-base.httpRequest",
"position": [
-2420,
-240
],
"parameters": {
"url": "=https://api.insee.fr/api-sirene/3.11/siret/{{ $json.unitesLegales[0].siren }}{{ $json.unitesLegales[0].periodesUniteLegale[0].nicSiegeUniteLegale }}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
},
{
"name": "X-INSEE-Api-Key-Integration",
"value": "={{ $('Set Insee API Key').all()[0].json['X-INSEE-Api-Key-Integration'] }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "89c223fe-289b-4d0f-922a-e9c0ad672b51",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3420,
-640
],
"parameters": {
"width": 460,
"height": 240,
"content": "### Enrich CRM data with data from French INSEE OpenDatabase API\nThis workflow takes all company entries from **Agile CRM** and enriches their data using the French [Insee Opendata API](https://portail-api.insee.fr/) (Free Access)\n\n__This will update :__ \n1) Official Address of the company headquarters\n2) Add government company id number (SIREN) in a Custom Field"
},
"typeVersion": 1
},
{
"id": "0bdc49dd-6f26-447f-a8ba-c2ba615dc7ec",
"name": "ReadOnly キーが設定されている企業をすべて除外",
"type": "n8n-nodes-base.code",
"position": [
-2880,
-220
],
"parameters": {
"jsCode": "// Get input data\nconst input = $input.all();\nconst output = input.filter(item => {\n const properties = item.json.properties || [];\n return !properties.some(property => property.name === \"RO\" && property.value === \"1\"); // Remove all ReadOnly entries\n}).map(item => {\n const companyId = item.json.id;\n const denominationUniteLegale = item.json.properties[0]?.value || null; \n return {\n json: {\n companyId,\n denominationUniteLegale\n }\n };\n});\n\n// Return the transformed output\nreturn output;\n"
},
"typeVersion": 2
},
{
"id": "0ef184f7-219c-4eb3-bfe0-4e68d2ce0b43",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2940,
-640
],
"parameters": {
"color": 5,
"width": 647,
"height": 232,
"content": "### 👨🎤 Setup\n1. Add your **Agile CRM** credentials\n2. Link each AgileCRM node to the correct **Agile CRM** credentials\n3. Add your **INSEE** API Key to the **\"Set Insee API Key\"** node\n4. Make sure the **Custom Fields** for the **companies** are set as below (Admin Settings):\n - Label : \"SIREN\", Type : \"Text Field\", Description \"N° de SIREN\"\n - Label : \"RO\", Type : \"Number\", Description \"Locks entry from update\"\n5. Click on **Test Workflow** to make sure everything is working\n6. Configure schedule if needed and don't forget to change status to **Active**"
},
"typeVersion": 1
},
{
"id": "78255253-195d-472d-a76c-ab63ceac126b",
"name": "Insee API キーを設定",
"type": "n8n-nodes-base.set",
"position": [
-3260,
-220
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "e993e665-cf31-48b1-8ca8-a4829dc82642",
"name": "X-INSEE-Api-Key-Integration",
"type": "string",
"value": "put-your-insee-api-key-here"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "90b13481-6570-4bfc-b3dc-4b6017c6c8b5",
"name": "スケジュールトリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-3440,
-140
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "88c8a6c6-2175-42c3-bfdb-f1d32a5d1c2d",
"name": "clean_route",
"type": "n8n-nodes-base.noOp",
"position": [
-2660,
-360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "522d83f6-752e-40b4-a889-334f0a96998b",
"name": "Agile CRM から全企業を取得",
"type": "n8n-nodes-base.agileCrm",
"position": [
-3080,
-220
],
"parameters": {
"options": {},
"resource": "company",
"operation": "getAll"
},
"credentials": {
"agileCrmApi": {
"id": "wb0EgiQFLQbiFuy4",
"name": "AgileCRM account"
}
},
"typeVersion": 1
},
{
"id": "8ff0632b-6aca-47d8-b611-72dbc8dec09b",
"name": "INSEE データで CRM をエンリッチ",
"type": "n8n-nodes-base.agileCrm",
"position": [
-1960,
-340
],
"parameters": {
"resource": "company",
"companyId": "={{ $json.companyId }}",
"operation": "update",
"additionalFields": {
"addressOptions": {
"addressProperties": [
{
"address": "={{ $json.etablissement.adresseEtablissement.complementAdresseEtablissement }}\n{{ $json.etablissement.adresseEtablissement.typeVoieEtablissement }} {{ $json.etablissement.adresseEtablissement.libelleVoieEtablissement }}\n{{ $json.etablissement.adresseEtablissement.codePostalEtablissement }}{{ $json.etablissement.adresseEtablissement.libelleCommuneEtablissement }}",
"subtype": "office"
}
]
},
"customProperties": {
"customProperty": [
{
"name": "SIREN",
"value": "={{ $json.etablissement.siren }}",
"subtype": "TEXT"
}
]
}
}
},
"credentials": {
"agileCrmApi": {
"id": "wb0EgiQFLQbiFuy4",
"name": "AgileCRM account"
}
},
"typeVersion": 1
},
{
"id": "8720be96-8181-4ea7-b114-ce0f5b8e09c1",
"name": "CRM 用にエンリッチされた CRM と SIREN データベースのデータを統合",
"type": "n8n-nodes-base.merge",
"position": [
-2180,
-340
],
"parameters": {
"mode": "combine",
"options": {},
"advanced": true,
"mergeByFields": {
"values": [
{
"field1": "denominationUniteLegale",
"field2": "etablissement.uniteLegale.denominationUniteLegale"
}
]
}
},
"typeVersion": 3
},
{
"id": "855a39e2-83ef-49d9-b630-ec31aaa96e72",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3460,
20
],
"parameters": {
"height": 80,
"content": "👆 You can use any of those two Trigger to start the process."
},
"typeVersion": 1
},
{
"id": "b003c1b8-6244-4b72-bbb0-025f563b5d71",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2260,
-640
],
"parameters": {
"width": 380,
"height": 240,
"content": "### 🗒️ Notes : \n1. This workflow is made to write over any entry already present. You can change this for each company by setting the **\"RO\"** Custom Field to **1**, making it read-only for this workflow.\n\n2. If you want to make it readonly after the update from this workflow, then **add a custom property** in the last node **Enrich CRM with INSEE Data** named **\"RO\"**, SubType **\"Number\"** and Value **\"1\"**"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9f328182-d131-4300-a1f4-2cb3dfe91632",
"connections": {
"88c8a6c6-2175-42c3-bfdb-f1d32a5d1c2d": {
"main": [
[
{
"node": "8720be96-8181-4ea7-b114-ce0f5b8e09c1",
"type": "main",
"index": 0
}
]
]
},
"90b13481-6570-4bfc-b3dc-4b6017c6c8b5": {
"main": [
[
{
"node": "78255253-195d-472d-a76c-ab63ceac126b",
"type": "main",
"index": 0
}
]
]
},
"78255253-195d-472d-a76c-ab63ceac126b": {
"main": [
[
{
"node": "522d83f6-752e-40b4-a889-334f0a96998b",
"type": "main",
"index": 0
}
]
]
},
"d406941b-80a1-43a3-ba19-2e29570192f2": {
"main": [
[
{
"node": "6ab3818b-2f09-44e2-874a-87c51478572b",
"type": "main",
"index": 0
}
]
]
},
"522d83f6-752e-40b4-a889-334f0a96998b": {
"main": [
[
{
"node": "0bdc49dd-6f26-447f-a8ba-c2ba615dc7ec",
"type": "main",
"index": 0
}
]
]
},
"a45b34c1-514e-4221-b363-abf2d4de43c4": {
"main": [
[
{
"node": "78255253-195d-472d-a76c-ab63ceac126b",
"type": "main",
"index": 0
}
]
]
},
"6ab3818b-2f09-44e2-874a-87c51478572b": {
"main": [
[
{
"node": "8720be96-8181-4ea7-b114-ce0f5b8e09c1",
"type": "main",
"index": 1
}
]
]
},
"0bdc49dd-6f26-447f-a8ba-c2ba615dc7ec": {
"main": [
[
{
"node": "d406941b-80a1-43a3-ba19-2e29570192f2",
"type": "main",
"index": 0
},
{
"node": "88c8a6c6-2175-42c3-bfdb-f1d32a5d1c2d",
"type": "main",
"index": 0
}
]
]
},
"8720be96-8181-4ea7-b114-ce0f5b8e09c1": {
"main": [
[
{
"node": "8ff0632b-6aca-47d8-b611-72dbc8dec09b",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 営業, マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Overpassリードジェネレーションシステム
OpenStreetMap データを使ってビジネスリードを生成して Google Sheets に保存
If
Set
Code
+
If
Set
Code
27 ノードAkram Kadri
営業
OpenAI、Google Sheets、Jina AI、Slackを活用したAI駆動型情報監視
AIベースの情報監視ワークフローで、OpenAI、Google Sheets、Jina AI、Slackを統合
If
Set
Code
+
If
Set
Code
31 ノードDataki
営業
Googleスプレッドシートに保存されているLinkedInプロファイルURLを豊富にする
Googleスプレッドシートに保存されているLinkedInプロフィールURLの情報を豊富にする
If
Set
Merge
+
If
Set
Merge
11 ノードAlQaisi
営業
AI生成されたPDFファイルの改訂职场自動化方案提出
Google Mapsを使ってリードを生成する
If
Set
Code
+
If
Set
Code
42 ノードAlex Kim
営業
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
自動WordPressブログ生成ツール（GPT＋Postgres＋WPメディア）
GPT-4、Postgresで追跡して自動生成してWordPressにSEO記事を投稿する
Set
Code
Merge
+
Set
Code
Merge
46 ノードAlexWantMoreB
人工知能
