n8n Workflow: Comprehensive SEO Keyword Research & Analysis

This n8n workflow automates a comprehensive SEO keyword research and analysis process, leveraging an external API (likely DataForSEO based on the directory name, though the JSON only shows a generic HTTP Request node) and Airtable for data management. It's designed to streamline the collection, processing, and storage of keyword data, making it easier to identify valuable SEO opportunities.

What it does

This workflow performs the following key steps:

1. Triggers on Webhook: The workflow starts when it receives an HTTP POST request to its webhook URL. This allows for flexible integration with other systems or manual triggering.
2. Makes an API Request: It then makes an HTTP request to an external API. This is where the keyword research data (e.g., search volume, CPC, competition) would be fetched.
3. Processes API Response: The data received from the API is then processed.
4. Splits Out Items: It splits the incoming data into individual items, likely for each keyword or data point received from the API.
5. Filters Data: The workflow applies a filter to the processed data, allowing you to include or exclude items based on specific conditions. This is crucial for refining your keyword list.
6. Edits/Sets Fields: It modifies or adds new fields to the data items. This step is used to structure the data appropriately before sending it to Airtable.
7. Saves to Airtable: Finally, the processed and filtered keyword data is saved to an Airtable base, providing a centralized and organized repository for your SEO research.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• Airtable Account: An Airtable account with an existing base and table configured to store your keyword data.
• API Key/Credentials for Keyword Research Tool: Credentials for the external API used for keyword research (e.g., DataForSEO, SEMrush, Ahrefs). The current workflow uses a generic HTTP Request node, so you'll need to configure this with your chosen service's API endpoint and authentication.

Setup/Usage

1. Import the Workflow:

   • Download the provided JSON file for this workflow.
   • In your n8n instance, click on "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the JSON content or upload the file.

2. Configure Credentials:

   • Airtable Node:
     • Click on the "Airtable" node.
     • Under "Credentials", select an existing Airtable credential or click "Create New" to add your Airtable API Key.
     • Enter the "Base ID" and "Table Name" where you want to store the keyword data.
   • HTTP Request Node:
     • Click on the "HTTP Request" node.
     • Configure the "URL" for your chosen keyword research API.
     • Set the "Method" (e.g., GET, POST).
     • Add any necessary "Headers" (e.g., Content-Type, Authorization with your API key).
     • Configure the "Body" with the parameters for your API request (e.g., keywords to search).

3. Configure Edit Fields Node:

   • Adjust the "Edit Fields" node to map the data received from the HTTP Request node to the desired field names in your Airtable table.

4. Configure Filter Node:

   • Modify the "Filter" node to define your specific conditions for including or excluding keyword data. For example, you might filter by minimum search volume, maximum CPC, or specific keyword phrases.

5. Activate the Workflow:

   • Once all credentials and configurations are set, click the "Activate" toggle in the top right corner of the workflow editor to enable it.

6. Trigger the Workflow:

   • Copy the "Webhook URL" from the "Webhook" node.
   • Send an HTTP POST request to this URL to initiate the workflow. The body of this request can contain any initial data you want to pass into the workflow, though for this specific setup, the primary input will come from the HTTP Request node's configuration.