AI-Powered RSS News to Google Sheets

# Automated RSS news collection with AI summaries in Google Sheets

This automation template solves the problem of continuously monitoring RSS feeds and processing new articles with AI-generated summaries. It´s ideal for professionals who need fast, structured insights from multiple content sources — without duplicates and in a centralized format.

## Who it´s for
- Marketers tracking news outlets and blogs
- Analysts collecting data from public sources
- Researchers organizing thematic information
- Editors managing content aggregators based on Google Sheets

## What the automation does
- Starts manually or on a schedule (cron)
- Reads a list of RSS feed URLs from Google Sheets
- Processes new items, filtering by publication date
- Checks for duplicates using article URLs
- Fetches full HTML content and converts it to Markdown
- Sends text to Gemini AI via OpenRouter for structured summarization
- Saves title, date, source, categories, and AI summary into Google Sheets

## What´s included
- Ready-to-use n8n workflow
- Trigger logic (scheduled and manual execution)
- Integrations with Google Sheets, RSS Feed, OpenRouter, and Gemini AI
- Basic textual instructions for setup and adaptation

## Requirements for setup
- n8n instance with access to HTTP requests and external APIs
- Google Sheets account with read/write permissions
- OpenRouter API key
- Access to Gemini AI model via OpenRouter
- Installed nodes for HTML Parser and LangChain (if used)

## Benefits and outcomes
- Saves time on manual review of numerous articles
- Eliminates duplicates through URL-based checks
- Delivers structured AI summaries instead of raw headlines
- Centralized data storage in Google Sheets
- Enables filtering and analysis by category and date
- Flexible: add new feeds without code changes
- Supports hands-free, recurring monitoring

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat