Yang This workflow corresponds to n8n.io template #4884 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "M8PPLx0heLyG4kmQ",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Auto-Generate AI News Commentary with Dumpling AI and GPT-4o",
"tags": [],
"nodes": [
{
"id": "35ce9dd5-cc21-4cf9-a7ac-6cc9718fa86a",
"name": "No Operation, do nothing",
"type": "n8n-nodes-base.noOp",
"position": [
-420,
-160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c572b2c3-9e72-4d7d-89f9-364aa5c00f79",
"name": "Run on Schedule (Daily)",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1080,
-60
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "412b5965-1278-4748-8d77-4c85d9eb9cff",
"name": "Fetch Topics with Empty Commentary",
"type": "n8n-nodes-base.googleSheets",
"position": [
-860,
-60
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupColumn": "generated commentary"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rCXEWnIZd6cKIqsVRRynHEygQTztJM76rm4HM8Xlqbw/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rCXEWnIZd6cKIqsVRRynHEygQTztJM76rm4HM8Xlqbw/edit?usp=drivesdk",
"cachedResultName": "News articles"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "c04e7811-4e30-4e68-8342-55d79669072e",
"name": "Loop Through Each Topic",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-640,
-60
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "435798d5-59b3-4379-831a-9b8801a99f38",
"name": "Wait Before News Search",
"type": "n8n-nodes-base.wait",
"position": [
-420,
40
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "f0098d01-fa3b-40e8-aeeb-e9dd31606ddb",
"name": "Search News with Dumpling AI",
"type": "n8n-nodes-base.httpRequest",
"position": [
-200,
40
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/search-news",
"method": "POST",
"options": {},
"jsonBody": "={\n \"query\": \"{{ $json.Topic }}\",\n \"country\": \"US\",\n \"page\": 3,\n \"language\": \"en\"\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "43862942-4e19-4856-a3b0-2546d8a7a462",
"name": "Split Returned News Articles",
"type": "n8n-nodes-base.splitOut",
"position": [
20,
40
],
"parameters": {
"options": {},
"fieldToSplitOut": "news"
},
"typeVersion": 1
},
{
"id": "9b45eb16-66b1-45bc-b4a3-5ad46696b295",
"name": "Scrape Article Content with Dumpling AI",
"type": "n8n-nodes-base.httpRequest",
"position": [
240,
40
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/scrape",
"method": "POST",
"options": {},
"jsonBody": "={\n \"url\": \"{{ $json.link}}\"\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "ffa392af-04d1-4c6a-a05e-f63f765d7eca",
"name": "Aggregate Scraped Article Content",
"type": "n8n-nodes-base.aggregate",
"position": [
460,
40
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "content"
}
]
}
},
"typeVersion": 1
},
{
"id": "5204f7c9-e5f8-4594-9428-4b46e92ba81d",
"name": "Clean Article Content",
"type": "n8n-nodes-base.code",
"position": [
680,
40
],
"parameters": {
"jsCode": "let rawContent = $input.first().json.content;\n\n// If content is not a string, try to stringify it\nif (typeof rawContent !== 'string') {\n rawContent = JSON.stringify(rawContent);\n}\n\nconst cleaned = rawContent\n .replace(/https?:\\/\\/[^\\s]+/g, '') // Remove full URLs\n .replace(/www\\.[^\\s]+/g, '') // Remove www links\n .replace(/\\[([^\\]]+)\\]\\(([^)]+)\\)/g, '$1') // Remove markdown links\n .replace(/<a[^>]*>(.*?)<\\/a>/gi, '$1') // Remove HTML anchor tags\n .replace(/\\s{2,}/g, ' ') // Remove extra spaces\n .trim();\n\nreturn [{\n json: {\n cleaned_content: cleaned\n }\n}];\n"
},
"typeVersion": 2
},
{
"id": "04fe4476-023b-49a5-8e72-0d251d78ae1a",
"name": "Generate LinkedIn Commentary (GPT-4o)",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
900,
40
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "chatgpt-4o-latest",
"cachedResultName": "CHATGPT-4O-LATEST"
},
"options": {},
"messages": {
"values": [
{
"content": "=You are a thought leader on LinkedIn. I will provide you with a news articles related to {{ $('Fetch Topics with Empty Commentary').item.json.Topic }}, and you will write a personal commentary in a confident, insightful, first-person voice.\n\nYour response should:\n- Start with a strong personal opinion or observation\n- Briefly connect the news to real-world trends or implications\n- Mention how this relates to your work, experience, or thinking\n- Use a human tone, no robotic phrasing or generic statements\n- End with a question or call to action to invite engagement\n\nKeep it under 600 characters. Avoid buzzwords or fluff. Be authentic.\n\nHere are the news articles:{{ $json.cleaned_content }}\n"
}
]
}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.8
},
{
"id": "ecc25fb7-52c0-4b89-94eb-06088b92e095",
"name": "Append Commentary Back to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1260,
40
],
"parameters": {
"columns": {
"value": {
"Topic": "={{ $('Fetch Topics with Empty Commentary').item.json.Topic }}",
"generated commentary": "={{ $json.message.content }}"
},
"schema": [
{
"id": "Topic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "generated commentary",
"type": "string",
"display": true,
"required": false,
"displayName": "generated commentary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Image",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Topic"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rCXEWnIZd6cKIqsVRRynHEygQTztJM76rm4HM8Xlqbw/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rCXEWnIZd6cKIqsVRRynHEygQTztJM76rm4HM8Xlqbw/edit?usp=drivesdk",
"cachedResultName": "News articles"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "62e5001b-0aa9-40eb-bf65-6ca6ff1e3b32",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1100,
-260
],
"parameters": {
"width": 1100,
"height": 340,
"content": "### \ud83d\udce5 Fetch Topics and Search News via Dumpling AI\n\nThis section starts with a scheduled trigger. It pulls entries from a Google Sheet where the \u201cgenerated commentary\u201d is empty, meaning the topic hasn\u2019t been processed. Each topic is looped individually. A short wait is applied to manage rate limits. Dumpling AI\u2019s `/search-news` endpoint is then triggered to retrieve relevant articles based on the topic keyword.\n"
},
"typeVersion": 1
},
{
"id": "3c3904a5-90d3-486a-8f69-bb6b33b5d234",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
-280
],
"parameters": {
"width": 1120,
"height": 360,
"content": "### \u270d\ufe0f Scrape Articles, Clean Text, Generate Commentary, and Append\n\nEach article is split out and scraped using Dumpling AI\u2019s `/scrape` endpoint to get full content. The aggregated content is cleaned via a Code node, removing links and excess formatting. GPT-4o generates a LinkedIn-style first-person commentary using this cleaned content. The final output is saved back to the Google Sheet under the \u201cgenerated commentary\u201d field.\n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "2f3ec71f-7ba1-46bf-bbd3-633a9e526a47",
"connections": {
"Clean Article Content": {
"main": [
[
{
"node": "Generate LinkedIn Commentary (GPT-4o)",
"type": "main",
"index": 0
}
]
]
},
"Loop Through Each Topic": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait Before News Search",
"type": "main",
"index": 0
}
]
]
},
"Run on Schedule (Daily)": {
"main": [
[
{
"node": "Fetch Topics with Empty Commentary",
"type": "main",
"index": 0
}
]
]
},
"Wait Before News Search": {
"main": [
[
{
"node": "Search News with Dumpling AI",
"type": "main",
"index": 0
}
]
]
},
"Search News with Dumpling AI": {
"main": [
[
{
"node": "Split Returned News Articles",
"type": "main",
"index": 0
}
]
]
},
"Split Returned News Articles": {
"main": [
[
{
"node": "Scrape Article Content with Dumpling AI",
"type": "main",
"index": 0
}
]
]
},
"Append Commentary Back to Sheet": {
"main": [
[
{
"node": "Loop Through Each Topic",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Scraped Article Content": {
"main": [
[
{
"node": "Clean Article Content",
"type": "main",
"index": 0
}
]
]
},
"Fetch Topics with Empty Commentary": {
"main": [
[
{
"node": "Loop Through Each Topic",
"type": "main",
"index": 0
}
]
]
},
"Generate LinkedIn Commentary (GPT-4o)": {
"main": [
[
{
"node": "Append Commentary Back to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Scrape Article Content with Dumpling AI": {
"main": [
[
{
"node": "Aggregate Scraped Article Content",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApihttpHeaderAuthopenAiApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow turns trending news into thoughtful first-person commentary for platforms like LinkedIn. It uses Dumpling AI’s News Search and Scraping APIs to find and extract article content, then feeds the cleaned text to GPT-4o to write personalized insights. The final output…
Source: https://n8n.io/workflows/4884/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
AI Institutional Stock Valuation Engine with Risk Scoring & Scenario Targets
Google Sheets, XML, HTTP Request +3
Overview This is a production-grade, fully automated stock analysis system built entirely in n8n. It combines institutional-level financial analysis, dual AI model consensus, and a self-improving back
Google Sheets, XML, HTTP Request +3
This automation is a complete end-to-end system designed to find, qualify, and contact B2B leads — fully automated and powered by AI. Searches for target companies on LinkedIn via Ghost Genius API, us
Google Sheets, HTTP Request, OpenAI +1
This comprehensive n8n automation template orchestrates a complete end-to-end workflow for generating engaging short-form Point-of-View (POV) style videos using multiple AI services and automatically
HTTP Request, OpenAI, Google Drive +4
A professional AI equity analysis automation built on n8n that transforms structured financial data and real-time news into disciplined, risk-adjusted price targets and actionable BUY/HOLD/SELL signal
Google Sheets, OpenAI, XML +3