使用Google Sheets和Telegram的Explorium MCP智能潜在客户触达
高级
这是一个AI领域的自动化工作流，包含 23 个节点。主要使用 If, Code, Telegram, GoogleSheets, Agent 等节点，结合人工智能技术实现智能自动化。 基于Explorium MCP、Google Sheets和Telegram的智能潜在客户触达
前置要求
- •Telegram Bot Token
- •Google Sheets API 凭证
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
- •Google Gemini API Key
- •PostgreSQL 数据库连接信息
使用的节点 (23)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "QJxM3oTiPoFiRO9Y",
"meta": {
"instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc"
},
"name": "使用 Google Sheets 和 Telegram 的 Explorium MCP 智能潜在客户触达",
"tags": [],
"nodes": [
{
"id": "8220566c-d068-4da5-af75-1b3f946a2e97",
"name": "Telegram 触发器",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
1580,
200
],
"webhookId": "19045114-ade9-4c43-9beb-64a226b7d297",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "2a50c70c-6537-498f-ad4c-6a232cd5225e",
"name": "增强型 AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1880,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0e31696b-7236-4809-a8b6-0939690520dc",
"name": "OpenAI GPT-4",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2380,
560
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "1f232c08-9eef-458e-a45d-48d16ba1766a",
"name": "Postgres 内存",
"type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
"position": [
2320,
660
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "38c484f5-8ad7-4ee9-a89e-b6499ea16498",
"name": "Explorium MCP 客户端",
"type": "@n8n/n8n-nodes-langchain.mcpClientTool",
"position": [
1560,
700
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a76e0f45-8501-4594-ab40-fd84a13adda2",
"name": "增强型 Tavily 搜索",
"type": "n8n-nodes-base.httpRequestTool",
"position": [
1760,
680
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "988248fa-cb4b-4228-be8a-35c2a2b2d6fc",
"name": "智能数据处理器",
"type": "n8n-nodes-base.code",
"position": [
2360,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4498b8d4-d348-4789-af18-d096831eda8b",
"name": "Telegram 响应",
"type": "n8n-nodes-base.telegram",
"position": [
2820,
140
],
"webhookId": "b673900a-8b35-4e7c-a662-c5ebef2c6ca5",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "d928e6f9-3bc0-497a-9f30-47690aaeb0d9",
"name": "潜在客户数据过滤器",
"type": "n8n-nodes-base.if",
"position": [
2560,
1180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0d79f485-6c48-45d7-8be3-a6571f8cd12c",
"name": "个人/公司拆分",
"type": "n8n-nodes-base.if",
"position": [
2800,
1160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e3977ba4-974d-45aa-9551-3bb3540145e0",
"name": "保存个人数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
4040,
1160
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "0038c8cd-a10c-462c-8ede-aacf5a7c9e1b",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "776b4d30-33ec-4772-972b-0a279aaafa09",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2220,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "128889b1-899d-40c3-a35f-52b669591db9",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1440,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4393728c-7a77-4a6e-856c-3f5a2db7698d",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1800,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "55d249fe-e7bf-487c-8956-7f7d0e73598b",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1480,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "905b4aa3-eb93-4860-99af-d8f6ac8ad4b0",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2520,
360
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6ec63191-bc63-4e4e-b38b-3741ddd96d2d",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
3000,
1140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "abb2ccfe-e0d9-4672-ae3c-fff00892c8b9",
"name": "Google Gemini聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2900,
1340
],
"parameters": {},
"typeVersion": 1
},
{
"id": "da26b1fe-a135-4729-a195-25ab8de7ecbd",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2680,
-20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "499121cf-5d7e-429e-a8b2-797f371e68bd",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
2040,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e24d339f-70e6-4f4e-be6c-c85b3d975808",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
3600,
1120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b9ed567b-6057-4377-b197-d3d60a6fb338",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
3360,
1140
],
"parameters": {},
"typeVersion": 2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "e3732194-a037-4234-9baa-021aa2d8f202",
"connections": {
"Code": {
"main": [
[
{
"node": "Save Person Data",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"OpenAI GPT-4": {
"ai_languageModel": [
[
{
"node": "Enhanced AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Postgres Memory": {
"ai_memory": [
[
{
"node": "Enhanced AI Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"Lead Data Filter": {
"main": [
[
{
"node": "Person/Company Split",
"type": "main",
"index": 0
}
]
]
},
"Telegram Trigger": {
"main": [
[
{
"node": "Enhanced AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Enhanced AI Agent": {
"main": [
[
{
"node": "Smart Data Processor",
"type": "main",
"index": 0
}
]
]
},
"Explorium MCP Client": {
"ai_tool": [
[
{
"node": "Enhanced AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Person/Company Split": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
],
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Smart Data Processor": {
"main": [
[
{
"node": "Telegram Response",
"type": "main",
"index": 0
},
{
"node": "Lead Data Filter",
"type": "main",
"index": 0
}
]
]
},
"Enhanced Tavily Search": {
"ai_tool": [
[
{
"node": "Enhanced AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI 助手已更新
Stacey - 您的 Telegram AI 助手（基于 MCP、Gemini 和 Google 工具）
Set
Code
Switch
+15
32 节点David Olusola
其他
AI驱动的线索丰富Telegram和Explorium MCP
使用GPT-4、Explorium MCP和Telegram生成个性化销售拓展
Telegram
Agent
Http Request Tool
+5
11 节点David Olusola
潜在客户开发
图像生成器
通过Google云端硬盘和表格实现AI图像生成与Telegram交付的自动化流程
Telegram
Google Drive
Http Request
+6
11 节点David Olusola
设计
企业版Telegram销售助手
AI销售代理：Telegram审批与Google表格同步
If
Telegram
Agent
+6
16 节点David Olusola
人工智能
PromptCraft AI
通过Telegram使用DALL-E和GPT生成增强AI图像
Telegram
Google Drive
Http Request
+5
12 节点David Olusola
设计
智能客户支持系统（集成GPT-4o、Gmail、Slack和Drive知识库）
集成GPT-4o、Gmail、Slack和Drive知识库的智能客户支持系统
If
Code
Gmail Tool
+13
19 节点David Olusola
客户支持
工作流信息
难度等级
高级
节点数量23
分类1
节点类型12
作者
David Olusola
@dae221AI automation consultant working with ambitious businesses on their most complex operational challenges. For project inquiries, reach me at david@daexai.com
外部链接
在 n8n.io 查看 →
分享此工作流