8
n8n 中文网amn8n.com

按域名提取Google Ads创意

高级

这是一个AI, Marketing领域的自动化工作流，包含 16 个节点。主要使用 Set, Switch, Function, HttpRequest, ManualTrigger 等节点，结合人工智能技术实现智能自动化。 使用SerpAPI按域名提取Google Ads创意并导出为CSV

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

使用的节点 (16)

Set
Switch
Function
StickyNote
HttpRequest
ManualTrigger
SpreadsheetFile

分类

人工智能
营销
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "04fd795d32aabb18b913b4a3350b5cd0e9313a422ea0e7bdac0da2fb76cac9f7"
  },
  "nodes": [
    {
      "id": "65aafe70-bcfb-4c28-96dd-17d9dd2f4203",
      "name": "获取广告第 1 页",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -380,
        580
      ],
      "parameters": {
        "url": "https://serpapi.com/search.json",
        "options": {},
        "authentication": "genericCredentialType",
        "genericAuthType": "httpQueryAuth",
        "queryParametersUi": {
          "parameter": [
            {
              "name": "engine",
              "value": "google_ads_transparency_center"
            },
            {
              "name": "text",
              "value": "={{$json[\"domain\"]}}"
            },
            {
              "name": "region",
              "value": "={{$json[\"region\"]}}"
            },
            {
              "name": "api_key",
              "value": "your_serpapi_key"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "6158066c-e944-42cf-9a40-5c2c309a8567",
      "name": "当点击\"测试工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1260,
        580
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "15dea6e9-0a6a-4ba1-ae36-7234f5f3ff13",
      "name": "设置域名和区域",
      "type": "n8n-nodes-base.set",
      "position": [
        -820,
        580
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "domain",
              "value": "example.com"
            },
            {
              "name": "region",
              "value": "example_region_code"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "8b768e62-6697-491e-89d6-6fa40aa36619",
      "name": "提取广告创意",
      "type": "n8n-nodes-base.function",
      "position": [
        60,
        580
      ],
      "parameters": {
        "functionCode": "const targetDomain = items[0].json.search_parameters.text.toLowerCase();\n\nreturn items[0].json.ad_creatives\n  .filter(ad => (ad.target_domain || '').toLowerCase() === targetDomain)\n  .map(ad => ({ json: ad }));\n"
      },
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "50bcee68-570e-4b2f-bc14-3e5148f63ed6",
      "name": "按格式 1 分割",
      "type": "n8n-nodes-base.switch",
      "rules": {
        "rules": [
          {
            "value1": "text",
            "operation": "equal"
          },
          {
            "value1": "image",
            "operation": "equal"
          },
          {
            "value1": "video",
            "operation": "equal"
          }
        ]
      },
      "position": [
        500,
        560
      ],
      "parameters": {
        "rules": {
          "rules": [
            {
              "value2": "text"
            },
            {
              "output": 1,
              "value2": "image"
            },
            {
              "output": 2,
              "value2": "video"
            }
          ]
        },
        "value1": "={{$json[\"format\"]}}",
        "dataType": "string"
      },
      "typeVersion": 1
    },
    {
      "id": "5a385bb4-a7eb-4327-8719-311ba61fe82a",
      "name": "将文本广告转换为 CSV",
      "type": "n8n-nodes-base.spreadsheetFile",
      "position": [
        900,
        220
      ],
      "parameters": {
        "options": {
          "fileName": "=/files/text_{{ $json.target_domain }}_ads.csv"
        },
        "operation": "toFile"
      },
      "typeVersion": 1
    },
    {
      "id": "2860d7c8-8c45-4d13-964d-40d6565e7a18",
      "name": "将图片广告转换为 CSV",
      "type": "n8n-nodes-base.spreadsheetFile",
      "position": [
        900,
        680
      ],
      "parameters": {
        "options": {
          "fileName": "=/files/image_{{ $json.target_domain }}_ads.csv"
        },
        "operation": "toFile",
        "fileFormat": "csv"
      },
      "typeVersion": 1
    },
    {
      "id": "2240db0a-0cb3-4449-a187-6daa52bca0fd",
      "name": "将视频广告转换为 CSV1",
      "type": "n8n-nodes-base.spreadsheetFile",
      "position": [
        900,
        1120
      ],
      "parameters": {
        "options": {
          "fileName": "=/files/video_{{ $json.target_domain }}_ads.csv"
        },
        "operation": "toFile",
        "fileFormat": "csv"
      },
      "typeVersion": 1
    },
    {
      "id": "bc86000d-ed7b-4690-a19e-3b9819024c8b",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1380,
        120
      ],
      "parameters": {
        "color": 7,
        "width": 360,
        "height": 420,
        "content": "# 节点注释"
      },
      "typeVersion": 1
    },
    {
      "id": "431fdfd5-9550-4eca-8489-26fb126e828e",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -940,
        120
      ],
      "parameters": {
        "width": 360,
        "height": 420,
        "content": "# ✏️ 设置域名和区域"
      },
      "typeVersion": 1
    },
    {
      "id": "245857fd-4405-4f75-95d1-41d7374b770a",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -500,
        120
      ],
      "parameters": {
        "width": 360,
        "height": 420,
        "content": "# 🌐 获取广告第 1 页"
      },
      "typeVersion": 1
    },
    {
      "id": "59c2eab0-ce67-463b-aaea-bf5c69fcb15e",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        120
      ],
      "parameters": {
        "width": 360,
        "height": 420,
        "content": "# 🧠 提取广告创意"
      },
      "typeVersion": 1
    },
    {
      "id": "e87811c5-2f2a-4bd4-828b-ec4333393839",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        120
      ],
      "parameters": {
        "width": 360,
        "height": 420,
        "content": "# 🔀 按格式分割"
      },
      "typeVersion": 1
    },
    {
      "id": "f18950f7-9c67-4ffb-8c89-b2b70287db05",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1140,
        120
      ],
      "parameters": {
        "color": 4,
        "width": 500,
        "height": 300,
        "content": "# 📄 将文本广告转换为 CSV"
      },
      "typeVersion": 1
    },
    {
      "id": "25d6d14b-e4c7-40e4-97be-b422871cc756",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1140,
        580
      ],
      "parameters": {
        "color": 4,
        "width": 500,
        "height": 300,
        "content": "# 🖼️ 将图片广告转换为 CSV"
      },
      "typeVersion": 1
    },
    {
      "id": "7d05ce27-42ee-4799-807a-eeb204b05553",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1140,
        1040
      ],
      "parameters": {
        "color": 4,
        "width": 500,
        "height": 300,
        "content": "# 🎞️ 将视频广告转换为 CSV"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Get Ads Page 1": {
      "main": [
        [
          {
            "node": "Extract Ad Creatives",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split by Format1": {
      "main": [
        [
          {
            "node": "Convert Text Ads to CSV",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Convert Image Ads to CSV",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Convert Video Ads to CSV1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Domain & Region": {
      "main": [
        [
          {
            "node": "Get Ads Page 1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Ad Creatives": {
      "main": [
        [
          {
            "node": "Split by Format1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Set Domain & Region",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 人工智能, 营销

需要付费吗？

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

相关工作流推荐

Brave搜索结构化数据提取（Bright Data MCP + Google Gemini）
使用Bright Data MCP和Google Gemini从Brave搜索中提取结构化数据
Set
Switch
Function
+9
24 节点Ranjan Dailata
人工智能
AI个性化多产品邮件营销
基于SMTP轮换的AI个性化多产品邮件营销（GPT-4o/o3-mini）
If
Code
Wait
+16
41 节点Badr
销售
## 🤖 **LIGUA033/LOREALCANTARA - 其他生成工作流**
基于AI的Meta广告分析与创建：使用Gemini、GPT-4.1 Mini和广告管理器
If
Set
Wait
+13
61 节点Daniel Setzermann
人工智能
YouTube
使用 Google Sheets 和 Telegram 提醒自动转发 TikTok 视频到 YouTube Shorts
Set
Code
Function
+7
22 节点Arkady Reveinz
人工智能
使用 Bright Data 抓取和 Google Gemini 自动化 Etsy 数据挖掘
使用 Bright Data 抓取和 Google Gemini 实现 Etsy 数据挖掘自动化
Set
Function
Split Out
+8
19 节点Ranjan Dailata
产品
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
If
Set
Code
+21
40 节点Immanuel
人工智能
工作流信息
难度等级
高级
节点数量16
分类2
节点类型7
难度说明

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

作者
Nikan Noorafkan

Nikan Noorafkan

@nikkannoora

Hey, I’m Nikan Noorafkan — a creator passionate about building smart, automated workflows that drive business outcomes. With a background in performance marketing, user acquisition, and retention strategies, I use n8n to connect data, automate repetitive tasks, and scale growth across the funnel.

外部链接
在 n8n.io 查看 →

分享此工作流