Extract SEO Keywords from any Website to an Airtable Base

Automate your SEO research by scraping any website, extracting key topics and a full keyword list with AI, and saving it all neatly into Airtable.

Workflow Overview

What is this?: This workflow automates the process of web scraping and SEO analysis. It takes any website URL you provide, extracts all its textual content, and then uses an AI model to generate a comprehensive list of relevant SEO keywords, which are then neatly organized and saved into your Airtable base.
What problem does it solve?: Tired of spending hours manually copying text from competitor websites and guessing their keyword strategy? This workflow eliminates the tedious, time-consuming task of manual SEO research, ensuring you can analyze multiple sites quickly and build a powerful keyword database without the manual labor.
What will you get?: By using this template, you will be able to fully automate your content and SEO research process, save countless hours of manual data entry each week, and build a structured, queryable database of competitor insights directly within Airtable to inform your marketing strategy.

Apps Included

How to Use

Prerequisites

An active n8n instance (Cloud or self-hosted).

An Airtable account with a ready-to-use base.

An OpenAI API key with access to the 'gpt-4o-mini' model.

Setup Steps

Prepare Your Airtable Base

Create a new table in your Airtable base with the following required fields: 'Website Name' (Single line text), 'Data' (Long text), 'Keyword' (Long text), and 'Status' (Single select with options 'Todo', 'In progress', 'Done').

Configure n8n Credentials

Navigate to the 'Credentials' section in your n8n instance. Add your OpenAI API key and connect your Airtable account using a Personal Access Token.

Map the Airtable Node

Open the workflow editor and click on the 'Airtable' node. Select your credential, then choose the correct Base and Table you prepared in step 1. Map the incoming data fields from the workflow to the corresponding columns in your table.

Activate and Run the Workflow

Save and activate the workflow. Use the 'Form Trigger' to input a target website URL and click 'Submit' to run the automation and see the results appear in your Airtable base.

Pro Tips

To get higher quality or more nuanced keyword suggestions, try changing the 'OpenAI Chat Model' nodes to use a more powerful model like 'gpt-4o', but be mindful of the increased cost.

Customize the AI prompt in the 'Keyword Extractor' node to change the number of keywords generated or to ask for specific types of keywords, such as long-tail or LSI keywords.

Consider adding a notification step using a Slack or Telegram node at the end of the workflow to be alerted every time a new website has been successfully analyzed.

Back

Information

Published date8/11/2025
Last updated8/11/2025