Automatische Sammlung und Verarbeitung von Google-News-Artikeln in Google Tabellen

Name: Automatische Sammlung und Verarbeitung von Google-News-Artikeln in Google Tabellen
Rating: 4.5 (10 reviews)
Author: Sulieman Said

Fortgeschritten

Dies ist ein Content Creation, Miscellaneous, Multimodal AI-Bereich Automatisierungsworkflow mit 11 Nodes. Hauptsächlich werden Set, Cron, Merge, Filter, ItemLists und andere Nodes verwendet. Automatische Sammlung und Verarbeitung von Google-Nachrichtenartikeln in Google Tabellen

Voraussetzungen

•Google Sheets API-Anmeldedaten

Verwendete Nodes (11)

Kategorie

Content-Erstellung

Verschiedenes

Multimodales KI

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Item Lists: Unique by URL

Merge Feeds (Append)

RSS Read — Google News (TOPIC_2)

RSS Read — Google News (TOPIC_1)

Append new Links

Set (Clean URL + Fields)

Filter (only complete Items)

Trigger: Monday 09:00

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "meta": {
    "instanceId": "40f29e455b10b3ef07629363459d0fa6954887d44ddad18e74a5539a487f2eee"
  },
  "nodes": [
    {
      "id": "c20dae93-b0a7-4e4d-96fe-58ce9533f2e6",
      "name": "Sticky: 🧼 Clean & Neu",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 448,
        "height": 592,
        "content": "## Gather Information\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9e4b1c28-4f02-4c3f-8a3b-7b2c11390860",
      "name": "Item Lists: Unique by URL",
      "type": "n8n-nodes-base.itemLists",
      "position": [
        928,
        304
      ],
      "parameters": {
        "operation": "removeDuplicates"
      },
      "typeVersion": 1
    },
    {
      "id": "07033869-1d9c-41de-919c-bcabe2a63f86",
      "name": "Merge Feeds (Append)",
      "type": "n8n-nodes-base.merge",
      "position": [
        320,
        304
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1118d0bb-6a84-49c8-af05-51399b0df255",
      "name": "RSS Read — Google News (TOPIC_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 Read — Google News (TOPIC_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": "Sticky: 🧼 Clean & Neu1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        0
      ],
      "parameters": {
        "width": 176,
        "height": 592,
        "content": "## Save in Sheets\n"
      },
      "typeVersion": 1
    },
    {
      "id": "bfb656db-8f3a-4f7b-a311-2c46086b5788",
      "name": "Sticky: 🧼 Clean & Neu2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        0
      ],
      "parameters": {
        "width": 576,
        "height": 592,
        "content": "## Clean & New\n"
      },
      "typeVersion": 1
    },
    {
      "id": "06267467-f32c-4115-9e0f-c39030abab1d",
      "name": "Append new Links",
      "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": "Set (Clean URL + Fields)",
      "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": "Filter (only complete Items)",
      "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": "Trigger: Monday 09:00",
      "type": "n8n-nodes-base.cron",
      "position": [
        -160,
        304
      ],
      "parameters": {
        "triggerTimes": {
          "item": [
            {
              "hour": 9,
              "mode": "everyWeek"
            }
          ]
        }
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "07033869-1d9c-41de-919c-bcabe2a63f86": {
      "main": [
        [
          {
            "node": "0040d423-82f0-4432-8fba-1ed8b3b07d31",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b9827b14-3e28-4de5-8be9-8a94c32aa1bc": {
      "main": [
        [
          {
            "node": "1118d0bb-6a84-49c8-af05-51399b0df255",
            "type": "main",
            "index": 0
          },
          {
            "node": "a588e5bc-c6a1-4fe1-9326-d40bd38dbcb4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0040d423-82f0-4432-8fba-1ed8b3b07d31": {
      "main": [
        [
          {
            "node": "11812dba-c56b-49fb-8a4d-cc36358c6242",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9e4b1c28-4f02-4c3f-8a3b-7b2c11390860": {
      "main": [
        [
          {
            "node": "06267467-f32c-4115-9e0f-c39030abab1d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "11812dba-c56b-49fb-8a4d-cc36358c6242": {
      "main": [
        [
          {
            "node": "9e4b1c28-4f02-4c3f-8a3b-7b2c11390860",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a588e5bc-c6a1-4fe1-9326-d40bd38dbcb4": {
      "main": [
        [
          {
            "node": "07033869-1d9c-41de-919c-bcabe2a63f86",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1118d0bb-6a84-49c8-af05-51399b0df255": {
      "main": [
        [
          {
            "node": "07033869-1d9c-41de-919c-bcabe2a63f86",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}

Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Content-Erstellung, Verschiedenes, Multimodales KI

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.