Automation library · Content

Creating SEO-optimized blogs for WordPress with OpenAI

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

LargeCalls a model: OpenAI, OpenRouter

Download free
100 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
1Loop or waits
4Services it connects to

The flow

Starts it 2Model 21Logic 25Service 12

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

  1. 1Structured Output ParserOutput Parser StructuredModel
  2. 2Structured Output Parser1Output Parser StructuredModel
  3. 3OpenAI Chat ModelLm Chat Open AiModel
  4. 4OpenRouter Chat Model1Lm Chat Open RouterModel
  5. 5OpenRouter Chat Model2Lm Chat Open RouterModel
  6. 6Select rows from a tablePostgresService
  7. 7Select rows from a table in PostgresPostgres ToolService
  8. 8Schedule TriggerSchedule triggerStarts it
  9. 9OpenRouter Chat Model6Lm Chat Open RouterModel
  10. 10Schedule Trigger1Schedule triggerStarts it
  11. 11OpenAI Chat Model1Lm Chat Open AiModel
  12. 12OpenAI Chat Model2Lm Chat Open AiModel
  13. 13OpenAI Chat Model3Lm Chat Open AiModel
  14. 14OpenAI Chat Model4Lm Chat Open AiModel
  15. 15OpenAI Chat Model5Lm Chat Open AiModel
  16. 16OpenAI Chat Model6Lm Chat Open AiModel
  17. 17Choose keywords, Intent, etcAgentModel
  18. 18create plan for devChain LlmModel
  19. 19Loop Over ItemsSplit In BatchesLogic
  20. 20Fetch Keywords1PostgresService
  21. 21FAQ sectionChain LlmModel
  22. 22select blog tablePostgresService
  23. 23header postChain LlmModel
  24. 24IntroChain LlmModel
  25. 25dev 1Chain LlmModel
  26. 26conclusionChain LlmModel
  27. 27dev 2Chain LlmModel
  28. 28Insert rows in a tablePostgresService
  29. 29Select rows from a table1PostgresService
  30. 30Split Out2Split OutLogic
  31. 31MergeMergeLogic
  32. 32All scoredNo OpLogic
  33. 33Score KeywordsCodeLogic
  34. 34Limit2LimitLogic
  35. 35Edit Fields20SetLogic
  36. 36limit to 1LimitLogic
  37. 37Merge2MergeLogic
  38. 38Edit Fields9SetLogic
  39. 39Edit Fields10SetLogic
  40. 40Edit Fields12SetLogic
  41. 41Edit Fields11SetLogic
  42. 42Code5CodeLogic
  43. 43Select rows from a table2PostgresService
  44. 44Aggregate4AggregateLogic
  45. 45Update scorePostgresService
  46. 46Edit Fields3SetLogic
  47. 47Preliminary PlanOpen AiModel
  48. 48Aggregate5AggregateLogic
  49. 49Primary keywordsPostgresService
  50. 50Code4CodeLogic
  51. 51Aggregate2AggregateLogic
  52. 52Message a modelPerplexityService
  53. 53Edit FieldsSetLogic
  54. 54Used secondaryPostgresService
  55. 55Split Out1Split OutLogic
  56. 56Split Out3Split OutLogic
  57. 57Edit Fields7SetLogic
  58. 58Edit Fields19SetLogic
  59. 59blog tablePostgresService
  60. 60Code6CodeLogic

How it's built

Starts on
A clock
Steps
100, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
GitHub, Postgres, Slack, WordPress
Model
OpenAI, OpenRouter, Perplexity

Questions

What does it need to run?

An n8n account, plus your own GitHub, Postgres, Slack 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 100 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 100 steps before you point it at anything that matters.