Automated UPSC current affairs digest from The Hindu to Google Sheets with Gemini AI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs on a schedule (every day at 07:00) (plus 1 other trigger). Along the way it connects Google Gemini Chat Model and Google Sheets. It also calls thehindu.com over HTTP.
How it runs
Trigger: On a schedule (every day at 07:00) (plus 1 other trigger).
- HTTP Request: calls thehindu.com
- HTML: parses or builds HTML
- Code: runs custom JavaScript code
- HTTP Request: calls an HTTP API
- HTML: parses or builds HTML
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 1 tool (Append row in sheet in Google Sheets)
- Append row in sheet (Google Sheets): append
Services it uses
HTTP calls to: thehindu.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - HTML
n8n-nodes-base.html - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
This template sets up a scheduled automation that scrapes the latest news from The Hindu website, uses a Google Gemini AI Agent to filter and analyze the content for relevance to the Competitive Exams like UPSC Civil Services Examination (CSE) syllabus, and…