Skip to main content

Seo keyword analysis and filter

Workflow preview

Workflow preview
100%
Seo keyword analysis and filter preview
Open on n8n.io

Important notice

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

1. Workflow Overview

Use case This workflow is designed for e commerce brands and content teams who: Need to scale SEO content production without sacrificing quality Want to eliminate manual keyword filtering (saves 10...

Best for

  • AI automation workflows
  • Marketing automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.manualtrigger, @n8n/n8n-nodes-langchain.lmchatopenai, n8n-nodes-base.googledrive, n8n-nodes-base.extractfromfile, n8n-nodes-base.aggregate, n8n-nodes-base.set, n8n-nodes-base.if, n8n-nodes-base.merge

Source and attribution

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

Original n8n.io source

1.1 Workflow description

Title
Seo keyword analysis and filter
Workflow name
Seo keyword analysis and filter

Use case This workflow is designed for e-commerce brands and content teams who:

  • Need to scale SEO content production without sacrificing quality
  • Want to eliminate manual keyword filtering (saves 10+ hours/week)
  • Aim to dominate niche search terms (e.g., "vegan leather crossbody bags")

What this workflow does Automates the end-to-end process from keyword discovery to publish-ready articles:

  • Keyword Harvesting: Pulls 1,000+ keywords/day from SEMrush/Ahrefs
  • Smart Filtering:Blocks competitor brands (e.g., "Zara alternatives")
  • Detects irrelevant demographics ("kids", "petite")
  • AI Content Generation:Flags non-compliant colors (non-black/white terms)
  • Multi-Channel Output: Formats content for blogs, product descriptions, and email campaigns

setup

  • Add Google,SEMrush and OpenAI credentials
  • Set the rules excel of google drive
  • Test workflow by testing workflow
  • Review generated opportunity report in Google Sheets

How to adjust this template

  • Change scenario: Replace the rules and define different target

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 - When clicking β€˜Test workflow’

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

Block 2 - OpenAI Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 3 - get the rule data

Type / Role
n8n-nodes-base.googleDrive - googleDrive
Config choices
Version 3

Block 4 - transform the data

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

Block 5 - data processing

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

Block 6 - add a merge field

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

Block 7 - get the keyword data

Type / Role
n8n-nodes-base.googleDrive - googleDrive
Config choices
Version 3

Block 8 - transform the data1

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

Block 9 - filter by volume and kd

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 10 - add the merge field

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

Block 11 - Merge rule and keyword

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3

Block 12 - filter the keyword by normal rule

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 13 - filter the data for deep rule

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 14 - AI Classifier

Type / Role
@n8n/n8n-nodes-langchain.textClassifier - textClassifier
Config choices
Version 1

Block 15 - Code fix the AI analysis

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 16 - Filter the right data

Type / Role
n8n-nodes-base.filter - filter
Config choices
Version 2.2

Block 17 - data formatting

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

Block 18 - Merge the filter catagory

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3

Block 19 - Merge with initial data

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3

Block 20 - output the results

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Block 21 - data processing2

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

Block 22 - Sticky Note

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

Block 23 - Sticky Note1

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

Block 24 - Sticky Note2

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

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

3. Summary Table

Workflow Seo keyword analysis and filter
Complexity advanced
Nodes 26
Categories AI, Marketing
Author Alex Huang
Published 08 Mar 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/3108/3108.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 Seo keyword analysis and filter do?

Use case This workflow is designed for e commerce brands and content teams who: Need to scale SEO content production without sacrificing quality Want to eliminate manual keyword filtering (saves 10...

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 AI, Marketing use case.