Google新闻文章自动收集与处理至Google表格

• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "40f29e455b10b3ef07629363459d0fa6954887d44ddad18e74a5539a487f2eee"
  },
  "nodes": [
    {
      "id": "c20dae93-b0a7-4e4d-96fe-58ce9533f2e6",
      "name": "便签：🧼 清理与更新",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 448,
        "height": 592,
        "content": "## 收集信息"
      },
      "typeVersion": 1
    },
    {
      "id": "9e4b1c28-4f02-4c3f-8a3b-7b2c11390860",
      "name": "项目列表：按URL去重",
      "type": "n8n-nodes-base.itemLists",
      "position": [
        928,
        304
      ],
      "parameters": {
        "operation": "removeDuplicates"
      },
      "typeVersion": 1
    },
    {
      "id": "07033869-1d9c-41de-919c-bcabe2a63f86",
      "name": "合并订阅源（追加）",
      "type": "n8n-nodes-base.merge",
      "position": [
        320,
        304
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1118d0bb-6a84-49c8-af05-51399b0df255",
      "name": "RSS读取 — Google新闻（主题_2）",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        80,
        416
      ],
      "parameters": {
        "url": "https://news.google.com/rss/search?q=AIAutomation&hl=de&gl=DE&ceid=DE:de",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "a588e5bc-c6a1-4fe1-9326-d40bd38dbcb4",
      "name": "RSS读取 — Google新闻（主题_1）",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        80,
        176
      ],
      "parameters": {
        "url": "https://news.google.com/rss/search?q=AI&hl=de&gl=DE&ceid=DE:de",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "05e7a035-5892-43c2-8413-6057d0e2d162",
      "name": "便签：🧼 清理与更新1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        0
      ],
      "parameters": {
        "width": 176,
        "height": 592,
        "content": "## 保存到表格"
      },
      "typeVersion": 1
    },
    {
      "id": "bfb656db-8f3a-4f7b-a311-2c46086b5788",
      "name": "便签：🧼 清理与更新2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        0
      ],
      "parameters": {
        "width": 576,
        "height": 592,
        "content": "## 清理与更新"
      },
      "typeVersion": 1
    },
    {
      "id": "06267467-f32c-4115-9e0f-c39030abab1d",
      "name": "追加新链接",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1120,
        304
      ],
      "parameters": {
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "fFcSSi3rDm6AUkqf",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "0040d423-82f0-4432-8fba-1ed8b3b07d31",
      "name": "设置（清理URL + 字段）",
      "type": "n8n-nodes-base.set",
      "position": [
        528,
        304
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "url",
              "value": "={{ $json[\"link\"] && $json[\"link\"].match(/[?&]url=([^&]+)/) ? decodeURIComponent($json[\"link\"].match(/[?&]url=([^&]+)/)[1]) : ($json[\"link\"] || $json[\"guid\"] || \"\") }}"
            },
            {
              "name": "title",
              "value": "={{$json[\"title\"] || \"\"}}"
            },
            {
              "name": "summary",
              "value": "={{$json[\"contentSnippet\"] || $json[\"summary\"] || \"\"}}"
            },
            {
              "name": "pubDate",
              "value": "={{$json[\"pubDate\"] || $json[\"isoDate\"] || $json[\"date\"] || \"\"}}"
            }
          ]
        },
        "options": {},
        "keepOnlySet": true
      },
      "typeVersion": 2
    },
    {
      "id": "11812dba-c56b-49fb-8a4d-cc36358c6242",
      "name": "筛选（仅完整项目）",
      "type": "n8n-nodes-base.filter",
      "position": [
        720,
        304
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "cond-title",
              "operator": {
                "name": "filter.operator.notEmpty",
                "type": "string",
                "operation": "notEmpty"
              },
              "leftValue": "={{$json[\"title\"]}}",
              "rightValue": ""
            },
            {
              "id": "cond-url",
              "operator": {
                "name": "filter.operator.notEmpty",
                "type": "string",
                "operation": "notEmpty"
              },
              "leftValue": "={{$json[\"url\"]}}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "b9827b14-3e28-4de5-8be9-8a94c32aa1bc",
      "name": "触发器：周一 09:00",
      "type": "n8n-nodes-base.cron",
      "position": [
        -160,
        304
      ],
      "parameters": {
        "triggerTimes": {
          "item": [
            {
              "hour": 9,
              "mode": "everyWeek"
            }
          ]
        }
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Merge Feeds (Append)": {
      "main": [
        [
          {
            "node": "Set (Clean URL + Fields)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger: Monday 09:00": {
      "main": [
        [
          {
            "node": "RSS Read — Google News (TOPIC_2)",
            "type": "main",
            "index": 0
          },
          {
            "node": "RSS Read — Google News (TOPIC_1)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set (Clean URL + Fields)": {
      "main": [
        [
          {
            "node": "Filter (only complete Items)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Item Lists: Unique by URL": {
      "main": [
        [
          {
            "node": "Append new Links",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter (only complete Items)": {
      "main": [
        [
          {
            "node": "Item Lists: Unique by URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "RSS Read — Google News (TOPIC_1)": {
      "main": [
        [
          {
            "node": "Merge Feeds (Append)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "RSS Read — Google News (TOPIC_2)": {
      "main": [
        [
          {
            "node": "Merge Feeds (Append)",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}