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.
-
-
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.
-
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.
-
Detect Content Cannibalization at Scale with Vector Embeddings: A Python and n8n Pipeline
Spreadsheets break past a few hundred URLs. Use OpenAI embeddings, Search Console overlap, and an n8n workflow to flag cannibalization across thousands of pages, score severity, and pre-classify each pair as merge, differentiate, or canonical.
-
Generative Engine Optimization (GEO): A Practitioner’s Playbook for Getting Cited by ChatGPT and AI Overviews
A working playbook for getting cited by ChatGPT, Perplexity, and Google AI Overviews — structural patterns that win, plus a five-job automation stack you can ship this week.
-
Agentic SEO with Claude Code: Build an Autonomous Technical Auditor That Files Its Own GitHub Issues
A teardown of an agentic SEO auditor built on Claude Code that crawls, diffs against history, and files engineering-ready GitHub issues — including architecture, the agent prompt that worked, and eight weeks of real ticket data.
-
How to Track Brand Visibility in ChatGPT and Google AI Overviews with Python and n8n
A working Python + n8n pipeline that polls four AI surfaces every morning, scores brand mentions and citations, and pushes a daily delta report to Slack and Google Sheets. Includes the asyncio orchestrator, z-score anomaly detection SQL, and operational cost notes from three months in production.
-
Automated Competitor Content Gap Analysis: A Python Workflow Using Search Console and Common Crawl
A Python pipeline that combines Google Search Console with Common Crawl to refresh a competitor content gap report weekly, with priority scoring and the failure modes you will hit in production.
