This workflow automates the process of collecting trending topics from Google Trends RSS feed, scraping related content, and storing summarized insights into Google Sheets for editorial planning. It is triggered manually for testing or scheduled to run hourly, ensuring up-to-date trend data.
The process begins with a manual trigger or schedule, followed by fetching trending topics from Google Trends RSS for Italy. It then loads existing keywords from Google Sheets to avoid duplicates. New trends that meet the traffic threshold and are not already recorded get processed further.
The workflow makes HTTP requests to the jina.ai API to scrape content from three related URLs per trend. After obtaining the content, it consolidates and summarizes the data, filtering out empty or insufficient content results. If meaningful content is captured, it maps all relevant data points such as keyword, traffic, publication date, links, and summaries to Google Sheets, supporting content planning and ideation.
This automation streamlines trend monitoring, content scraping, and data organization, making it ideal for digital marketing teams, content creators, or SEO specialists aiming to stay ahead of trending topics with minimal manual effort.
Reviews
There are no reviews yet.