8
n8n 中文网amn8n.com

连接Pipedrive交易结果至GA4和Google Ads

高级

这是一个CRM领域的自动化工作流,包含 17 个节点。主要使用 If, Set, Code, Filter, SplitOut 等节点。 通过Measurement Protocol连接Pipedrive交易结果至GA4和Google Ads

前置要求
  • 可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "2718e70d3927cc6f222cd0fca1f41929053688eb8b4504451ee7746fdfef7be1",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "fa95d57a-f2b6-46ca-bb38-e28884c2e8c9",
      "name": "Pipedrive 触发器",
      "type": "n8n-nodes-base.pipedriveTrigger",
      "position": [
        -256,
        -32
      ],
      "webhookId": "ec33bea1-799e-4bd3-afdb-5d765a43e4da",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "80166a20-b905-4c1a-b651-8cda376f3d5c",
      "name": "获取交易",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        192,
        -32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e64b0e87-3839-4d9c-9571-9ebd79fa6760",
      "name": "获取人员",
      "type": "n8n-nodes-base.pipedrive",
      "position": [
        -256,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "10a27d10-b9f3-4fe6-9dba-e1cb98eee13d",
      "name": "获取人员字段",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -32,
        240
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "93fef903-0796-4a5b-a24e-a6903ff1c78d",
      "name": "获取 client_id 和 consent_granted",
      "type": "n8n-nodes-base.code",
      "position": [
        192,
        240
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "6eeec802-400a-4ce1-acc5-d4ac0f352b76",
      "name": "如果 client_id 存在且已授予同意",
      "type": "n8n-nodes-base.if",
      "position": [
        416,
        256
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "76768652-f956-40ad-96bc-759c9d518d61",
      "name": "构造 GA4 对象",
      "type": "n8n-nodes-base.code",
      "position": [
        656,
        352
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "57159bf5-56c3-464c-a557-9ee3bfb019d9",
      "name": "HTTP 请求 — 发送 GA4",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        880,
        464
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "67d35252-ecac-44ba-b64a-5184f70c9e46",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        272
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "d05bd151-eb80-4500-b55e-607c68f9e831",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        608,
        272
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "ef28a480-bbdf-49c4-9b01-86b35f576401",
      "name": "分配变量",
      "type": "n8n-nodes-base.set",
      "position": [
        -32,
        -32
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "811509a0-b914-4359-ba1a-77e9ba9eaa20",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        -1232
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "1a75cd8d-67bf-40a4-880f-cb013a6c2c00",
      "name": "获取管道的阶段",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        400,
        -32
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "5c9e0e84-08d0-4235-91a3-b99ab270415e",
      "name": "分离",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        656,
        -32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c7eb606a-f314-4213-bbda-c30021abc5ce",
      "name": "过滤器",
      "type": "n8n-nodes-base.filter",
      "position": [
        864,
        -32
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "922ae9a4-3aad-4289-8149-25f7823c7a76",
      "name": "如果阶段名称正确",
      "type": "n8n-nodes-base.if",
      "position": [
        -512,
        256
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "45e70305-559b-4e6b-b251-a9b326ba6aa7",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        -768
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Filter": {
      "main": [
        [
          {
            "node": "If correct stage name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get a deal": {
      "main": [
        [
          {
            "node": "get stages for pipeline",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get a person": {
      "main": [
        [
          {
            "node": "get personFields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Assign Variables": {
      "main": [
        [
          {
            "node": "Get a deal",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get personFields": {
      "main": [
        [
          {
            "node": "Get client_id and consent_granted",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pipedrive Trigger": {
      "main": [
        [
          {
            "node": "Assign Variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Construct GA4 object": {
      "main": [
        [
          {
            "node": "HTTP Request — Send GA4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If correct stage name": {
      "main": [
        [
          {
            "node": "Get a person",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get stages for pipeline": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get client_id and consent_granted": {
      "main": [
        [
          {
            "node": "If client_id exists and consent is given",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If client_id exists and consent is given": {
      "main": [
        [
          {
            "node": "Construct GA4 object",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

高级 - 客户关系管理

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
高级
节点数量17
分类1
节点类型9
难度说明

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

作者

Software Engineer & Automations Specialist

外部链接
在 n8n.io 查看

分享此工作流