✨ Seo keyword analysis and filter
⚡ 781 views · ✨ AI & LLMs
💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.
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
🔗 Nodes Used
Google Sheets, Google Drive, Filter, OpenAI Chat Model, Extract from File, Text Classifier
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File