Googleスクレイピング、Bright Data、Gemini AIを使用したキーワード検索意図の分析
上級
これはMarket Research, AI Summarization分野の自動化ワークフローで、24個のノードを含みます。主にSet, Merge, SplitOut, HttpRequest, GoogleSheetsなどのノードを使用。 Google Scraping、Bright Data、そして Gemini AI を使用してキーワード検索の意図を分析する
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •Google Gemini API Key
使用ノード (24)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "db80165df40cb07c0377167c050b3f9ab0b0fb04f0e8cae0dc53f5a8527103ca",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "63865e5c-9e83-49ad-8d51-02391ee9e36c",
"name": "ワークフロー実行時",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-920,
-700
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e935f831-25e0-4325-b0a4-72dd632c6c46",
"name": "Google 検索結果を取得 JSON",
"type": "n8n-nodes-base.httpRequest",
"position": [
-20,
-680
],
"parameters": {
"url": "https://api.brightdata.com/request",
"method": "POST",
"options": {
"redirect": {
"redirect": {}
}
},
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "zone",
"value": "serp_api1"
},
{
"name": "url",
"value": "=https://www.google.com/search?q={{ $json.search_term .replaceAll(\" \", \"+\")}}&start=0&brd_json=1"
},
{
"name": "country",
"value": "={{ $json['country code'] }}"
},
{
"name": "format",
"value": "raw"
}
]
},
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "async",
"value": "true"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "gfLRVcGG09VEZv5B",
"name": "Brightdata Header"
}
},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "91fa9b7c-626d-48aa-9728-2126f75be833",
"name": "分割",
"type": "n8n-nodes-base.splitOut",
"position": [
160,
-680
],
"parameters": {
"options": {},
"fieldToSplitOut": "organic"
},
"typeVersion": 1
},
{
"id": "ee4881f0-9148-493e-825e-ce2dde83fbae",
"name": "キーワード取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
-700,
-700
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QU9rwawCZLiYW8nlYYRMj-9OvAUNZoe2gP49KbozQqw/edit#gid=0",
"cachedResultName": "Keywords to Track"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1QU9rwawCZLiYW8nlYYRMj-9OvAUNZoe2gP49KbozQqw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QU9rwawCZLiYW8nlYYRMj-9OvAUNZoe2gP49KbozQqw/edit?usp=drivesdk",
"cachedResultName": "Position Tracking for Keyword + Dashboard "
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ZAI2a6Qt80kX5a9s",
"name": "Google Sheets account✅ "
}
},
"typeVersion": 4.6
},
{
"id": "69fff95a-24de-4331-89a8-14d4ea25c066",
"name": "アイテムループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-460,
-700
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "c4d31168-a21a-44ba-8cb6-a4a51167aa49",
"name": "フィールド整形",
"type": "n8n-nodes-base.set",
"position": [
320,
-680
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bcca5d0b-e07d-4488-9e7f-4454bb7d2924",
"name": "Keyword",
"type": "string",
"value": "={{ $('set keyword').item.json.search_term }}"
},
{
"id": "d39c09ec-b94a-4d38-8ba1-5f54395186de",
"name": "ranking page",
"type": "string",
"value": "={{ $json.link }}"
},
{
"id": "a167b825-4324-42a5-bb16-9ae5d40b20eb",
"name": "title",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "035f315b-1199-4e1a-bc1d-8055774cc290",
"name": "Meta description",
"type": "string",
"value": "={{ $json.description }}"
},
{
"id": "8c6b4298-420c-4648-9438-864ca9d9cb72",
"name": "extensions",
"type": "string",
"value": "={{ $json.extensions?.toJsonString() }}"
},
{
"id": "243329e0-2cae-4e75-a589-1ea098614ae5",
"name": "position ",
"type": "number",
"value": "={{ $json.rank }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ee815b25-9a77-4bb5-96f8-54e26a8dcb6e",
"name": "ランキング結果追加",
"type": "n8n-nodes-base.googleSheets",
"position": [
1300,
-680
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "position ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "position ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ranking page",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ranking page",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meta description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Meta description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extensions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "extensions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "intent",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "intent",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"ranking page"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1031244896,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QU9rwawCZLiYW8nlYYRMj-9OvAUNZoe2gP49KbozQqw/edit#gid=1031244896",
"cachedResultName": "Sheet2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1QU9rwawCZLiYW8nlYYRMj-9OvAUNZoe2gP49KbozQqw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1QU9rwawCZLiYW8nlYYRMj-9OvAUNZoe2gP49KbozQqw/edit?usp=drivesdk",
"cachedResultName": "Position Tracking for Keyword + Dashboard "
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ZAI2a6Qt80kX5a9s",
"name": "Google Sheets account✅ "
}
},
"typeVersion": 4.6
},
{
"id": "baf30b06-9307-4c35-94f1-0c7342a08604",
"name": "意図分類器",
"type": "@n8n/n8n-nodes-langchain.textClassifier",
"position": [
500,
-720
],
"parameters": {
"options": {},
"inputText": "=Keyword: {{ $json.Keyword}}\n\nTop pages title : {{ $json.title }}\n\nmeta descriptions : {{ $json.description }}",
"categories": {
"categories": [
{
"category": "Informational",
"description": "=The user wants to learn something (e.g., guides, tutorials, definitions)"
},
{
"category": "Navigational",
"description": "The user is looking for a specific brand or website."
},
{
"category": "Commercial",
"description": "=The user is researching products/services before making a purchase."
},
{
"category": "Transactional",
"description": "=The user is ready to take action or make a purchase (e.g., sign up, buy, download)."
},
{
"category": "Mixed",
"description": "=If results show multiple types equally (e.g., some blogs, some product pages)."
}
]
}
},
"typeVersion": 1.1
},
{
"id": "430917d7-75ea-481b-ae98-f11997f97863",
"name": "Google Gemini チャットモデル2",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
520,
-480
],
"parameters": {
"options": {}
},
"credentials": {
"googlePalmApi": {
"id": "Xp5T9q3YYxBIw2nd",
"name": "Google Gemini(PaLM) Api account✅"
}
},
"typeVersion": 1
},
{
"id": "2cd17548-dc51-4b6a-a13f-ee3c60146412",
"name": "情報取得型",
"type": "n8n-nodes-base.set",
"position": [
880,
-1000
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f02fd6cc-9d46-47a0-9e65-cf0436c92ae7",
"name": "intent",
"type": "string",
"value": "informational"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "1b6604e2-aefb-4c5b-929c-633161b0871b",
"name": "ナビゲーション型",
"type": "n8n-nodes-base.set",
"position": [
880,
-840
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f02fd6cc-9d46-47a0-9e65-cf0436c92ae7",
"name": "intent",
"type": "string",
"value": "Navigational"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "b4bd39b8-ae9d-4a6a-9cdb-3cdb86b218eb",
"name": "商業調査型",
"type": "n8n-nodes-base.set",
"position": [
880,
-680
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f02fd6cc-9d46-47a0-9e65-cf0436c92ae7",
"name": "intent",
"type": "string",
"value": "Commercial"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "60e4efd2-52cc-44cb-9f6f-541a187364f0",
"name": "取引目的型",
"type": "n8n-nodes-base.set",
"position": [
880,
-540
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f02fd6cc-9d46-47a0-9e65-cf0436c92ae7",
"name": "intent",
"type": "string",
"value": "Transactional"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "6cdb9432-caff-4338-986e-ecde27f7d8bb",
"name": "複合型",
"type": "n8n-nodes-base.set",
"position": [
880,
-400
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f02fd6cc-9d46-47a0-9e65-cf0436c92ae7",
"name": "intent",
"type": "string",
"value": "Mixed"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "7d335e4f-c521-4711-9aeb-e6e4c861fc4c",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-940
],
"parameters": {
"color": 2,
"width": 320,
"height": 620,
"content": "## Analyze intent of the top ranking pages \n\n- We use AI to analyze each title and its intent as informational, Commercial, transactional, navigational or Mixed in the case it doesn't fall into any of those\n"
},
"typeVersion": 1
},
{
"id": "ca13d5f0-8bbe-464b-9778-18dee7b959ea",
"name": "意図統合",
"type": "n8n-nodes-base.merge",
"position": [
1120,
-720
],
"parameters": {
"numberInputs": 5
},
"typeVersion": 3.2
},
{
"id": "ad137e75-05e9-4582-981f-43f6df6becbf",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1260,
-780
],
"parameters": {
"width": 260,
"height": 280,
"content": "## How it works\n\n- We add our keywords and country code to a G sheet that we need to monitor and research on\n- Run the system\n- Scrape the top 10 pages\n- Analyze the intents of the top 10 and update to a G sheet\n"
},
"typeVersion": 1
},
{
"id": "ad89de82-a005-4851-8c40-102b83f3c912",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-740,
-820
],
"parameters": {
"width": 220,
"height": 320,
"content": "- Make a copy of this [G sheet](https://docs.google.com/spreadsheets/d/1QU9rwawCZLiYW8nlYYRMj-9OvAUNZoe2gP49KbozQqw/edit?usp=sharing)\n\n- Add your desired keywords"
},
"typeVersion": 1
},
{
"id": "571a1981-a9f3-4b66-8c9f-3d4779425df6",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
-820
],
"parameters": {
"color": 5,
"width": 200,
"height": 340,
"content": "- We loop over each item one at a time"
},
"typeVersion": 1
},
{
"id": "5b39d950-56e9-4069-81f0-8a061a56795d",
"name": "キーワード設定",
"type": "n8n-nodes-base.set",
"position": [
-180,
-680
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "cee3c6fe-dc44-43b2-9243-a1f1a62f9fa1",
"name": "search_term",
"type": "string",
"value": "={{ $json.Keyword }}"
},
{
"id": "3c58a493-6d15-4b90-bc5a-154d6f6d6474",
"name": "country code",
"type": "string",
"value": "={{ $json['country code'] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "72f54c66-32df-45a4-8b1d-84a02cc7c4b8",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-220,
-800
],
"parameters": {
"color": 4,
"width": 340,
"height": 320,
"content": "- Map keyword and country code \n- Update the Zone name to match your zone on Bright Data\n- Run the scraper"
},
"typeVersion": 1
},
{
"id": "336c7e9e-6d26-46d4-96b6-ebbcea39411b",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
-460
],
"parameters": {
"color": 7,
"width": 300,
"height": 280,
"content": "## Setting up SERP scraper in Bright Data\n\n1. On Bright Data, go to the [Proxies & Scraping](https://brightdata.com/cp/zones) tab\n2. Under SERP API, create a new zone\n3. Give it a suitable name and description. The default is `serp_api`\n3. Add this to your account\n\n\n"
},
"typeVersion": 1
},
{
"id": "bb416232-7254-499e-98e5-6495ebd35e8d",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
-1060
],
"parameters": {
"color": 6,
"width": 200,
"height": 820,
"content": "- Set intent field name for each path or output"
},
"typeVersion": 1
},
{
"id": "24866dbb-0b4f-4f36-8ed6-a474b51455ac",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
-780
],
"parameters": {
"width": 220,
"height": 360,
"content": "- Append the top pages to the G sheet for further analysis"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"6cdb9432-caff-4338-986e-ecde27f7d8bb": {
"main": [
[
{
"node": "ca13d5f0-8bbe-464b-9778-18dee7b959ea",
"type": "main",
"index": 4
}
]
]
},
"91fa9b7c-626d-48aa-9728-2126f75be833": {
"main": [
[
{
"node": "c4d31168-a21a-44ba-8cb6-a4a51167aa49",
"type": "main",
"index": 0
}
]
]
},
"b4bd39b8-ae9d-4a6a-9cdb-3cdb86b218eb": {
"main": [
[
{
"node": "ca13d5f0-8bbe-464b-9778-18dee7b959ea",
"type": "main",
"index": 2
}
]
]
},
"5b39d950-56e9-4069-81f0-8a061a56795d": {
"main": [
[
{
"node": "e935f831-25e0-4325-b0a4-72dd632c6c46",
"type": "main",
"index": 0
}
]
]
},
"ee4881f0-9148-493e-825e-ce2dde83fbae": {
"main": [
[
{
"node": "69fff95a-24de-4331-89a8-14d4ea25c066",
"type": "main",
"index": 0
}
]
]
},
"1b6604e2-aefb-4c5b-929c-633161b0871b": {
"main": [
[
{
"node": "ca13d5f0-8bbe-464b-9778-18dee7b959ea",
"type": "main",
"index": 1
}
]
]
},
"ca13d5f0-8bbe-464b-9778-18dee7b959ea": {
"main": [
[
{
"node": "ee815b25-9a77-4bb5-96f8-54e26a8dcb6e",
"type": "main",
"index": 0
}
]
]
},
"60e4efd2-52cc-44cb-9f6f-541a187364f0": {
"main": [
[
{
"node": "ca13d5f0-8bbe-464b-9778-18dee7b959ea",
"type": "main",
"index": 3
}
]
]
},
"c4d31168-a21a-44ba-8cb6-a4a51167aa49": {
"main": [
[
{
"node": "baf30b06-9307-4c35-94f1-0c7342a08604",
"type": "main",
"index": 0
}
]
]
},
"2cd17548-dc51-4b6a-a13f-ee3c60146412": {
"main": [
[
{
"node": "ca13d5f0-8bbe-464b-9778-18dee7b959ea",
"type": "main",
"index": 0
}
]
]
},
"69fff95a-24de-4331-89a8-14d4ea25c066": {
"main": [
[],
[
{
"node": "5b39d950-56e9-4069-81f0-8a061a56795d",
"type": "main",
"index": 0
},
{
"node": "69fff95a-24de-4331-89a8-14d4ea25c066",
"type": "main",
"index": 0
}
]
]
},
"baf30b06-9307-4c35-94f1-0c7342a08604": {
"main": [
[
{
"node": "2cd17548-dc51-4b6a-a13f-ee3c60146412",
"type": "main",
"index": 0
}
],
[
{
"node": "1b6604e2-aefb-4c5b-929c-633161b0871b",
"type": "main",
"index": 0
}
],
[
{
"node": "b4bd39b8-ae9d-4a6a-9cdb-3cdb86b218eb",
"type": "main",
"index": 0
}
],
[
{
"node": "60e4efd2-52cc-44cb-9f6f-541a187364f0",
"type": "main",
"index": 0
}
],
[
{
"node": "6cdb9432-caff-4338-986e-ecde27f7d8bb",
"type": "main",
"index": 0
}
]
]
},
"430917d7-75ea-481b-ae98-f11997f97863": {
"ai_languageModel": [
[
{
"node": "baf30b06-9307-4c35-94f1-0c7342a08604",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"e935f831-25e0-4325-b0a4-72dd632c6c46": {
"main": [
[
{
"node": "91fa9b7c-626d-48aa-9728-2126f75be833",
"type": "main",
"index": 0
}
]
]
},
"63865e5c-9e83-49ad-8d51-02391ee9e36c": {
"main": [
[
{
"node": "ee4881f0-9148-493e-825e-ce2dde83fbae",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 市場調査, AI要約
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
01 AIメディアバイヤーでFacebook広告のパフォーマンスを分析し、インサイトをGoogle Sheetsへ送信
Gemini AIを使用してFacebook広告を分析し、インサイトをGoogle Sheetsに送信
If
Set
Code
+
If
Set
Code
34 ノードJJ Tham
市場調査
アイデア捕集テンプレート
Reddit、YouTube、Xを分析してコンテンツ戦略レポートを生成するGeminiの使用
If
Set
Code
+
If
Set
Code
34 ノードSheryl
市場調査
Bright Data と Gemini AI を使用して SEO 最適化されたタイトルとメタディスクリプションを生成
Bright DataとGemini AIを使ってSEO最適化されたタイトルとメタディスクリプションを生成する
Set
Http Request
Google Sheets
+
Set
Http Request
Google Sheets
16 ノードZacharia Kimotho
市場調査
潜在顧客開掘とメールワーキングフロー
Google Maps、SendGrid、AIを使用してB2Bリード獲得とメールマーケティングを自動化
If
Set
Code
+
If
Set
Code
141 ノードEzema Kingsley Chibuzo
リード獲得
YouTube視聴者コメント分析ツール
Gemini AIを使ってYouTubeコメントの感情を分析し、Google Sheetsに保存する
If
Split Out
Http Request
+
If
Split Out
Http Request
17 ノードAgent Circle
市場調査
Meta広告の自動分析
Meta 広告を Gemini AI、ScrapingFlash、Google Sheets で自動分析
Limit
Split Out
Http Request
+
Limit
Split Out
Http Request
17 ノードPaul-François GORIAUX
市場調査
ワークフロー情報
難易度
上級
ノード数24
カテゴリー2
ノードタイプ10
作成者
Zacharia Kimotho
@imperolqAutomation expert with years of experience helping businesses improve their efficiency and productivity with smart automations that are affordable, scalable, and flexible.
外部リンク
n8n.ioで表示 →
このワークフローを共有