AI驱动的活动后报告和摘要生成器
这是一个Document Extraction, AI Summarization领域的自动化工作流,包含 13 个节点。主要使用 Code, Webhook, Postgres, EmailSend, HttpRequest 等节点。 使用GPT-4生成活动后报告,支持邮件发送和数据库存储
- •HTTP Webhook 端点(n8n 会自动生成)
- •PostgreSQL 数据库连接信息
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
{
"id": "emSWwmKVuZ5u4kGh",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "AI 驱动的活动后报告和摘要生成器",
"tags": [],
"nodes": [
{
"id": "40f721fb-9648-4923-a897-db0901ddd7b2",
"name": "Webhook触发器",
"type": "n8n-nodes-base.webhook",
"position": [
-592,
-80
],
"webhookId": "6295dc5d-b2bd-45e0-b859-28f027870a6b",
"parameters": {
"path": "event-report",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 1
},
{
"id": "69ee8fd6-b823-4bd9-b8a0-185feb4634d4",
"name": "获取参会者",
"type": "n8n-nodes-base.httpRequest",
"position": [
-368,
-176
],
"parameters": {
"url": "https://oneclick.com/GetAttendees",
"options": {}
},
"typeVersion": 4.1
},
{
"id": "08cf380e-2ab1-49ab-806b-a677c8250a3c",
"name": "获取参与度指标",
"type": "n8n-nodes-base.httpRequest",
"position": [
-368,
16
],
"parameters": {
"url": "https://oneclick.com/GetEngagement",
"options": {}
},
"typeVersion": 4.1
},
{
"id": "874ce067-4545-4d7a-9f05-f7d19e2706bf",
"name": "处理指标",
"type": "n8n-nodes-base.code",
"position": [
-144,
-80
],
"parameters": {},
"typeVersion": 2
},
{
"id": "c61d0bca-ff64-46c5-a9e8-a74b6c11d38c",
"name": "AI 生成报告",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
160,
144
],
"parameters": {
"model": "=gpt-4o-mini",
"options": {
"maxTokens": 2000,
"temperature": 0.7
}
},
"credentials": {
"openAiApi": {
"id": "CDQ16eImh6D4tY15",
"name": "OpenAi account 2 - test"
}
},
"typeVersion": 1
},
{
"id": "43cfaa09-76a3-41f8-a907-dc55b893d266",
"name": "发送报告邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
432,
-176
],
"webhookId": "462313f0-1066-449e-b6bb-51254d2f0774",
"parameters": {
"options": {},
"subject": "=Event Report: {{ $('Process Metrics').first().json.eventName }}",
"toEmail": "xyz@gmail.com",
"fromEmail": "abc@gmail.com"
},
"credentials": {
"smtp": {
"id": "G1kyF8cSWTZ4vouN",
"name": "SMTP -test"
}
},
"typeVersion": 2
},
{
"id": "6ec7c1e0-89ab-469b-9e7c-4c789f3858c2",
"name": "保存到数据库",
"type": "n8n-nodes-base.postgres",
"position": [
432,
16
],
"parameters": {
"table": {
"__rl": true,
"mode": "name",
"value": "="
},
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"typeVersion": 2.4
},
{
"id": "0013804f-9eb8-422b-8224-e7fac9b68423",
"name": "发送响应",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
656,
-80
],
"parameters": {
"options": {},
"respondWith": "json",
"responseBody": "={{ { \n success: true, \n message: 'Report generated successfully',\n eventId: $('Process Metrics').first().json.eventId,\n reportSent: true\n} }}"
},
"typeVersion": 1
},
{
"id": "e97cfa0a-3df5-4a64-88d6-ec9988b59271",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
80,
-80
],
"parameters": {
"options": {}
},
"typeVersion": 2.2
},
{
"id": "725e3338-5236-4013-8caf-bf0a287b9259",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-624,
-208
],
"parameters": {
"width": 160,
"height": 288,
"content": "通过 HTTP POST 请求启动"
},
"typeVersion": 1
},
{
"id": "3c4fe130-d1e5-4327-9cde-d0bdafbdc856",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
-304
],
"parameters": {
"width": 384,
"height": 480,
"content": "获取参与者和参与度指标"
},
"typeVersion": 1
},
{
"id": "d9c2e32b-e18d-4b1b-beec-4d25f4da5eb7",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-304
],
"parameters": {
"width": 448,
"height": 464,
"content": "向利益相关者发送报告"
},
"typeVersion": 1
},
{
"id": "68aac399-61b4-4e2b-b966-3a93a9121961",
"name": "## 试试看!",
"type": "n8n-nodes-base.stickyNote",
"position": [
64,
-208
],
"parameters": {
"width": 256,
"height": 288,
"content": "使用 GPT-4 生成专业报告"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "58d015a9-dfd8-418b-92be-61f190f62e19",
"connections": {
"AI Agent": {
"main": [
[
{
"node": "Send Report Email",
"type": "main",
"index": 0
},
{
"node": "Save to Database",
"type": "main",
"index": 0
}
]
]
},
"Get Attendees": {
"main": [
[
{
"node": "Process Metrics",
"type": "main",
"index": 0
}
]
]
},
"Process Metrics": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Webhook Trigger": {
"main": [
[
{
"node": "Get Attendees",
"type": "main",
"index": 0
},
{
"node": "Get Engagement Metrics",
"type": "main",
"index": 0
}
]
]
},
"Save to Database": {
"main": [
[
{
"node": "Send Response",
"type": "main",
"index": 0
}
]
]
},
"Send Report Email": {
"main": [
[
{
"node": "Send Response",
"type": "main",
"index": 0
}
]
]
},
"AI Generate Report": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Get Engagement Metrics": {
"main": [
[
{
"node": "Process Metrics",
"type": "main",
"index": 0
}
]
]
}
}
}如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 文档提取, AI 摘要总结
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
分享此工作流