Curate & Translate News from RSS using Google Gemini, Sheets, and Slack

Description

🤖 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
Fetch & Filter: Pulls NHK RSS and filters for keywords (e.g., "Tokyo").
AI Processing: Google Gemini rewrites articles, extracts locations, and translates text.
Archive & Notify: Saves structured data to Google Sheets and alerts Slack.

Setup Requirements
Credentials: Google Gemini, Google Sheets, Slack.
Google Sheet: Create headers: title, summary, location, en, zh, ko, url.
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": "도쿄 타워는..."
}