What This Automation Does
This workflow fetches and sorts hundreds of Israeli news articles every evening using two RSS feeds.
It removes duplicates and picks the top 5 most important news items by relevance.
AI (OpenAI GPT-4o) helps decide which articles matter most for a senior executive.
The final news digest is sent as a clean HTML email in Hebrew every day at 8 PM Israel time.
How This Workflow Works (Inputs → Processing → Output)
Inputs
- RSS feeds from two Israeli news sites: Calcalist and Mako.
Processing Steps
- Reads articles from both RSS URLs.
- Cleans titles, publication dates, and links for standard format.
- Merges both feed lists into one stream.
- Filters out articles missing valid publication dates.
- Sorts articles newest to oldest.
- Removes duplicate articles by link and takes top 50.
- Formats article list into text for AI prompt.
- Uses GPT-4o AI with instructions to select 5 most relevant articles for a senior executive focused on economy, technology, and security.
- Splits AI JSON output into individual article items.
- Fetches full HTML content for each selected article.
- Extracts summary paragraphs from article HTML using CSS selectors.
- Formats clean text summaries and links for email.
- Aggregates article data into one object for templating.
- Builds a right-to-left Hebrew HTML email template including summaries and workable links.
- Adds the current Israeli date for email subject and content.
- Sends email daily using configured SMTP credentials.
Output
A daily HTML newsletter email delivered automatically containing 5 key news stories.
Who Should Use This Workflow
This is good for busy managers who want to save time on reading news.
It helps keep up with the most important Israeli economic, tech, and security news.
People working in strategy, security, and senior leadership can benefit.
Tools and Services Used
- n8n Automation Platform: Runs the workflow and handles tasks like scheduling and merging.
- OpenAI GPT-4o API: Chooses the most relevant news articles based on prompt instructions.
- SMTP Email Server: Sends the final newsletter email automatically each day.
- Calcalist and Mako RSS feeds: Provide fresh news articles every evening.
Beginner Step-by-Step: How to Use This Workflow in n8n
Step 1: Import the Workflow
- Download the provided workflow file using the Download button on this page.
- Open n8n editor.
- Use the Import from File option to add the workflow to your environment.
Step 2: Configure Required Credentials
- Add OpenAI API credentials (include API Key) in n8n credentials manager.
- Insert SMTP email account details (username, password, host) into the Email Send node credentials.
Step 3: Update Workflow Settings if Needed
- Edit email recipient address in the Email Send node to the desired destination.
- If you want different RSS feeds, update URLs in the RSS Feed Read nodes for Calcalist and Mako.
- Check the system prompt in the OpenAI node; it is ready to use but can be adjusted if needed.
Step 4: Test the Workflow
- Run the workflow manually in n8n editor to check if articles and email content appear correctly.
- Check the email inbox for the test digest.
Step 5: Activate the Workflow
- Enable the scheduled trigger so the workflow runs daily at 8 PM Israel time automatically.
- Monitor the first runs for issues using n8n execution logs.
If running on a private instance, consider self-host n8n for full control.
Edge Cases and Troubleshooting
Problem: No News Articles Found or Email is Empty
Check RSS feed URLs for correctness and availability.
Try loading URLs in a browser to confirm they return data.
Problem: GPT-4o Picks Irrelevant Articles or Outputs Bad JSON
Verify the formatting code node prepares input text properly.
Refine AI prompt for clearer instructions if needed.
Problem: Email Fails to Send or Lands in Spam
Confirm SMTP credentials are accurate and tested in n8n.
Ensure emails have correct HTML and from/to addresses.
Customization Ideas
- Change or add more RSS feed sources to include other news providers.
- Modify AI instructions in the OpenAI node prompt to prioritize other topics.
- Adjust the HTML email template to match company branding or add extra sections like weather.
- Modify date formatting or timezone for localization preferences.
- Add multiple recipients or dynamic email addresses in the Email Send node.
Summary
✓ Fetches and filters Israeli news from Calcalist and Mako daily.
✓ Uses GPT-4o AI to pick top 5 most relevant news for business leaders.
✓ Sends a clean, right-to-left Hebrew HTML email digest every evening.
→ Saves time reading news by delivering only the most important articles.
→ Enables better focus on economic, tech, and security updates quickly.
