# Automate SEO blog pipeline from keywords to WordPress: n8n workflow

> Started by a clock, and works across Postgres and WordPress. It hands the judgement calls to OpenAI, OpenRouter and one other.

Source: https://millionrounds.com/workflow/automate-seo-blog-pipeline-from-keywords-to-wordpress (Millionrounds; every figure on the page links to its filing or article)

[Automation library](https://millionrounds.com/workflows) · [CRM](https://millionrounds.com/workflows?category=CRM#library)

# 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.

Large Calls a model: OpenAI, OpenRouter

[Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fautomate-seo-blog-pipeline-from-keywords-to-wordpress)

**79 steps** Large: read it before trusting it with anything live

**0** Branches: places the flow splits

**5** Loops or waits

**2** Services it connects to

## The flow

Starts it 2 Model 23 Logic 21 Service 14

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

- 1 **Structured Output Parser3** Output Parser Structured *Model*
- 2 **OpenAI Chat Model8** Lm Chat Open Ai *Model*
- 3 **Schedule Trigger3** Schedule trigger *Starts it*
- 4 **OpenAI Chat Model10** Lm Chat Open Ai *Model*
- 5 **OpenAI Chat Model11** Lm Chat Open Ai *Model*
- 6 **OpenAI Chat Model12** Lm Chat Open Ai *Model*
- 7 **OpenAI Chat Model13** Lm Chat Open Ai *Model*
- 8 **OpenAI Chat Model14** Lm Chat Open Ai *Model*
- 9 **OpenAI Chat Model15** Lm Chat Open Ai *Model*
- 10 **OpenRouter Chat Model** Lm Chat Open Router *Model*
- 11 **OpenRouter Chat Model1** Lm Chat Open Router *Model*
- 12 **Structured Output Parser** Output Parser Structured *Model*
- 13 **Select rows from a table** Postgres *Service*
- 14 **Select rows from a table in Postgres** Postgres Tool *Service*
- 15 **Schedule Trigger** Schedule trigger *Starts it*
- 16 **OpenAI Chat Model1** Lm Chat Open Ai *Model*
- 17 **create plan for dev1** Chain Llm *Model*
- 18 **select blog table1** Postgres *Service*
- 19 **header post1** Chain Llm *Model*
- 20 **Intro1** Chain Llm *Model*
- 21 **dev 1** Chain Llm *Model*
- 22 **conclusion1** Chain Llm *Model*
- 23 **dev 2** Chain Llm *Model*
- 24 **FAQ section1** Chain Llm *Model*
- 25 **Basic LLM Chain** Chain Llm *Model*
- 26 **Basic LLM Chain1** Chain Llm *Model*
- 27 **Choose keywords, Intent, etc** Agent *Model*
- 28 **Loop Over Items** Split In Batches *Logic*
- 29 **Fetch Keywords1** Postgres *Service*
- 30 **Merge1** Merge *Logic*
- 31 **limit to** Limit *Logic*
- 32 **Merge3** Merge *Logic*
- 33 **Edit Fields16** Set *Logic*
- 34 **Edit Fields19** Set *Logic*
- 35 **Edit Fields22** Set *Logic*
- 36 **Edit Fields21** Set *Logic*
- 37 **Edit Fields26** Set *Logic*
- 38 **Create Image1** Http Request *Service*
- 39 **Create Image3** Http Request *Service*
- 40 **Insert rows in a table** Postgres *Service*
- 41 **Select rows from a table1** Postgres *Service*
- 42 **Split Out2** Split Out *Logic*
- 43 **All scored** No Op *Logic*
- 44 **Score Keywords** Code *Logic*
- 45 **Limit2** Limit *Logic*
- 46 **Aggregate8** Aggregate *Logic*
- 47 **Preliminary Plan1** Open Ai *Model*
- 48 **Aggregate9** Aggregate *Logic*
- 49 **10 Seconds1** Wait *Logic*
- 50 **10 Seconds3** Wait *Logic*
- 51 **Code5** Code *Logic*
- 52 **Select rows from a table2** Postgres *Service*
- 53 **Update score** Postgres *Service*
- 54 **Edit Fields3** Set *Logic*
- 55 **Message a model1** Perplexity *Service*
- 56 **Edit Fields2** Set *Logic*
- 57 **Get Result1** Http Request *Service*
- 58 **Get Result3** Http Request *Service*
- 59 **Primary keywords** Postgres *Service*
- 60 **Code4** Code *Logic*

## 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.

## Run it in n8n

- **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n)
- **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fautomate-seo-blog-pipeline-from-keywords-to-wordpress)
- **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts.

Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind.

## Connects to

Each opens the other workflows that use it.

[Postgres](https://millionrounds.com/workflows?service=Postgres#library)[WordPress](https://millionrounds.com/workflows?service=WordPress#library)

## Workflows like it

Also crm, with the same services where possible, closest in size first.

- [**Analyze customer feedback and send AI-written replies** 31 steps · calls a model · Email, Google Sheets](https://millionrounds.com/workflow/analyze-customer-feedback-and-send-ai-written-replies)
- [**Score customer churn risk and trigger CS follow-ups** 16 steps · ClickUp, Gmail](https://millionrounds.com/workflow/score-customer-churn-risk-and-trigger-cs-follow-ups)
- [**Flight deal analyzer with OpenAI and Google Flights** 15 steps · calls a model · Slack, WordPress](https://millionrounds.com/workflow/flight-deal-analyzer-with-openai-and-google-flights)
- [**Territory mapper: maps CRM data** 14 steps · calls a model · Postgres](https://millionrounds.com/workflow/territory-mapper-maps-crm-data)
- [**Resilient AI Opportunity Scoring Engine with Salesforce** 9 steps · calls a model · Postgres, Salesforce](https://millionrounds.com/workflow/resilient-ai-opportunity-scoring-engine-with-salesforce)
- [**ETL pipeline for text processing with MongoDB and Postgres** 9 steps · MongoDB, Postgres](https://millionrounds.com/workflow/etl-pipeline-for-text-processing-with-mongodb-and-postgres)