n8n templatesn8n templates

My workflow 2

This workflow automatically fetches popular keywords and related information from Google Trends in the Italian region, filters out new trending keywords, and uses the jina.ai API to obtain relevant webpage content to generate summaries. Finally, the data is stored in Google Sheets as an editorial planning database. Through this process, users can efficiently monitor market dynamics, avoid missing important information, and enhance the accuracy and efficiency of keyword monitoring, making it suitable for content marketing, SEO optimization, and market analysis scenarios.

Workflow Diagram
My workflow 2 Workflow diagram

Workflow Name

My workflow 2

Key Features and Highlights

This workflow automatically fetches trending keywords and related news from the Google Trends RSS feed for the Italy region. It filters out high-traffic, previously unrecorded new trend keywords, then uses the jina.ai API to scrape relevant web content and generate consolidated summaries. Finally, the processed data is saved into Google Sheets as an editorial planning database. The workflow is highly automated, capable of accurately filtering and updating trending keywords, helping users stay informed of market dynamics in real time.

Core Problems Addressed

Manual monitoring of Google Trends data is time-consuming and prone to missing critical information. This workflow automates data fetching, content extraction, deduplication, summary generation, and data storage, significantly improving the efficiency and accuracy of keyword monitoring while preventing duplicate records and irrelevant data.

Application Scenarios

  • Content marketing teams regularly acquiring the latest trending topics to support content creation planning
  • SEO specialists monitoring keyword trends to adjust optimization strategies
  • Market analysts tracking industry developments and user interest hotspots
  • Media editors automating the collection and organization of news leads

Main Workflow Steps

  1. Scheduled Trigger (Cron Trigger): Initiates the workflow at the 11th minute of every hour to ensure timely data updates.
  2. Load Configuration Parameters (CONFIG): Sets minimum traffic threshold, maximum result count, and jina.ai API key.
  3. Read Saved Keywords (Google Sheets): Retrieves historical keywords to avoid duplicate processing.
  4. Fetch Google Trends RSS (HTTP Request): Obtains the latest trending keywords and associated news links.
  5. Parse XML to JSON (XML Node): Converts RSS XML data into a JSON format for easier processing.
  6. Filter New Keywords (Code Node): Selects new, high-potential keywords based on traffic thresholds and deduplication logic.
  7. Batch Process Keywords (SplitInBatches): Iterates through each keyword in batches.
  8. Scrape Related News Content (HTTP Request + jina.ai): Calls the jina.ai API to retrieve text content from three related news webpages.
  9. Merge Content and Generate Summary (Set Node): Combines the three news contents into a single comprehensive summary.
  10. Validate Content (If Node): Ensures only valid content is saved to prevent empty data entries.
  11. Save Data to Google Sheets: Stores keywords, traffic, publication time, summaries, and news links for subsequent use.

Involved Systems and Services

  • Google Trends RSS (Trend data source)
  • Google Sheets (Data storage and management)
  • jina.ai API (Web content scraping and summary generation)
  • n8n Automation Platform (Workflow orchestration)
  • Built-in n8n nodes including HTTP Request, XML Parsing, Code Processing, and Conditional Logic

Target Users and Value

  • Content operators and editors: Automatically capture the latest trending topics to support content strategy.
  • SEO/SEM professionals: Monitor keyword traffic dynamics and adjust strategies accordingly.
  • Market researchers and data analysts: Real-time industry trend monitoring for rapid market response.
  • Automation enthusiasts and technical personnel: Learn and apply complex data scraping and processing workflows to enhance automation capabilities.

In summary, "My workflow 2" is an efficient tool integrating trend data collection, intelligent content scraping, and automated data management. It is well-suited for professionals who need to stay abreast of market trends and improve content production efficiency in real time.