每日Magento 2客户同步到Google通讯录和Sheets(无重复)

中级

这是一个CRM领域的自动化工作流,包含 11 个节点。主要使用 Code、SplitOut、HttpRequest、GoogleSheets、GoogleContacts 等节点。 每日Magento 2客户同步到Google通讯录和Sheets(无重复)

前置要求
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证

分类

工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "c3b23fffea49117e798bf0289bfe84ed0e7c634b0def397db74b35f7d28d1f5f",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "9fab883b-4e0d-4a0c-bdd7-645bdcf2bc64",
      "name": "创建Google联系人",
      "type": "n8n-nodes-base.googleContacts",
      "position": [
        420,
        960
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "01a90ff9-45c4-4e4e-b70e-2a7c4b579ee2",
      "name": "拆分客户",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -20,
        960
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ac435ff1-821b-4212-a5ca-9b766c763508",
      "name": "记录同步邮件",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        420,
        760
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "7ae863b1-386e-4b24-b033-4d5c1b083a19",
      "name": "比较数据集",
      "type": "n8n-nodes-base.compareDatasets",
      "position": [
        200,
        840
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "4a18f856-216f-466a-aa91-ed016b3e9785",
      "name": "获取前一天日期",
      "type": "n8n-nodes-base.code",
      "position": [
        -460,
        960
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2
    },
    {
      "id": "09386b6e-0658-4875-9093-c8b74b971074",
      "name": "获取新客户",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -240,
        960
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "de076cab-43e3-4b31-97e6-d80a8aa64ac4",
      "name": "获取现有邮件",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -20,
        760
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 3
    },
    {
      "id": "853608e4-1ba2-4673-82c8-7bd0436c9373",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        620
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "22564aa5-ed78-426e-9d67-e4b418eb5d58",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -760,
        620
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "583ab4b6-c08d-436d-9e3d-92f006ee27e4",
      "name": "定时触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -680,
        800
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "28e76d85-dbad-4e30-aa29-06b9dff6d6b9",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -760,
        440
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Split Customers": {
      "main": [
        [
          {
            "node": "Compare Datasets",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Compare Datasets": {
      "main": [
        [],
        [],
        [],
        [
          {
            "node": "Create Google Contact",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log Synced Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Existing Emails",
            "type": "main",
            "index": 0
          },
          {
            "node": "GET PREVIOUS DATE",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GET PREVIOUS DATE": {
      "main": [
        [
          {
            "node": "Get New Customers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get New Customers": {
      "main": [
        [
          {
            "node": "Split Customers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Existing Emails": {
      "main": [
        [
          {
            "node": "Compare Datasets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Google Contact": {
      "main": [
        []
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

这是一个中级难度的工作流,适用于CRM等场景。适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

需要付费吗?

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

工作流信息
难度等级
中级
节点数量11
分类1
节点类型8
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

作者
Kanaka Kishore Kandregula

Kanaka Kishore Kandregula

@kmyprojects

Experienced Magento 2 Developer with 10+ years of expertise in building and optimizing eCommerce solutions. Over the past year, I’ve expanded my skills into workflow automation using n8n, streamlining business processes and integrating systems for efficiency. Passionate about solving complex problems, enhancing performance, and leveraging automation to drive smarter workflows.

外部链接
在 n8n.io 上查看 →

分享此工作流