Automate content scraping from Google Trends to Google Sheets

• Automatically gather trending keywords for content planning
• Streamline data collection from Google Trends to Google Sheets
• Enhance SEO strategies with real-time keyword insights
• Create an editorial calendar based on current trends

Triggers the workflow every hour to fetch trending keywords from Google Trends Processes the XML data into a readable JSON format Filters keywords based on minimum traffic and checks against saved keywords in Google Sheets Scrapes content from associated news articles for each keyword Maps the scraped data into a structured format for Google Sheets Saves the compiled data into Google Sheets if valid content is available

1. 1
   Import the workflow template into your n8n instance
2. 2
   Set up Google Sheets credentials for data storage
3. 3
   Configure the Jina.ai API key for content scraping
4. 4
   Adjust minimum traffic and maximum results settings in the CONFIG node
5. 5
   Run the workflow to start automating content scraping