Skip to main content

Comprehensive SEO keyword research & analysis with DataForSEO and Airtable

Workflow preview

Workflow preview
100%
Comprehensive SEO keyword research & analysis with DataForSEO and Airtable preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Premium n8n Workflow: DataForSEO + Airtable Keyword Research This premium n8n workflow harnesses the power of DataForSEO's API combined with Airtable's relational database capabilities to transform...

Best for

  • Content Creation automation workflows
  • Market Research automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.stickynote, n8n-nodes-base.httprequest, n8n-nodes-base.airtable, n8n-nodes-base.splitout, n8n-nodes-base.set, n8n-nodes-base.filter, n8n-nodes-base.webhook

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Gloria.

Original n8n.io source

1.1 Workflow description

Title
Comprehensive SEO keyword research & analysis with DataForSEO and Airtable
Workflow name
Comprehensive SEO keyword research & analysis with DataForSEO and Airtable

Premium n8n Workflow: DataForSEO + Airtable Keyword Research

This premium n8n workflow harnesses the power of DataForSEO's API combined with Airtable's relational database capabilities to transform your keyword research process, providing deeper insights for content creation without the hefty price tag of traditional SEO tools.


πŸš€ Features

πŸ” Comprehensive Data

Extracts related keywords, search volume πŸ“ˆ, keyword difficulty πŸ“Š, search intent πŸ€”, and more directly from DataForSEO's powerful API πŸš€.

πŸ’° Cost-Effective

Leverages DataForSEO's pay-as-you-go model πŸ’Έ, making it budget-friendly.

πŸ—οΈ Airtable Integration

Organizes your data in a powerful relational database for advanced filtering, sorting, and visualization capabilities.

πŸ”„ Cross-Reference Capabilities

Create relationships between keyword sets to identify content opportunities traditional tools miss.

πŸ€– Fully Automated

Set up once and run keyword research with a single click.

βš™οΈ Efficient & Scalable

Handles large keyword lists with Airtable's robust data management system.


πŸ‘₯ This Workflow is Perfect For:

  • Content creators πŸ“
  • Bloggers πŸ’»
  • YouTubers πŸŽ₯
  • Small business owners πŸ’Ό
  • Digital marketers πŸ“Š
  • SEO professionals πŸ”
  • Entrepreneurs πŸš€
  • E-Commerce website owners πŸ’»

Stop overspending on expensive SEO tools and start generating actionable keyword insights with a professional-grade database.


πŸ“ What's Included?

βš™οΈ n8n Workflow Template

Ready-to-use workflow with pre-configured DataForSEO API endpoints for comprehensive keyword data collection.

πŸ“Š Airtable Database Structure

Pre-built tables and fields specifically designed for SEO keyword analysis.

πŸ”Œ DataForSEO Integration

Complete setup for pulling multiple data types (related keywords, suggestions, people also ask, subtopics) from DataForSEO's API.

πŸ”„ Automated Data Processing

Logic to clean, format, and structure raw API data into usable insights.

πŸ“‹ Documentation

Step-by-step instructions for connecting your DataForSEO account and configuring the workflow.


πŸ† Why Choose the Airtable Version?

  • πŸ“± Access Anywhere: Review your keyword research on any device through Airtable's apps.
  • 🀝 Team Collaboration: Share your keyword database for collaborative planning.
  • πŸ”„ Data Relationships: Connect keywords, content ideas, and publishing schedules in one place.
  • πŸ”Œ Extensibility: Integrate with other tools via Airtable's ecosystem.
  • 🎯 Content Planning: Use Airtable as a complete content management system, from research to publication tracking.

πŸ› οΈ How It Works

1️⃣ Import the provided n8n workflow into your n8n instance πŸ“₯.
2️⃣ Configure your DataForSEO API credentials and Airtable connections βš™οΈ.
3️⃣ Input your target keywords and desired parameters πŸ“.
4️⃣ Trigger the workflow β€” n8n automatically gathers and organizes your keyword research in Airtable πŸ€–.
5️⃣ Use Airtable’s interface to analyze relationships, identify opportunities, and plan your strategy πŸ“Š.

Additional detailed instructions are provided in the workflow.


🏁 What You Need to Get Started

  • πŸ”Ή Access to n8n (self-hosted or cloud) ☁️
  • πŸ”Ή A DataForSEO account with API credentials πŸ”‘
  • πŸ”Ή An Airtable account (free tier works, Pro recommended for advanced features) πŸ“Š
  • πŸ”Ή Basic understanding of API usage and n8n workflows 🧠

πŸ’‘ You can also connect this workflow with my SEO-Based Keyword Categorization & Clustering Strategy Workflow with Airtable and my Multi-Agent SEO Optimized Blog Writing System with Hyperlinks for E-Commerce, both available on my profile, to build a fully automated, end-to-end SEO content machine.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 2 - Related API Request

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 3 - Get Primary Keyword

Type / Role
n8n-nodes-base.airtable - airtable
Config choices
Version 2.1

Block 4 - Split Out Result Items

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 5 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - KW Suggestions API Request

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 7 - Split Out Suggested KWs

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 8 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - KW Ideas API Request

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 10 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 11 - Split Out Autocomplete

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 12 - Sticky Note4

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 13 - Serp API Request1

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 14 - Autocomplete API Request

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 15 - Split Out SERP

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 16 - Create SERPS

Type / Role
n8n-nodes-base.airtable - airtable
Config choices
Version 2.1

Block 17 - Split Out People Also Ask

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 18 - Sticky Note5

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 19 - Generate Subtopics API Request

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 20 - Split Out Subtopics

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 21 - Sticky Note6

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 22 - Set Fields for API Request

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 23 - Set KW Suggestion Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 24 - Set KW Related Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Showing the first 24 of 49 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Comprehensive SEO keyword research & analysis with DataForSEO and Airtable
Complexity advanced
Nodes 49
Categories Content Creation, Market Research
Author Gloria
Published 18 Sept 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/8722/8722.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Comprehensive SEO keyword research & analysis with DataForSEO and Airtable do?

Premium n8n Workflow: DataForSEO + Airtable Keyword Research This premium n8n workflow harnesses the power of DataForSEO's API combined with Airtable's relational database capabilities to transform...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Market Research use case.