Automated content strategy with Google Trends, News, Firecrawl & Claude AI
UnknownWhat this workflow does
This AI workflow has 37 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Anthropic Chat Model, Serpapi (community) and Firecrawl (community).
How it runs
Trigger: On a schedule (every day).
- Get Query (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Search trend (Serp Api): uses Serp Api
- Trends OK ? (If): checks a condition and branches into true / false
- Classing query (Code): runs custom JavaScript code
- Sorting queries (Basic LLM Chain): sends a prompt to an LLM, with model: Anthropic Chat Model; output parser: Structured Output Parser
- Sorting output > table (Code): runs custom JavaScript code
- Create sheets (Google Sheets): uses Google Sheets
- Add datas (Google Sheets): uses Google Sheets
- Sort related query (Code): runs custom JavaScript code
…plus 23 more steps. See the full node list below.
Services it uses
Uses Firecrawl. New users get 10% off with our link.
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 2 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-serpapi is verified or supports 3.0 (used in Search trend, Search GNews query 1, Search GNews query 2).
- Check that @mendable/n8n-nodes-firecrawl is verified or supports 3.0 (used in Scrape query 1, Scrape query 3, Scrape query 2).
Nodes used (12)
- Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Serp Api
n8n-nodes-serpapi.serpApi - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Switch
n8n-nodes-base.switch - Firecrawl
@mendable/n8n-nodes-firecrawl.firecrawl
From the author
📺 Full walkthrough video: https://youtu.be/dXz5OTbm4c8 Automated trend monitoring for content strategy Who's it for Content creators, marketers, and social media managers who want to stay ahead of emerging trends and generate relevant content ideas based on…