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