Utiliser Google Scraper, Bright Data et Gemini AI pour analyser l'intention de recherche des mots-clés
Avancé
Ceci est unMarket Research, AI Summarizationworkflow d'automatisation du domainecontenant 24 nœuds.Utilise principalement des nœuds comme Set, Merge, SplitOut, HttpRequest, GoogleSheets. Utiliser Google Crawling, Bright Data et Gemini AI pour analyser l'intention de recherche de mots-clés
Prérequis
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
- •Clé API Google Gemini
Nœuds utilisés (24)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"meta": {
"instanceId": "db80165df40cb07c0377167c050b3f9ab0b0fb04f0e8cae0dc53f5a8527103ca",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "63865e5c-9e83-49ad-8d51-02391ee9e36c",
"name": "Lors du clic sur 'Exécuter le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-920,
-700
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e935f831-25e0-4325-b0a4-72dd632c6c46",
"name": "Récupérer les résultats de recherche 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": "Diviser",
"type": "n8n-nodes-base.splitOut",
"position": [
160,
-680
],
"parameters": {
"options": {},
"fieldToSplitOut": "organic"
},
"typeVersion": 1
},
{
"id": "ee4881f0-9148-493e-825e-ce2dde83fbae",
"name": "Obtenir les mots-clés",
"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": "Boucler sur les éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-460,
-700
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "c4d31168-a21a-44ba-8cb6-a4a51167aa49",
"name": "formater les champs",
"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": "ajouter le résultat de classement",
"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": "Classificateur d'intention",
"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 Modèle de chat 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": "informationnel",
"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": "navigationnel",
"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": "transactionnel",
"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": "mixte",
"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": "Note adhésive 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": "Fusionner les intentions",
"type": "n8n-nodes-base.merge",
"position": [
1120,
-720
],
"parameters": {
"numberInputs": 5
},
"typeVersion": 3.2
},
{
"id": "ad137e75-05e9-4582-981f-43f6df6becbf",
"name": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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": "définir le mot-clé",
"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": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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": "Note adhésive 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
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Étude de marché, Résumé IA
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
01 Analyser la performance des publicités Facebook avec un acheteur d'espace médias IA et envoyer les informations dans Google Sheets
Analyser les publicités Facebook et envoyer les insights dans Google Sheets avec Gemini AI
If
Set
Code
+
If
Set
Code
34 NœudsJJ Tham
Étude de marché
Modèle pour attraper les sujets
Utiliser Gemini pour analyser Reddit, YouTube et X et générer des rapports de stratégie de contenu
If
Set
Code
+
If
Set
Code
34 NœudsSheryl
Étude de marché
Génération de titres et de méta-descriptions optimisés pour le SEO avec Bright Data et Gemini AI
Utiliser Bright Data et Gemini AI pour générer des titres et meta-descriptions optimisés SEO
Set
Http Request
Google Sheets
+
Set
Http Request
Google Sheets
16 NœudsZacharia Kimotho
Étude de marché
Prospection et workflow d'e-mails
Utiliser Google Maps, SendGrid et l'IA pour automatiser le développement de prospects B2B et le marketing par e-mail
If
Set
Code
+
If
Set
Code
141 NœudsEzema Kingsley Chibuzo
Génération de leads
Analyseur de commentaires des spectateurs YouTube
Utiliser Gemini AI pour analyser le sentiment des commentaires YouTube et sauvegarder dans Google Sheets
If
Split Out
Http Request
+
If
Split Out
Http Request
17 NœudsAgent Circle
Étude de marché
Analyse automatisée des publicités Meta
Analyse automatique des publicités Meta avec Gemini AI, ScrapingFlash et Google Sheets
Limit
Split Out
Http Request
+
Limit
Split Out
Http Request
17 NœudsPaul-François GORIAUX
Étude de marché
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds24
Catégorie2
Types de nœuds10
Description de la difficulté
Auteur
Zacharia Kimotho
@imperolqAutomation expert with years of experience helping businesses improve their efficiency and productivity with smart automations that are affordable, scalable, and flexible.
Liens externes
Voir sur n8n.io →
Partager ce workflow