My workflow 2

Automated workflow for Google Sheets that runs hourly to fetch trending keywords from Google Trends, filters results based on traffic, and compiles summaries from multiple sources. This process enhances content planning by ensuring timely updates and organized data management, ultimately saving time and improving efficiency.

7/8/2025
26 nodes
Complex
schedulecomplexgooglesheetssplitinbatchesschedule triggersticky notenoopautomationadvanceddataparsingapiintegrationcronlogicconditional
Categories:
Schedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
GoogleSheetsSplitInBatchesSchedule TriggerSticky NoteNoOp

Target Audience

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.

Problem Solved

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.

Workflow Steps

  • 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.

    • Customization Guide

    Users can customize this workflow by adjusting the following parameters:
    - Minimum Traffic: Modify the min_traffic value to filter out lower traffic keywords based on specific needs.
    - Maximum Results: Change the max_results parameter to increase or decrease the number of trending keywords processed.
    - Jina API Key: Input your own jina_key for content scraping to ensure access to the scraping service.
    - Google Sheets Integration: Update the documentId and sheetName parameters to connect to your specific Google Sheets document for saving results.
    - Schedule Timing: Adjust the cron expression in the schedule trigger to change the frequency of data retrieval according to your requirements.