Automate Daily UPSC News Workflow

Заказчик: AI | Опубликовано: 30.11.2025

Every morning I sift through multiple national dailies to curate the ten most relevant news items for my UPSC-focused channel. The routine is predictable—collect headlines, draft crisp bullet summaries, add source links, then push everything to my content calendar—but it still takes up the bulk of my day. I’d like a streamlined, end-to-end workflow that does the heavy lifting for me. Here’s what I need: • A repeatable automation that pulls the latest editions of leading newspapers (The Hindu, Indian Express, etc.) as soon as they’re available. • Smart filtering so only UPSC-worthy stories surface—no generic lifestyle or entertainment pieces. • Automatic extraction of headline, date, and a short summary for exactly ten top stories. • A ready-to-publish output (Google Sheet, Notion table, or similar) that I can quickly review and schedule to my channel. I’m flexible on the stack—Zapier, Make (Integromat), Microsoft Power Automate, Python scripts, RSS parsing, or an API blend—whatever delivers the cleanest result with minimal manual tweaks. Just keep it low-maintenance and clearly documented so I can tweak sources or keywords later on. Acceptance criteria 1. One-click (or scheduled) trigger that completes the full pipeline. 2. Output consistently lists ten items with headline, 40–60 word summary, original URL, and publication name. 3. Workflow setup and how-to guide handed over so I can rerun or expand it myself. If you’ve built similar news, RSS, or content aggregation automations, let’s get this in place right away.