Keyword Research Workflow

Scale your keyword research with AI-powered analysis

What you’ll build

A workflow that automates keyword research by fetching data from multiple sources, analyzing search intent with AI, and organizing results for content planning.

Time to build: 20 minutes

Nodes used: Semrush, YourTextGuru, LLM, Google Sheets

The problem

Traditional keyword research is slow:

• Manually checking tools like Semrush, Ahrefs
• Analyzing search intent for each keyword
• Categorizing and prioritizing hundreds of keywords
• Creating content briefs from keyword data

This workflow does it all automatically.

Workflow overview

graph LR
    A[Seed Keywords] --> B[Semrush Expand]
    B --> C[Loop Keywords]
    C --> D[YourTextGuru]
    D --> E[LLM Intent Analysis]
    E --> F[Google Sheets]

Step-by-step guide

Step 1: Define your seed keywords

Start with a list of seed keywords in Google Sheets:

Step 2: Create the workflow

1. Click New Workflow
2. Name it “Keyword Research”

Step 3: Fetch seed keywords

Step 4: Expand keywords with Semrush

Step 5: Get content optimization data

Step 6: Analyze search intent with AI

Analyze this keyword for search intent and content planning.

Keyword: {{Loop_0.currentItem.keyword}}
Search Volume: {{Semrush_0.volume}}
Difficulty: {{Semrush_0.difficulty}}
Related Keywords: {{Semrush_0.relatedKeywords}}

Provide:
1. Search Intent (informational, navigational, commercial, transactional)
2. Content Type Recommendation (blog post, landing page, guide, etc.)
3. Suggested Title
4. Key Topics to Cover (5-7 points)
5. Target Word Count
6. Priority Score (1-10 based on volume vs difficulty)

Format as JSON.

Step 7: Save to Google Sheets

Sample output

Advanced options

Competitor keyword gap analysis

Find keywords your competitors rank for but you don’t:

graph LR
    A[Your Domain] --> C[Gap Analysis]
    B[Competitor Domains] --> C
    C --> D[Missing Keywords]
    D --> E[Prioritized List]

Add a Semrush Domain Keywords node:

Your keywords: {{Semrush_0.yourKeywords}}
Competitor keywords: {{Semrush_1.competitorKeywords}}
Gap: Filter keywords in competitor but not in yours

SERP feature analysis

Identify keywords with featured snippets, PAA, etc.:

Add to LLM prompt:

SERP Features: {{Semrush_0.serpFeatures}}

Also analyze:
- Featured snippet opportunity (yes/no)
- People Also Ask opportunity
- Recommended content format for snippets

Content clustering

Group related keywords into topic clusters:

Add a second LLM node:

Given these keywords: {{allKeywords}}

Group them into topical clusters where:
- Each cluster has a pillar topic
- Supporting keywords are related subtopics
- Suggest internal linking structure

Output as:
{
  "clusters": [
    {
      "pillar": "SEO Guide",
      "keywords": ["seo basics", "seo tips", "seo strategy"],
      "suggested_links": [...]
    }
  ]
}

Best practices

Filter by search intent

Focus your workflow based on goals:

Balance volume and difficulty

Use the AI priority score, or create your own formula:

Priority = (Volume / 1000) * (100 - Difficulty) / 10

Validate with real SERPs

Add a Serper node to check actual search results:

Serper → Analyze top 10 results
       → Confirm AI intent analysis
       → Identify content gaps

Results you can expect

Template workflow

Use our pre-built keyword research template:

Next steps