SEO Keyword Analysis and Filter

Description

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