8
n8n Deutschamn8n.com

Automatischer News-Sammler → Google-Tabelle

Experte

Dies ist ein AI Summarization, Multimodal AI-Bereich Automatisierungsworkflow mit 19 Nodes. Hauptsächlich werden If, Set, Code, Merge, HttpRequest und andere Nodes verwendet. Sammeln und Zusammenfassen mehrsprachiger Nachrichten mit NewsAPI, OpenAI und Google-Tabellen

Voraussetzungen
  • •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • •Google Sheets API-Anmeldedaten
  • •OpenAI API Key

Verwendete Nodes (19)

If
Set
Code
Merge
StickyNote
HttpRequest
GoogleSheets
ScheduleTrigger
OpenAi

Kategorie

KI-Zusammenfassung
Multimodales KI
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "id": "5NjNI3YAZnLdY5c7",
  "meta": {
    "instanceId": "ad59d09d8e026d0e92690243618d86d51b0293b236148394ca356eae1d1ea59b"
  },
  "name": "News Auto Collector → Google Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "9aaf1c30-f25e-4a12-9de8-5fd8b129e707",
      "name": "Zeitplan-Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "notes": "Runs daily at 13:00. Change schedule here if needed.",
      "position": [
        -560,
        144
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 13
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "ed496364-3115-46b2-9ef4-b90761a133c3",
      "name": "Zeilen aus Tabelle abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Read keywords from your Google Sheet.\nRequired columns: Keyword, SearchRequired (values: Yes / No).",
      "position": [
        -336,
        144
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_INPUT_SHEET_NAME_OR_GID"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_SHEET_ID_HERE"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "1rA9hHryjFoOeyM0",
          "name": "Google Sheets account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.7
    },
    {
      "id": "ab48f5cb-6d00-4129-b4e6-cb62202b4a68",
      "name": "Wenn Suche erforderlich",
      "type": "n8n-nodes-base.if",
      "notes": "Continue only if SearchRequired === Yes.",
      "position": [
        -112,
        144
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "combinator": "and",
          "conditions": [
            {
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json['SearchRequired'] }}",
              "rightValue": "Yes"
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "22d44aea-7fee-4341-9b8c-de5434735c1a",
      "name": "HTTP Request (EN)",
      "type": "n8n-nodes-base.httpRequest",
      "notes": "NewsAPI call (English). Insert your own NewsAPI key in query param `apiKey`.",
      "position": [
        112,
        48
      ],
      "parameters": {
        "url": "=https://newsapi.org/v2/everything",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "q",
              "value": "={{ $json['Keyword'] }}"
            },
            {
              "name": "language",
              "value": "en"
            },
            {
              "name": "pageSize",
              "value": "5"
            },
            {
              "name": "apiKey",
              "value": "YOUR_API_KEY_HERE"
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "68ae47ba-bb06-4fac-b6b8-ce1fec4297a6",
      "name": "HTTP Request (JP)",
      "type": "n8n-nodes-base.httpRequest",
      "notes": "NewsAPI call (Japanese sources). Insert your own NewsAPI key in query param `apiKey`.",
      "position": [
        112,
        240
      ],
      "parameters": {
        "url": "=https://newsapi.org/v2/everything",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "q",
              "value": "={{ $json['Keyword'] }}"
            },
            {
              "name": "domains",
              "value": "nhk.or.jp,asahi.com,nikkei.com,news.yahoo.co.jp,itmedia.co.jp,impress.co.jp,ascii.jp,prtimes.jp"
            },
            {
              "name": "sortBy",
              "value": "publishedAt"
            },
            {
              "name": "pageSize",
              "value": "5"
            },
            {
              "name": "apiKey",
              "value": "YOUR_API_KEY_HERE"
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.2
    },
    {
      "id": "b68aa0df-1b9f-407c-941e-421039031439",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "height": 300,
        "content": "## Collect both English and Japanese news articles"
      },
      "typeVersion": 1
    },
    {
      "id": "e3fc1ce3-da2d-4555-bffd-cf1010b815d5",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        32
      ],
      "parameters": {
        "height": 240,
        "content": "## Runs daily at 13:00 (change in Schedule Trigger)"
      },
      "typeVersion": 1
    },
    {
      "id": "a17355f0-963d-497e-b4a5-99bb8ef9639d",
      "name": "Artikel zusammenführen",
      "type": "n8n-nodes-base.merge",
      "notes": "Merge both article streams before summarization.",
      "position": [
        704,
        160
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 3.2
    },
    {
      "id": "92fe30b8-4d8b-4386-9dba-9d76d9415087",
      "name": "Zusammenfassen mit OpenAI",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "notes": "Connect your own OpenAI credentials. Charges apply to your account.",
      "position": [
        912,
        144
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "You are an editor summarizing news articles into concise Japanese sentences (~50 characters). No opinions, no emojis."
            },
            {
              "content": "=Summarize the following article (~50 characters in Japanese).\nTitle: {{$json[\"title\"]}}\nContent: {{$json[\"description\"] || $json[\"content\"] || \"No content\"}}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "xWUO0jq5mcmikNzw",
          "name": "OpenAi account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 1.8
    },
    {
      "id": "0b666902-6e4d-4f46-b520-33e1c88ad933",
      "name": "Zeilen an Tabelle anhängen",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Append summarized results to your Google Sheet. Set Spreadsheet ID and output sheet name.",
      "position": [
        1488,
        144
      ],
      "parameters": {
        "columns": {
          "value": {
            "URL": "={{ $('Merge Articles').item.json.url }}",
            "Date": "={{ $('HTTP Request (EN)').item.json.articles[0].publishedAt }}",
            "Keyword": "={{ $('Get rows from sheet').item.json['Keyword'] }}",
            "Summary": "={{ $json.summary }}"
          },
          "mappingMode": "defineBelow"
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_OUTPUT_SHEET_NAME_OR_GID"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_SHEET_ID_HERE"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "1rA9hHryjFoOeyM0",
          "name": "Google Sheets account"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.7
    },
    {
      "id": "f400b87f-1cfb-4a15-9631-89d585375c3c",
      "name": "Artikel aufteilen (EN)",
      "type": "n8n-nodes-base.code",
      "position": [
        336,
        48
      ],
      "parameters": {
        "jsCode": "// Flatten articles array so that 1 item = 1 article\nconst arr = $json.articles ?? [];\nreturn arr.map(a => ({ json: a }));"
      },
      "typeVersion": 2
    },
    {
      "id": "921fc188-9097-48e0-b4fb-c4f2cd6bd7b6",
      "name": "Artikel aufteilen (JP)",
      "type": "n8n-nodes-base.code",
      "position": [
        336,
        240
      ],
      "parameters": {
        "jsCode": "// Flatten articles array so that 1 item = 1 article\nconst arr = $json.articles ?? [];\nreturn arr.map(a => ({ json: a }));"
      },
      "typeVersion": 2
    },
    {
      "id": "d2b09870-fe3e-4804-bc50-12b633fc55f9",
      "name": "Felder vorbereiten",
      "type": "n8n-nodes-base.set",
      "notes": "Prepare fields (Date, Keyword, Summary, URL) for appending to Google Sheets.",
      "position": [
        1264,
        144
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "name": "summary",
              "type": "string",
              "value": "={{$json[\"message\"]?.[\"content\"]}}"
            },
            {
              "name": "link",
              "type": "string",
              "value": "={{$node[\"Merge Articles\"].json[\"url\"]}}"
            }
          ]
        },
        "includeOtherFields": true
      },
      "notesInFlow": true,
      "typeVersion": 3.4
    },
    {
      "id": "ee847bc9-1489-405a-86f6-7616cbd0b31c",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        0
      ],
      "parameters": {
        "height": 240,
        "content": "## 1 item = 1 article"
      },
      "typeVersion": 1
    },
    {
      "id": "c906f8fa-043f-48f8-881b-36a8f5dde4b0",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        336
      ],
      "parameters": {
        "height": 200,
        "content": "## Set your own Google Sheet (enter Spreadsheet ID & Sheet name)"
      },
      "typeVersion": 1
    },
    {
      "id": "3155f915-3ccb-43c4-995b-fb46e49ba915",
      "name": "Haftnotiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        336
      ],
      "parameters": {
        "width": 192,
        "height": 208,
        "content": "Prepare your own Google Spreadsheet with the following structure:\n\nSpreadsheet title (example):\n\"News Auto Collector (Demo)\"\n\nTabs:\n- 01_Input\n   Columns: \n     - Keyword (enter your search term here)\n     - SearchRequired (Yes/No)\n   Example rows:\n     1 | (e.g. OpenAI) | Yes\n     2 | (e.g. n8n)    | No\n\n- 02_Output\n   Columns: Date, Keyword, Summary, URL\n   (Initially empty, rows will be appended automatically)"
      },
      "typeVersion": 1
    },
    {
      "id": "7cba26a3-70b4-429d-a164-b89f2d66c0a6",
      "name": "Haftnotiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        400
      ],
      "parameters": {
        "content": "## Insert your NewsAPI key here"
      },
      "typeVersion": 1
    },
    {
      "id": "d3b0b79b-0387-4e5a-81d1-964342358d9a",
      "name": "Haftnotiz6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        368
      ],
      "parameters": {
        "width": 272,
        "height": 176,
        "content": "## Connect your own OpenAI account here (or deactivate this node if not needed)"
      },
      "typeVersion": 1
    },
    {
      "id": "340bc3d3-c75f-4f60-bbf1-bdde0a0f5722",
      "name": "Haftnotiz7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1424,
        352
      ],
      "parameters": {
        "width": 272,
        "content": "## Output sheet must have columns: Date, Keyword, Summary, URL (empty at first)"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "7e465735-af5e-4ee3-acf1-8e61d9418420",
  "connections": {
    "a17355f0-963d-497e-b4a5-99bb8ef9639d": {
      "main": [
        [
          {
            "node": "92fe30b8-4d8b-4386-9dba-9d76d9415087",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d2b09870-fe3e-4804-bc50-12b633fc55f9": {
      "main": [
        [
          {
            "node": "0b666902-6e4d-4f46-b520-33e1c88ad933",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9aaf1c30-f25e-4a12-9de8-5fd8b129e707": {
      "main": [
        [
          {
            "node": "ed496364-3115-46b2-9ef4-b90761a133c3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "22d44aea-7fee-4341-9b8c-de5434735c1a": {
      "main": [
        [
          {
            "node": "f400b87f-1cfb-4a15-9631-89d585375c3c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "68ae47ba-bb06-4fac-b6b8-ce1fec4297a6": {
      "main": [
        [
          {
            "node": "921fc188-9097-48e0-b4fb-c4f2cd6bd7b6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ab48f5cb-6d00-4129-b4e6-cb62202b4a68": {
      "main": [
        [
          {
            "node": "22d44aea-7fee-4341-9b8c-de5434735c1a",
            "type": "main",
            "index": 0
          },
          {
            "node": "68ae47ba-bb06-4fac-b6b8-ce1fec4297a6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ed496364-3115-46b2-9ef4-b90761a133c3": {
      "main": [
        [
          {
            "node": "ab48f5cb-6d00-4129-b4e6-cb62202b4a68",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f400b87f-1cfb-4a15-9631-89d585375c3c": {
      "main": [
        [
          {
            "node": "a17355f0-963d-497e-b4a5-99bb8ef9639d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "921fc188-9097-48e0-b4fb-c4f2cd6bd7b6": {
      "main": [
        [
          {
            "node": "a17355f0-963d-497e-b4a5-99bb8ef9639d",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "92fe30b8-4d8b-4386-9dba-9d76d9415087": {
      "main": [
        [
          {
            "node": "d2b09870-fe3e-4804-bc50-12b633fc55f9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
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?

Experte - KI-Zusammenfassung, 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.

Verwandte Workflows

Tägliche intelligente Analyse der WhatsApp-Gruppen: GPT-4.1-Analyse und Transkription von Sprachnachrichten
Tägliche intelligente Analyse von WhatsApp-Gruppen: GPT-4.1-Analyse und Transkription von Sprachnachrichten
If
Set
Code
+
If
Set
Code
52 NodesDaniel Lianes
Verschiedenes
Neue Version des E-Mail-Finders für Unternehmen
Finde E-Mail-Adressen von B2B-Entscheidern mit Serper.dev und AnyMailFinder und baue eine Lead-Datenbank auf
If
Set
Code
+
If
Set
Code
33 NodesAlexandra Spalato
KI-Zusammenfassung
KI-gesteuerte Videowerkzeugung und Upload zu Instagram, TikTok und YouTube
AI-gestützte Videoerstellung aus Google Drive und hochladen zu Instagram, TikTok und YouTube
If
Set
Code
+
If
Set
Code
53 NodesDevCode Journey
Content-Erstellung
Batch-SEO-Inhalts-Erstellung mit Webflow-Entwürfen und KI-Bildern (Vorlage)
Batch-SEO-Inhalts-Generierung mit GPT, Gemini-Bildern und Webflow-Entwürfen
If
Set
Code
+
If
Set
Code
54 NodesDahiana
Content-Erstellung
Auf KI basierende Meeting-Recherche und Tagesagenda (Google Kalender, Attio CRM und Slack)
Auf KI basierende Meeting-Recherche und Tagesagenda: Nutzung von Google Kalender, Attio CRM und Slack
If
Set
Code
+
If
Set
Code
30 NodesHarry Siggins
KI-Zusammenfassung
Konkurrenz-Analyse-Content-Inspector: Automatische Themen-Mapping von Websites
Analyse von Wettbewerbsinhalten und -lücken mit Gemini AI, Apify und Google Sheets
If
Set
Code
+
If
Set
Code
30 NodesMychel Garzon
Verschiedenes
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes19
Kategorie2
Node-Typen9
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Autor
Supira Inc.

Supira Inc.

@supira
Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34