Automated Google Trends Workflow

This workflow is ideal for content marketers, SEO specialists, and digital marketers who want to stay updated with trending keywords and topics. It is also suitable for businesses looking to enhance their content strategy by leveraging current trends from Google Trends, and for data analysts who need to automate data collection and reporting processes.

This workflow addresses the challenge of manually tracking trending keywords and related content. It automates the process of fetching data from Google Trends, scraping content from multiple sources, and organizing it into a structured format suitable for analysis and reporting. This significantly reduces the time and effort required to gather and analyze trending topics, enabling users to focus on strategic decision-making.

1. Trigger: The workflow is triggered every hour past the 11th minute using a cron expression, ensuring timely updates.
2. Configuration: It retrieves configuration settings such as minimum traffic of 500 and a maximum of 3 results.
3. Fetch Keywords: The workflow fetches saved keywords from Google Sheets to avoid duplicates.
4. Get Trending Data: It retrieves the latest trending data from Google Trends using an RSS feed.
5. Process Data: The fetched XML data is parsed, and relevant information such as approximate traffic and publication date is extracted.
6. Filter and Sort: New items are filtered based on the minimum traffic threshold and sorted by traffic.
7. Scraping Content: For each trending keyword, the workflow scrapes content from up to 3 URLs to generate a summary.
8. Mapping Data: The scraped content is mapped to predefined fields for Google Sheets.
9. Conditional Save: If at least one URL has been successfully scraped and the summary length exceeds 100 characters, the data is saved to Google Sheets. If all scraping attempts fail, no record is saved.
10. Completion: The workflow concludes, ensuring that only high-quality, relevant data is stored.