Análisis de personalidad de clientes (Bazi, DISC, astrología) con Gemini y Google Sheets
Avanzado
Este es unLead Generation, Multimodal AIflujo de automatización del dominio deautomatización que contiene 24 nodos.Utiliza principalmente nodos como If, Code, Merge, Filter, Aggregate. Análisis de personalidad de clientes (ba zi, DISC, astrología) usando Gemini y Google Sheets
Requisitos previos
- •Credenciales de API de Google Sheets
Nodos utilizados (24)
Categoría
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": "783d2046f405cc6ecb20ef185376ed1023323a3da628b9d8156b1fb75c75e037"
},
"nodes": [
{
"id": "1830c823-4513-4ef3-90d2-c76c32574cbe",
"name": "Hojas de Google Trigger",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-32,
352
],
"parameters": {},
"typeVersion": 1
},
{
"id": "872f99cc-9a63-4f54-8e17-ef77a04d19ab",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
1200,
848
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "b6f1df09-ff2a-4f8d-82b4-be386cf60e7e",
"name": "If1",
"type": "n8n-nodes-base.if",
"position": [
1200,
656
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "8b03f1c0-4618-40aa-ae45-04db1c82fe82",
"name": "If2",
"type": "n8n-nodes-base.if",
"position": [
1200,
448
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c9372ec7-1152-479a-95b3-d2b3a2b2a9ff",
"name": "Fusionar",
"type": "n8n-nodes-base.merge",
"position": [
2096,
624
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "91c350a4-ae83-4973-b50f-584bd52032fe",
"name": "Agregar",
"type": "n8n-nodes-base.aggregate",
"position": [
2096,
832
],
"parameters": {},
"typeVersion": 1
},
{
"id": "21be391a-4121-4640-9889-3505a67f3e6d",
"name": "Actualizar fila en sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
432
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "545ae9fb-af0a-4902-9112-ba923c106156",
"name": "Actualizar fila en sheet2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
640
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "27578658-3119-4726-ba00-943e2b11b31f",
"name": "Actualizar fila en sheet3",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
832
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "546a1f41-9bf6-4a93-99ad-4e5882d46d96",
"name": "Actualizar fila en sheet4",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
176
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "d9a135fe-3522-4697-8638-abaffff61eca",
"name": "Filtrar",
"type": "n8n-nodes-base.filter",
"position": [
176,
352
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "720d5e54-999d-4c37-b7ab-b117d00b1675",
"name": "Recorrer elementos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
880,
352
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f9e5cbfa-e82e-4d9e-b252-baffcb4433a9",
"name": "Obtener fila(s) en sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
224
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "ed97228e-8590-4a9f-8b92-07a07cfef0f7",
"name": "Actualizar fila en sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2208,
224
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5e06bfdc-4cce-4e24-9172-82e776b57231",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bedb9097-a577-4705-9b82-0f8c9fc72b29",
"name": "Compute Bazi",
"type": "n8n-nodes-base.code",
"position": [
400,
352
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4a551a1b-faa8-4c36-a31c-28ea7dcf3857",
"name": "Compute Numerology",
"type": "n8n-nodes-base.code",
"position": [
640,
352
],
"parameters": {},
"typeVersion": 2
},
{
"id": "02af4f4c-b58d-4284-bb58-1ca473cd8276",
"name": "Numerology analysis",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1456,
432
],
"parameters": {},
"typeVersion": 1
},
{
"id": "49c88283-828a-46d2-8a9e-425e423739ec",
"name": "Bazi Analysis",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1456,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1aa1c178-e987-4af3-939f-239cf6e7cd4d",
"name": "DISC Analysis",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1456,
832
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ff31f356-4935-43e5-80a7-f83a752c093c",
"name": "Summary Customer Insight",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1456,
224
],
"parameters": {},
"typeVersion": 1
},
{
"id": "92866b3d-681f-44f4-b395-9a9ffa193b10",
"name": "Writing Script for Salers",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1808,
224
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5220ff92-68a2-4007-8c94-1285f4c2a1cd",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
512
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "63e91a2d-bd2b-40e9-8534-7880c9a89adb",
"name": "Nota adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
768
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"872f99cc-9a63-4f54-8e17-ef77a04d19ab": {
"main": [
[
{
"node": "1aa1c178-e987-4af3-939f-239cf6e7cd4d",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"b6f1df09-ff2a-4f8d-82b4-be386cf60e7e": {
"main": [
[
{
"node": "49c88283-828a-46d2-8a9e-425e423739ec",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"8b03f1c0-4618-40aa-ae45-04db1c82fe82": {
"main": [
[
{
"node": "02af4f4c-b58d-4284-bb58-1ca473cd8276",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "bedb9097-a577-4705-9b82-0f8c9fc72b29",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"bedb9097-a577-4705-9b82-0f8c9fc72b29": {
"main": [
[
{
"node": "4a551a1b-faa8-4c36-a31c-28ea7dcf3857",
"type": "main",
"index": 0
}
]
]
},
"49c88283-828a-46d2-8a9e-425e423739ec": {
"main": [
[
{
"node": "545ae9fb-af0a-4902-9112-ba923c106156",
"type": "main",
"index": 0
}
]
]
},
"1aa1c178-e987-4af3-939f-239cf6e7cd4d": {
"main": [
[
{
"node": "27578658-3119-4726-ba00-943e2b11b31f",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "f9e5cbfa-e82e-4d9e-b252-baffcb4433a9",
"type": "main",
"index": 0
}
],
[
{
"node": "8b03f1c0-4618-40aa-ae45-04db1c82fe82",
"type": "main",
"index": 0
},
{
"node": "b6f1df09-ff2a-4f8d-82b4-be386cf60e7e",
"type": "main",
"index": 0
},
{
"node": "872f99cc-9a63-4f54-8e17-ef77a04d19ab",
"type": "main",
"index": 0
}
]
]
},
"4a551a1b-faa8-4c36-a31c-28ea7dcf3857": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
},
{
"node": "546a1f41-9bf6-4a93-99ad-4e5882d46d96",
"type": "main",
"index": 0
}
]
]
},
"f9e5cbfa-e82e-4d9e-b252-baffcb4433a9": {
"main": [
[
{
"node": "ff31f356-4935-43e5-80a7-f83a752c093c",
"type": "main",
"index": 0
}
]
]
},
"02af4f4c-b58d-4284-bb58-1ca473cd8276": {
"main": [
[
{
"node": "21be391a-4121-4640-9889-3505a67f3e6d",
"type": "main",
"index": 0
}
]
]
},
"21be391a-4121-4640-9889-3505a67f3e6d": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"545ae9fb-af0a-4902-9112-ba923c106156": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"27578658-3119-4726-ba00-943e2b11b31f": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"ff31f356-4935-43e5-80a7-f83a752c093c": {
"main": [
[
{
"node": "92866b3d-681f-44f4-b395-9a9ffa193b10",
"type": "main",
"index": 0
}
]
]
},
"92866b3d-681f-44f4-b395-9a9ffa193b10": {
"main": [
[
{
"node": "ed97228e-8590-4a9f-8b92-07a07cfef0f7",
"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 - Generación de leads, IA Multimodal
¿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
基于AIde潜在clientegeneración系统（correo electrónico个性化yLinkedIn）
基于AIde潜在clientegeneración系统：包含correo electrónico个性化yLinkedIn功能
If
Code
Limit
+
If
Code
Limit
51 NodosMatthieu
Generación de leads
Informe automatizado de noticias tecnológicas de ApiFlash, Gemini Vision y Sheets a Telegram
Informe automatizado de noticias tecnológicas con ApiFlash, Gemini Vision y Sheets a Telegram
Set
Code
Limit
+
Set
Code
Limit
18 NodosCong Nguyen
Investigación de mercado
Crear prospectos calificados y guiones de llamadas en frío usando LinkedIn, OpenAI y Sales Navigator
Crear leads cualificados y guiones para llamadas frías usando LinkedIn, OpenAI y Sales Navigator
If
Code
Limit
+
If
Code
Limit
47 NodosMatthieu
Generación de leads
Extracción de Datos de Negocios en Google Maps Impulsada por IA y Exportación a Tablas
Extracción de datos de negocios en Google Maps basada en IA, con soporte para enriquecimiento de datos y exportación a tablas
If
Code
Wait
+
If
Code
Wait
25 NodosMsaid Mohamed el hadi
Generación de leads
WordPress Blog Automation Pro (Investigación profunda) v2.1 Marketplace
Usar GPT-4o, Perplexity AI y soporte multilingüe para automatizar la creación de blogs optimizados para SEO
If
Set
Xml
+
If
Set
Xml
125 NodosDaniel Ng
Creación de contenido
Usar IA y Freepik para convertir dolores empresariales de Reddit en contenido viral para LinkedIn
Usar IA y Freepik para convertir problemas de negocios de Reddit en contenido viral para LinkedIn
If
Set
Code
+
If
Set
Code
48 NodosDaniel Lianes
Creación de contenido
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
Cong Nguyen
@cong-nguyenI’m a developer specialized in building web and mobile applications with AI integration and intelligent automation. With a solid background in data science, I help businesses build smarter digital solutions using cutting-edge technologies.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo