Automation library · CRM

Automate SEO blog pipeline from keywords to WordPress

Started by a clock, and works across Postgres and WordPress. It hands the judgement calls to OpenAI, OpenRouter and one other. 79 steps, 5 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI, OpenRouter

Download free
79 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
5Loops or waits
2Services it connects to

The flow

Starts it 2Model 23Logic 21Service 14

The steps in the order they run, from what starts it. The first 60 of 79.

  1. 1Structured Output Parser3Output Parser StructuredModel
  2. 2OpenAI Chat Model8Lm Chat Open AiModel
  3. 3Schedule Trigger3Schedule triggerStarts it
  4. 4OpenAI Chat Model10Lm Chat Open AiModel
  5. 5OpenAI Chat Model11Lm Chat Open AiModel
  6. 6OpenAI Chat Model12Lm Chat Open AiModel
  7. 7OpenAI Chat Model13Lm Chat Open AiModel
  8. 8OpenAI Chat Model14Lm Chat Open AiModel
  9. 9OpenAI Chat Model15Lm Chat Open AiModel
  10. 10OpenRouter Chat ModelLm Chat Open RouterModel
  11. 11OpenRouter Chat Model1Lm Chat Open RouterModel
  12. 12Structured Output ParserOutput Parser StructuredModel
  13. 13Select rows from a tablePostgresService
  14. 14Select rows from a table in PostgresPostgres ToolService
  15. 15Schedule TriggerSchedule triggerStarts it
  16. 16OpenAI Chat Model1Lm Chat Open AiModel
  17. 17create plan for dev1Chain LlmModel
  18. 18select blog table1PostgresService
  19. 19header post1Chain LlmModel
  20. 20Intro1Chain LlmModel
  21. 21dev 1Chain LlmModel
  22. 22conclusion1Chain LlmModel
  23. 23dev 2Chain LlmModel
  24. 24FAQ section1Chain LlmModel
  25. 25Basic LLM ChainChain LlmModel
  26. 26Basic LLM Chain1Chain LlmModel
  27. 27Choose keywords, Intent, etcAgentModel
  28. 28Loop Over ItemsSplit In BatchesLogic
  29. 29Fetch Keywords1PostgresService
  30. 30Merge1MergeLogic
  31. 31limit to LimitLogic
  32. 32Merge3MergeLogic
  33. 33Edit Fields16SetLogic
  34. 34Edit Fields19SetLogic
  35. 35Edit Fields22SetLogic
  36. 36Edit Fields21SetLogic
  37. 37Edit Fields26SetLogic
  38. 38Create Image1Http RequestService
  39. 39Create Image3Http RequestService
  40. 40Insert rows in a tablePostgresService
  41. 41Select rows from a table1PostgresService
  42. 42Split Out2Split OutLogic
  43. 43All scoredNo OpLogic
  44. 44Score KeywordsCodeLogic
  45. 45Limit2LimitLogic
  46. 46Aggregate8AggregateLogic
  47. 47Preliminary Plan1Open AiModel
  48. 48Aggregate9AggregateLogic
  49. 4910 Seconds1WaitLogic
  50. 5010 Seconds3WaitLogic
  51. 51Code5CodeLogic
  52. 52Select rows from a table2PostgresService
  53. 53Update scorePostgresService
  54. 54Edit Fields3SetLogic
  55. 55Message a model1PerplexityService
  56. 56Edit Fields2SetLogic
  57. 57Get Result1Http RequestService
  58. 58Get Result3Http RequestService
  59. 59Primary keywordsPostgresService
  60. 60Code4CodeLogic

How it's built

Starts on
A clock
Steps
79, 5 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Postgres, WordPress
Model
OpenAI, OpenRouter, Perplexity

Questions

What does it need to run?

An n8n account, plus your own Postgres and WordPress accounts, and a key for OpenAI and OpenRouter. 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 OpenAI, OpenRouter and Perplexity. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 79 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 79 steps before you point it at anything that matters.