Scrape, AI-Summarize News Posts (No RSS) & Save to NocoDB

This n8n workflow targets news sites lacking RSS feeds, like Colt's resources page, by first scraping the index to collect post links and publication dates using precise CSS selectors. It filters for the newest entries to avoid duplicates, then fetches full content from each link. Leveraging OpenAI's ChatGPT API, it generates concise summaries and extracts technical keywords from each article, streamlining content processing.

Benefits include hands-free content curation, saving hours of manual aggregation and analysis. It's ideal for marketing teams tracking industry news, enabling quick insights without full reads. The output integrates seamlessly with NocoDB (or any SQL DB) for querying, reporting, or feeding into newsletters/CRM systems.

Use cases span competitive intelligence, content collaboration, and automated briefings. Adaptable to any structured news site with CSS-selectable dates/links; runs weekly via cron for fresh data. Requires ChatGPT API, NocoDB setup, and basic selector knowledge—perfect for non-technical automators boosting productivity.