Analyse de la personnalité client (Ba Zi, DISC, Astrologie) avec Gemini et Google Sheets
Avancé
Ceci est unLead Generation, Multimodal AIworkflow d'automatisation du domainecontenant 24 nœuds.Utilise principalement des nœuds comme If, Code, Merge, Filter, Aggregate. Analyse de la personnalité des clients (八字, DISC, astrologie) avec Gemini et Google Sheets
Prérequis
- •Informations d'identification Google Sheets API
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": "783d2046f405cc6ecb20ef185376ed1023323a3da628b9d8156b1fb75c75e037"
},
"nodes": [
{
"id": "1830c823-4513-4ef3-90d2-c76c32574cbe",
"name": "Google Sheets 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": "Fusionner",
"type": "n8n-nodes-base.merge",
"position": [
2096,
624
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "91c350a4-ae83-4973-b50f-584bd52032fe",
"name": "Agréger",
"type": "n8n-nodes-base.aggregate",
"position": [
2096,
832
],
"parameters": {},
"typeVersion": 1
},
{
"id": "21be391a-4121-4640-9889-3505a67f3e6d",
"name": "Update row in sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
432
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "545ae9fb-af0a-4902-9112-ba923c106156",
"name": "Update row in sheet2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
640
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "27578658-3119-4726-ba00-943e2b11b31f",
"name": "Update row in sheet3",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
832
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "546a1f41-9bf6-4a93-99ad-4e5882d46d96",
"name": "Update row in sheet4",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
176
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "d9a135fe-3522-4697-8638-abaffff61eca",
"name": "Filtrer",
"type": "n8n-nodes-base.filter",
"position": [
176,
352
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "720d5e54-999d-4c37-b7ab-b117d00b1675",
"name": "Boucler sur les éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
880,
352
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f9e5cbfa-e82e-4d9e-b252-baffcb4433a9",
"name": "Get row(s) in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
224
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "ed97228e-8590-4a9f-8b92-07a07cfef0f7",
"name": "Update row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2208,
224
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5e06bfdc-4cce-4e24-9172-82e776b57231",
"name": "Note adhésive",
"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": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
512
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "63e91a2d-bd2b-40e9-8534-7880c9a89adb",
"name": "Note adhésive2",
"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
}
]
]
},
"1830c823-4513-4ef3-90d2-c76c32574cbe": {
"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
}
]
]
}
}
}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é - Génération de leads, IA Multimodale
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
基于AIde潜在clientgénération系统（e-mail个性化etLinkedIn）
基于AIde潜在clientgénération系统：包含e-mail个性化etLinkedIn功能
If
Code
Limit
+
If
Code
Limit
51 NœudsMatthieu
Génération de leads
Rapport automatisé d'actualités technologiques avec ApiFlash, Gemini Vision et Sheets vers Telegram
Rapport automatisé sur les actualités technologiques via ApiFlash, Gemini Vision, Sheets vers Telegram
Set
Code
Limit
+
Set
Code
Limit
18 NœudsCong Nguyen
Étude de marché
Créer des prospects qualifiés et des scripts de démarchage froid avec LinkedIn, OpenAI et Sales Navigator
Créer des prospects qualifiés et des scripts pour des appels à froid via LinkedIn, OpenAI et Sales Navigator
If
Code
Limit
+
If
Code
Limit
47 NœudsMatthieu
Génération de leads
AI驱动de谷歌地图商家données抓取与表格exportation
基于AIde谷歌地图商家données抓取，支持données丰富化并exportation至表格
If
Code
Wait
+
If
Code
Wait
25 NœudsMsaid Mohamed el hadi
Génération de leads
Version professionnelle de l'automatisation de blog WordPress (recherche approfondie) v2.1 sur le marché
Automatisation de la création de blog optimisé pour le SEO avec GPT-4o, Perplexity AI et support multilingue
If
Set
Xml
+
If
Set
Xml
125 NœudsDaniel Ng
Création de contenu
Convertir les points de douleur commerciaux Reddit en contenu viral LinkedIn avec l'IA et Freepik
Utiliser l'IA et Freepik pour convertir les points de douleur métier Reddit en contenu LinkedIn viral
If
Set
Code
+
If
Set
Code
48 NœudsDaniel Lianes
Création de contenu
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds24
Catégorie2
Types de nœuds10
Description de la difficulté
Auteur
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.
Liens externes
Voir sur n8n.io →
Partager ce workflow