No Products in the Cart
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Content creators, marketers, and social media managers who want to stay ahead of emerging trends and generate relevant content ideas based on data-driven insights.
This workflow automatically identifies trending topics related to your industry, collects recent news articles about these trends, and generates content suggestions. It transforms raw trend data into actionable editorial opportunities by analyzing search volume growth and current news coverage.
The workflow follows a three-step automation process:
Trend Analysis: Examines searches related to your topics and identifies those with the strongest recent growth
Article Collection: Searches Google News for current articles about emerging trends and scrapes their full content
Content Generation: Creates personalized content suggestions based on collected articles and trend data
The system automatically excludes geo-localized searches to provide a global perspective on trends, though this can be customized.
SerpAPI account (for trend and news data)
Firecrawl API key (for scraping article content from Google News results)
Google Sheets access
AI model API key (for content analysis and recommendations - you can use any LLM provider you prefer)
Duplicate this Google Sheets template : https://docs.google.com/spreadsheets/d/1z7iP_i98PT9BQuUypAi0c3NHkdhREEPJWkDjyj8Snfw
Rename your copy and ensure it's accessible
Before running the workflow, set up the following credentials in n8n:
SerpAPI: For trend analysis and Google News search
Firecrawl API: For scraping article content
AI Model API: For content analysis and recommendations (Anthropic Claude, OpenAI GPT, or any other LLM provider)
Google Sheets OAuth2: For accessing and updating your tracking spreadsheet
In the "Get Query" node, paste your duplicated Google Sheets URL in the "Document" field
In your Google Sheet "Query" tab, enter the topics you want to monitor
The workflow is currently configured for French content and France location. You can modify these settings in the SerpAPI nodes:
Language (hl): Change from "fr" to your preferred language code
Geographic location (geo/gl): Change from "FR" to your target country code
Date range: Currently set to "today 1-m" (last month) but can be adjusted
The "Sorting Queries" node excludes geo-localized queries by default. You can modify the AI agent's instructions to include location-specific queries or change filtering criteria based on your requirements.
The workflow includes an automated scheduler that runs monthly (1st day of each month at 8 AM). You can modify the cron expression 0 8 1 * * in the Schedule Trigger node to change:
Frequency (daily, weekly, monthly)
Time of execution
Day of the month
Change trend count: The workflow processes up to 10 related queries per topic but filters them through AI to select the most relevant non-geolocalized ones
Adjust article collection: Currently collects exactly 3 news articles per query for analysis
Content style: Customize the AI prompts in content generation nodes to match your brand voice
Output format: Modify the Google Sheets structure to include additional data points
AI model: Replace the Anthropic model with your preferred LLM provider
Scraping options: Configure Firecrawl settings to extract specific content elements from articles
For each monitored topic, the workflow generates a separate sheet named by month and topic (eg, "January Digital Marketing") containing:
Data structure (four columns):
Query: The trending search term ranked by growth
Evolution: Growth percentage over the last month
News: Links to 3 relevant news articles
Idée: AI-generated content suggestions based on comprehensive article analysis
The workflow provides monthly retrospective analysis, helping you identify emerging topics before competitors and optimize your content calendar with high-potential subjects.
Processes up to 10 related queries per topic with AI filtering
Collects exactly 3 news articles per query
Results are automatically organized in monthly sheets
Requires stable internet connection for API calls
