Create Data-Driven SEO Content Briefs with AI Analysis of SERP Data Using Bright Data
This workflow is your all-in-one **AI Content Strategist**, designed to generate comprehensive, data-driven **content briefs** by analyzing top-ranking competitors.
It operates through a simple **chat interface**. You provide a target **keyword**, and the workflow automates the entire research process. First, it scrapes the **top 10 Google search results** using the powerful **[Bright Data SERP API](https://get.brightdata.com/unstoppable)**.
Then, for each of those results, it performs a deep dive, using the **Bright Data Web Unblocker** to reliably extract the full content from each page, bypassing any **anti-bot measures**.
Finally, all the gathered data—titles, headings, word counts, and page summaries—is synthesized by a **Large Language Model (LLM)** to produce a **strategic content plan**. This plan identifies **search intent**, **core topics**, and crucial **content gaps**, giving you a clear roadmap to **outrank the competition**. This template is indispensable for **SEO specialists**, **content marketers**, and **digital agencies** looking to scale their content production with strategies that are proven to work.
---
## Why Use This AI Content Strategist Workflow?
* **Data-Driven Insights**: Base your content strategy on what is actually ranking on **Google**, not guesswork.
* **Automated Competitive Analysis**: Instantly understand the structure, length, and key themes of the **top-performing articles** for any keyword.
* **Strategic Gap Detection**: The **AI analysis** highlights poorly covered topics and **missed opportunities**, allowing you to create content that provides **unique value**.
* **Massive Time Savings**: Condenses hours of **manual research** into a fully automated process that runs in minutes.
---
## How It Works
1. **Chat Interaction Begins**: The workflow is initiated via a **chat UI**. The user enters a target **keyword** to start the analysis.
2. **Google SERP Scraping (Bright Data)**: The **Google SERP** node uses **Bright Data's SERP API** to fetch the **top 10 organic results**, providing the URLs for the next stage.
3. **Individual Page Scraping (Bright Data)**: The workflow loops through each URL. The **Access and extract data** node uses the **Bright Data Web Unblocker** to ensure **successful and complete HTML scraping** of every competitor's page.
4. **Content Extraction & Aggregation**: A series of `Code` nodes **clean the raw HTML** and **extract structured data** (title, meta description, headings, word count). The `Aggregate` node then **compiles the data** from all 10 pages into a single dataset.
5. **AI Synthesis (OpenRouter)**: The **Analysis** node sends the entire compiled dataset to an **LLM** via **OpenRouter**. The **AI** performs a **holistic analysis** to identify **search intent**, **must-cover topics**, and **differentiation opportunities**.
6. **Strategic Brief Generation**: The **Format Output** node takes the AI's structured **JSON analysis** and transforms it into a clean, human-readable **Markdown report**, which is then delivered back to the user in the chat interface.
---
## Prerequisites
To use this workflow, you will need active accounts with both **[Bright Data](https://get.brightdata.com/unstoppable)** (for web scraping) and **OpenRouter** (for AI model access).
### Setting Up Your Credentials:
1. **Bright Data Account**:
* Sign up for a free trial account on their [website](https://get.brightdata.com/unstoppable).
* Inside your Bright Data dashboard, you will need to activate both the **SERP API** and the **Web Unblocker** products to create the necessary Zones.
* In n8n, navigate to the **Credentials** section, add a new **Brightdata API** credential, and enter your API key.
* In the workflow, select your newly created credential in both the **Google SERP** node and the **Access and extract data from a specific URL** node.
2. **OpenRouter Account**:
* Sign up for an account at [OpenRouter.ai](https://openrouter.ai/).
* Navigate to your account settings to find your **API Key**.
* In n8n, go to **Credentials**, add a new **OpenRouter API** credential, and paste your key.
* In the workflow, select this credential in all three **OpenRouter Chat Model** nodes.
---
[Phil | Inforeole](https://inforeole.fr)
**Contactez-nous pour automatiser vos processus**
n8nFree