Templates / Automated content strategy with Google Trends, News, Firecrawl & Claude AI

Automated content strategy with Google Trends, News, Firecrawl & Claude AI

Unknown

by Allan Vaccarizi ✓ · 5,307 views · created 2025-08-14 · Market Research, Multimodal AI

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What 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).

  1. Get Query (Google Sheets): uses Google Sheets
  2. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  3. Search trend (Serp Api): uses Serp Api
  4. Trends OK ? (If): checks a condition and branches into true / false
  5. Classing query (Code): runs custom JavaScript code
  6. Sorting queries (Basic LLM Chain): sends a prompt to an LLM, with model: Anthropic Chat Model; output parser: Structured Output Parser
  7. Sorting output > table (Code): runs custom JavaScript code
  8. Create sheets (Google Sheets): uses Google Sheets
  9. Add datas (Google Sheets): uses Google Sheets
  10. Sort related query (Code): runs custom JavaScript code

…plus 23 more steps. See the full node list below.

Services it uses

Google SheetsAnthropic Chat ModelSerpapi (community)Firecrawl (community)

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)

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…

Excerpt from Allan Vaccarizi's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.