Website Content Scraper & SEO Keyword Extractor with GPT-4o-mini and Airtable

This workflow allows you to scrape website content, clean the HTML, extract structured information using GPT-4o-mini, and store the results along with SEO keywords into Airtable. Ideal for building keyword lists and organizing web content for SEO research.

---

Setup Instructions

1. Prerequisites

• n8n Community or Cloud instance
• Airtable account with a base and table ready
• OpenAI API Key with access to GPT-4o-mini

---

2. Airtable Structure

Ensure your Airtable table has the following fields:

Field Name

Type

Notes

Website Name

String

Name or URL of the website

Data

String

Cleaned website text

Keyword

String

Extracted SEO keyword list

Status

Options

Values: Todo, In progress, Done

---

3. Node Setup

✅ Form Trigger:
Collects website URL from the user.

✅ HTTP Request:
Fetches the website content.

✅ HTML Cleaner (Code Node):
Strips out styles, tags, and whitespace to get clean text.

✅ Topic Extractor (AI Agent + GPT-4o-mini):
Extracts topic-wise information from the cleaned website content.

✅ Text Cleaner (Code Node):
Removes unwanted symbols like ### and **.

✅ Keyword Extractor (AI Agent + GPT-4o-mini):
Generates a list of 90 important SEO keywords.

✅ Airtable Upsert:
Stores the cleaned data, keywords, and status in Airtable.

---

4. Key Features

✅ Automatic website content scraping
✅ Clean HTML and extract plain text
✅ Use GPT-4o-mini for topic-wise information extraction
✅ Generate 90-keyword SEO lists
✅ Store and manage data in Airtable

---

5. Use Cases

• SEO Keyword Research
• Competitor Website Content Analysis
• Structured Website Data Collection

---

Additional Workflow Recommendations

✅ Rename Nodes for Clarity

Current Name

Suggested Name

Website Name

Website URL Input Form

HTTP Request

Fetch Website Content

Code

HTML to Plain Text Cleaner

Split Out1

Clean Text Splitter

AI Agent1

Topic Extractor (GPT-4o-mini)

Code1

Text Cleanup Formatter

Split Out2

Final Text Splitter

AI Agent

Keyword Extractor (GPT-4o-mini)

Airtable

Airtable Data Upsert

Wait1

Delay Before Merge

Merge

Combine Data for Airtable

---