Predict SEO traffic impact scenarios with Postgres and OpenAI GPT-4.1
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Postgres and OpenAI Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Set - Config (Edit Fields (Set)): sets 4 fields: maxActions, maxHorizonMonths, defaultHorizonMonths…
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- Postgres: run a query
- Respond - Validation Error (400) (Respond to Webhook): sends the response back to the webhook caller
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Postgres
n8n-nodes-base.postgres - Merge
n8n-nodes-base.merge - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Quick overview This workflow exposes a header-authenticated webhook API that simulates the SEO traffic impact of merging, creating, or removing pages using baseline metrics from Postgres, then generates a validated strategy narrative with OpenAI and logs the…