Verwendung von Google Scraping, Bright Data und Gemini AI zur Analyse der Suchintention von Schlüsselwörtern
Experte
Dies ist ein Market Research, AI Summarization-Bereich Automatisierungsworkflow mit 24 Nodes. Hauptsächlich werden Set, Merge, SplitOut, HttpRequest, GoogleSheets und andere Nodes verwendet. Analyse des Suchintention mit Google Crawling, Bright Data und Gemini AI
Voraussetzungen
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
- •Google Gemini API Key
Verwendete Nodes (24)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"meta": {
"instanceId": "db80165df40cb07c0377167c050b3f9ab0b0fb04f0e8cae0dc53f5a8527103ca",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "63865e5c-9e83-49ad-8d51-02391ee9e36c",
"name": "Bei Klick auf 'Workflow ausführen'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-920,
-700
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e935f831-25e0-4325-b0a4-72dd632c6c46",
"name": "Abrufen der Google Suchergebnisse 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": "Aufteilen",
"type": "n8n-nodes-base.splitOut",
"position": [
160,
-680
],
"parameters": {
"options": {},
"fieldToSplitOut": "organic"
},
"typeVersion": 1
},
{
"id": "ee4881f0-9148-493e-825e-ce2dde83fbae",
"name": "Keywords abrufen",
"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": "Über Elemente iterieren",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-460,
-700
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "c4d31168-a21a-44ba-8cb6-a4a51167aa49",
"name": "Felder formatieren",
"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": "Ranking-Ergebnis anhängen",
"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": "Intent Classifier",
"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 Chat Model2",
"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": "Informational",
"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": "Navigational",
"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": "Commercial",
"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": "Transactional",
"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": "Mixed",
"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": "Notizzettel1",
"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": "Intents zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
1120,
-720
],
"parameters": {
"numberInputs": 5
},
"typeVersion": 3.2
},
{
"id": "ad137e75-05e9-4582-981f-43f6df6becbf",
"name": "Notizzettel3",
"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": "Notizzettel4",
"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": "Notizzettel5",
"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": "Keyword setzen",
"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": "Notizzettel6",
"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": "Notizzettel7",
"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": "Notizzettel8",
"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": "Notizzettel9",
"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
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Marktforschung, KI-Zusammenfassung
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
01 Nutze den AI-Media-Buyer zur Analyse der Facebook-Werbeanzeigenleistung und sende Erkenntnisse an Google Sheets
Facebook-Werbung mit Gemini AI analysieren und Erkenntnisse in Google Sheets senden
If
Set
Code
+
If
Set
Code
34 NodesJJ Tham
Marktforschung
Ideenfang-Vorlage
Verwendung von Gemini zur Analyse von Reddit, YouTube und X zur Generierung eines Inhaltstrategieberichts
If
Set
Code
+
If
Set
Code
34 NodesSheryl
Marktforschung
SEO-optimierte Titel und Meta-Beschreibungen mit Bright Data und Gemini AI generieren
SEO-optimierte Titel und Meta-Beschreibungen mit Bright Data und Gemini AI generieren
Set
Http Request
Google Sheets
+
Set
Http Request
Google Sheets
16 NodesZacharia Kimotho
Marktforschung
Lead-Generierung und E-Mail-Arbeitsabläufe
Automatisierung der B2B-Lead-Generierung und E-Mail-Marketing mit Google Maps, SendGrid und KI
If
Set
Code
+
If
Set
Code
141 NodesEzema Kingsley Chibuzo
Lead-Generierung
YouTube-Publikums-Kommentar-Analyse-Tools
Gemini AI zur Analyse der sentiment-Analyse der YouTube-Kommentare und zum Speichern in Google Sheets verwenden
If
Split Out
Http Request
+
If
Split Out
Http Request
17 NodesAgent Circle
Marktforschung
Automatisierte Meta-Analyse
Automatische Analyse von Meta-Anzeigen mit Gemini AI, ScrapingFlash und Google Sheets
Limit
Split Out
Http Request
+
Limit
Split Out
Http Request
17 NodesPaul-François GORIAUX
Marktforschung
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes24
Kategorie2
Node-Typen10
Autor
Zacharia Kimotho
@imperolqAutomation expert with years of experience helping businesses improve their efficiency and productivity with smart automations that are affordable, scalable, and flexible.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen