SEO Keyword Analysis and Filtering

**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 on 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 targets