AI Facebook广告间谍工具
高级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 29 个节点。主要使用 Wait, Filter, Switch, GoogleDrive, HttpRequest 等节点。 基于Apify、OpenAI、Gemini和Google Sheets的AI Facebook广告间谍工具
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (29)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "FrfJDXvSHBhQrcon",
"meta": {
"instanceId": "d7661a849ead114a9aa6d9ceaf4160465aeb79532a35bde62160c840ffba9fc8",
"templateCredsSetupCompleted": true
},
"name": "AI Facebook 广告间谍工具",
"tags": [],
"nodes": [
{
"id": "sticky-note-1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
-400
],
"parameters": {
"width": 380,
"height": 200,
"content": "## 🕵️ 步骤 1：Facebook 广告库抓取"
},
"typeVersion": 1
},
{
"id": "sticky-note-2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
-800
],
"parameters": {
"width": 420,
"height": 240,
"content": "## 📹 步骤 2：视频广告处理流程"
},
"typeVersion": 1
},
{
"id": "sticky-note-3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
-100
],
"parameters": {
"width": 400,
"height": 220,
"content": "## 🖼️ 步骤 3：图片和文本广告处理"
},
"typeVersion": 1
},
{
"id": "sticky-note-4",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-400
],
"parameters": {
"width": 400,
"height": 220,
"content": "## 💰 商业价值与应用"
},
"typeVersion": 1
},
{
"id": "18536cf3-1626-44ee-95d5-6eb28baa712b",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1300,
-140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e201ba62-cc45-45e6-b50c-08f913a27c87",
"name": "条件分支",
"type": "n8n-nodes-base.switch",
"position": [
-640,
-140
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Video",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "9dbbe6e7-fd80-44ab-88f0-ab438cfd997e",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.snapshot.videos[0].video_sd_url }}",
"rightValue": "=https://video-"
}
]
},
"renameOutput": true
},
{
"outputKey": "Image",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0b7cee75-ca57-4946-971e-1f526b49324f",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.snapshot.images[0].original_image_url }}",
"rightValue": "https://scontent-ho"
}
]
},
"renameOutput": true
}
]
},
"options": {
"fallbackOutput": "extra",
"renameFallbackOutput": "Text"
}
},
"typeVersion": 3.2
},
{
"id": "ca9ee8b5-c562-4339-b6ad-6c7e8d31e4ef",
"name": "按点赞数筛选",
"type": "n8n-nodes-base.filter",
"position": [
-860,
-140
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c1d74591-13e8-4c79-9a34-117cc6816dfb",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.advertiser.ad_library_page_info.page_info.likes }}",
"rightValue": 1000
}
]
}
},
"typeVersion": 2.2
},
{
"id": "abdf6521-2599-4741-9dab-f6ce60775ec7",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
380,
160
],
"webhookId": "1cda7407-6321-4d8d-b532-19f42514eb63",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "56c2f9ea-5427-4cd1-a7ce-0f3b918960d2",
"name": "等待1",
"type": "n8n-nodes-base.wait",
"position": [
640,
-140
],
"webhookId": "1cda7407-6321-4d8d-b532-19f42514eb63",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "1b41ce15-b4b1-4189-940e-f4d38062619e",
"name": "下载视频",
"type": "n8n-nodes-base.httpRequest",
"position": [
-120,
-520
],
"parameters": {
"url": "={{ $json.snapshot.videos[0].video_sd_url }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "9a1730f8-c73c-4771-a718-a6729f68374c",
"name": "上传视频到云端硬盘",
"type": "n8n-nodes-base.googleDrive",
"position": [
100,
-520
],
"parameters": {
"name": "Example File",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "root",
"cachedResultName": "/ (Root folder)"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "8R2NiLt8owCA0E2O",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "decfca56-689f-4332-9813-00edf6ec00b5",
"name": "等待2",
"type": "n8n-nodes-base.wait",
"position": [
2100,
-440
],
"webhookId": "1cda7407-6321-4d8d-b532-19f42514eb63",
"parameters": {
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "6adbf90c-a132-4ef1-88f7-9ab798c955a3",
"name": "运行广告库抓取器",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1080,
-140
],
"parameters": {
"url": "https://api.apify.com/v2/acts/XtaWFhbtfxyzqrFmd/run-sync-get-dataset-items",
"method": "POST",
"options": {},
"jsonBody": "{\n \"count\": 200,\n \"period\": \"last7d\",\n \"scrapeAdDetails\": true,\n \"scrapePageAds.activeStatus\": \"active\",\n \"urls\": [\n {\n \"url\": \"https://www.facebook.com/ads/library/?active_status=active&ad_type=all&country=US&is_targeted_country=false&media_type=all&q=%22ai%20automation%22&search_type=keyword_exact_phrase&start_date[min]=2025-06-12&start_date[max]\",\n \"method\": \"GET\"\n }\n ]\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer <yourApiKey>"
},
{
"name": "Accept",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "1380cc04-7732-4070-8306-7c986c513ce7",
"name": "循环处理图片广告",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-420,
-140
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "dafb1f75-ba45-4c08-8581-5e6554de9089",
"name": "循环处理文本广告",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-420,
160
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "66fc9090-11f2-4da1-bdec-9a24be1f5669",
"name": "循环处理视频广告",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-420,
-445
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "2a753af7-acfd-4813-9fc7-1feeae3e38ec",
"name": "开始 Gemini 上传会话",
"type": "n8n-nodes-base.httpRequest",
"position": [
300,
-520
],
"parameters": {
"url": "https://generativelanguage.googleapis.com/upload/v1beta/files",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "key",
"value": "<yourApiKey>"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-Goog-Upload-Protocol",
"value": "resumable"
},
{
"name": "X-Goog-Upload-Command",
"value": "start"
},
{
"name": "X-Goog-Upload-Header-Content-Length",
"value": "={{ $json.size }}"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "fed903ba-79f3-466f-b1e3-6cc72f05f341",
"name": "重新下载视频",
"type": "n8n-nodes-base.googleDrive",
"position": [
520,
-520
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Upload Video to Drive').item.json.id }}"
},
"options": {},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "8R2NiLt8owCA0E2O",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "bf9a84ef-a025-4d08-bc70-0627c1e5f553",
"name": "上传视频到 Gemini",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
-520
],
"parameters": {
"url": "={{ $json.headers['x-goog-upload-url'] }}",
"method": "POST",
"options": {},
"sendBody": true,
"sendQuery": true,
"contentType": "binaryData",
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "key",
"value": "<yourApiKey>"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Content-Length",
"value": "={{ $('Upload Video to Drive').item.json.size }}"
},
{
"name": "X-Goog-Upload-Offset",
"value": "0"
},
{
"name": "X-Goog-Upload-Command",
"value": "upload, finalize"
}
]
},
"inputDataFieldName": "=data"
},
"typeVersion": 4.2
},
{
"id": "9f389a74-0097-4e4f-847f-c80494d9b8a8",
"name": "使用 Gemini 分析视频",
"type": "n8n-nodes-base.httpRequest",
"position": [
1220,
-520
],
"parameters": {
"url": "https://generativelanguage.googleapis.com/v1beta/models/gemini-2.0-flash:generateContent",
"method": "POST",
"options": {},
"jsonBody": "={\n \"contents\": [\n {\n \"parts\": [\n {\n \"text\": \"Describe this video in excruciating detail. Do not output anything but the description of the video.\"\n },\n {\n \"file_data\": {\n \"mime_type\": \"{{ $json.file.mimeType }}\",\n \"file_uri\": \"{{ $json.file.uri }}\"\n }\n }\n ]\n }\n ]\n}",
"sendBody": true,
"sendQuery": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "key",
"value": "<yourApiKey>"
}
]
}
},
"retryOnFail": true,
"typeVersion": 4.2,
"waitBetweenTries": 15
},
{
"id": "1528dc3d-fff4-452c-ad42-2d2e9bdf1f4e",
"name": "输出视频摘要",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1500,
-520
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1",
"cachedResultName": "GPT-4.1"
},
"options": {
"temperature": 0.7
},
"messages": {
"values": [
{
"role": "system",
"content": "You're a helpful, intelligent advertisement analysis bot. You analyze advertisements."
},
{
"content": "Your task is to take as input a scraped javascript object from an advertisement in the FB ad library, and then summarize it + spin (repurpose, rewrite) the ad copy. \n\nYou're doing this for strategic intelligence. We run an advertising agency and we're always looking at what our competitor advertisers are doing.\n\nOutput your results in this JSON format:\n\n{\"summary\":\"\",\"rewrittenAdCopy\":\"\"}\n\nRules:\n- The intended style and attitude is generally analytical, inquisitive, and precise, despite exploring complex topics, in the “classic style” of Western writing.\nthe level of formality should be inverse to the topic’s novelty: the weirder something is, the more formal. For ‘safer’ topics, one should cut loose with the humor, epigraphs, typographical stunts and experiments, etc.\n- Avoid hedging and qualifying, even at the risk of making overly-strong claims. It is a slippery slope.\n- Use casual abbreviations (like San Francisco -> SF, thanks -> thx, question -> q ), casual contractions (like \"I've\"), shortened forms of common nouns (like \"info\", \"vid\", \"app\") as this signals more human written speech. Do not use em dashes (eliminate — from your vocabulary completely!\n- No rhetorical questions.\n- Make your summary extremely comprehensive and analytical."
},
{
"content": "=JSON scrape:\n\n{{ $('Loop Over Video Ads').item.json.toJsonString() }}\n\nVideo description:\n\n{{ $json.candidates[0].content.parts[0].text }}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "oLLACDYfGm4C4ouV",
"name": "YouTube "
}
},
"typeVersion": 1.8
},
{
"id": "e3fc12fa-d845-435c-95e7-1fc121f0bb48",
"name": "添加类型 = 视频",
"type": "n8n-nodes-base.googleSheets",
"position": [
1860,
-520
],
"parameters": {
"columns": {
"value": {
"type": "video",
"page_id": "={{ $('Loop Over Video Ads').item.json.page_id }}",
"summary": "={{ $json.message.content.summary }}",
"page_url": "={{ $('Loop Over Video Ads').item.json.snapshot.page_profile_uri }}",
"page_name": "={{ $('Loop Over Video Ads').item.json.snapshot.page_name }}",
"date_added": "={{ $now }}",
"image_prompt": "=",
"video_prompt": "={{ $('Analyze Video with Gemini').item.json.candidates[0].content.parts[0].text }}",
"ad_archive_id": "={{ $('Loop Over Video Ads').item.json.ad_archive_id }}",
"rewritten_ad_copy": "={{ $json.message.content.rewrittenAdCopy }}"
},
"schema": [
{
"id": "ad_archive_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ad_archive_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_added",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "date_added",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rewritten_ad_copy",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "rewritten_ad_copy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_prompt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "image_prompt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "video_prompt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "video_prompt",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo/edit#gid=0",
"cachedResultName": "Ads"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo/edit?usp=drivesdk",
"cachedResultName": "Facebook Ad Library Analyzer DB"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "EOibXIc4U8wcXyRR",
"name": "YouTube"
}
},
"typeVersion": 4.6
},
{
"id": "47291e4b-ae46-4bff-8134-8cf330cfb7aa",
"name": "分析图片",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-120,
-220
],
"parameters": {
"text": "What's in this image? Be extremely comprehensive.",
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"options": {},
"resource": "image",
"imageUrls": "={{ $json.snapshot.images[0].original_image_url }}",
"operation": "analyze"
},
"credentials": {
"openAiApi": {
"id": "oLLACDYfGm4C4ouV",
"name": "YouTube "
}
},
"typeVersion": 1.8
},
{
"id": "34ee9e0e-4be8-41f2-b3fc-1868ec912fb8",
"name": "输出图片摘要",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
80,
-220
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1",
"cachedResultName": "GPT-4.1"
},
"options": {
"temperature": 0.7
},
"messages": {
"values": [
{
"role": "system",
"content": "You're a helpful, intelligent advertisement analysis bot. You analyze advertisements."
},
{
"content": "Your task is to take as input a scraped javascript object from an advertisement in the FB ad library, and then summarize it + spin (repurpose, rewrite) the ad copy. \n\nYou're doing this for strategic intelligence. We run an advertising agency and we're always looking at what our competitor advertisers are doing.\n\nOutput your results in this JSON format:\n\n{\"summary\":\"\",\"rewrittenAdCopy\":\"\"}\n\nRules:\n- The intended style and attitude is generally analytical, inquisitive, and precise, despite exploring complex topics, in the “classic style” of Western writing.\nthe level of formality should be inverse to the topic’s novelty: the weirder something is, the more formal. For ‘safer’ topics, one should cut loose with the humor, epigraphs, typographical stunts and experiments, etc.\n- Avoid hedging and qualifying, even at the risk of making overly-strong claims. It is a slippery slope.\n- Use casual abbreviations (like San Francisco -> SF, thanks -> thx, question -> q ), casual contractions (like \"I've\"), shortened forms of common nouns (like \"info\", \"vid\", \"app\") as this signals more human written speech. Do not use em dashes (eliminate — from your vocabulary completely!\n- No rhetorical questions.\n- Make your summary extremely comprehensive and analytical."
},
{
"content": "=JSON scrape:\n\n{{ $('Loop Over Image Ads').item.json.toJsonString() }}\n\nImage description:\n\n{{ $json.content }}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "oLLACDYfGm4C4ouV",
"name": "YouTube "
}
},
"typeVersion": 1.8
},
{
"id": "522169ec-669f-441a-9d20-3679426d0b9d",
"name": "添加类型 = 图片",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
-220
],
"parameters": {
"columns": {
"value": {
"type": "image",
"page_id": "={{ $('Loop Over Image Ads').item.json.page_id }}",
"summary": "={{ $json.message.content.summary }}",
"page_url": "={{ $('Loop Over Image Ads').item.json.snapshot.page_profile_uri }}",
"page_name": "={{ $('Loop Over Image Ads').item.json.snapshot.page_name }}",
"date_added": "={{ $now }}",
"image_prompt": "={{ $('Analyze Image').item.json.content }}",
"ad_archive_id": "={{ $('Loop Over Image Ads').item.json.ad_archive_id }}",
"rewritten_ad_copy": "={{ $json.message.content.rewrittenAdCopy }}"
},
"schema": [
{
"id": "ad_archive_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ad_archive_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_added",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "date_added",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rewritten_ad_copy",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "rewritten_ad_copy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_prompt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "image_prompt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "video_prompt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "video_prompt",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo/edit#gid=0",
"cachedResultName": "Ads"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo/edit?usp=drivesdk",
"cachedResultName": "Facebook Ad Library Analyzer DB"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "EOibXIc4U8wcXyRR",
"name": "YouTube"
}
},
"typeVersion": 4.6
},
{
"id": "f43bb15e-9c7d-4a97-9a10-7c9ce835f1f6",
"name": "输出文本摘要",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-200,
80
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1",
"cachedResultName": "GPT-4.1"
},
"options": {
"temperature": 0.7
},
"messages": {
"values": [
{
"role": "system",
"content": "You're a helpful, intelligent advertisement analysis bot. You analyze advertisements."
},
{
"content": "Your task is to take as input a scraped javascript object from an advertisement in the FB ad library, and then summarize it + spin (repurpose, rewrite) the ad copy. \n\nYou're doing this for strategic intelligence. We run an advertising agency and we're always looking at what our competitor advertisers are doing.\n\nOutput your results in this JSON format:\n\n{\"summary\":\"\",\"rewrittenAdCopy\":\"\"}\n\nRules:\n- The intended style and attitude is generally analytical, inquisitive, and precise, despite exploring complex topics, in the “classic style” of Western writing.\nthe level of formality should be inverse to the topic’s novelty: the weirder something is, the more formal. For ‘safer’ topics, one should cut loose with the humor, epigraphs, typographical stunts and experiments, etc.\n- Avoid hedging and qualifying, even at the risk of making overly-strong claims. It is a slippery slope.\n- Use casual abbreviations (like San Francisco -> SF, thanks -> thx, question -> q ), casual contractions (like \"I've\"), shortened forms of common nouns (like \"info\", \"vid\", \"app\") as this signals more human written speech. Do not use em dashes (eliminate — from your vocabulary completely!\n- No rhetorical questions.\n- Make your summary extremely comprehensive and analytical."
},
{
"content": "={{ $json.toJsonString() }}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "oLLACDYfGm4C4ouV",
"name": "YouTube "
}
},
"typeVersion": 1.8
},
{
"id": "62aec040-3729-447b-864d-00685857d721",
"name": "添加类型 = 文本",
"type": "n8n-nodes-base.googleSheets",
"position": [
160,
80
],
"parameters": {
"columns": {
"value": {
"type": "text",
"page_id": "={{ $('Loop Over Text Ads').item.json.page_id }}",
"summary": "={{ $json.message.content.summary }}",
"page_url": "={{ $('Loop Over Text Ads').item.json.snapshot.page_profile_uri }}",
"page_name": "={{ $('Loop Over Text Ads').item.json.snapshot.page_name }}",
"date_added": "={{ $now }}",
"ad_archive_id": "={{ $('Loop Over Text Ads').item.json.ad_archive_id }}",
"rewritten_ad_copy": "={{ $json.message.content.rewrittenAdCopy }}"
},
"schema": [
{
"id": "ad_archive_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ad_archive_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_added",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "date_added",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "page_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "page_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "rewritten_ad_copy",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "rewritten_ad_copy",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_prompt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "image_prompt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "video_prompt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "video_prompt",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo/edit#gid=0",
"cachedResultName": "Ads"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Cgm0DfKQxgtsjdw6h2LFVBtZnLAioTntzdXgfJCJIqo/edit?usp=drivesdk",
"cachedResultName": "Facebook Ad Library Analyzer DB"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "EOibXIc4U8wcXyRR",
"name": "YouTube"
}
},
"typeVersion": 4.6
},
{
"id": "7079dc10-2ce5-4df9-889a-0e861f1025a5",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1320,
-560
],
"parameters": {
"width": 700,
"height": 260,
"content": "## AI Facebook 广告间谍工具"
},
"typeVersion": 1
},
{
"id": "33c52cea-4169-43b1-91e9-f8c6c35f06e1",
"name": "等待3",
"type": "n8n-nodes-base.wait",
"position": [
960,
-520
],
"webhookId": "ac11c85a-5b73-4a29-9667-615e811a5ad8",
"parameters": {
"amount": 15
},
"typeVersion": 1.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "b72f86e7-7d73-495b-935c-f99008fcd705",
"connections": {
"Wait": {
"main": [
[
{
"node": "Loop Over Text Ads",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Loop Over Image Ads",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Loop Over Video Ads",
"type": "main",
"index": 0
}
]
]
},
"Wait3": {
"main": [
[
{
"node": "Analyze Video with Gemini",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "Loop Over Video Ads",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Image Ads",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Text Ads",
"type": "main",
"index": 0
}
]
]
},
"Analyze Image": {
"main": [
[
{
"node": "Output Image Summary",
"type": "main",
"index": 0
}
]
]
},
"Download Video": {
"main": [
[
{
"node": "Upload Video to Drive",
"type": "main",
"index": 0
}
]
]
},
"Filter For Likes": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Redownload Video": {
"main": [
[
{
"node": "Upload Video to Gemini",
"type": "main",
"index": 0
}
]
]
},
"Add as Type = Text": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Text Ads": {
"main": [
[],
[
{
"node": "Output Text Summary",
"type": "main",
"index": 0
}
]
]
},
"Add as Type = Image": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Add as Type = Video": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Image Ads": {
"main": [
[],
[
{
"node": "Analyze Image",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Video Ads": {
"main": [
[],
[
{
"node": "Download Video",
"type": "main",
"index": 0
}
]
]
},
"Output Text Summary": {
"main": [
[
{
"node": "Add as Type = Text",
"type": "main",
"index": 0
}
]
]
},
"Output Image Summary": {
"main": [
[
{
"node": "Add as Type = Image",
"type": "main",
"index": 0
}
]
]
},
"Output Video Summary": {
"main": [
[
{
"node": "Add as Type = Video",
"type": "main",
"index": 0
}
]
]
},
"Upload Video to Drive": {
"main": [
[
{
"node": "Begin Gemini Upload Session",
"type": "main",
"index": 0
}
]
]
},
"Run Ad Library Scraper": {
"main": [
[
{
"node": "Filter For Likes",
"type": "main",
"index": 0
}
]
]
},
"Upload Video to Gemini": {
"main": [
[
{
"node": "Wait3",
"type": "main",
"index": 0
}
]
]
},
"Analyze Video with Gemini": {
"main": [
[
{
"node": "Output Video Summary",
"type": "main",
"index": 0
}
]
]
},
"Begin Gemini Upload Session": {
"main": [
[
{
"node": "Redownload Video",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Run Ad Library Scraper",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
广告监测工具（含AI模型名称：GPT-4、Gemini）
广告监测工具（含AI模型名称：GPT-4、Gemini）
Wait
Filter
Switch
+7
29 节点Electrabot
市场调研
我的工作流
使用 Apify、GPT-4o 和 Facebook 广告库进行竞争广告研究与图像生成
Set
Wait
Limit
+10
32 节点Nick Saraev
内容创作
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+26
156 节点Diptamoy Barman
内容创作
使用 Apify、GPT-4 和 Google Drive 从竞争对手生成 AI Facebook 广告变体
使用 Apify、GPT-4 和 Google Drive 从竞争对手生成 AI Facebook 广告变体
Set
Wait
Limit
+10
29 节点Electrabot
内容创作
Gemini_NanoBanana_模板
使用 Fal.ai 模型（nano-banana、WAN2.2、Veo3）从 Google Sheets 生成 UGC 广告
If
Set
Code
+13
36 节点Jaruphat J.
内容创作
智能发票跟进系统
集成GPT-4.1、Gmail和Google Sheets的智能发票催收系统
Set
Gmail
Filter
+7
16 节点Nick Saraev
发票处理
工作流信息
难度等级
高级
节点数量29
分类2
节点类型10
作者
Nick Saraev
@nicksaraevHi 👋 I'm Nick. I make money with automation & teach others how they can too. If you have any questions about my templates or about my n8n builds, feel free to ask and I'll happily respond in the comments. Thanks for reading!
外部链接
在 n8n.io 查看 →
分享此工作流