8
n8n 中文网amn8n.com

内容研究引擎

中级

这是一个AI Summarization, Multimodal AI领域的自动化工作流，包含 14 个节点。主要使用 Set, Merge, Reddit, GoogleSheets, Agent 等节点。 通过Reddit爬取、AI分析和Google Sheets自动化内容研究

前置要求
  • •Google Sheets API 凭证
  • •OpenAI API Key

使用的节点 (14)

Set
Merge
Reddit
StickyNote
GoogleSheets
Agent
ScheduleTrigger
LmChatOpenAi
OutputParserStructured

分类

AI 摘要总结
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "VzbX3arUtQZaRd9e",
  "meta": {
    "instanceId": "00761fd5aea81495387b0889e15912dcc912b73b7bf62f5ca3898afbd7a79723",
    "templateCredsSetupCompleted": true
  },
  "name": "内容研究引擎",
  "tags": [
    {
      "id": "j0SNhalFSbPAhdWo",
      "name": "n8n creator",
      "createdAt": "2025-09-02T01:40:23.866Z",
      "updatedAt": "2025-09-02T01:40:23.866Z"
    }
  ],
  "nodes": [
    {
      "id": "7cd98b8f-2b80-4f54-8ea1-b633810c5aec",
      "name": "计划触发器1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -272,
        496
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 7
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "4771abaa-5a07-426f-acb2-7163eb7b2313",
      "name": "r/smallbusiness/automation",
      "type": "n8n-nodes-base.reddit",
      "position": [
        0,
        496
      ],
      "parameters": {
        "limit": 2,
        "keyword": "Scaling Leads",
        "operation": "search",
        "subreddit": "startups",
        "additionalFields": {
          "sort": "new"
        }
      },
      "credentials": {
        "redditOAuth2Api": {
          "id": "PD9bs67DcqBKv2ZH",
          "name": "Reddit account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "69503a42-99b4-423e-ae63-1fea9aa1e7f0",
      "name": "r/smallbusiness/AI Automation",
      "type": "n8n-nodes-base.reddit",
      "position": [
        0,
        320
      ],
      "parameters": {
        "limit": 2,
        "keyword": "Lead Generation",
        "operation": "search",
        "subreddit": "marketing",
        "additionalFields": {
          "sort": "new"
        }
      },
      "credentials": {
        "redditOAuth2Api": {
          "id": "PD9bs67DcqBKv2ZH",
          "name": "Reddit account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "902e6dfc-537f-44f1-a9ab-18bc24cb2ea0",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        272,
        480
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3.1
    },
    {
      "id": "534d380c-1f70-4962-a54d-006499dc39f8",
      "name": "r/smallbusiness/automation1",
      "type": "n8n-nodes-base.reddit",
      "position": [
        0,
        688
      ],
      "parameters": {
        "limit": 2,
        "keyword": "Business Automation",
        "operation": "search",
        "subreddit": "smallbusiness",
        "additionalFields": {
          "sort": "new"
        }
      },
      "credentials": {
        "redditOAuth2Api": {
          "id": "PD9bs67DcqBKv2ZH",
          "name": "Reddit account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "78e0dc48-d2a9-4c1f-a8af-8a81f03bcdc8",
      "name": "编辑字段",
      "type": "n8n-nodes-base.set",
      "position": [
        480,
        496
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "a89f1ca3-3c1d-4c6b-933f-04dc38c2e568",
              "name": "subreddit",
              "type": "string",
              "value": "={{ $json.subreddit }}"
            },
            {
              "id": "795929f6-fb60-4e31-9a4f-2332ccfa1d8f",
              "name": "text",
              "type": "string",
              "value": "={{ $json.selftext }}"
            },
            {
              "id": "3b25b1b0-e861-4c8b-89fa-9ff625d1e37b",
              "name": "title",
              "type": "string",
              "value": "={{ $json.title }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "8ccbd0a2-aea8-4195-86c0-3aa5210d1081",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        688,
        496
      ],
      "parameters": {
        "text": "=Subreddit:  {{ $json.subreddit }}\nText: {{ $json.text }}\nTitle: {{ $json.title }}",
        "options": {
          "systemMessage": "You are a content research analyst AI trained to study raw Reddit posts and extract structured insights for marketing, lead generation, and business automation research.\n\nYour role is to transform messy, conversational Reddit text into short, business-ready insights that can be stored in a database and later used for content creation, strategy, or trend analysis.\n\nWhen analyzing a Reddit post (title + body):\n\t1.\tSummarize the post clearly and concisely.\n\t•\tUse neutral, plain English.\n\t•\tOne sentence, ≤20 words.\n\t•\tNo filler, no speculation beyond what is written.\n\t2.\tIdentify the core pain point.\n\t•\tExpress it in ≤15 words.\n\t•\tUse the poster’s perspective (“Can’t find…”, “Struggling with…”, “Wants to know…”).\n\t•\tBoil it down to the single biggest problem they are expressing.\n\t3.\tGenerate 2–3 actionable content angles.\n\t•\tEach ≤10 words.\n\t•\tFrame them as potential articles, guides, or content pieces someone could create.\n\t•\tThey should answer or address the pain point.\n\t•\tKeep them concrete and practical (e.g. “Best tools for automating client onboarding” vs “Automation thoughts”).\n\t4.\tOutput must be valid JSON only.\n\t•\tNo extra commentary, no markdown, no explanations.\n\t•\tFormat must exactly match the schema below."
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "e1e69d68-af98-4089-965d-b814f0a9db10",
      "name": "OpenAI 聊天模型2",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        672,
        848
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "QsPyEUltWeliSiFb",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "1ce1add4-4b05-4f55-a11e-210773d39b13",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        816,
        704
      ],
      "parameters": {
        "autoFix": true,
        "jsonSchemaExample": "{\n  \"summary\": \"<1 sentence, ≤20 words, neutral overview of what the post is about>\",\n  \"pain_point\": \"<1 short sentence, ≤15 words, the core problem the poster is facing>\",\n  \"content_angle\": [\n    \"<idea 1: ≤10 words, actionable topic framing for content/insight>\",\n    \"<idea 2: ≤10 words, actionable topic framing>\",\n    \"<idea 3: ≤10 words, optional>\"\n  ]\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "4d7a85e6-43ad-49c2-b975-987cc3c424fd",
      "name": "在表格中追加行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1120,
        496
      ],
      "parameters": {
        "columns": {
          "value": {
            "Summary": "={{ $json.output.summary }}",
            "Pain Point": "={{ $json.output.pain_point }}",
            "Content Angle": "={{ $json.output.content_angle }}"
          },
          "schema": [
            {
              "id": "Summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Pain Point",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Pain Point",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Content Angle",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Content Angle",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {
          "useAppend": true
        },
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vmLGPnlCVdSU5_3IpYVEUzhTGvUn0p6u2v_RZo7ULmk/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1vmLGPnlCVdSU5_3IpYVEUzhTGvUn0p6u2v_RZo7ULmk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1vmLGPnlCVdSU5_3IpYVEUzhTGvUn0p6u2v_RZo7ULmk/edit?usp=drivesdk",
          "cachedResultName": "Reddit "
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "6UWtW8DQlbmfYbkk",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "1be411b7-51a2-4432-b250-082792e7db39",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1216,
        48
      ],
      "parameters": {
        "width": 768,
        "height": 912,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "29dbe4f2-f5a4-48ab-9ede-34ec60479546",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        16
      ],
      "parameters": {
        "width": 160,
        "height": 848,
        "content": "## 选择您想要抓取的子版块和关键词"
      },
      "typeVersion": 1
    },
    {
      "id": "4da89c31-46c0-40ae-99e4-393b324b9a77",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        304
      ],
      "parameters": {
        "width": 272,
        "height": 352,
        "content": "## AI Agent将遍历项目以发现痛点和内容角度"
      },
      "typeVersion": 1
    },
    {
      "id": "b9715a73-0155-4c44-afc2-946ba93df79a",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        304
      ],
      "parameters": {
        "width": 192,
        "height": 352,
        "content": "## 数据存储在Google Sheet中"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "f3def437-7e43-43ca-9797-d3fb7fa52911",
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "r/smallbusiness/automation",
            "type": "main",
            "index": 0
          },
          {
            "node": "r/smallbusiness/AI Automation",
            "type": "main",
            "index": 0
          },
          {
            "node": "r/smallbusiness/automation1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Structured Output Parser",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "r/smallbusiness/automation": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "r/smallbusiness/automation1": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "r/smallbusiness/AI Automation": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - AI 摘要总结, 多模态 AI

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

自动向客户发送发票
通过 OCR.Space、GPT-4 和 Google Drive 到 Gmail 实现发票处理的自动化
If
Set
Code
+12
29 节点Michael Taleb
AI 摘要总结
呼叫中心转录情感分析 n8n
使用GPT-4o-mini和Google Sheets自动化呼叫中心情感分析
Set
Google Sheets
Split In Batches
+5
9 节点InfyOm Technologies
AI 摘要总结
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
使用ScrapeGraph AI提取n8n社区最近添加的工作流
使用ScrapeGraphAI和Gemini提取和存储n8n社区最近添加的工作流
Set
Merge
Split Out
+12
21 节点Davide
杂项
使用 Perplexity AI 研究业务线索并使用 OpenAI 保存到 Google Sheets
使用 Perplexity AI 研究业务线索并使用 OpenAI 保存到 Google Sheets
Set
Merge
Split Out
+8
18 节点Robert Breen
杂项
AI 自动保存 Gmail 收据
AI自动保存Gmail收据到Google表格和Google云端硬盘
Set
Gmail
Merge
+8
14 节点Matt Chong
发票处理
工作流信息
难度等级
中级
节点数量14
分类2
节点类型9
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Michael Taleb

Michael Taleb

@michaeltaleb

n8n developer helping businesses save time and scale by automating complex business processes with n8n and smart integrations.

外部链接
在 n8n.io 查看 →

分享此工作流