Skip to main content

Curate & translate news from RSS using Google Gemini, Sheets, and Slack

n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

🤖 Automated Multi-lingual News Curator & Archiver

Overview This workflow automates news monitoring by fetching RSS feeds, rewriting content using AI, translating it (EN/ZH/KO), and archiving it.

Who is this for? Content Curators, Localization Teams, and Travel Bloggers.

How it works

  1. Fetch & Filter: Pulls NHK RSS and filters for keywords (e.g., "Tokyo").
  2. AI Processing: Google Gemini rewrites articles, extracts locations, and translates text.
  3. Archive & Notify: Saves structured data to Google Sheets and alerts Slack.

Setup Requirements

  1. Credentials: Google Gemini, Google Sheets, Slack.
  2. Google Sheet: Create headers: title, summary, location, en, zh, ko, url.
  3. Slack: Configure Channel IDs.

Customization

  • RSS Read: Change feed URL.
  • If Node: Update filter keywords.
  • AI Agent: Adjust system prompts for tone.

1. Fetch & Filter

Runs on a schedule to fetch the latest RSS items. Filters articles based on specific keywords (e.g., "Tokyo" or "Season") before processing.

2. AI Analysis & Parsing

Uses Google Gemini to rewrite the news, extract specific locations, and translate content. The Code node cleans the JSON output for the database.

3. Archive & Notify

Appends the structured data to Google Sheets and sends a formatted notification to Slack (or alerts if an article was skipped).

Output Example (JSON) The translation agent outputs data in this format:

{
  "en": "Tokyo Tower is...",
  "zh": "东京塔是...",
  "ko": "도쿄 타워는..."
}