Analyze domain keyword rankings and summarize with SE Ranking and GPT-4.1-mini

Description

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 into actionable SEO intelligence.

Who this is for?

This workflow is designed for:

SEO engineers and technical marketers
Growth teams running programmatic SEO
Agencies managing multi-domain keyword analysis
Product teams building SEO analytics pipelines
Developers using n8n for data enrichment and reporting

If you work with keyword data and need machine-readable output plus human-readable insights, this workflow is for you.

What this workflow does

Accepts a target domain or URL, region, keyword type (organic/paid), and filters
Fetches keyword ranking data from the SE Ranking Domain Keywords API
Extracts metrics such as:

Keyword positions
Search volume & CPC
Competition & difficulty
SERP features & search intent
Traffic estimates
Uses OpenAI GPT-4.1-mini to generate:

A comprehensive narrative summary
A concise abstract overview
Merges raw data and AI insights into a single enriched dataset
Exports the final output as structured JSON for downstream use

Setup

Prerequisites

Active SE Ranking API access
OpenAI API key with GPT-4.1-mini enabled
Running n8n instance (self-hosted or cloud)
Basic understanding of keyword ranking metrics

Configuration steps

If you are new to SE Ranking, please signup on seranking.com

Import the workflow JSON into n8n
Configure credentials:

SE Ranking using HTTP Header Authentication. Please make sure to set the header authentication as below. The value should contain a Token followed by a space with the SE Ranking API Key.



OpenAI API (GPT-4.1-mini model)
Open the Set the Input Fields node and define:

target_site (domain or URL)
source (region, e.g. us)
type (organic or paid)
limit, filters, and requested columns
Verify the output as per the export data handling.

Converts enriched SEO results into structured JSON output
Creates binary data to support file-based exports
Converts processed data into CSV format for easy analysis
Inserts or updates records in Google Sheets for reporting
Ensures data consistency across all export destinations
Enables downstream automation, dashboards, and audits


Click Execute Workflow

How to customize this workflow to your needs

You can easily adapt this workflow by:

Switching between organic and paid keyword analysis
Changing regions for international SEO tracking
Modifying requested keyword columns and SERP filters
Customizing the OpenAI prompt to generate:

SEO action items
Competitive insights
Executive summaries
Replacing file export with:

Databases
Dashboards
Slack/Email alerts
Data warehouses

Summary

This n8n template delivers a production ready SEO analytics pipeline that bridges structured SERP data with AI powered interpretation. By combining SE Ranking’s keyword intelligence with OpenAI driven summarization, it enables faster insights, better reporting, and scalable SEO decision making without manual analysis.