ChatGPTCreativeWritingAI score · PendingAI-assisted edit · no obvious prompt-injection riskn8n.io

Daily Israeli Economic Newsletter Automation: RSS + GPT-4o with RTL Email

Input: Calcalist and Mako RSS feeds; Processing: deduplication, GPT-4o curation, web extraction, RTL HTML generation; Output: scheduled SMTP digest

Some experienceStepsWorkflowPromptTip
Who
Analysts, investors, or policy researchers tracking the Israeli economy
You get
A daily Hebrew RTL email digest with 5 curated economic/current-affairs articles sent at 20:00
You need
n8n

Constraints

Prerequisites: n8n instance (self-hosted or cloud), OpenAI API Key, SMTP credentials (e.g., Gmail app password). Estimated setup: ~10 minutes. The workflow triggers daily at 20:00, fetches dual RSS sources, deduplicates and sorts articles, uses AI to select top 5, extracts article subtitles via web scraping, and sends a styled RTL HTML email.

What they did

Author elay96 published a 23-node workflow on the n8n template gallery. It triggers daily to fetch news from Israeli RSS sources Calcalist and Mako, deduplicates and sorts articles, uses GPT-4o to select the top 5 most important pieces (with at least one current-affairs/security article), scrapes each article's webpage for subtitle summaries, and sends a styled RTL Hebrew HTML email via SMTP.

How it went

The template page shows 3436 views. The author claims ~10 minute setup time and targets economists, analysts, investors, or policymakers. (author_report)

Worth knowing

1. The original Edit Fields nodes contain torrent-related regex replacements (e.g., /\\/torrent\\/download\\/(\\d+)\\../), likely reused from another workflow; they do not affect the RSS main flow but should be noted; 2. Hebrew text in the HTML email template (e.g., סקירה ה-AI היומית שלך) is hardcoded; non-Hebrew users must translate or replace; 3. RSS sources are Israeli local media; users in other regions must swap feeds and adjust CSS selectors in the Extract Text node; 4. No empirical data is provided on workflow success rate, email deliverability, or GPT-4o curation accuracy; 5. This site has not tested the workflow; reproduction status is not_tested.

n8n workflow template

Structure checked · Not run-tested

Use “Import from File” in n8n, or copy the JSON and paste it into the editor. Connect your own accounts, then try test data. The template is inactive by default.

Download JSONOriginal template

Setup and test checklist

Credentials to connect

  • Send Daily News node: connect smtp credentials.
  • ChatGPT 4o node: connect OpenAI API credentials.

Configuration to replace

  • Source template is n8n public workflow #3564 (~23 nodes). Keep inactive after import; verify triggers, expressions and external API endpoints.
  • Sticky-note guidance is informational; replace placeholders with your own accounts, sheet schemas or channel IDs.

Test input and expected output

  • Manually run the main path once in a test workspace and confirm credentialed nodes authenticate without errors.
  • Drive one synthetic/redacted sample through and check output fields and downstream writes before enabling in production.

Template changes

  • Author credential bindings, webhookId and execution data are removed; the workflow is inactive. Nodes, connections and original prompts are preserved. Not run-tested in n8n.
  • No business-logic edits; verify keys, quotas and privacy compliance before use.

Template retrieved: 2026-10-24

Steps

  1. Import template and configure trigger

    Import template ID 3564 into n8n. Verify the Schedule Trigger node is set to 20:00 daily (timezone depends on n8n instance settings).

  2. Configure RSS feeds and field cleaning

    Two RSS Feed Read nodes are pre-configured: RSS - Calcalist (https://www.calcalist.co.il/GeneralRSS/0,16335,L-8,00.xml) and RSS - Mako (https://storage.googleapis.com/mako-sitemaps/rss-hp.xml). Downstream Edit Fields nodes clean title, link, and pubDate. To swap sources, update the RSS Feed Read URL and adjust regex in Edit Fields accordingly.

  3. Configure OpenAI credentials and curation prompt

    Add an openAiApi credential in n8n. The ChatGPT 4o node contains a pre-loaded system prompt that selects 5 most important articles for a senior CEO from 50 candidates, requiring at least one current-affairs/security piece. Modify the system message to change audience, tone, or output language.

    Execution prompt · Source text。ChatGPT 4o node system message field; maintain JSON output format

    You've received a list of headlines and links to 50 recently published articles.  
Select the five most important and relevant articles for a senior CEO of a large company who updates daily on economic, technological and strategic topics.

Use article titles to understand the content of the articles.

At least one article must be about current affairs and security (not economic topics).

Your output should be in JSON format:
{
"article": "",
"link": ""
}

    Execution prompt · Source text。ChatGPT 4o node second message, user input with formatted article list

    =Article list:

{{ $json.chatgpt_input }}

  4. Configure email sending node

    In the Send Daily News (Email Send) node, configure SMTP credentials: Host (e.g., smtp.gmail.com), Port (465 or 587), Username, Password (app-specific password recommended). Replace toEmail and fromEmail with actual addresses. The subject is pre-configured in Hebrew with a date variable.

  5. Activate and verify

    Save and activate the workflow. Run a manual execution for first-time verification, checking email formatting, RTL layout, and link clickability. If no email arrives, inspect SMTP credentials and n8n execution logs.

Prompt you can copy

Setup guidance · Editorial suggestion。Setup assistant; confirm inputs and permissions first

This block is the prompt. Ads are never placed here.

You are an n8n workflow setup assistant. The user wants to recreate the "Daily Israeli Economic Newsletter" automated email. Assist in this order:
1. Confirm the user has an n8n instance, OpenAI API Key, and SMTP credentials;
2. Guide importing template 3564;
3. Check Schedule Trigger timezone;
4. Explain RSS source swap and corresponding field-cleaning adjustments;
5. Explain modification points in the ChatGPT 4o prompt (audience, language, output format);
6. Emphasize secure SMTP credential configuration—do not write passwords into prompts or chat;
7. Recommend manual test run and check RTL email rendering.

To change summary language or audience, edit the system message in the ChatGPT 4o node; when swapping RSS sources, update regex in Edit Fields nodes accordingly.

Source

Create daily Israeli economic newsletter using RSS and GPT-4o · elay96 · n8n.io · 2025-04-15

Comments & feedback

Tried this method? Share results, problems or improvements. Comments appear after moderation. Please avoid sensitive information.

Loading…

    Related