Google SheetsからSinergiaCRMで連絡先とアクティビティ登録を作成
上級
これはCRM, Multimodal AI分野の自動化ワークフローで、20個のノードを含みます。主にIf, Set, Merge, GoogleSheets, SinergiaCrmなどのノードを使用。 Google SheetsからSinergiaCRMへの自動化：イベント参加者登録
前提条件
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "ekpF9klMhZsn7kDH",
"meta": {
"instanceId": "863f6f16da50abd2de4a658ee58a61c1f2392ca5348eff8a1ce770be81c4514b",
"templateCredsSetupCompleted": true
},
"name": "Create contacts and event registrations in SinergiaCRM from Google Sheets",
"tags": [
{
"id": "52gEP1RAeC1i5aJZ",
"name": "n8n Creator",
"createdAt": "2025-08-27T11:32:09.072Z",
"updatedAt": "2025-08-27T11:32:09.072Z"
}
],
"nodes": [
{
"id": "9425f505-8d3e-43f7-bd40-c578a1eb6026",
"name": "Google Sheetsトリガー",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-64,
-848
],
"parameters": {
"event": "rowAdded",
"options": {
"valueRender": "FORMATTED_VALUE"
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit?usp=drivesdk",
"cachedResultName": "SinergiaCRM - Workflows"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "N5cHO7MFUHqbOE1E",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "92e25a51-e446-4a28-ba0a-fc9687d13c0c",
"name": "SinergiaCRM: 連絡先作成",
"type": "n8n-nodes-sinergiacrm.sinergiaCrm",
"position": [
1504,
-752
],
"parameters": {
"data": "={\n \"first_name\": \"{{ $json['First name'] }}\",\n \"last_name\": \"{{ $json['Last name'] }}\",\n \"email1\": \"{{ $json.Email }}\",\n \"stic_identification_type_c\": \"nif\",\n \"stic_identification_number_c\": \"{{ $json.NIF }}\"\n}\n",
"module": "Contacts",
"operation": "create"
},
"credentials": {
"SinergiaCRMCredentials": {
"id": "ojmiJxUk7IYJooG3",
"name": "SinergiaCRM account 2"
}
},
"typeVersion": 1
},
{
"id": "2700a9e3-1fc6-4b38-b6e6-6049e52d85a7",
"name": "SinergiaCRM: リレーションシップ作成",
"type": "n8n-nodes-sinergiacrm.sinergiaCrm",
"position": [
1504,
-944
],
"parameters": {
"data": "={\n \"start_date\": \"{{ $json['Relation date'] }}\",\n \"relationship_type\": \"{{ $json['Relation type'] }}\",\n \"stic_contacts_relationships_contactscontacts_ida\": \"{{ $json.id }}\",\n \"assigned_user_id\": \"2\"\n}",
"module": "stic_Contacts_Relationships",
"operation": "create"
},
"credentials": {
"SinergiaCRMCredentials": {
"id": "ojmiJxUk7IYJooG3",
"name": "SinergiaCRM account 2"
}
},
"typeVersion": 1
},
{
"id": "ff4db6a7-3545-4d1f-9c15-96cfd99b2cc0",
"name": "SinergiaCRM: 登録作成",
"type": "n8n-nodes-sinergiacrm.sinergiaCrm",
"position": [
1728,
-944
],
"parameters": {
"data": "={\n \"stic_registrations_contactscontacts_ida\": \"{{ $('IF: Person exist').item.json.id }}\",\n \"stic_registrations_stic_eventsstic_events_ida\": \"{{ $('IF: Person exist').item.json['Event ID'] }}\",\n \"participation_type\": \"attendant\",\n \"attendees\": \"1\",\n \"assigned_user_id\": \"2\",\n \"status\": \"confirmed\",\n \"registration_date\": \"{{ $('IF: Person exist').item.json['Registration date'] }}\"\n}",
"module": "stic_Registrations",
"operation": "create"
},
"credentials": {
"SinergiaCRMCredentials": {
"id": "ojmiJxUk7IYJooG3",
"name": "SinergiaCRM account 2"
}
},
"typeVersion": 1
},
{
"id": "e9c8836d-8f17-421c-b28d-e6b5608bb682",
"name": "Google Sheets: 処理済みマーク = Sí",
"type": "n8n-nodes-base.googleSheets",
"position": [
2176,
-944
],
"parameters": {
"columns": {
"value": {
"NIF": "={{ $('IF: Person exist').item.json.NIF }}",
"Processed": "Yes"
},
"schema": [
{
"id": "First name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "First name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NIF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NIF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Relation type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Relation type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Relation date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Relation date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Event ID",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Event ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Registration date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Registration date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "To CRM",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "To CRM",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Processed",
"type": "string",
"display": true,
"required": false,
"displayName": "Processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"NIF"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit?usp=drivesdk",
"cachedResultName": "SinergiaCRM - Workflows"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "u5nmgtcJQ2F1YzhC",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "1fe200ba-1909-4c3b-925b-5b80340b712b",
"name": "IF: to CRM == Yes",
"type": "n8n-nodes-base.if",
"position": [
160,
-848
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "140b0257-5336-4f90-aceb-ecae84dedb32",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json['To CRM'] }}",
"rightValue": "Yes"
}
]
}
},
"typeVersion": 2
},
{
"id": "af5074a1-11ef-4a81-b167-dbf89dae317f",
"name": "IF: 未処理 == No",
"type": "n8n-nodes-base.if",
"position": [
384,
-848
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f174aa87-e1ee-4877-9de8-282b314724e4",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Processed }}",
"rightValue": "No"
}
]
}
},
"typeVersion": 2
},
{
"id": "64c626cd-b7d0-4c87-a59f-77e06a8194aa",
"name": "IF: 人物が存在",
"type": "n8n-nodes-base.if",
"position": [
1280,
-848
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "92d7b7c4-2564-4eec-ab05-586340a484ec",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.id }}",
"rightValue": ""
}
]
}
},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "dfac6070-5bf8-4729-b4f8-fb9f419f63da",
"name": "NIFで人物を検索",
"type": "n8n-nodes-sinergiacrm.sinergiaCrm",
"position": [
608,
-976
],
"parameters": {
"module": "Contacts",
"options": {
"filters": {
"Filter": [
{
"field": "stic_identification_number_c",
"value": "={{ $json.NIF }}"
}
]
}
}
},
"credentials": {
"SinergiaCRMCredentials": {
"id": "ojmiJxUk7IYJooG3",
"name": "SinergiaCRM account 2"
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "92859515-4463-4c38-ba53-d0c4fdf426e8",
"name": "CRMのIDを結合",
"type": "n8n-nodes-base.merge",
"position": [
832,
-848
],
"parameters": {
"mode": "combine",
"options": {},
"advanced": true,
"joinMode": "enrichInput2",
"mergeByFields": {
"values": [
{
"field1": "attributes.stic_identification_number_c",
"field2": "NIF"
}
]
}
},
"typeVersion": 3.2
},
{
"id": "005a1758-b6ac-40ef-8951-57fbb715447e",
"name": "SinergiaCRM: リレーションシップ作成1",
"type": "n8n-nodes-sinergiacrm.sinergiaCrm",
"position": [
1728,
-752
],
"parameters": {
"data": "={\n \"start_date\": \"{{ $('IF: Person exist').item.json['Relation date'] }}\",\n \"relationship_type\": \"{{ $('IF: Person exist').item.json['Relation type'] }}\",\n \"stic_contacts_relationships_contactscontacts_ida\": \"{{ $json.id }}\",\n \"assigned_user_id\": \"2\"\n}",
"module": "stic_Contacts_Relationships",
"operation": "create"
},
"credentials": {
"SinergiaCRMCredentials": {
"id": "ojmiJxUk7IYJooG3",
"name": "SinergiaCRM account 2"
}
},
"typeVersion": 1
},
{
"id": "f1485c90-4ac8-45ce-b835-35ee6fe91399",
"name": "SinergiaCRM: 登録作成1",
"type": "n8n-nodes-sinergiacrm.sinergiaCrm",
"position": [
1952,
-752
],
"parameters": {
"data": "={\n \"stic_registrations_contactscontacts_ida\": \"{{ $('SinergiaCRM: Create Contact').item.json.id }}\",\n \"stic_registrations_stic_eventsstic_events_ida\": \"{{ $('SinergiaCRM: Create Contact').item.json.id }}\",\n \"participation_type\": \"attendant\",\n \"attendees\": \"1\",\n \"assigned_user_id\": \"2\",\n \"status\": \"confirmed\",\n \"registration_date\": \"{{ $('IF: Person exist').item.json['Relation date'] }}\"\n}",
"module": "stic_Registrations",
"operation": "create"
},
"credentials": {
"SinergiaCRMCredentials": {
"id": "ojmiJxUk7IYJooG3",
"name": "SinergiaCRM account 2"
}
},
"typeVersion": 1
},
{
"id": "94312c1a-788a-407f-a07d-83a897ab3982",
"name": "Google Sheets: 処理済みマーク = Sí1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2176,
-752
],
"parameters": {
"columns": {
"value": {
"NIF": "={{ $('SinergiaCRM: Create Contact').item.json.attributes.stic_identification_number_c }}",
"Processed": "Yes"
},
"schema": [
{
"id": "First name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "First name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NIF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NIF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Relation type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Relation type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Relation date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Relation date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Event ID",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Event ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Registration date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Registration date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "To CRM",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "To CRM",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Processed",
"type": "string",
"display": true,
"required": false,
"displayName": "Processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"NIF"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XRjRmPPv5ToZ5ZsFQyX1o5g8pWg-rod0yOmkKO-Ec3A/edit?usp=drivesdk",
"cachedResultName": "SinergiaCRM - Workflows"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "u5nmgtcJQ2F1YzhC",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "523588fd-0d0e-4645-adac-5d58d3ea6a87",
"name": "フィールド編集",
"type": "n8n-nodes-base.set",
"position": [
1056,
-848
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "551c98ad-18dc-4123-8e7e-65f88de385e1",
"name": "First name",
"type": "string",
"value": "={{ $json['First name'] }}"
},
{
"id": "1c06fe43-c098-44bf-8701-130fa167ed34",
"name": "Last name",
"type": "string",
"value": "={{ $json['Last name'] }}"
},
{
"id": "0abf9847-0966-4fa9-8852-decd2c4e1b73",
"name": "NIF",
"type": "string",
"value": "={{ $json.NIF }}"
},
{
"id": "e32878ed-45a5-490d-8e4f-e53118da990b",
"name": "Email",
"type": "string",
"value": "={{ $json.Email }}"
},
{
"id": "78a239a1-7404-4135-bfbf-16186c509938",
"name": "Relation type",
"type": "string",
"value": "={{ $json['Relation type'] }}"
},
{
"id": "62a1c21d-410d-4008-9b88-37d9078d7a1e",
"name": "Relation date",
"type": "string",
"value": "={{ $json['Relation date'] }}"
},
{
"id": "e6081bb1-b353-41b6-8f04-bd4ce55786c7",
"name": "Registration date",
"type": "string",
"value": "={{ $json['Relation date'] }}"
},
{
"id": "c631ca9e-3c1a-47db-90a2-2c73dca606cc",
"name": "Event ID",
"type": "string",
"value": "={{ $json['Event ID'] }}"
},
{
"id": "632788f1-5b4c-4113-ae73-ee16421820c5",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "1369d32f-01d4-4167-8eaa-a22e5803d0a5",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
-976
],
"parameters": {
"width": 448,
"height": 400,
"content": "## Workflow Overview\n\nThis workflow listens for new rows in a Google Sheet and creates contact and event registration records in SinergiaCRM.\n\n### Key Steps:\n1. Google Sheets Trigger detects a new row.\n2. Checks if the row should be sent to CRM.\n3. Searches the contact by NIF.\n4. If found, registers the person and creates relationship.\n5. If not found, creates the contact first.\n6. Marks the row as processed.\n"
},
"typeVersion": 1
},
{
"id": "4cc84d89-c396-4e91-a36c-8b7d474527aa",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-1344
],
"parameters": {
"width": 416,
"height": 768,
"content": "## Google Sheet Setup\n\nMake sure your Google Sheet includes these columns:\n\n- First name\n- Last name\n- NIF\n- Email\n- Relation type\n- Relation date\n- Event ID\n- Registration date\n- To CRM → must be \"Yes\"\n- Processed → should be \"No\" to trigger\n\nOnly rows with:\n- To CRM = Yes\n- Processed = No\nwill be processed.\n\nUpdate the document ID and sheet name in the trigger settings.\n"
},
"typeVersion": 1
},
{
"id": "de331bc1-7eca-4c76-a071-e8025a7dff81",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
304,
-1344
],
"parameters": {
"width": 672,
"height": 768,
"content": "## SinergiaCRM Requirements\n\nEnsure you have the following modules available in your SinergiaCRM instance:\n\n- Contacts\n- stic_Contacts_Relationships\n- stic_Registrations\n\nEach node requires authenticated credentials.\nYou'll need to:\n1. Set up OAuth credentials for SinergiaCRM.\n2. Update the user ID (e.g. `\"assigned_user_id\": \"2\"`) if needed.\n\nCustom fields like `stic_identification_number_c` must be informed in your system.\n"
},
"typeVersion": 1
},
{
"id": "99bf98a7-ca7b-45ce-a4fb-7dfdf1385d0a",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
-1344
],
"parameters": {
"width": 448,
"height": 768,
"content": "## Contact Check Logic\n\nThis IF node decides the path:\n\n- ✅ If contact exists: continue with relationship and registration.\n- ❌ If not: create the contact first, then continue.\n\nMatching is done by NIF ( `stic_identification_number_c`).\n"
},
"typeVersion": 1
},
{
"id": "9d101aeb-60a5-4405-a1c1-f979dbe4d8e6",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2080,
-1344
],
"parameters": {
"width": 448,
"height": 768,
"content": "## Mark Row as Processed\n\nAfter a successful registration, the corresponding row in Google Sheets is updated:\n\n- Processed = \"Sí\"\n\nMatching is done by the NIF field.\nThis prevents duplicate processing of the same entry.\n\n"
},
"typeVersion": 1
},
{
"id": "8fd28865-6c05-4637-b289-5dd948664915",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2544,
-976
],
"parameters": {
"width": 448,
"height": 400,
"content": "## Troubleshooting Tips\n\n- Make sure your spreadsheet column names match exactly.\n- If no contact is created, check NIF formatting.\n- Confirm custom fields exist in your CRM.\n- Check logs for any errors returned by the API.\n\n"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": "u9Tk2Qoss5uVjdTl",
"executionOrder": "v1",
"executionTimeout": 900,
"saveExecutionProgress": true,
"timeSavedPerExecution": 5
},
"versionId": "6c8968d1-eb9c-4dc5-9591-d8c5784614dc",
"connections": {
"523588fd-0d0e-4645-adac-5d58d3ea6a87": {
"main": [
[
{
"node": "64c626cd-b7d0-4c87-a59f-77e06a8194aa",
"type": "main",
"index": 0
}
]
]
},
"64c626cd-b7d0-4c87-a59f-77e06a8194aa": {
"main": [
[
{
"node": "2700a9e3-1fc6-4b38-b6e6-6049e52d85a7",
"type": "main",
"index": 0
}
],
[
{
"node": "92e25a51-e446-4a28-ba0a-fc9687d13c0c",
"type": "main",
"index": 0
}
]
]
},
"1fe200ba-1909-4c3b-925b-5b80340b712b": {
"main": [
[
{
"node": "af5074a1-11ef-4a81-b167-dbf89dae317f",
"type": "main",
"index": 0
}
],
[]
]
},
"dfac6070-5bf8-4729-b4f8-fb9f419f63da": {
"main": [
[
{
"node": "92859515-4463-4c38-ba53-d0c4fdf426e8",
"type": "main",
"index": 0
}
]
]
},
"92859515-4463-4c38-ba53-d0c4fdf426e8": {
"main": [
[
{
"node": "523588fd-0d0e-4645-adac-5d58d3ea6a87",
"type": "main",
"index": 0
}
]
]
},
"9425f505-8d3e-43f7-bd40-c578a1eb6026": {
"main": [
[
{
"node": "1fe200ba-1909-4c3b-925b-5b80340b712b",
"type": "main",
"index": 0
}
]
]
},
"af5074a1-11ef-4a81-b167-dbf89dae317f": {
"main": [
[
{
"node": "dfac6070-5bf8-4729-b4f8-fb9f419f63da",
"type": "main",
"index": 0
},
{
"node": "92859515-4463-4c38-ba53-d0c4fdf426e8",
"type": "main",
"index": 1
}
],
[]
]
},
"92e25a51-e446-4a28-ba0a-fc9687d13c0c": {
"main": [
[
{
"node": "005a1758-b6ac-40ef-8951-57fbb715447e",
"type": "main",
"index": 0
}
]
]
},
"ff4db6a7-3545-4d1f-9c15-96cfd99b2cc0": {
"main": [
[
{
"node": "e9c8836d-8f17-421c-b28d-e6b5608bb682",
"type": "main",
"index": 0
}
]
]
},
"2700a9e3-1fc6-4b38-b6e6-6049e52d85a7": {
"main": [
[
{
"node": "ff4db6a7-3545-4d1f-9c15-96cfd99b2cc0",
"type": "main",
"index": 0
}
]
]
},
"f1485c90-4ac8-45ce-b835-35ee6fe91399": {
"main": [
[
{
"node": "94312c1a-788a-407f-a07d-83a897ab3982",
"type": "main",
"index": 0
}
]
]
},
"005a1758-b6ac-40ef-8951-57fbb715447e": {
"main": [
[
{
"node": "f1485c90-4ac8-45ce-b835-35ee6fe91399",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 顧客管理, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
仕事の流れ9_旧バージョン
MagicHourとGeminiを使ってGoogleスプレッドシートから毎日YouTube動画を作成
If
Set
Code
+
If
Set
Code
31 ノードDivyansh Chauhan
コンテンツ作成
QuickBooksの顧客と見積もり作成を自動化
Google Sheetsを使用してQuickBooks顧客と見積もりの作成を自動化
If
Set
Quickbooks
+
If
Set
Quickbooks
16 ノードIntuz
顧客管理
> GSheets CRM
Google スプレッドシートメール通知と時間追跡を使った自動 prospective客から顧客へのパイプライン
If
Set
Code
+
If
Set
Code
24 ノードZiad Adel
顧客管理
Stripe決済から自動テンプレートを顧客に配送
Stripe、GPT-4o、Gmailを使った自動テンプレート配信システム
If
Code
Gmail
+
If
Code
Gmail
44 ノードRahul Joshi
顧客管理
リアルタイムステータス更新付きの自動化オーダーロガー
Google SheetsにECサイトの注文を記録し、月別ページネーションとステータス追跡をサポート
If
Set
Webhook
+
If
Set
Webhook
16 ノードRuthwik Masina
顧客管理
AI駆動型動画制作＆Instagram／TikTok／YouTubeへの自動アップロード
クラウドドライブからAI駆動の動画作成およびInstagram、TikTok、YouTubeへのアップロード
If
Set
Code
+
If
Set
Code
53 ノードDevCode Journey
コンテンツ作成
ワークフロー情報
難易度
上級
ノード数20
カテゴリー2
ノードタイプ7
作成者
Javier Quilez Cabello
@javierquilezAs a specialist in automation for non-profits, I’m dedicated to driving efficiency through open source solutions that empower NGOs. Leveraging tools like Mautic, RocketChat, Cal.com, KoBoToolbox, Nextcloud, Taiga, WordPress, WooCommerce, and Baserow, I integrate these platforms with the third-sector CRM, SinergiaCRM. Passionate about #tech4good, I develop workflows that enhance collaboration and amplify social impact. My mission is to harness automation for meaningful change. #n8n4good
外部リンク
n8n.ioで表示 →
このワークフローを共有