8
n8n 中文网amn8n.com

Gmail冷邮件序列,含Google Sheets跟踪与Slack通知

高级

这是一个Marketing领域的自动化工作流,包含 62 个节点。主要使用 If, Set, Wait, Gmail, Merge 等节点。 Gmail冷邮件序列,含Google Sheets跟踪与Slack通知

前置要求
  • Google 账号和 Gmail API 凭证
  • Slack Bot Token 或 Webhook URL
  • Google Sheets API 凭证

分类

工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "28099d2544433ae0f39c65315a4d4c531947fcb0f060a94d6047d7be5df31063"
  },
  "nodes": [
    {
      "id": "84caf762-17f0-43f3-a7ec-7529ec4d6d07",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        5800,
        -140
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "db6bcbf9-1196-4c80-a097-431ef2b9aace",
      "name": "Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        6740,
        -340
      ],
      "webhookId": "806ebfab-0c1c-4011-b116-7d06dbf16ec4",
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "9ac61303-b53d-48a4-81a1-b54cb5fa5ec1",
      "name": "切换2",
      "type": "n8n-nodes-base.switch",
      "position": [
        6740,
        -140
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "c37b59ec-0d13-44d4-ae9c-50d2d93bd2a8",
      "name": "Google Sheets9",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        7180,
        -140
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "de97e213-c036-47e8-ab78-fd37a2ba9d63",
      "name": "遍历项目4",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        6520,
        -140
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "5c08aa81-9530-49db-b8fc-94354175c5b9",
      "name": "Google Sheets8",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        6040,
        -140
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "0481574f-8022-4d0d-b13b-10e22d60a78f",
      "name": "等待4",
      "type": "n8n-nodes-base.wait",
      "position": [
        7400,
        -60
      ],
      "webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "0a9f5adf-2131-4c34-918c-15e7285502b1",
      "name": "Gmail1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        6960,
        -140
      ],
      "webhookId": "7991dbd6-9db7-4a38-ab95-b4c9756b93ee",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "ccba6cef-3ef7-48e3-896b-a43eaba2acfc",
      "name": "Gmail2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        7120,
        980
      ],
      "webhookId": "08ecae03-f38c-403c-adf1-0bf01d70946a",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "6c094cfb-b2c4-447d-a1f5-7991105cf6b6",
      "name": "已回复?",
      "type": "n8n-nodes-base.gmail",
      "position": [
        6420,
        1020
      ],
      "webhookId": "6cdae860-913e-4fa7-97af-e49f0cdcd11d",
      "parameters": {},
      "typeVersion": 2.1,
      "alwaysOutputData": true
    },
    {
      "id": "a17e6764-1bbd-4bdb-91bc-59120d6c70ed",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        6800,
        1080
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "2699dded-07da-433d-a1c5-8045f2c9fd23",
      "name": "条件判断",
      "type": "n8n-nodes-base.if",
      "position": [
        6940,
        1080
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "2392bf75-264e-4bd4-86ac-b77352397e51",
      "name": "编辑字段",
      "type": "n8n-nodes-base.set",
      "position": [
        6600,
        1020
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "e91069b4-b86c-4add-9bff-175e915bc71a",
      "name": "等待5",
      "type": "n8n-nodes-base.wait",
      "position": [
        7440,
        1160
      ],
      "webhookId": "5fcbde9f-0750-405b-8ff7-8bce2e4a16ef",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "fceef30e-954c-497f-8d2f-087a1e9d53f0",
      "name": "遍历项目5",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        6200,
        1220
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "17eae9b4-06d5-42ee-aeb9-e10381f9fb5e",
      "name": "计划触发器2",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        5720,
        1220
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "f6a4e588-54cf-4b22-8b95-5688ca21c785",
      "name": "Google Sheets6",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        7120,
        1180
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5aee383a-e158-44d5-989b-3e6d2cf2f8b7",
      "name": "Google Sheets7",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        5940,
        1220
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "3935df1f-5950-4195-ae06-dfd774e8145a",
      "name": "Google Sheets10",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        7320,
        980
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "3c1ef6c6-4e33-42c4-9a24-d2e1355cbec9",
      "name": "Slack1",
      "type": "n8n-nodes-base.slack",
      "position": [
        6740,
        900
      ],
      "webhookId": "267f4e71-4c7f-4afd-a8bd-c646da347d21",
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "0dfae213-358a-4b6e-b40a-adea6aa354bc",
      "name": "编辑字段2",
      "type": "n8n-nodes-base.set",
      "position": [
        6560,
        460
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2871c53a-d387-4b8a-94cc-14ca0364aacd",
      "name": "条件判断2",
      "type": "n8n-nodes-base.if",
      "position": [
        6900,
        420
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "a6a231dc-6e62-47fb-b1a2-a780938898cc",
      "name": "合并2",
      "type": "n8n-nodes-base.merge",
      "position": [
        6740,
        380
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "1f4ac8b2-b3c4-4569-88e8-05727cdd084b",
      "name": "已回复?2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        6400,
        460
      ],
      "webhookId": "6cdae860-913e-4fa7-97af-e49f0cdcd11d",
      "parameters": {},
      "typeVersion": 2.1,
      "alwaysOutputData": true
    },
    {
      "id": "5809a0b8-cca8-456f-8685-fe4c96aa9e92",
      "name": "计划触发器1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        5760,
        400
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "4a451140-ab91-44a6-931b-ee9af8d540fc",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        6240,
        340
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "82e8ec69-1fe7-4b21-823f-80f214ddc473",
      "name": "等待",
      "type": "n8n-nodes-base.wait",
      "position": [
        7420,
        560
      ],
      "webhookId": "5fcbde9f-0750-405b-8ff7-8bce2e4a16ef",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "cd3bd80c-42c3-4643-9548-08d0e8c7ccb5",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        5980,
        400
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "680f5400-0287-4400-84a8-1e5535586145",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        7180,
        480
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "ee0f2db4-b881-4d79-9392-47dde27d39a1",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5580,
        -380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "27caf049-83cf-4aed-a111-9f56b182cba8",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5580,
        200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "774566b9-a394-4e12-987e-527b95caa682",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5580,
        840
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cadea34d-7a39-4088-b882-66234b501dd5",
      "name": "Slack2",
      "type": "n8n-nodes-base.slack",
      "position": [
        6420,
        240
      ],
      "webhookId": "a6040d00-9752-4ed3-972c-345b60d0ed71",
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "c7ef6501-ac5c-43ad-ad08-eaf49a1de6c9",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        7120,
        260
      ],
      "webhookId": "7991dbd6-9db7-4a38-ab95-b4c9756b93ee",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "a4dba48e-e13e-4e76-af55-829ad5b15f29",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4940,
        -380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5dfcfa8e-22d2-4a8d-befd-d6c9cd64acda",
      "name": "切换1",
      "type": "n8n-nodes-base.switch",
      "position": [
        5020,
        1220
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "a7fec2be-b80e-427d-85d7-bba9ed1efdc8",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4980,
        1000
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5e46a521-eb94-41eb-806c-ad4f9e765f1a",
      "name": "计划触发器3",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        7720,
        480
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "2cf7d2aa-f2da-46c9-b023-3ff0e75bb16f",
      "name": "Slack3",
      "type": "n8n-nodes-base.slack",
      "position": [
        9000,
        -280
      ],
      "webhookId": "806ebfab-0c1c-4011-b116-7d06dbf16ec4",
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "3e83c24e-dd93-4684-b1fc-d7f84cead9e1",
      "name": "切换",
      "type": "n8n-nodes-base.switch",
      "position": [
        9000,
        -80
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "4a84fbd0-51b7-48c8-afe0-2c964b381df5",
      "name": "Google Sheets11",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        9440,
        -80
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "8a27bc70-15dd-4890-be58-eb444f94774b",
      "name": "遍历项目6",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        8780,
        -80
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "a8d9c509-44a0-448c-a7ba-2618582e0e0e",
      "name": "Google Sheets12",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        7960,
        480
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "13f9d6b0-9b4a-4432-8365-af83b85d1028",
      "name": "等待6",
      "type": "n8n-nodes-base.wait",
      "position": [
        9660,
        0
      ],
      "webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "e37b9e69-da56-4da0-9ea0-92464413834e",
      "name": "Gmail3",
      "type": "n8n-nodes-base.gmail",
      "position": [
        9220,
        -80
      ],
      "webhookId": "7991dbd6-9db7-4a38-ab95-b4c9756b93ee",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "9a27afa2-0d9c-4617-a2cb-caa28e57633b",
      "name": "切换3",
      "type": "n8n-nodes-base.switch",
      "position": [
        8400,
        480
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "8d57b350-9c3c-48b3-b98e-af2f312cc4c1",
      "name": "Slack4",
      "type": "n8n-nodes-base.slack",
      "position": [
        9020,
        280
      ],
      "webhookId": "806ebfab-0c1c-4011-b116-7d06dbf16ec4",
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "9156f873-a675-4ca7-bf5e-5c43ba4d3c85",
      "name": "切换4",
      "type": "n8n-nodes-base.switch",
      "position": [
        9020,
        480
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "5453c9f0-b911-4766-8b11-dcd88c153fc1",
      "name": "Google Sheets13",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        9460,
        480
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5ed60660-7b33-4619-9f33-124ebe00d89a",
      "name": "遍历项目7",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        8800,
        480
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "edf9f03f-e0c9-4917-b095-82584c7496da",
      "name": "等待7",
      "type": "n8n-nodes-base.wait",
      "position": [
        9680,
        560
      ],
      "webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "2e2c5f39-f56f-47e0-9324-8bda8da210e2",
      "name": "Gmail4",
      "type": "n8n-nodes-base.gmail",
      "position": [
        9240,
        480
      ],
      "webhookId": "7991dbd6-9db7-4a38-ab95-b4c9756b93ee",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "212fed9b-4952-4937-ad01-40ffa29ec2cd",
      "name": "Slack5",
      "type": "n8n-nodes-base.slack",
      "position": [
        9020,
        780
      ],
      "webhookId": "806ebfab-0c1c-4011-b116-7d06dbf16ec4",
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "cd095e10-2b91-4e22-b184-9c24c1ade508",
      "name": "切换5",
      "type": "n8n-nodes-base.switch",
      "position": [
        9020,
        980
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "793f16a7-8876-403c-b1cb-ad044865b514",
      "name": "Google Sheets14",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        9460,
        980
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "537865b4-d8a1-493b-b23d-2ee5c902565c",
      "name": "遍历项目8",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        8800,
        980
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "1aaed1ae-5855-4018-905a-eafe98b2eec7",
      "name": "等待8",
      "type": "n8n-nodes-base.wait",
      "position": [
        9680,
        1060
      ],
      "webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "5250bc18-d24b-41ec-962b-84c9d2445474",
      "name": "Gmail5",
      "type": "n8n-nodes-base.gmail",
      "position": [
        9240,
        980
      ],
      "webhookId": "7991dbd6-9db7-4a38-ab95-b4c9756b93ee",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "19c365a0-2f3e-4c6e-9035-fca98103165c",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        7660,
        -380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b0057cdf-a691-4829-bb9f-bccc6e90fb7d",
      "name": "条件判断1",
      "type": "n8n-nodes-base.if",
      "position": [
        8180,
        480
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "e5bb4c7e-1231-4040-850f-d36099267cef",
      "name": "条件判断3",
      "type": "n8n-nodes-base.if",
      "position": [
        5000,
        840
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "8ab0b11e-1561-4c4b-bf49-fdd0277bce64",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4980,
        600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Google Sheets6",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Gmail2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If1": {
      "main": [
        [
          {
            "node": "Switch3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If2": {
      "main": [
        [
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait4": {
      "main": [
        [
          {
            "node": "Loop Over Items4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait5": {
      "main": [
        [
          {
            "node": "Loop Over Items5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait6": {
      "main": [
        [
          {
            "node": "Loop Over Items6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait7": {
      "main": [
        [
          {
            "node": "Loop Over Items7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait8": {
      "main": [
        [
          {
            "node": "Loop Over Items8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail1": {
      "main": [
        [
          {
            "node": "Google Sheets9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail2": {
      "main": [
        [
          {
            "node": "Google Sheets10",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail3": {
      "main": [
        [
          {
            "node": "Google Sheets11",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail4": {
      "main": [
        [
          {
            "node": "Google Sheets13",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail5": {
      "main": [
        [
          {
            "node": "Google Sheets14",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge2": {
      "main": [
        [
          {
            "node": "If2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Gmail3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch2": {
      "main": [
        [
          {
            "node": "Gmail1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch3": {
      "main": [
        [
          {
            "node": "Loop Over Items6",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Items7",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Items8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch4": {
      "main": [
        [
          {
            "node": "Gmail4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch5": {
      "main": [
        [
          {
            "node": "Gmail5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Replied?": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Replied?2": {
      "main": [
        [
          {
            "node": "Edit Fields2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Edit Fields2": {
      "main": [
        [
          {
            "node": "Merge2",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets6": {
      "main": [
        [
          {
            "node": "Loop Over Items5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets7": {
      "main": [
        [
          {
            "node": "Loop Over Items5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets8": {
      "main": [
        [
          {
            "node": "Loop Over Items4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets9": {
      "main": [
        [
          {
            "node": "Wait4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets10": {
      "main": [
        [
          {
            "node": "Wait5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets11": {
      "main": [
        [
          {
            "node": "Wait6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets12": {
      "main": [
        [
          {
            "node": "If1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets13": {
      "main": [
        [
          {
            "node": "Wait7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets14": {
      "main": [
        [
          {
            "node": "Wait8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Slack2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Replied?2",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items4": {
      "main": [
        [
          {
            "node": "Slack",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Switch2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items5": {
      "main": [
        [
          {
            "node": "Slack1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Replied?",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items6": {
      "main": [
        [
          {
            "node": "Slack3",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items7": {
      "main": [
        [
          {
            "node": "Slack4",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Switch4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items8": {
      "main": [
        [
          {
            "node": "Slack5",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Switch5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger2": {
      "main": [
        [
          {
            "node": "Google Sheets7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger3": {
      "main": [
        [
          {
            "node": "Google Sheets12",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 营销

需要付费吗?

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

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

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

作者
Electrabot

Electrabot

@vansh404

AI Automation Agency Based In Canada Reach out to me if you need any help -https://www.linkedin.com/in/vansharoraa/

外部链接
在 n8n.io 查看

分享此工作流