1
🤖 AI News Bot
An AI-powered news summarization automation built with n8n. Users submit a topic through a simple form, the workflow fetches live news headlines, summarizes them using Google Gemini, and automatically logs the results to Google Sheets — a complete no-code automation pipeline combining data retrieval, AI reasoning, and structured storage.
🎯 What It Does
A user submits a topic (e.g. "technology", "cricket", "AI regulation") through a web form.
The workflow fetches the 5 most recent news headlines on that topic from Google News RSS.
An AI Agent (Google Gemini) reads the headlines and generates a concise 4–6 sentence summary of the key trends and takeaways.
The summary — along with the topic and a timestamp — is automatically appended as a new row in a Google Sheet.
🧩 Tech Stack
Component Tool
Automation engine n8n
AI summarization Google Gemini (gemini-2.0-flash)
News source Google News RSS (free, no API key)
Data storage Google Sheets
User input n8n Form Trigger
⚙️ How It Works (Workflow Breakdown)
Form Trigger (topic input)
↓
HTTP Request → Google News RSS (fetch headlines)
↓
Code Node → Extract & clean top 5 headlines
↓
AI Agent (Google Gemini) → Summarize headlines
↓
Set Node → Prepare row (Date, Topic, Summary)
↓
Google Sheets → Append row
Node-by-node
Get Topic (Form Trigger) — collects the topic from the user via a simple web form.
Fetch News RSS (HTTP Request) — calls https://news.google.com/rss/search?q={topic} to retrieve recent headlines, no API key required.
Extract Headlines (Code) — parses the raw RSS/XML response and extracts the top 5 clean headline titles.
AI Summarizer (AI Agent + Google Gemini Chat Model) — generates a concise, neutral summary of the headlines with one notable takeaway.
Prepare Row (Set) — formats the output (timestamp, topic, summary) for storage.
Save to Google Sheets (Google Sheets — Append Row) — logs each request as a permanent record.
🚀 Setup
Import the workflow into your n8n instance (Workflows → Import from File/Clipboard).
Connect credentials:
Google Gemini API key (aistudio.google.com — free tier available)
Google Sheets OAuth2 (connect your Google account)
Create a Google Sheet with the headers: Date | Topic | Summary
Select that sheet + tab in the Save to Google Sheets node.
Activate/Publish the workflow.
Open the form's Production URL (found in the "Get Topic" node) to use it.
📝 Example
Input topic: technology
Output summary:
Recent technology headlines highlight major developments in AI regulation, new product launches, and industry partnerships. Several reports point to increased investment in AI infrastructure, while regulatory bodies continue to scrutinize data privacy practices. One notable trend: smaller startups are increasingly partnering with established tech giants rather than competing directly.
⚠️ Known Limitations
Uses Google Gemini's free tier, which has rate limits (requests per minute). Heavy or concurrent use may return a quota error.
Google News RSS occasionally returns no results for very obscure or narrow topics.
This is a learning/demo project — no authentication or spam protection is implemented on the form.
💡 Next Steps / Ideas
Add rate-limiting or submission caps for public use
Support multiple languages/regions for news search
Add a scheduled daily digest mode instead of on-demand only
Deliver summaries via email/Slack in addition to Google Sheets
🛠️ Built By
Built as a hands-on learning project to explore AI agent orchestration, webhook/API integration, and no-code automation with n8n.
Add a comment
0/2000