客户个性分析（八字、DISC、命理学）与 Gemini 和 Google Sheets
高级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 24 个节点。主要使用 If, Code, Merge, Filter, Aggregate 等节点。 使用 Gemini 和 Google Sheets 进行客户个性分析（八字、DISC、命理学）
前置要求
- •Google Sheets API 凭证
使用的节点 (24)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "783d2046f405cc6ecb20ef185376ed1023323a3da628b9d8156b1fb75c75e037"
},
"nodes": [
{
"id": "1830c823-4513-4ef3-90d2-c76c32574cbe",
"name": "Google Sheets 触发器",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-32,
352
],
"parameters": {},
"typeVersion": 1
},
{
"id": "872f99cc-9a63-4f54-8e17-ef77a04d19ab",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
1200,
848
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "b6f1df09-ff2a-4f8d-82b4-be386cf60e7e",
"name": "条件判断1",
"type": "n8n-nodes-base.if",
"position": [
1200,
656
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "8b03f1c0-4618-40aa-ae45-04db1c82fe82",
"name": "条件判断2",
"type": "n8n-nodes-base.if",
"position": [
1200,
448
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c9372ec7-1152-479a-95b3-d2b3a2b2a9ff",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
2096,
624
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "91c350a4-ae83-4973-b50f-584bd52032fe",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"position": [
2096,
832
],
"parameters": {},
"typeVersion": 1
},
{
"id": "21be391a-4121-4640-9889-3505a67f3e6d",
"name": "在 sheet1 中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
432
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "545ae9fb-af0a-4902-9112-ba923c106156",
"name": "在 sheet2 中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
640
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "27578658-3119-4726-ba00-943e2b11b31f",
"name": "在 sheet3 中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
832
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "546a1f41-9bf6-4a93-99ad-4e5882d46d96",
"name": "在 sheet4 中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
176
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "d9a135fe-3522-4697-8638-abaffff61eca",
"name": "筛选器",
"type": "n8n-nodes-base.filter",
"position": [
176,
352
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "720d5e54-999d-4c37-b7ab-b117d00b1675",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
880,
352
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f9e5cbfa-e82e-4d9e-b252-baffcb4433a9",
"name": "获取工作表中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
224
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "ed97228e-8590-4a9f-8b92-07a07cfef0f7",
"name": "在 sheet 中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
2208,
224
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5e06bfdc-4cce-4e24-9172-82e776b57231",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bedb9097-a577-4705-9b82-0f8c9fc72b29",
"name": "计算八字",
"type": "n8n-nodes-base.code",
"position": [
400,
352
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4a551a1b-faa8-4c36-a31c-28ea7dcf3857",
"name": "计算数字命理",
"type": "n8n-nodes-base.code",
"position": [
640,
352
],
"parameters": {},
"typeVersion": 2
},
{
"id": "02af4f4c-b58d-4284-bb58-1ca473cd8276",
"name": "数字命理分析",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1456,
432
],
"parameters": {},
"typeVersion": 1
},
{
"id": "49c88283-828a-46d2-8a9e-425e423739ec",
"name": "八字分析",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1456,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1aa1c178-e987-4af3-939f-239cf6e7cd4d",
"name": "DISC 分析",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1456,
832
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ff31f356-4935-43e5-80a7-f83a752c093c",
"name": "客户洞察总结",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1456,
224
],
"parameters": {},
"typeVersion": 1
},
{
"id": "92866b3d-681f-44f4-b395-9a9ffa193b10",
"name": "编写销售话术",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1808,
224
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5220ff92-68a2-4007-8c94-1285f4c2a1cd",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
512
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "63e91a2d-bd2b-40e9-8534-7880c9a89adb",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
768
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "DISC Analysis",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"If1": {
"main": [
[
{
"node": "Bazi Analysis",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"If2": {
"main": [
[
{
"node": "Numerology analysis",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Compute Bazi",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Compute Bazi": {
"main": [
[
{
"node": "Compute Numerology",
"type": "main",
"index": 0
}
]
]
},
"Bazi Analysis": {
"main": [
[
{
"node": "Update row in sheet2",
"type": "main",
"index": 0
}
]
]
},
"DISC Analysis": {
"main": [
[
{
"node": "Update row in sheet3",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "If2",
"type": "main",
"index": 0
},
{
"node": "If1",
"type": "main",
"index": 0
},
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Compute Numerology": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
},
{
"node": "Update row in sheet4",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Summary Customer Insight",
"type": "main",
"index": 0
}
]
]
},
"Numerology analysis": {
"main": [
[
{
"node": "Update row in sheet1",
"type": "main",
"index": 0
}
]
]
},
"Update row in sheet1": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Update row in sheet2": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Update row in sheet3": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Summary Customer Insight": {
"main": [
[
{
"node": "Writing Script for Salers",
"type": "main",
"index": 0
}
]
]
},
"Writing Script for Salers": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
Set
Code
Limit
+9
18 节点Cong Nguyen
市场调研
使用LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
通过LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
If
Code
Limit
+11
47 节点Matthieu
潜在客户开发
AI驱动的谷歌地图商家数据抓取与表格导出
基于AI的谷歌地图商家数据抓取，支持数据丰富化并导出至表格
If
Code
Wait
+13
25 节点Msaid Mohamed el hadi
潜在客户开发
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
If
Set
Code
+16
48 节点Daniel Lianes
内容创作
工作流信息
难度等级
高级
节点数量24
分类2
节点类型10
作者
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.
外部链接
在 n8n.io 查看 →
分享此工作流