Analyze domain keyword rankings and summarize with SE Ranking and GPT-4.1-mini
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model and Google Sheets. It also calls api.seranking.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set the Input Fields (Edit Fields (Set)): sets 6 fields: target_site, type, limit…
- SE Ranking Request (HTTP Request): calls api.seranking.com
- SE Ranking AI Summarizer (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Extract Summary (Code): runs custom JavaScript code
- Extract Raw Response (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Aggregate: combines items into one
- Create a Binary Data (Function): runs custom JavaScript (legacy Function node)
- Persist on DataTable (Data table): uses Data table
- Append or update row in sheet (Google Sheets): append or update
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.seranking.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Create a Binary Data: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Create a Binary Data | Code node, mode 'Run Once for All Items' |
Nodes used (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Function
n8n-nodes-base.function - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - Convert to File
n8n-nodes-base.convertToFile - Google Sheets
n8n-nodes-base.googleSheets - Data table
n8n-nodes-base.dataTable
From the author
This n8n workflow automates domain level keyword ranking analysis and enriches raw SEO metrics with AI-generated summaries. It combines structured keyword data from SE Ranking with natural-language insights produced by OpenAI, turning complex SERP datasets…