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

This n8n workflow streamlines SEO research by scraping website content via a form-triggered URL input, fetching HTML with HTTP Request, and cleaning it in a Code node to remove styles, tags, and excess whitespace for plain text extraction.

Next, it leverages GPT-4o-mini through AI Agents to extract topic-wise structured information and generate a comprehensive list of 90 high-value SEO keywords. Additional cleaning ensures data quality by stripping markdown symbols like ### and **.

Finally, results including website details, cleaned content, keywords, and status are upserted into Airtable for easy management. Benefits include massive time savings on manual scraping and keyword research, scalable SEO data organization, and integration of AI for precise extractions.

Ideal use cases: Building keyword databases for content marketing, competitor analysis, auditing site topics, or automating lead generation from web sources. Requires OpenAI API and Airtable setup for seamless operation.