8
n8n 中文网amn8n.com

按周期报告的Meta Ads广告系列

高级

这是一个Marketing领域的自动化工作流,包含 28 个节点。主要使用 If, Set, Code, Gmail, Filter 等节点。 ✨ 按周期Meta Ads广告系列报告 - 通过WhatsApp和邮件自动发送

前置要求
  • Google 账号和 Gmail API 凭证
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • Facebook Graph API 凭证

分类

工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "WSpTyf6azM6X3JFt",
  "meta": {
    "instanceId": "d49d9457bb3cc049d64d7e8d551f5988e9ee3ecf773d20cf30b8a07fb71a2d76"
  },
  "name": "按周期报告的 Meta Ads 广告系列",
  "tags": [
    {
      "id": "3IaFu4je6QHc6mn6",
      "name": "BUSINESS",
      "createdAt": "2025-04-17T15:13:19.793Z",
      "updatedAt": "2025-04-17T15:13:19.793Z"
    }
  ],
  "nodes": [
    {
      "id": "3d44cc05-4d4a-41b1-b51e-4b45496b9198",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1080,
        60
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9d5104af-eb98-482a-8e68-7393da934fc0",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -540,
        100
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4dc8a09c-b3aa-419d-8c45-0f2d3d96333a",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "dd28d994-ae91-452a-bbd6-c4c0f5939c6e",
      "name": "添加",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        0,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "27715111-64c0-4fa0-9d40-421864423074",
      "name": "过滤器",
      "type": "n8n-nodes-base.filter",
      "position": [
        -1660,
        240
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "1e4567cd-f0b7-4313-b887-22d53f2e651d",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1700,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2e3eb2c1-8bd5-48ed-b11a-846052050910",
      "name": "开始时间",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1960,
        320
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "ae3116e7-be38-4bba-8ad7-69400647de74",
      "name": "广告账户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1480,
        240
      ],
      "parameters": {},
      "typeVersion": 4.4
    },
    {
      "id": "1f6f5525-1f7e-4e4b-82a6-4f8ee0989417",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1520,
        60
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bb5614fa-c1ac-4b58-8bde-1efea7acab35",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1520,
        420
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b2bff7f3-e3eb-4ac9-86f8-859fa504ac80",
      "name": "点击下一步",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -1280,
        180
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "8c1a4b8d-05f9-45f3-8b36-dcb31a6ee1c4",
      "name": "设置数据",
      "type": "n8n-nodes-base.set",
      "position": [
        -1040,
        240
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "0b2e5a11-d87b-462e-bf05-abaad1fb6945",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -900,
        60
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0040e273-de3e-46e1-acf2-12a4b9cd89be",
      "name": "按周期统计的广告",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        -860,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2828df26-1a9e-45a0-906a-9ff4718ddad0",
      "name": "所以如果",
      "type": "n8n-nodes-base.if",
      "position": [
        -700,
        240
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "09b9062d-2759-42cf-902d-91cf91295663",
      "name": "保存数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -300,
        140
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "078d3952-c9c3-4fd1-b995-2b94c17c5298",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        -40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8954bfce-e748-4cbd-9896-cf30a5c3371a",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a24f7837-9fa4-4b10-8898-dd26fdedf41e",
      "name": "过滤是否有转化",
      "type": "n8n-nodes-base.if",
      "position": [
        -300,
        460
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "2c123f0b-977f-4295-be0b-970a495424d2",
      "name": "重命名标题",
      "type": "n8n-nodes-base.set",
      "position": [
        -140,
        420
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "122dd0a9-4b23-430e-9df2-b9e82feea6cb",
      "name": "条件分支",
      "type": "n8n-nodes-base.switch",
      "position": [
        280,
        420
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "df0c490a-7789-494f-9c15-df1719ef705f",
      "name": "通过电子邮件发送",
      "type": "n8n-nodes-base.gmail",
      "position": [
        540,
        300
      ],
      "webhookId": "9e1584cf-db6d-427c-a287-8c7ff2c2dd3e",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "fd518c5f-181f-4eba-92e5-2489953cf2b5",
      "name": "通过 WhatsApp 发送",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        540,
        460
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "b8a29fad-382e-4b23-81fe-c7f1685f2a81",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cebd5d40-fdcd-4ba7-a6c4-beea89648120",
      "name": "返回循环",
      "type": "n8n-nodes-base.noOp",
      "onError": "continueRegularOutput",
      "position": [
        800,
        500
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7b063dab-c483-4216-aee1-84a2141a7741",
      "name": "便签 10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2100,
        -40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "09239d2e-9f88-480f-bda1-679f17ebdefd",
      "name": "按创意统计的数据",
      "type": "n8n-nodes-base.code",
      "position": [
        -500,
        280
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "2f14d043-d7c8-4d57-b6e9-a0b9cde96a14",
      "name": "拆分文本",
      "type": "n8n-nodes-base.code",
      "position": [
        140,
        420
      ],
      "parameters": {},
      "typeVersion": 2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "baf50703-15c7-4ad8-9070-e1b8b86a01ee",
  "connections": {
    "So if": {
      "main": [
        [
          {
            "node": "Data by Creative",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Click Next",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter": {
      "main": [
        [
          {
            "node": "Ad Accounts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Send by Email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send by WhatsApp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Agregar": {
      "main": [
        [
          {
            "node": "Dismember Text",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Data": {
      "main": [
        [
          {
            "node": "Ads by Period",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Click Next": {
      "main": [
        [],
        [
          {
            "node": "Set Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start Time": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Ad Accounts": {
      "main": [
        [
          {
            "node": "Click Next",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Ads by Period": {
      "main": [
        [
          {
            "node": "So if",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Rename Titles": {
      "main": [
        [
          {
            "node": "Agregar",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send by Email": {
      "main": [
        [
          {
            "node": "Return to the loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Dismember Text": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data by Creative": {
      "main": [
        [
          {
            "node": "Save Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "Filter if there was Conversion",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send by WhatsApp": {
      "main": [
        [
          {
            "node": "Return to the loop",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Return to the loop": {
      "main": [
        [
          {
            "node": "Click Next",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter if there was Conversion": {
      "main": [
        [
          {
            "node": "Rename Titles",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Click Next",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 营销

需要付费吗?

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

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

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

作者
Amanda Benks

Amanda Benks

@amanda

Hi loves! I've been making workflows for n8n for two years, and I hope you like my flows <3

外部链接
在 n8n.io 查看

分享此工作流