Automated Trend Content Collection & Storage Workflow

This n8n workflow automates the process of fetching trending topics from Google Trends, scraping relevant content from related news URLs, analyzing and filtering the data, and storing the summarized insights into Google Sheets for editorial planning. Triggered manually or scheduled to run hourly, it ensures a continuously updated database of trending keywords and associated content. The workflow begins with a manual trigger or schedule, retrieves trending topics via RSS, filters keywords based on traffic thresholds, fetches content from linked news sites using jina.ai, processes, filters, and maps the data, and finally stores the summarized details in Google Sheets. This automation is ideal for content creators, social media teams, or SEO professionals aiming to stay current with trending topics and efficiently manage content curation.