Request to Build an Automated Workflow for Translating and Emailing News

Questions
1

II’d like to build an automated workflow using a tool like n8n to help me stay updated with news from different websites in my preferred language. Here’s exactly what I need:

:wrench: Workflow Requirements:

  1. Input:

I will maintain a list of news website RSS feed URLs in a Google Sheet.

I will also specify the target translation language (e.g., Arabic, French, etc.).

  1. Process:

The system should fetch the latest articles from each RSS feed daily.

If the news content is not in the target language, it should be automatically translated.

Preferably using OpenAI GPT or another accurate translation API.

The translated news (title and summary or content) should be formatted nicely.

  1. Output:

A daily email should be sent to me containing all the translated news.

Optional: Save the translated news to a new tab or sheet for record-keeping.

:memo: Example Use Case:

Google Sheet:

Column A: Website RSS Feed

Column B: Language (e.g., ar for Arabic)

Every day:

Fetch news → Translate if needed → Email summary in target language.

2

If you would like to build it, what is stopping you? :slight_smile:

How can we, as free community forum, help you?

3

In need helping to translation i create it and news come to me but i need translation node and i didn’t know how can i doit

4

There is a google translate node, would that do?

5

I tried many ways but not working, if you tried things like this before please provide steps

6

Can you please be more specific as to what exactly is not working and how you tried (one way is enough)?

7

this the issue below :

if i removed node transleat its working find but the issue when i add node translate

image
image1820×782 104 KB

{
“errorMessage”: “Response body is not valid JSON. Change "Response Format" to "String"”,
“errorDetails”: {},
“n8nDetails”: {
“nodeName”: “Translate News”,
“nodeType”: “n8n-nodes-base.httpRequest”,
“nodeVersion”: 2,
“itemIndex”: 0,
“time”: “2‏/7‏/2025 5:19:35 م”,
“n8nVersion”: “1.100.1 (Self Hosted)”,
“binaryDataMode”: “filesystem”,
“stackTrace”: [
“NodeOperationError: Response body is not valid JSON. Change "Response Format" to "String"”,
" at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-nodes-base@file+packages+nodes-base_@[email protected]_asn1.js@5_1af219c3f47f2a1223ec4ccec249a974/node_modules/n8n-nodes-base/nodes/HttpRequest/V2/HttpRequestV2.node.ts:1169:14)“,
" at processTicksAndRejections (node:internal/process/task_queues:105:5)”,
" at WorkflowExecute.runNode (/usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1193:9)“,
" at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:1542:27”,
" at /usr/local/lib/node_modules/n8n/node_modules/.pnpm/n8n-core@[email protected][email protected][email protected][email protected]_/node_modules/n8n-core/src/execution-engine/workflow-execute.ts:2108:11"
]
}
}

8

Sorry, I don’t have an API key for libretranslate.de and I don’t know anything about that service. If you wish to use Google Translate, use corresponding node.

image
image1361×512 27.9 KB