Google広告のコンテンツをドメイン別に抽出
上級
これはAI, Marketing分野の自動化ワークフローで、16個のノードを含みます。主にSet, Switch, Function, HttpRequest, ManualTriggerなどのノードを使用、AI技術を活用したスマート自動化を実現。 SerpAPIを使ってドメインごとにGoogle Adsのクリエイティブを抽出し、CSVにエクスポート
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下の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": "Format1で分割",
"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": "# Node Annotations\n\n✅ When clicking 'Test workflow'\nTrigger the workflow manually during testing or development.\n\n📌 Note:\nUsed for debugging or one-time executions. No configuration needed."
},
"typeVersion": 1
},
{
"id": "431fdfd5-9550-4eca-8489-26fb126e828e",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-940,
120
],
"parameters": {
"width": 360,
"height": 420,
"content": "# ✏️ Set Domain & Region\n\nDefine which domain and region you want to extract ads for.\n\n📌 Note:\n\nSet the domain (e.g., example.com)\n\nSet the region using the numeric SerpApi region code\n\n🔗 https://serpapi.com/google-ads-transparency-center-regions"
},
"typeVersion": 1
},
{
"id": "245857fd-4405-4f75-95d1-41d7374b770a",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
120
],
"parameters": {
"width": 360,
"height": 420,
"content": "# 🌐 Get Ads Page 1\n\nCalls SerpApi to fetch Google Ads Transparency data based on the domain and region.\n\n📌 Note:\n\nUses the SerpApi google_ads_transparency_center engine\n\nRequires a SerpApi API Key\n\nMake sure the region code is supported\n\nYou can paginate using next_page_token in future improvements\n\n🔗 https://serpapi.com/google-ads-transparency-center-api"
},
"typeVersion": 1
},
{
"id": "59c2eab0-ce67-463b-aaea-bf5c69fcb15e",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
120
],
"parameters": {
"width": 360,
"height": 420,
"content": "# 🧠 Extract Ad Creatives\n\nFilters only the ad creatives where target_domain exactly matches your input.\n\n📌 Note:\n\nThis avoids pulling unrelated advertiser ads\n\nMakes sure only relevant ads for your domain are processed further"
},
"typeVersion": 1
},
{
"id": "e87811c5-2f2a-4bd4-828b-ec4333393839",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
120
],
"parameters": {
"width": 360,
"height": 420,
"content": "# 🔀 Split by Format\n\nSorts the ads by their format into separate branches: text, image, or video.\n\n📌 Note:\n\nBased on format field of each ad\n\nEnsures clean CSV outputs for each type"
},
"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": "# 📄 Convert Text Ads to CSV\n\nSaves text ads in a CSV file named: text_{domain}_ads.csv\n\n📌 Note:\n\nUse this for text-only creatives\n\nFile will be saved in your /files/ directory"
},
"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": "# 🖼️ Convert Image Ads to CSV\nSaves image-based ads to: image_{domain}_ads.csv\n\n📌 Note:\n\nContains ad dimensions and image URLs\n\n"
},
"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": "# 🎞️ Convert Video Ads to CSV\nExports video ads into: video_{domain}_ads.csv\n\n📌 Note:\n\nContains video links (HTML preview links or embedded content)"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"65aafe70-bcfb-4c28-96dd-17d9dd2f4203": {
"main": [
[
{
"node": "8b768e62-6697-491e-89d6-6fa40aa36619",
"type": "main",
"index": 0
}
]
]
},
"50bcee68-570e-4b2f-bc14-3e5148f63ed6": {
"main": [
[
{
"node": "5a385bb4-a7eb-4327-8719-311ba61fe82a",
"type": "main",
"index": 0
}
],
[
{
"node": "2860d7c8-8c45-4d13-964d-40d6565e7a18",
"type": "main",
"index": 0
}
],
[
{
"node": "2240db0a-0cb3-4449-a187-6daa52bca0fd",
"type": "main",
"index": 0
}
]
]
},
"15dea6e9-0a6a-4ba1-ae36-7234f5f3ff13": {
"main": [
[
{
"node": "65aafe70-bcfb-4c28-96dd-17d9dd2f4203",
"type": "main",
"index": 0
}
]
]
},
"8b768e62-6697-491e-89d6-6fa40aa36619": {
"main": [
[
{
"node": "50bcee68-570e-4b2f-bc14-3e5148f63ed6",
"type": "main",
"index": 0
}
]
]
},
"6158066c-e944-42cf-9a40-5c2c309a8567": {
"main": [
[
{
"node": "15dea6e9-0a6a-4ba1-ae36-7234f5f3ff13",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 人工知能, マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Brave検索による構造化データ抽出（Bright Data MCP + Google Gemini）
Bright Data MCPとGoogle Geminiを使用してBrave検索から構造化されたデータを抽出
Set
Switch
Function
+
Set
Switch
Function
24 ノードRanjan Dailata
人工知能
AI个性化多製品メールマーケティング
基于SMTP轮换のAI个性化多製品メールマーケティング（GPT-4o/o3-mini）
If
Code
Wait
+
If
Code
Wait
41 ノードBadr
営業
## 🤖 **LIGUA033/LOREALCANTARA - 其他生成ワークフロー**
基于AIのMeta广告分析与作成：使用Gemini、GPT-4.1 Miniと广告管理器
If
Set
Wait
+
If
Set
Wait
61 ノードDaniel Setzermann
人工知能
YouTube
Google SheetsとTelegramリマインダーを使用してTikTok動画をYouTube Shortsに自動転送
Set
Code
Function
+
Set
Code
Function
22 ノードArkady Reveinz
人工知能
Bright Data を使用して Google Gemini で Etsy データをスクレイピングし自動化
Etsy データマイニングの自動化を実現：Bright Data によるスクレピング、Google Gemini
Set
Function
Split Out
+
Set
Function
Split Out
19 ノードRanjan Dailata
プロダクト
GPT-4o、WordPress、LinkedInを使ってRSSから自動でブログ記事を投稿
GPT-4o、WordPress、LinkedInを使ってRSSコンテンツを自動のにブログ記事へ公開
If
Set
Code
+
If
Set
Code
40 ノードImmanuel
人工知能
ワークフロー情報
難易度
上級
ノード数16
カテゴリー2
ノードタイプ7
作成者
Nikan Noorafkan
@nikkannooraHey, 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で表示 →
このワークフローを共有