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:

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