Usar Google Scraping, Bright Data y Gemini AI para analizar la intención de búsqueda de palabras clave
Avanzado
Este es unMarket Research, AI Summarizationflujo de automatización del dominio deautomatización que contiene 24 nodos.Utiliza principalmente nodos como Set, Merge, SplitOut, HttpRequest, GoogleSheets. Usar web scraping de Google, Bright Data y Gemini AI para analizar la intención de búsqueda de palabras clave
Requisitos previos
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
- •Clave de API de Google Gemini
Nodos utilizados (24)
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"meta": {
"instanceId": "db80165df40cb07c0377167c050b3f9ab0b0fb04f0e8cae0dc53f5a8527103ca",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "63865e5c-9e83-49ad-8d51-02391ee9e36c",
"name": "Al hacer clic en 'Ejecutar flujo de trabajo'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-920,
-700
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e935f831-25e0-4325-b0a4-72dd632c6c46",
"name": "Obtener resultados de búsqueda 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": "Separar",
"type": "n8n-nodes-base.splitOut",
"position": [
160,
-680
],
"parameters": {
"options": {},
"fieldToSplitOut": "organic"
},
"typeVersion": 1
},
{
"id": "ee4881f0-9148-493e-825e-ce2dde83fbae",
"name": "Obtener palabras clave",
"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": "Iterar sobre elementos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-460,
-700
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "c4d31168-a21a-44ba-8cb6-a4a51167aa49",
"name": "formatear campos",
"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": "agregar resultado de ranking",
"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": "Clasificador de intención",
"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 Modelo de Chat2",
"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": "informativo",
"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": "navegacional",
"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": "comercial",
"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": "transaccional",
"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": "mixto",
"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": "Nota adhesiva1",
"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": "Combinar intenciones",
"type": "n8n-nodes-base.merge",
"position": [
1120,
-720
],
"parameters": {
"numberInputs": 5
},
"typeVersion": 3.2
},
{
"id": "ad137e75-05e9-4582-981f-43f6df6becbf",
"name": "Nota adhesiva3",
"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": "Nota adhesiva4",
"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": "Nota adhesiva5",
"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": "establecer palabra clave",
"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": "Nota adhesiva6",
"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": "Nota adhesiva7",
"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": "Nota adhesiva8",
"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": "Nota adhesiva9",
"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
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Investigación de mercado, Resumen de IA
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
01 Usar comprador de medios AI para analizar el rendimiento de anuncios de Facebook y enviar información a Google Sheets
Analizar anuncios de Facebook con Gemini AI y enviar insights a Google Sheets
If
Set
Code
+
If
Set
Code
34 NodosJJ Tham
Investigación de mercado
Plantilla de Creador de Temas
Usar Gemini para analizar Reddit, YouTube y X y generar informes de estrategia de contenido
If
Set
Code
+
If
Set
Code
34 NodosSheryl
Investigación de mercado
Generar títulos y meta descripciones optimizados para SEO con Bright Data y Gemini AI
Usar Bright Data y Gemini AI para generar títulos optimizados para SEO y meta descripciones
Set
Http Request
Google Sheets
+
Set
Http Request
Google Sheets
16 NodosZacharia Kimotho
Investigación de mercado
Desarrollo de leads y flujos de correo electrónico
Usar Google Maps, SendGrid e IA para automatizar el desarrollo de leads B2B y el marketing por correo electrónico
If
Set
Code
+
If
Set
Code
141 NodosEzema Kingsley Chibuzo
Generación de leads
Analizador de comentarios de espectadores de YouTube
Usar Gemini AI para analizar el sentimiento de los comentarios de YouTube y guardar en Google Sheets
If
Split Out
Http Request
+
If
Split Out
Http Request
17 NodosAgent Circle
Investigación de mercado
Análisis automatizado de anuncios de Meta
Análisis automatizado de anuncios de Meta usando Gemini AI, ScrapingFlash y Google Sheets
Limit
Split Out
Http Request
+
Limit
Split Out
Http Request
17 NodosPaul-François GORIAUX
Investigación de mercado
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos24
Categoría2
Tipos de nodos10
Descripción de la dificultad
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.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo