8
n8n 中文网amn8n.com

从Google Sheets在SinergiaCRM中创建联系人和活动注册

高级

这是一个CRM, Multimodal AI领域的自动化工作流，包含 20 个节点。主要使用 If, Set, Merge, GoogleSheets, SinergiaCrm 等节点。 Google Sheets到SinergiaCRM：自动化活动参与者注册

前置要求
  • •Google Sheets API 凭证

使用的节点 (20)

If
Set
Merge
StickyNote
GoogleSheets
SinergiaCrm
GoogleSheetsTrigger

分类

客户关系管理
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "ekpF9klMhZsn7kDH",
  "meta": {
    "instanceId": "863f6f16da50abd2de4a658ee58a61c1f2392ca5348eff8a1ce770be81c4514b",
    "templateCredsSetupCompleted": true
  },
  "name": "从 Google Sheets 在 SinergiaCRM 中创建联系人和活动注册",
  "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：标记已处理 = 是",
      "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：发送到 CRM == 是",
      "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：未处理 == 否",
      "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：标记已处理 = 是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": "## 工作流概览"
      },
      "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 设置"
      },
      "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 要求"
      },
      "typeVersion": 1
    },
    {
      "id": "99bf98a7-ca7b-45ce-a4fb-7dfdf1385d0a",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        -1344
      ],
      "parameters": {
        "width": 448,
        "height": 768,
        "content": "## 联系人检查逻辑"
      },
      "typeVersion": 1
    },
    {
      "id": "9d101aeb-60a5-4405-a1c1-f979dbe4d8e6",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2080,
        -1344
      ],
      "parameters": {
        "width": 448,
        "height": 768,
        "content": "## 标记行为已处理"
      },
      "typeVersion": 1
    },
    {
      "id": "8fd28865-6c05-4637-b289-5dd948664915",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2544,
        -976
      ],
      "parameters": {
        "width": 448,
        "height": 400,
        "content": "## 故障排除提示"
      },
      "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）可能需要您自行付费。

相关工作流推荐

使用MagicHour和Gemini从Google
使用MagicHour和Gemini从Google Sheets每日创建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表格邮件通知和时间跟踪的自动化潜在客户到客户管道
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中记录电商订单，支持月度分页和状态跟踪
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
难度说明

适合高级用户，包含 16+ 个节点的复杂工作流

作者
Javier Quilez Cabello

Javier Quilez Cabello

@javierquilez

As 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 查看 →

分享此工作流

分类

多模态 AI
1540
人工智能
1108
内容创作
695
AI 摘要总结
516
营销
419
AI 聊天机器人
251
工程
241
市场调研
203
杂项
193
其他
176
销售
162
IT 运维
156
文档提取
147
AI RAG 检索增强
146
构建模块
144
社交媒体
137
潜在客户开发
125
个人效率
117
开发运维
111
人力资源
101
客户支持
97
客户培育
87
客户关系管理
82
财务
81
产品
77
客服机器人
76
设计
70
工单管理
67
安全运维
57
发票处理
53
加密货币交易
49
文件管理
39
项目管理
35
内部知识库
32

分类: 34