通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
高级
这是一个Market Research, Multimodal AI领域的自动化工作流，包含 18 个节点。主要使用 Set, Code, Limit, Filter, SplitOut 等节点。 通过ApiFlash、Gemini Vision和Sheets到Telegram的自动化科技新闻报告
前置要求
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (18)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "783d2046f405cc6ecb20ef185376ed1023323a3da628b9d8156b1fb75c75e037",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "7b30536c-cfcb-4571-88e1-3ad6ba493496",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
208,
0
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2eed1a6d-8758-43f5-a02f-8771bc0eff16",
"name": "分析图像",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
416,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6abd306b-2eb0-4cdc-aa6b-d285857a8019",
"name": "发送照片消息",
"type": "n8n-nodes-base.telegram",
"position": [
416,
-192
],
"webhookId": "96f1daef-5995-4f02-9a85-548401781800",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "daf214ad-3b49-4b21-acc1-a9212c414efb",
"name": "发送短信",
"type": "n8n-nodes-base.telegram",
"position": [
976,
480
],
"webhookId": "79422d09-af4b-4007-970e-ee1dece6cd87",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "f5613c28-0ab6-49f4-b7e8-d355e7e30a24",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-624,
192
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "7c5901a0-1d73-4931-8cf8-d2eefe2ff115",
"name": "读取整个工作表",
"type": "n8n-nodes-base.googleSheets",
"position": [
1472,
0
],
"parameters": {},
"typeVersion": 4
},
{
"id": "740ade70-af43-4c5c-8cd9-9cc2e8eaed66",
"name": "AI 趋势报告",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
656,
480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d74f5e6d-b1d5-4229-90ff-de65ba94ca96",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
624,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a9247b68-e3a4-4fa4-b9d2-44513b28a733",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
832,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "efd2abec-3d89-4fb9-9e33-c405cb0fa96a",
"name": "在表格中追加行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1040,
0
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "f6b65a80-d2fa-4984-a206-83d04352dd09",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
1248,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e5d4cb55-1864-4157-9606-e4c0aacd42fc",
"name": "聚合 1",
"type": "n8n-nodes-base.aggregate",
"position": [
1360,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "129d1d6c-275d-406f-b0b2-b241565c0151",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
848,
240
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "983032fd-7557-4a61-9000-ad8eeeed10bb",
"name": "过滤器",
"type": "n8n-nodes-base.filter",
"position": [
640,
240
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "323a76a0-6e78-4128-b971-1a3603bc092d",
"name": "限制",
"type": "n8n-nodes-base.limit",
"position": [
1056,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e131e3e2-180d-4c65-9580-444a43cf158d",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7054fa99-84e0-408e-8990-489b39de027a",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
192
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "83769ea5-b9ba-4355-ae8f-6c72b1dcd858",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-624,
-240
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Code": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Aggregate1",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Read entire Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Aggregate1": {
"main": [
[
{
"node": "AI Trend Report",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Analyze image",
"type": "main",
"index": 0
},
{
"node": "Send a photo message",
"type": "main",
"index": 0
}
]
]
},
"Analyze image": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"AI Trend Report": {
"main": [
[
{
"node": "Send a text message",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Read entire Sheet": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
竞争对手WordPress分析器
使用图表、Gemini和Telegram报告的每日竞争对手WordPress分析
Limit
Merge
Telegram
+6
16 节点Cong Nguyen
市场调研
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
YouTube评论情感和关键词提取器
使用Gemini AI分析YouTube评论情感和关键词并通过Telegram报告
Set
Code
Telegram
+10
20 节点Budi SJ
市场调研
WordPress SEO发布器
集成Anthropic AI、Google Docs和媒体自动化的WordPress SEO发布器
Set
Code
Merge
+12
41 节点Cong Nguyen
内容创作
内容生成器 v3
AI驱动博客自动化：使用GPT-4生成并发布SEO文章至WordPress和Twitter
If
Set
Code
+25
144 节点Jay Emp0
内容创作
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
工作流信息
难度等级
高级
节点数量18
分类2
节点类型12
作者
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 查看 →
分享此工作流