Website content scraper & SEO keyword extractor with GPT-5-mini and Airtable

This workflow allows you to scrape website content, clean the HTML, extract structured information using GPT-5-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-5-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-5-mini): Extracts topic-wise information from the cleaned website content.

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

✅ Keyword Extractor (AI Agent + GPT-5-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-5-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