8
n8n 中文网amn8n.com

新闻

高级

这是一个AI Summarization, Multimodal AI领域的自动化工作流,包含 22 个节点。主要使用 If, Set, Html, Filter, Markdown 等节点。 使用Gemini AI总结RSS新闻并存储到Google Sheets

前置要求
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • Google Gemini API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "oqitoUUaeO8RP9XO",
  "meta": {
    "instanceId": "fe4297863f6caf9d9f79aa73357d5644567645eba9c5053b46f8a58989877334",
    "templateCredsSetupCompleted": true
  },
  "name": "新闻",
  "tags": [],
  "nodes": [
    {
      "id": "b405627a-e76e-45bb-8e7e-749b1ddff8e2",
      "name": "点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        2000,
        2032
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d5f5b93e-6e92-43b6-baf1-f881ac645341",
      "name": "获取 RSS 源列表",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Get feeds Url's  from Google Sheet",
      "position": [
        2688,
        1888
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('Settings').item.json[\"Rss Feeds\"] }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('Settings').item.json.Document }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Eda4lgtccHztuAQN",
          "name": "Google Sheets account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "d5914453-9f83-4384-8f60-24883df66559",
      "name": "读取 RSS",
      "type": "n8n-nodes-base.rssFeedRead",
      "notes": "This read RSS channel",
      "position": [
        3152,
        1984
      ],
      "parameters": {
        "url": "={{ $json[\"RSS URL\"] }}",
        "options": {
          "ignoreSSL": true
        }
      },
      "executeOnce": true,
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "a35c2466-8f5d-4354-a3a9-0661b1f732f2",
      "name": "循环处理 RSS 元素",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        3648,
        1632
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "e62e1ec7-3996-4315-94d3-6eb944697109",
      "name": "检查 URL 是否在表格中",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Check if the record with the link exists in Google Sheets",
      "position": [
        3872,
        1584
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json.link }}",
              "lookupColumn": "link"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('Settings').item.json[\"Articles Sheet\"] }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('Settings').item.json.Document }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Eda4lgtccHztuAQN",
          "name": "Google Sheets account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "ad0a5be4-06fa-42e1-9e29-4c52307ba5ad",
      "name": "将 HTML 转换为 Markdown",
      "type": "n8n-nodes-base.markdown",
      "notes": "Markdown is more friendly LLM format than HTML",
      "position": [
        4768,
        1664
      ],
      "parameters": {
        "html": "={{ $json.data }}",
        "options": {
          "ignore": "img,form",
          "blockElements": ""
        }
      },
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "id": "89400cba-1e6a-425c-9870-91ff465f916a",
      "name": "将摘要添加到 Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        5584,
        1840
      ],
      "parameters": {
        "columns": {
          "value": {
            "link": "={{ $('Loop Over Rss Elements').item.json.link }}",
            "title": "={{ $('Loop Over Rss Elements').item.json.title }}",
            "source": "={{ $('Loop Over Rss Elements').item.json[\"RSS NAME\"] }}",
            "pubDate": "={{ $('Loop Over Rss Elements').item.json.pubDate.toDateTime().format('dd-MM-yyyy HH:mm') }}",
            "ai summary": "={{ $json.text }}",
            "categories": "={{ ($('Loop Over Rss Elements').item.json.categories || []).toJsonString() || \"[]\" }}"
          },
          "schema": [
            {
              "id": "pubDate",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "pubDate",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "source",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "source",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "link",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "categories",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "categories",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ai summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "ai summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "link"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {
          "useAppend": true,
          "cellFormat": "RAW"
        },
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('Settings').item.json[\"Articles Sheet\"] }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('Settings').item.json.Document }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Eda4lgtccHztuAQN",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "302dc32d-1ae7-4532-9cbf-13d242f451d5",
      "name": "将 RSS 与来源名称合并",
      "type": "n8n-nodes-base.set",
      "position": [
        3360,
        1984
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "72a6cb17-fefb-44c6-b2d5-348ce57e8270",
              "name": "RSS NAME",
              "type": "string",
              "value": "={{ $('Loop Over RSS Feed').item.json[\"RSS NAME\"] }}"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "d9942de9-312c-4b5a-bc74-d5bda6c28789",
      "name": "检查文章是否存在",
      "type": "n8n-nodes-base.if",
      "notes": "We check if the object is empty",
      "position": [
        4096,
        1664
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "f2fe5727-5ae3-40fe-86c5-e2ad6288303b",
              "operator": {
                "type": "object",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $item(\"0\").$node[\"Get Row for URL is in Sheets\"].json }}",
              "rightValue": ""
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "25db0aba-76cd-4de5-bfbf-ec52e14e2b75",
      "name": "内容摘要",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        4992,
        1664
      ],
      "parameters": {
        "text": "=Hi Narayan Summarize This:\n\n<basic_information>\n- Date: {{ $('Loop Over Rss Elements').item.json.isoDate }}\n- Title: {{ $('Loop Over Rss Elements').item.json.title }}\n- Author/Source: {{ $('Loop Over Rss Elements').item.json.creator }} / {{ $('Loop Over Rss Elements').item.json.link }}\n- Category: {{ ($('Loop Over Rss Elements').item.json.categories || []).toJsonString() || \"[]\" }}\n\n</basic_information>\n\n<content>\n{{ $json.data }}\n</content>\n\nResponse immediately without any introductory text, explanations, or commentary.",
        "batching": {},
        "messages": {
          "messageValues": [
            {
              "message": "=You Are Narayan.\n<role>\nNarayan is an expert at creating concise, valuable article summaries. He can process content from various domains and specializes in extracting key information and practical insights from any type of article.\n</role>\n\n<task>\nNarayan create a structured summary format of the provided article, preserving key information and practical insights.\n</task>\n\n<steps>\n- Identify main content of sended by user.\n- Prepare summary, when writing use <writing_guidelines>.\n- Make quality control based on <quality_control>.\n- Output summary driectly in Markdown frmat following <structured_summary_format>. Check <output_formatting> for guidelines.\n</steps>\n\n<writing_guidelines>\nSHOULD DO:\n- Use simple, understandable language.\n- Maintain objectivity and accuracy.\n- Extract practical insights.\n- Emphasize specific data and numbers.\n- Prioritize actionable information.\n- Adjust detail level to article length.\n- Use bullet points for better readability.\n\nSHOULD AVOID:\n- Adding her own opinions beyond the article.\n- Repeating information in different sections.\n- Using jargon without explanation.\n- Omitting important caveats/limitations.\n- Exceeding 300 words in total summary.\n- Copying entire fragments verbatim.\n</writing_guidelines>\n\n<special_cases>\n- FOR TECHNICAL ARTICLES: Narayan should explain complex terms, highlight technical requirements, and note implementation difficulty level.\n- FOR BUSINESS ARTICLES: Narayan should focus on ROI and metrics, highlight potential costs/benefits, and note target audience.\n- FOR CASE STUDIES: Narayan should describe context and challenge, present applied solution, and highlight results and success metrics.\n- TONE AND STYLE: Narayan should maintain a professional but accessible tone that is concise and concrete, focused on reader value, and action-oriented.\n</special_cases>\n\n<quality_control>\nBefore finalizing, Narayan should check:\n- Does the summary capture the essence of the article?\n- Are all sections filled?\n- Is the information accurate and verified?\n- Is the length appropriate?\n- Does the summary have practical value?\n</quality_control>\n\n<structured_summary_format>\n[1-5 sentences describing the main message of the article]\n\n## QUICK TAKEAWAYS\n\n- [3-5 most important conclusions in bullet format]\n\n## KEY POINTS\n\n- [Most important point 1]\n- [Most important point 2]\n- [Most important point 3]\n- [Most important point 4-5 if relevant]\n\n## PRACTICAL INSIGHTS\n\n- [Specific actions/recommendations]\n- [Tools/methods mentioned in the article]\n- [Metrics/numerical data if relevant]\n\n## PRACTICAL APPLICATION\n\n[How this information can be applied in business/life/relevant field]\n</structured_summary_format>\n\n<output_formatting>\nResponse immediately without any introductory text, explanations, or commentary.\nOutput formatting is Markdown.\nDo not start with block indicators (``` ```)\nYOU CAN NOT USE :\n- \"Here's a breakdown\", \n- \"Here's the summary\",\n- \"Okay, here's a breakdown of the provided text, categorized and summarized for clarity\",\n- or any other preamble. Go directly to the structured summary format.\n</output_formatting>"
            }
          ]
        },
        "promptType": "define"
      },
      "retryOnFail": true,
      "typeVersion": 1.7
    },
    {
      "id": "924b610c-adf5-44c4-b485-b49da6b1b0bb",
      "name": "格式化输出",
      "type": "n8n-nodes-base.set",
      "position": [
        5344,
        1664
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "52023808-641d-4f4d-9c8f-b51c9b3bbbd1",
              "name": "text",
              "type": "string",
              "value": "={{ $json.text.replace(/<think>[\\s\\S]*?<\\/think>/g, '') }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "2759d4b1-4f12-44f3-806a-85d9f942674f",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        2000,
        1792
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 6
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "2886be38-acbb-4965-bfd8-f90d4e277c55",
      "name": "筛选最近 X 天",
      "type": "n8n-nodes-base.filter",
      "notes": "This filter only news from last x days",
      "position": [
        3360,
        1632
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "516c4ec9-fc16-4687-a376-86a79115afc8",
              "operator": {
                "type": "dateTime",
                "operation": "after"
              },
              "leftValue": "={{ $json.pubDate }}",
              "rightValue": "={{ $('Settings').item.json['Current Time'].toDateTime().minus($('Settings').item.json['Last X Days'],'days').startOf('day') }}"
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "3098ec88-253d-4ca5-836a-2bbb3ebab55c",
      "name": "设置",
      "type": "n8n-nodes-base.set",
      "notes": "Set Here Your Gogle Sheets URLs and Last x Days Filter",
      "position": [
        2240,
        1888
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "93e02cc9-f9c9-4167-ad2c-688433aa9b36",
              "name": "Document",
              "type": "string",
              "value": "https://docs.google.com/spreadsheets/d/1SGYctcCWYHDxpuzv5o2Hp1uveRuOrnpRJ1DmaSUii7g/edit?gid=0#gid=0"
            },
            {
              "id": "c95234c3-baff-4dd6-a3ec-3a97a10e44c1",
              "name": "Articles Sheet",
              "type": "string",
              "value": "https://docs.google.com/spreadsheets/d/1SGYctcCWYHDxpuzv5o2Hp1uveRuOrnpRJ1DmaSUii7g/edit?gid=0#gid=0"
            },
            {
              "id": "794e4b87-caa1-4ff3-ae81-c9aa55cb5fe5",
              "name": "Today Sheet",
              "type": "string",
              "value": "https://docs.google.com/spreadsheets/d/1SGYctcCWYHDxpuzv5o2Hp1uveRuOrnpRJ1DmaSUii7g/edit?gid=1944615086#gid=1944615086"
            },
            {
              "id": "c94d9441-3b2b-421b-bb57-cfa041b132d6",
              "name": "Rss Feeds",
              "type": "string",
              "value": "https://docs.google.com/spreadsheets/d/1SGYctcCWYHDxpuzv5o2Hp1uveRuOrnpRJ1DmaSUii7g/edit?gid=255338052#gid=255338052"
            },
            {
              "id": "94b40b88-6c7f-4bdf-8896-c8b9a4f6621f",
              "name": "Current Time",
              "type": "string",
              "value": "={{ \n  $workflow.trigger === 'Schedule Trigger' ? \n  $('Schedule Trigger').item.json.timestamp : \n  $now \n}}"
            },
            {
              "id": "eba798d1-5a87-4446-bdc4-63e8a27bc510",
              "name": "Last X Days",
              "type": "number",
              "value": 1
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 3.4
    },
    {
      "id": "44b17401-e75d-43ba-9d72-be7089ffe1d2",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2848,
        1840
      ],
      "parameters": {
        "width": 676,
        "height": 368,
        "content": "## 循环:为 RSS 记录添加来源名称"
      },
      "typeVersion": 1
    },
    {
      "id": "3b0cd618-100a-4baa-ac3e-d73c1ede22b6",
      "name": "工作流结束",
      "type": "n8n-nodes-base.noOp",
      "position": [
        3872,
        1392
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8194db5e-c0ac-4c06-8b96-5b0d777a5f66",
      "name": "获取网页 HTML 内容",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        4320,
        1664
      ],
      "parameters": {
        "url": "={{ $('Loop Over Rss Elements').item.json.link }}",
        "options": {
          "response": {
            "response": {
              "responseFormat": "text"
            }
          }
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "49a8e2a6-8037-4933-8203-9fe06670b7b4",
      "name": "提取 HTML 正文内容",
      "type": "n8n-nodes-base.html",
      "notes": "We need only body without images",
      "position": [
        4544,
        1664
      ],
      "parameters": {
        "options": {
          "trimValues": true,
          "cleanUpText": true
        },
        "operation": "extractHtmlContent",
        "extractionValues": {
          "values": [
            {
              "key": "data",
              "cssSelector": "body",
              "returnValue": "html"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "930b2371-6eb3-410a-873c-d8007fc1061e",
      "name": "Google Gemini 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        4992,
        1856
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "yFYrP9GclqLZJzWr",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "4d44ea96-9068-4e47-b812-9afbdf2bff4b",
      "name": "将摘要添加到 Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        5568,
        1616
      ],
      "parameters": {
        "columns": {
          "value": {
            "link": "={{ $('Loop Over Rss Elements').item.json.link }}",
            "title": "={{ $('Loop Over Rss Elements').item.json.title }}",
            "source": "={{ $('Loop Over Rss Elements').item.json[\"RSS NAME\"] }}",
            "pubDate": "={{ $('Loop Over Rss Elements').item.json.pubDate.toDateTime().format('dd-MM-yyyy HH:mm') }}",
            "ai summary": "={{ $json.text }}",
            "categories": "={{ ($('Loop Over Rss Elements').item.json.categories || []).toJsonString() || \"[]\" }}"
          },
          "schema": [
            {
              "id": "pubDate",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "pubDate",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "source",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "source",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "link",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "categories",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "categories",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "ai summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "ai summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "link"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {
          "useAppend": true,
          "cellFormat": "RAW"
        },
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('Settings').item.json[\"Today Sheet\"] }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('Settings').item.json.Document }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Eda4lgtccHztuAQN",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "e1d29324-7071-4494-8cd4-eb722853cc71",
      "name": "清空表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2464,
        1888
      ],
      "parameters": {
        "operation": "clear",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1944615086,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SGYctcCWYHDxpuzv5o2Hp1uveRuOrnpRJ1DmaSUii7g/edit#gid=1944615086",
          "cachedResultName": "Today"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1SGYctcCWYHDxpuzv5o2Hp1uveRuOrnpRJ1DmaSUii7g",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SGYctcCWYHDxpuzv5o2Hp1uveRuOrnpRJ1DmaSUii7g/edit?usp=drivesdk",
          "cachedResultName": "RSS READER N8N"
        },
        "keepFirstRow": true
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Eda4lgtccHztuAQN",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "d1bdd656-f646-42e2-b246-4a672ef34120",
      "name": "循环处理 RSS 源",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2912,
        1888
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    }
  ],
  "active": true,
  "pinData": {
    "Schedule Trigger": [
      {
        "json": {
          "Hour": "06",
          "Year": "2025",
          "Month": "August",
          "Minute": "00",
          "Second": "26",
          "Timezone": "Asia/Kolkata (UTC+05:30)",
          "timestamp": "2025-08-27T06:00:26.013+05:30",
          "Day of week": "Wednesday",
          "Day of month": "27",
          "Readable date": "August 27th 2025, 6:00:26 am",
          "Readable time": "6:00:26 am"
        }
      }
    ]
  },
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1ef11ad2-14f6-4d45-a4d4-586991600d33",
  "connections": {
    "Read RSS": {
      "main": [
        [
          {
            "node": "Combine Rss with source name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Settings": {
      "main": [
        [
          {
            "node": "Clear sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clear sheet": {
      "main": [
        [
          {
            "node": "Get RSS Feed List",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Output": {
      "main": [
        [
          {
            "node": "Append Aummary to Google Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Append Aummary to Google Sheets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Settings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get RSS Feed List": {
      "main": [
        [
          {
            "node": "Loop Over RSS Feed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Content": {
      "main": [
        [
          {
            "node": "Format Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Last X Days": {
      "main": [
        [
          {
            "node": "Loop Over Rss Elements",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over RSS Feed": {
      "main": [
        [
          {
            "node": "Filter Last X Days",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Read RSS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Rss Elements": {
      "main": [
        [
          {
            "node": "End of worfklow",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get Row for URL is in Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check If Article Exists": {
      "main": [
        [
          {
            "node": "Get Webpage HTML Content",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Rss Elements",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert HTML to Markdown": {
      "main": [
        [
          {
            "node": "Summarize Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Webpage HTML Content": {
      "main": [
        [
          {
            "node": "Extract Body Content in HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Summarize Content",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Combine Rss with source name": {
      "main": [
        [
          {
            "node": "Loop Over RSS Feed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Body Content in HTML": {
      "main": [
        [
          {
            "node": "Convert HTML to Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Row for URL is in Sheets": {
      "main": [
        [
          {
            "node": "Check If Article Exists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append Aummary to Google Sheets": {
      "main": [
        [
          {
            "node": "Loop Over Rss Elements",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Settings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

工作流信息
难度等级
高级
节点数量22
分类2
节点类型15
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Jayesh Kaithwas

Jayesh Kaithwas

@j4t35h

I help businesses work smarter with AI automations while building my expertise in cybersecurity and red teaming. I’ve built chatbots, workflow automations, bulk messaging systems, and Google Sheets ERPs that save teams hours of repetitive work. If you’re looking to make your business smarter and more secure, let’s connect.

外部链接
在 n8n.io 查看

分享此工作流