8
n8n 中文网amn8n.com

从Google表格自动创建Facebook广告

中级

这是一个Marketing领域的自动化工作流,包含 8 个节点。主要使用 Set, HttpRequest, GoogleSheets, FacebookGraphApi, GoogleSheetsTrigger 等节点。 从Google表格自动创建Facebook广告

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

分类

工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "2718e70d3927cc6f222cd0fca1f41929053688eb8b4504451ee7746fdfef7be1"
  },
  "nodes": [
    {
      "id": "d82a3afd-4d22-4886-b175-d2f78ec54f94",
      "name": "获取图片",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        480,
        20
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "9aaf29e7-17f9-453f-88fb-cd9f90611706",
      "name": "上传广告图片",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        700,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d1539410-3b66-4790-a20d-ec48276bc61d",
      "name": "Facebook 广告创意",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        920,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0481e563-bffb-4c97-addc-74ff3620270f",
      "name": "创建广告",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        1140,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "762da443-fcc0-4dc7-b024-b90b9ec563ba",
      "name": "Google Sheets 触发器",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -180,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "42c1cf13-b87d-4700-bee6-655fcc7afe8c",
      "name": "创建广告组",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        260,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7f42f413-b004-4ee3-9f1e-8bcb943e8088",
      "name": "更新 Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1360,
        20
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "1bbafbf9-5848-4009-b6b5-49e1ea6a2471",
      "name": "指定变量",
      "type": "n8n-nodes-base.set",
      "position": [
        40,
        20
      ],
      "parameters": {},
      "typeVersion": 3.4
    }
  ],
  "pinData": {
    "Google Sheets Trigger": [
      {
        "Hooks": "\"Ever wish you could sprinkle a little magic into their day, even with your busy schedule?\"",
        "ad id": "120219801541720760",
        "Render URL": "https://templated-assets.s3.amazonaws.com/render/d8785acf-a6f4-4f25-bb17-46abe7376cd4.jpg",
        "generate ad": "generated"
      }
    ]
  },
  "connections": {
    "Get image": {
      "main": [
        [
          {
            "node": "Upload Ad image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create an Ad": {
      "main": [
        [
          {
            "node": "Update Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload Ad image": {
      "main": [
        [
          {
            "node": "Facebook Ad Creative",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create an Ad Set": {
      "main": [
        [
          {
            "node": "Get image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Specify variables": {
      "main": [
        [
          {
            "node": "Create an Ad Set",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Facebook Ad Creative": {
      "main": [
        [
          {
            "node": "Create an Ad",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "Specify variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 营销

需要付费吗?

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

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

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

作者
外部链接
在 n8n.io 查看

分享此工作流