使用Excel、Outlook和AI的每日新闻简报服务
高级
这是一个AI, Marketing领域的自动化工作流，包含 33 个节点。主要使用 If, Set, Html, Merge, SplitOut 等节点，结合人工智能技术实现智能自动化。 使用Excel、Outlook和AI的每日新闻简报服务
前置要求
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
使用的节点 (33)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "408f9fb9940c3cb18ffdef0e0150fe342d6e655c3a9fac21f0f644e8bedabcd9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "c3a9ba81-3a7e-4afe-be8b-cf482cbb88c2",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1040,
-540
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 6
}
]
}
},
"typeVersion": 1.2
},
{
"id": "f63d035c-5a7b-4cf4-8730-5fa7dff6f94b",
"name": "获取订阅者",
"type": "n8n-nodes-base.microsoftExcel",
"position": [
-860,
-540
],
"parameters": {
"options": {},
"resource": "worksheet",
"workbook": {
"__rl": true,
"mode": "id",
"value": "="
},
"operation": "readRows",
"worksheet": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"microsoftExcelOAuth2Api": {
"id": "56tIUYYVARBe9gfX",
"name": "Microsoft Excel account"
}
},
"typeVersion": 2.1
},
{
"id": "e93aa8de-5c68-4a01-ae60-beb141e0a430",
"name": "获取唯一类别",
"type": "n8n-nodes-base.set",
"position": [
-400,
-160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "fe138128-50d5-469f-8c0b-0af8c873f198",
"name": "categories",
"type": "array",
"value": "={{ $input.all().flatMap(item => item.json.categories).unique() }}"
}
]
}
},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "a874ae4e-d67e-4019-9e5c-03ea677468ae",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
760,
80
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8gccIjcuf3gvaoEr",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "bc9c7578-3b6f-45fb-9f93-94637774d125",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
1180,
40
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "ae83c9e2-a267-463c-a606-b4d101f93f92",
"name": "收集字段",
"type": "n8n-nodes-base.set",
"position": [
980,
-60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4a266505-4b88-41cf-bf22-f38c705c27e5",
"name": "workflow_id",
"type": "number",
"value": "={{ $('Workflows to Items').item.json.workflow.id }}"
},
{
"id": "df3348e2-b6ec-4c38-a146-c38be9b830bc",
"name": "workflow_name",
"type": "string",
"value": "={{ $('Workflows to Items').item.json.workflow.name }}"
},
{
"id": "b4646059-748f-407a-b829-d6605d5ab683",
"name": "workflow_desc",
"type": "string",
"value": "={{ $json.response.text }}"
},
{
"id": "eac0d9ab-9445-4bc2-9e64-160fe44b9ace",
"name": "workflow_created_at",
"type": "string",
"value": "={{ $('Workflows to Items').item.json.workflow.createdAt }}"
},
{
"id": "24a3c0cb-224c-4ce6-b59e-38b10ab2c02f",
"name": "author_id",
"type": "number",
"value": "={{ $('Workflows to Items').item.json.workflow.user.id }}"
},
{
"id": "a2b8a52f-be72-484c-aa86-582b73be1859",
"name": "author_name",
"type": "string",
"value": "={{ $('Workflows to Items').item.json.workflow.user.name }}"
},
{
"id": "ae735511-8c7c-4bef-b6ac-cfe3d4b87b4f",
"name": "author_username",
"type": "string",
"value": "={{ $('Workflows to Items').item.json.workflow.user.username }}"
},
{
"id": "2dc1f59f-a854-4322-85df-c5998f782dcd",
"name": "category",
"type": "string",
"value": "={{ $('For Each Category').item.json.category }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "8ca1ea7e-9098-4e82-919b-ba98ae7d7574",
"name": "类别转项目",
"type": "n8n-nodes-base.splitOut",
"position": [
-220,
-160
],
"parameters": {
"options": {
"destinationFieldName": "category"
},
"fieldToSplitOut": "categories"
},
"typeVersion": 1
},
{
"id": "eb6d74b8-f1ed-4ab2-8c5f-7e6c6361b055",
"name": "遍历每个类别",
"type": "n8n-nodes-base.splitInBatches",
"position": [
320,
-160
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "8640ffac-9df6-4154-bcd5-dfa90c3843d4",
"name": "工作流转项目",
"type": "n8n-nodes-base.splitOut",
"position": [
500,
-60
],
"parameters": {
"options": {
"destinationFieldName": "workflow"
},
"fieldToSplitOut": "workflows"
},
"typeVersion": 1
},
{
"id": "4456a43b-df26-4bb8-a62d-b9f05eff4479",
"name": "工作流摘要生成器",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
660,
-60
],
"parameters": {
"text": "=## Description\n```\n{{ $json.workflow.description.replaceAll('#', '') }}\n```",
"messages": {
"messageValues": [
{
"message": "=You have received a description of a n8n template from the official template gallery. Your task is to summarize the description into one or two sentences. The summary should loosely follow the structure of:\n* identify the goal of the template\n* describe the method or approached implemented\n* highlight which important n8n nodes were used\n\neg. \"Obtain real-time crypto market insights using an AI-powered workflow with CoinMarketCap APIs through Telegram\""
}
]
},
"promptType": "define"
},
"typeVersion": 1.5
},
{
"id": "5f4a5921-c954-4523-8925-90401d8dbf22",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
660,
-460
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 3.1
},
{
"id": "f95fb28c-875c-4105-aa83-9fea257ea440",
"name": "获取每类别最新10个",
"type": "n8n-nodes-base.httpRequest",
"position": [
-40,
-160
],
"parameters": {
"url": "=https://n8n.io/api/product-api/workflows/search",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "category",
"value": "={{$json.category }}"
},
{
"name": "rows",
"value": "10"
},
{
"name": "sort",
"value": "createdAt:desc"
},
{
"name": "page",
"value": "1"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "4dda6cbc-e53f-452d-b257-df9ef18abd75",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
1560,
-460
],
"parameters": {},
"typeVersion": 1
},
{
"id": "881337d8-3ca8-43d2-931f-9cfec16cc367",
"name": "获取相关工作流",
"type": "n8n-nodes-base.set",
"position": [
1380,
-280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "fbd0ad94-e5aa-4082-81f5-d7b2e08dfbcf",
"name": "workflows",
"type": "array",
"value": "={{\n$json.categories\n .flatMap(cat =>\n $('Flatten Workflows').first().json.workflows.filter(item => item.category === cat)\n )\n}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "b3ad0e26-e495-4dae-bfdd-f65961178acc",
"name": "扁平化工作流",
"type": "n8n-nodes-base.set",
"position": [
500,
-280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "17a82dd9-3fcf-44d9-b5da-bf89a1f53d59",
"name": "workflows",
"type": "array",
"value": "={{\n$input.all().flatMap(item => item.json.data)\n}}"
}
]
}
},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "05f72731-f8b0-4d8f-ba78-66ef8fbaf059",
"name": "移除已查看",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
1740,
-280
],
"parameters": {
"options": {},
"operation": "removeItemsSeenInPreviousExecutions",
"dedupeValue": "={{ $('For Each Subscriber').item.json.name.toSnakeCase() }}_{{ $json.workflow_id }}"
},
"typeVersion": 2
},
{
"id": "3904d2a2-9a95-4e11-883e-b2e88c6a884f",
"name": "工作流转项目",
"type": "n8n-nodes-base.splitOut",
"position": [
1560,
-280
],
"parameters": {
"options": {},
"fieldToSplitOut": "workflows"
},
"typeVersion": 1
},
{
"id": "d416dee7-df0f-4579-a25f-6baed16453e8",
"name": "合并工作流",
"type": "n8n-nodes-base.aggregate",
"position": [
1920,
-280
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "3797dd21-3144-47e8-9359-841b97073001",
"name": "有新工作流吗？",
"type": "n8n-nodes-base.if",
"position": [
1380,
-600
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "08403b2a-4ae6-4cf5-aa88-cc49441e3c56",
"operator": {
"type": "array",
"operation": "lengthGt",
"rightType": "number"
},
"leftValue": "={{ $json.data }}",
"rightValue": 0
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0cd6ce35-c083-4db6-bc87-9d21e70a3bab",
"name": "带用户引用",
"type": "n8n-nodes-base.set",
"position": [
2100,
-280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d69921eb-b518-4614-af63-e67a521ee373",
"name": "name",
"type": "string",
"value": "={{ $('For Each Subscriber').item.json.name }}"
},
{
"id": "01ee6e0a-9d03-42f6-ad46-68b9df861679",
"name": "email",
"type": "string",
"value": "={{ $('For Each Subscriber').item.json.email }}"
},
{
"id": "5263e512-1b24-43c8-9033-6547dab2811b",
"name": "categories",
"type": "array",
"value": "={{ $('For Each Subscriber').item.json.categories }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "b3a616c7-615f-49ff-8e6f-530324a98be4",
"name": "生成 HTML 模板",
"type": "n8n-nodes-base.html",
"position": [
1740,
-720
],
"parameters": {
"html": "<h1>New Workflows for {{ $now.format('DD') }}</h1>\n{{\n$json.categories\n .filter(cat =>\n $json.data.filter(item => item.category === cat).length > 0\n )\n .map(category => `\n <h2>${category.toSentenceCase()}</h2>\n <ul>\n ${$json.data\n .filter(workflow => workflow.category === category)\n .map(workflow => `\n <li>\n <a href=\"https://n8n.io/workflows/${workflow.workflow_id}\">\n <h3>${workflow.workflow_name}</h3>\n </a>\n <p>\n by\n <a href=\"https://n8n.io/creators/${workflow.author_username}\">\n ${workflow.author_name}\n </a>\n ·\n created on ${DateTime.fromISO(workflow.workflow_created_at).toFormat('DD')}\n </p>\n <p>${workflow.workflow_desc}</p>\n </li>\n `).join('\\n')}\n </ul>\n `)\n .join('\\n')\n}}"
},
"typeVersion": 1.2
},
{
"id": "0c9865c7-9352-4fda-a943-34c8f524de6c",
"name": "解析行",
"type": "n8n-nodes-base.set",
"position": [
-660,
-540
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d89dfc07-3c1f-4fbc-9a52-3748797a4840",
"name": "name",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "c622ceca-2e6d-4bab-bb08-235f704c7e2f",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "9fca8e33-330a-4e4d-b461-251cd7e5c620",
"name": "categories",
"type": "array",
"value": "={{ $json.categories.split(',') }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "f5fbd7f2-65e5-4dd7-8e43-38a8a99e3321",
"name": "发送每日摘要",
"type": "n8n-nodes-base.microsoftOutlook",
"position": [
1920,
-720
],
"webhookId": "8cd83f97-1e5f-4280-9a9d-26d1ee05c45e",
"parameters": {
"subject": "=New Workflows for {{ $now.format('DD') }}",
"bodyContent": "={{\n$json.html\n .replaceAll('\\n', '')\n .replaceAll(' ', '')\n .trim()\n}}",
"toRecipients": "={{ $('Has New Workflows?').item.json.email }}",
"additionalFields": {
"from": "=no-reply <no-reply@example.com>",
"replyTo": "=no-reply <no-reply@example.com>",
"bodyContentType": "html"
}
},
"credentials": {
"microsoftOutlookOAuth2Api": {
"id": "EWg6sbhPKcM5y3Mr",
"name": "Microsoft Outlook account"
}
},
"typeVersion": 2
},
{
"id": "e81ba3a0-e3f6-4231-8870-8ef03edf41e1",
"name": "附加类别",
"type": "n8n-nodes-base.set",
"position": [
140,
-160
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b965dee8-f3b5-419b-b39a-79bf2b7d04c1",
"name": "category",
"type": "string",
"value": "={{ $('Categories to Items').item.json.category }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "e1c2c743-a560-47e8-b906-a2e8fd17622f",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1060,
-740
],
"parameters": {
"color": 7,
"width": 440,
"content": "## 1. 从 Excel 获取订阅者"
},
"typeVersion": 1
},
{
"id": "e10a23be-2af7-4b92-9b5f-df855e6ee349",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
-420
],
"parameters": {
"color": 7,
"width": 620,
"height": 220,
"content": "## 2. 从 n8n 获取最新模板"
},
"typeVersion": 1
},
{
"id": "0ee0b2ca-0247-4471-a6f5-920fd8e67f96",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
260
],
"parameters": {
"color": 7,
"width": 580,
"height": 180,
"content": "## 3. 为每个模板生成 AI 摘要"
},
"typeVersion": 1
},
{
"id": "ab234694-2878-440b-aeb5-37573ebe517e",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1680,
-60
],
"parameters": {
"color": 7,
"width": 580,
"height": 200,
"content": "## 4. 为订阅者筛选相关模板"
},
"typeVersion": 1
},
{
"id": "460a8b3d-c125-41c3-95c5-afdfe63c7561",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1740,
-960
],
"parameters": {
"color": 7,
"width": 580,
"height": 200,
"content": "## 5. 生成每日摘要并通过 Outlook 发送"
},
"typeVersion": 1
},
{
"id": "c79a2775-6276-41df-a9f0-64017e88a8c7",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
0
],
"parameters": {
"color": 5,
"width": 200,
"height": 120,
"content": "### 执行一次"
},
"typeVersion": 1
},
{
"id": "5290822e-b63b-4b73-8511-6a12e2387656",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-940,
-360
],
"parameters": {
"color": 5,
"width": 280,
"height": 120,
"content": "### 列"
},
"typeVersion": 1
},
{
"id": "56acbd11-7fa5-44b8-b031-fcdeb6e44839",
"name": "遍历每个订阅者",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1180,
-460
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "6aef7efc-1bc7-4a1d-b0cb-459484b3d179",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1600,
-1400
],
"parameters": {
"width": 500,
"height": 1000,
"content": "## 试试看！"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "For Each Subscriber",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "For Each Category",
"type": "main",
"index": 0
}
]
]
},
"Parse Rows": {
"main": [
[
{
"node": "Get Unique Categories",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Collect Fields": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Append Category": {
"main": [
[
{
"node": "For Each Category",
"type": "main",
"index": 0
}
]
]
},
"Get Subscribers": {
"main": [
[
{
"node": "Parse Rows",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get Subscribers",
"type": "main",
"index": 0
}
]
]
},
"Combine Workflows": {
"main": [
[
{
"node": "With User Reference",
"type": "main",
"index": 0
}
]
]
},
"Flatten Workflows": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"For Each Category": {
"main": [
[
{
"node": "Flatten Workflows",
"type": "main",
"index": 0
}
],
[
{
"node": "Workflows to Items",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Workflow Summarizer",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Workflow to Items": {
"main": [
[
{
"node": "Remove Already Seen",
"type": "main",
"index": 0
}
]
]
},
"Has New Workflows?": {
"main": [
[
{
"node": "Generate HTML Template",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Workflows to Items": {
"main": [
[
{
"node": "Workflow Summarizer",
"type": "main",
"index": 0
}
]
]
},
"Categories to Items": {
"main": [
[
{
"node": "Fetch Latest 10 per Category",
"type": "main",
"index": 0
}
]
]
},
"For Each Subscriber": {
"main": [
[
{
"node": "Has New Workflows?",
"type": "main",
"index": 0
}
],
[
{
"node": "Get Relevant Workflows",
"type": "main",
"index": 0
}
]
]
},
"Remove Already Seen": {
"main": [
[
{
"node": "Combine Workflows",
"type": "main",
"index": 0
}
]
]
},
"With User Reference": {
"main": [
[
{
"node": "For Each Subscriber",
"type": "main",
"index": 0
}
]
]
},
"Workflow Summarizer": {
"main": [
[
{
"node": "Collect Fields",
"type": "main",
"index": 0
}
]
]
},
"Get Unique Categories": {
"main": [
[
{
"node": "Categories to Items",
"type": "main",
"index": 0
}
]
]
},
"Generate HTML Template": {
"main": [
[
{
"node": "Send Daily Digest",
"type": "main",
"index": 0
}
]
]
},
"Get Relevant Workflows": {
"main": [
[
{
"node": "Workflow to Items",
"type": "main",
"index": 0
}
]
]
},
"Fetch Latest 10 per Category": {
"main": [
[
{
"node": "Append Category",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
YouTube RAG 搜索前端（使用 Apify、Qdrant 和 AI）
基于 Apify、Qdrant 和 AI 的 YouTube RAG 搜索前端
If
Set
Html
+23
62 节点Jimleuk
人工智能
使用AI和APIFY自动化销售会议准备并发送至WhatsApp
使用AI和APIFY自动化销售会议准备并发送至WhatsApp
If
Set
Html
+15
61 节点Jimleuk
销售
使用 n8n、Apify 和 OpenAI o3 自托管 AI 深度研究代理
使用 n8n、Apify 和 OpenAI o3 自托管 AI 深度研究代理
If
Set
Code
+20
87 节点Jimleuk
人工智能
使用AI自动化品牌风格博客创建
使用AI自动化品牌风格博客创建
Set
Html
Limit
+11
27 节点Jimleuk
人工智能
自动化 Discord 垃圾信息审核
结合 AI 和人机协作的自动化 Discord 垃圾信息审核
If
Set
Code
+14
30 节点Jimleuk
人工智能
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
工作流信息
难度等级
高级
节点数量33
分类2
节点类型16
作者
Jimleuk
@jimleukFreelance consultant based in the UK specialising in AI-powered automations. I work with select clients tackling their most challenging projects. For business enquiries, send me an email at hello@jimle.uk LinkedIn: https://www.linkedin.com/in/jimleuk/ X/Twitter: https://x.com/jimle_uk
外部链接
在 n8n.io 查看 →
分享此工作流