Automation library · Content

Comprehensive SEO keyword research with OpenAI and DataForSEO

Started by another system calling it, and works across NocoDB and Slack. It hands the judgement calls to OpenAI. 26 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

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

The flow

Starts it 1Model 7Logic 10Service 8

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

  1. 1OpenAI Chat ModelLm Chat Open AiModel
  2. 2Structured Output ParserOutput Parser StructuredModel
  3. 3OpenAI Chat Model2Lm Chat Open AiModel
  4. 4Get Input from NocoDBWebhookStarts it
  5. 5OpenAI Chat Model1Lm Chat Open AiModel
  6. 6Topic ExpansionAgentModel
  7. 7Final Keyword StrategyAgentModel
  8. 8Set relevant fieldsSetLogic
  9. 9Competitor AnalysisAgentModel
  10. 10split primary keywordsSplit OutLogic
  11. 11Merge Topic Expansion, SV, CPC & KWDMergeLogic
  12. 12Write Content Brief Noco DbService
  13. 13Update Status - DoneNoco DbService
  14. 14Send NotificationSlackService
  15. 15Format Json and add Competitor URLsCodeLogic
  16. 16Merge EverythingMergeLogic
  17. 17Update Status - StartedNoco DbService
  18. 18Start NotificationSlackService
  19. 19Aggregate Competitor AnalysisAggregateLogic
  20. 20Search Volume & CPCData For SeoService
  21. 21Keyword DifficultyData For SeoService
  22. 22Split the Competitor URLsSplit OutLogic
  23. 23Aggregate SV & CPCAggregateLogic
  24. 24Aggregate KWDAggregateLogic
  25. 25Keyword Ranking per URLData For SeoService
  26. 26Merge SV, CPC & KWDMergeLogic

How it's built

Starts on
Another system calling it
Steps
26
Size
Large: read it before trusting it with anything live
Connects to
NocoDB, Slack
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own NocoDB and Slack accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on another system calling it.

Does it use AI?

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

How long does it take to set up?

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