Automate Keyword Clustering at Scale: From a Raw Export to Content Topics with Embeddings + HDBSCAN
A working Python + n8n pipeline that groups thousands of keywords into content topics by intent using embeddings, UMAP and HDBSCAN.
-
-
The Hidden Signature That Triggers Google’s Helpful Content Penalty (And It’s Not What You Think)
A 1,200-post site lost 99.6% of its traffic in a single day despite averaging 1,250+ words per post. The reason is not depth — it is signature similarity at scale. Here is what Google’s classifier is actually reading.
-
How to Automate SEO Content Briefs with Python, SERP Data, and an LLM
Build a Python pipeline that turns a target keyword into a data-grounded SEO content brief in under a minute: scrape the SERP, count what ranks, and let an LLM draft the outline from real evidence.
-
Build an MCP Server for Google Search Console: Give Claude Live SEO Data Access
Stop writing a new script for every SEO question. Build a Model Context Protocol (MCP) server that exposes Google Search Console as tools an agent can drive live — with working Python code.
-
Automate Title Tag & Meta Description Rewrites: A CTR-Driven GSC Pipeline (Python + LLM)
Build a pipeline that finds CTR-decayed pages in Search Console, rewrites their title tags and meta descriptions with an LLM, QA-gates the output, and ships the winners.
-
Embedding Models for SEO, Compared: OpenAI vs Voyage vs Cohere vs Open-Source BGE
Choosing an embedding model for SEO isn’t a leaderboard question. A practitioner’s framework for OpenAI vs Voyage vs Cohere vs BGE, with a reproducible AUC benchmark, the dimension trade-off, and the cost math at scale.
-
SEO Regression Testing in CI/CD: Block Bad SEO Before It Ships
Build an automated SEO regression testing pipeline in GitHub Actions that crawls a preview deployment, asserts SEO invariants with pytest, and fails the build before titles, canonicals, robots directives, or schema break in production.
-
Automate 301 Redirect Mapping for Site Migrations with Python and Embeddings
Build an automated 301 redirect mapper that matches old URLs to new ones by meaning with sentence embeddings, confidence thresholds, and post-launch validation.
-
Playwright vs Puppeteer vs Selenium: The SEO Engineer’s Headless Browser Showdown
Raw-HTML crawlers miss the JavaScript-rendered web. A hands-on comparison of Playwright, Puppeteer, and Selenium for SEO automation — rendering JS pages, capturing Core Web Vitals, and crawling at scale, with working code.
-
Automate Image Alt Text at Scale with a Vision LLM: A Python + n8n Pipeline
Missing alt text starves Google Image Search and multimodal AI of the one signal they need. Here is a working Python + n8n pipeline that inventories, generates with a vision LLM, quality-gates, and writes back image alt text at scale.
