AutomationMart
Home/Browse/Website content scraper & SEO keyword extractor with GPT-5-mini and Airtable
n8n

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

n8nn8n13 modulesv1.0
AirtableOpenAI

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: | Fi

At a glance

Website content scraper & SEO keyword extractor with GPT-5-mini and Airtable is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Airtable, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Airtable, OpenAI
Modules
13
Price
Free
Version
v1.0
Website content scraper & SEO keyword extractor with GPT-5-mini and Airtable workflow diagram

About this workflow

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: | 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-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 | 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-5-mini) | | Code1 | Text Cleanup Formatter | | Split Out2 | Final Text Splitter | | AI Agent | Keyword Extractor (GPT-5-mini) | | Airtable | Airtable Data Upsert | | Wait1 | Delay Before Merge | | Merge | Combine Data for Airtable | ---

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Actioning your meeting next steps using transcripts and AI

This n8n workflow demonstrates how you can summarise and automate post-meeting actions from video transcripts fed into an AI Agent. Save time between meetings by allowing AI handle the chores of organising follow-up meetings and invites. How it works This workflow scans for the calendar for client or team meetings which were held online. Attempts will be made to fetch any recorded transcripts which are then sent to the AI agent. The AI agent summarises and identifies if any follow-on meetings

Free

Convert YouTube videos into SEO blog posts using WayinVideo and GPT-4o-mini

Description Automatically convert any video URL into a fully structured, publish-ready SEO blog post using WayinVideo AI transcription, GPT-4o-mini, and Google Sheets — zero manual writing required. --- What This Workflow Does This workflow takes a single video URL and does everything for you. It transcribes the video using WayinVideo — a powerful multilingual video transcription API that accurately converts spoken content into clean, structured text — then passes that transcript to an AI Agent

Free

Personalize an introduction message with ChatGPT for new Facebook leads and store them on a Google Sheet for review

Easily tailor engaging introduction messages using ChatGPT for new Facebook leads, and organize them in a Google Sheet for easy review, ensuring effective outreach.

Free

LinkedIn post automation with AI (GPT-4o) generation & Slack approval

LinkedIn Post Automation with AI Generation (Gpt-4o) & Slack Approval How it Works ## This workflow automates the creation and publishing of LinkedIn posts with AI-generated content and human approval via Slack, using Google Sheets, OpenAI (GPT-4), Slack Interactive Messages, and the LinkedIn API. Whether you're a social media manager, content creator, or marketing professional, this workflow helps you maintain consistent LinkedIn presence and scale

Free

Generate social media posts with GPT-4 for LinkedIn, X, and Facebook

Automatically generates engaging marketing posts using OpenAI and publishes them across LinkedIn, Twitter (X), and Facebook. Creates platform-optimized content with hashtags, emojis, and proper formatting. How it works 1. Trigger — Runs daily at 10 AM or manual trigger for on-demand content 2. Generate — Creates tailored marketing content using OpenAI GPT-4 based on topic/theme 3. Optimize — Customizes content for each platform (character limits, hashtags, tone) 4. Review — Optional human approv

Free

Create a new Notion page for every new article trigger from RSS and ChatGPT

Automatically create a new Notion page for every article triggered from RSS, enriched by ChatGPT and Anthropic Claude insights, streamlining content management.

Free

Hotel receptionist with WhatsApp, Gemini model-switching, Redis & Google Sheets

Overview This project is an AI-powered hotel receptionist built using n8n, designed to handle guest queries automatically through WhatsApp. It integrates Google Gemini, Redis, MySQL, and Google Sheets via LangChain to create an intelligent conversational system that understands and answers booking-related questions in real time. A standout feature of this workflow is its AI model-switching system — it dynamically assigns users to different Gemini mo

Free

Download TikTok videos without watermarks via Telegram bot

TikTok Video Downloader (No Watermark) - Telegram Bot > Download TikTok videos instantly without watermarks via Telegram > Fast, reliable, and user-friendly automated workflow --- ✨ What This Workflow Does This powerful automation turns your Telegram bot into a TikTok video downloader. Simply send any TikTok link, and the bot will: - ✅ Validate the URL automatically - ⚡ Extract video without watermark - 📊 Display video statistics (views, likes, author) - 🚀 Send the cl

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free