Comprehensive SEO keyword research with OpenAI & DataForSEO analytics to NocoDB

AI-Powered SEO Keyword Research Workflow with n8n > automates comprehensive keyword research for content creation !Workflow Overview Table of Contents 1. Introduction(introduction) 2. Workflow Architecture(workflow-architecture) 3. NocoDB Integration(nocodb-integration) 4. Data Flow(data-flow) 5. Core Components(core-components) 6. Setup Requirements(setup-requirements) 7. Possible Improvements(possible-improvements) Introduction This n8n workflow automates SEO keyword research using AI and data-driven analytics. It combines OpenAI's language models with DataForSEO's analytics to generate comprehensive keyword strategies for content creation. The workflow is triggered by a webhook from NocoDB, processes the input data through multiple stages, and returns a detailed content brief with optimized keywords. Workflow Architecture The workflow follows a structured process: 1. Input Collection: Receives data via webhook from NocoDB 2. Topic Expansion: Generates keywords using AI 3. Keyword Metrics Analysis: Gathers search volume, CPC, and difficulty metrics 4. Competitor Analysis: Analyzes competitor content for ranking keywords 5. Final Strategy Creation: Combines all data to generate a comprehensive keyword strategy 6. Output Storage: Saves results back to NocoDB and sends notifications NocoDB Integration Database Structure The workflow integrates with two tables in NocoDB: Input Table Schema This table collects the input parameters for the keyword research: | Field Name | Type | Description | | --------------- | ------------- | --------------------------------------------------------------------------- | | ID | Auto Number | Unique identifier | | Primary Topic | Text | The main keyword/topic to research | | Competitor URLs | Text | Comma-separated list of competitor websites | | Target Audience | Single Select | Description of the target audience (Solopreneurs, Marketing Managers, etc.) | | Content Type | Single Select | Type of content (Blog, Product page, etc.) | | Location | Single Select | Target geographic location | | Language | Single Select | Target language for keywords | | Status | Single Select | Workflow status (Pending, Started, Done) | | Start Research | Checkbox | Active Workflow when you set this to true | !Input Table Screenshot Output Table Schema This table stores the generated keyword strategy: | Field Name | Type | Description | | ------------------ | ----------- | ------------------------------------------------ | | ID | Auto Number | Unique identifier | | primarytopicused | Text | The topic that was researched | | reportcontent | Long Text | The complete keyword strategy in Markdown format | | generatedAt | Datetime | Automatically generated by NocoDb | !Output Table Screenshot Webhook Settings NocoDB Webhook Settings !Webhook Settings Data Flow The workflow handles data in the following sequence: 1. Webhook Trigger: Receives input from NocoDB when a new keyword research request is created !Start Slack Notification 2. Field Extraction: Extracts primary topic, competitor URLs, audience, and other parameters 3. AI Topic Expansion: Uses OpenAI to generate related keywords, categorized by type and intent 4. Keyword Analysis: Sends primary keywords to DataForSEO to get search volume, CPC, and difficulty 5. Competitor Research: Analyzes competitor pages to identify their keyword rankings 6. Strategy Generation: Combines all data to create a comprehensive keyword strategy 7. Storage & Notification: Saves the strategy to NocoDB and sends a notification to Slack Core Components 1. Topic Expansion This component uses OpenAI and a structured output parser to generate: - 20 primary keywords - 30 long-tail keywords with search intent - 15 question-based keywords - 10 related topics 2. DataForSEO Integration Two API endpoints are used: - Search Volume & CPC: Gets monthly search volume and cost-per-click data - Keyword Difficulty: Evaluates how difficult it would be to rank for each keyword 3. Competitor Analysis This c