自动化 Meta 广告分析

• •可能需要目标 API 的认证凭证
• •Google Sheets API 凭证
• •Google Gemini API Key

{
  "meta": {
    "instanceId": "1f5ba07b3d13878feccf2edc6715cb776b71c7f07f9111b940d134cc0b5c944e"
  },
  "nodes": [
    {
      "id": "84fd2525-1a80-42e8-b0c1-d179b96d5d31",
      "name": "README",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1520,
        -2400
      ],
      "parameters": {
        "width": 500,
        "height": 980,
        "content": "## AI Meta 广告分析师"
      },
      "typeVersion": 1
    },
    {
      "id": "501e6350-a65e-4e61-a9ca-0ec2efcb9c8b",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -848,
        -1920
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6b82376a-d57a-4be2-9354-6f891f474238",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -848,
        -2128
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "38c384ad-f9ad-4ccd-8a20-3ceefc8eec82",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -848,
        -2400
      ],
      "parameters": {
        "color": 7,
        "width": 316,
        "height": 240,
        "content": "## 1. 触发与获取 URL"
      },
      "typeVersion": 1
    },
    {
      "id": "54543b50-a2cb-44c7-8152-4be093167276",
      "name": "获取要抓取的 URL",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -560,
        -2032
      ],
      "parameters": {
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "2edfce52-e8c7-41a3-ae21-8516cf7e8957",
      "name": "请求至 scrapingflash.com",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -288,
        -2032
      ],
      "parameters": {
        "url": "https://api.scrapingflash.com/v1/facebook_ads",
        "method": "POST",
        "options": {},
        "authentication": "predefinedCredentialType",
        "nodeCredentialType": "headerAuth"
      },
      "typeVersion": 4.2
    },
    {
      "id": "c70a0c61-d6f6-44e1-9ab2-da906b67a9c7",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -2400
      ],
      "parameters": {
        "color": 7,
        "width": 332,
        "height": 224,
        "content": "## 2. 抓取 Meta 广告"
      },
      "typeVersion": 1
    },
    {
      "id": "b020da3e-8f9a-4af0-8f2e-0986725bbd45",
      "name": "拆分所有广告",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -48,
        -2032
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "body.ads"
      },
      "typeVersion": 1
    },
    {
      "id": "0765638f-61e9-40d3-b1a1-dd5b261566b6",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        160,
        -2032
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "d42b014e-63cc-41d8-8741-b7b028e74d02",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        64,
        -2400
      ],
      "parameters": {
        "color": 7,
        "width": 444,
        "height": 224,
        "content": "## 3. 处理并循环广告"
      },
      "typeVersion": 1
    },
    {
      "id": "9e197a15-e01f-479a-a149-76887d4f2fcc",
      "name": "限制为 10 个广告",
      "type": "n8n-nodes-base.limit",
      "position": [
        368,
        -2032
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "cbf96cba-eccb-4e5a-ba88-f8a6dd9a6fd7",
      "name": "分类每个 Meta 广告",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        608,
        -2032
      ],
      "parameters": {
        "text": "Analyse this D2C newsletter",
        "messages": {
          "messageValues": [
            {
              "message": "=You are a highly skilled Meta Ads Analyst, possessing a deep understanding of advertising principles, consumer psychology, and Meta's advertising platform. Your expertise lies in evaluating ad creatives (images and text) to predict their performance and provide actionable insights. Your analysis will culminate in a score (out of 5) and a concise TL;DR summarizing the ad's strengths and weaknesses.\n\nHere's the format you will use to analyze the provided Meta ad and deliver your assessment:\n\n---\n\n## Meta Ad Analysis\n\n**Ad Image:**\n**Ad Text:** \n\n\n**Analysis:**\n\n* **Strengths:** [Identify at least three strengths of the ad, explaining why they are effective. Consider elements like visual appeal, clarity of message, value proposition, call to action, and relevance to the target audience.]\n* **Weaknesses:** [Identify at least three weaknesses of the ad, explaining why they might hinder performance. Consider elements like confusing messaging, lack of visual appeal, weak call to action, irrelevance to the target audience, and potential for misinterpretation.]\n* **Potential Improvements:** [Suggest specific, actionable improvements to address the identified weaknesses. Be practical and consider the limitations of the Meta Ads platform.]\n\n**Scoring:**\n\n* **Overall Score (out of 5):** [Provide a score between 1 and 5, with 5 being an exceptionally strong ad and 1 being a very weak ad.]\n* **Justification:** [Briefly explain the reasoning behind your score, highlighting the key factors that influenced your assessment.]\n\n**TL;DR:** [Provide a concise summary (one or two sentences) of the ad's overall effectiveness and key areas for improvement.]\n\n---\n\nHere is the Meta Ad you are tasked with analyzing: [ENTER META AD IMAGE DESCRIPTION AND TEXT HERE]"
            },
            {
              "type": "HumanMessagePromptTemplate",
              "imageUrl": "=",
              "messageType": "imageUrl"
            }
          ]
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.4
    },
    {
      "id": "ac7d5925-9115-4fbf-8108-0c8a1c17a9fb",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        -2400
      ],
      "parameters": {
        "color": 7,
        "width": 348,
        "height": 224,
        "content": "## 4. 使用 Gemini AI 分析广告"
      },
      "typeVersion": 1
    },
    {
      "id": "303cc507-4916-4340-a824-85ca0a90b9af",
      "name": "Google Gemini聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        608,
        -1792
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-pro-vision"
      },
      "typeVersion": 1
    },
    {
      "id": "23e184a4-81a9-49bf-9d62-618e8c2febc5",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        864,
        -1792
      ],
      "parameters": {
        "schemaType": "manual",
        "inputSchema": "{\n  \"type\": \"object\",\n  \"properties\": {\n    \"ad_image\": {\n      \"type\": \"string\",\n      \"description\": \"Description of the ad image.\"\n    },\n    \"ad_text\": {\n      \"type\": \"string\",\n      \"description\": \"Text used in the Meta ad.\"\n    },\n    \"analysis\": {\n      \"type\": \"object\",\n      \"properties\": {\n        \"strengths\": {\n          \"type\": \"array\",\n          \"items\": { \"type\": \"string\" },\n          \"description\": \"List of at least 3 strengths with explanations.\"\n        },\n        \"weaknesses\": {\n          \"type\": \"array\",\n          \"items\": { \"type\": \"string\" },\n          \"description\": \"List of at least 3 weaknesses with explanations.\"\n        },\n        \"potential_improvements\": {\n          \"type\": \"array\",\n          \"items\": { \"type\": \"string\" },\n          \"description\": \"Specific, actionable improvement suggestions.\"\n        }\n      },\n      \"required\": [\"strengths\", \"weaknesses\", \"potential_improvements\"]\n    },\n    \"scoring\": {\n      \"type\": \"object\",\n      \"properties\": {\n        \"overall_score\": {\n          \"type\": \"number\",\n          \"minimum\": 1,\n          \"maximum\": 5,\n          \"description\": \"Overall score from 1 to 5.\"\n        },\n        \"justification\": {\n          \"type\": \"string\",\n          \"description\": \"Reasoning behind the given score.\"\n        }\n      },\n      \"required\": [\"overall_score\", \"justification\"]\n    },\n    \"tldr\": {\n      \"type\": \"string\",\n      \"description\": \"One or two sentence summary of effectiveness and key improvements.\"\n    }\n  },\n  \"required\": [\"ad_image\", \"ad_text\", \"analysis\", \"scoring\", \"tldr\"]\n}\n"
      },
      "typeVersion": 1.2
    },
    {
      "id": "08482067-31af-4586-a89e-48f493149b21",
      "name": "在表格中添加行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1152,
        -2032
      ],
      "parameters": {
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "4304793b-6545-4cd8-b35f-9143090a4897",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        992,
        -2400
      ],
      "parameters": {
        "color": 7,
        "width": 412,
        "height": 224,
        "content": "## 5. 将分析保存到 Google Sheets"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Limit to 10 ads": {
      "main": [
        [
          {
            "node": "Categorise every Meta Ads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Limit to 10 ads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get URL to scrap": {
      "main": [
        [
          {
            "node": "Request to scrapingflash.com",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get URL to scrap",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split all the ads": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Categorise every Meta Ads",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Categorise every Meta Ads",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Categorise every Meta Ads": {
      "main": [
        [
          {
            "node": "Add row in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Request to scrapingflash.com": {
      "main": [
        [
          {
            "node": "Split all the ads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get URL to scrap",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}