Automation library · Content

Automated content strategy with Google Trends and News

Started by a clock, and works across Google Sheets. It hands the judgement calls to Claude. 37 steps, 2 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Claude

Download free
37 stepsLarge: read it before trusting it with anything live
2Branches: places the flow splits
1Loop or waits
1Service it connects to

The flow

Starts it 1Model 7Logic 13Service 16

The steps in the order they run, from what starts it.

  1. 1Structured Output ParserOutput Parser StructuredModel
  2. 2Anthropic Chat ModelLm Chat AnthropicModel
  3. 3Schedule TriggerSchedule triggerStarts it
  4. 4Sonnet 4.6Lm Chat AnthropicModel
  5. 5Sorting queriesChain LlmModel
  6. 6Get QueryGoogle SheetsService
  7. 7Article analysis query 3Chain LlmModel
  8. 8Article analysis query 2Chain LlmModel
  9. 9Article analysis query 1Chain LlmModel
  10. 10Sorting output > tableCodeLogic
  11. 11Loop Over ItemsSplit In BatchesLogic
  12. 12Add article datas query 3Google SheetsService
  13. 13Add article datas query 2Google SheetsService
  14. 14Add article datas query 1Google SheetsService
  15. 15Create sheetsGoogle SheetsService
  16. 16Add datasGoogle SheetsService
  17. 17Search trendSerp ApiService
  18. 18Merge queriesMergeLogic
  19. 19Sort related queryCodeLogic
  20. 20Trends OK ?IfLogic
  21. 21SwitchSwitchLogic
  22. 22Classing queryCodeLogic
  23. 23Search GNews query 1Serp ApiService
  24. 24Search GNews query 2Serp ApiService
  25. 25Search GNews query 3Serp ApiService
  26. 26Return URL only query 1CodeLogic
  27. 27Return URL only query 2CodeLogic
  28. 28Return URL only query 3CodeLogic
  29. 29Scrape query 1FirecrawlService
  30. 30Article error google sheets query 1Google SheetsService
  31. 31Scrape query 2FirecrawlService
  32. 32Article error google sheets query 2Google SheetsService
  33. 33Scrape query 3FirecrawlService
  34. 34Article error google sheets query 3Google SheetsService
  35. 35Clean markdown for AI Query 1CodeLogic
  36. 36Clean markdown for AI Query 2CodeLogic
  37. 37Clean markdown for AI Query 3CodeLogic

How it's built

Starts on
A clock
Steps
37, with 2 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets
Model
Claude

Questions

What does it need to run?

An n8n account, plus your own Google Sheets account, and a key for Claude. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls Claude. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 37 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 37 steps before you point it at anything that matters.