Cluster webpage topics from Google Sheets to Google Sheets for AI discovery

Description

📊 Description
Streamline AI-focused SEO research by automatically analyzing URLs stored in Google Sheets, extracting semantic signals from each webpage, and generating high-quality topic clusters for AI discovery. 🤖🔍 This automation fetches URLs weekly, scrapes headings (H1–H6), extracts entities, keywords, topics, and summaries using GPT-4o-mini, and classifies each page into clusters and subclusters optimized for LLM search visibility. It also generates internal linking suggestions for better topical authority and writes all results back into Google Sheets. Perfect for content strategists, SEO teams, and AI-search optimization workflows. 📈🧩

🔁 What This Template Does
1️⃣ Triggers weekly to process URLs stored in Google Sheets. 📅
2️⃣ Fetches all URL records from the configured sheet. 📥
3️⃣ Processes URLs in batches to avoid API overload. 🔁
4️⃣ Extracts webpage HTML and pulls semantic headings (H1–H6). 📰
5️⃣ Sends headings + URL context to GPT-4o-mini for structured extraction of:
— title
— entities
— keywords
— topics
— summary
6️⃣ Generates high-level cluster + subcluster labels for each page. 🧠
7️⃣ Recommends 3–5 internal linking URLs to strengthen topical authority. 🔗
8️⃣ Updates Google Sheets with all extracted fields + status flags. 📊
9️⃣ Repeats the process until all URLs are analyzed. 🔄

⭐ Key Benefits
✅ Automates topical clustering for AI search optimization
✅ Extracts entities, keywords, and topics with high semantic accuracy
✅ Strengthens internal linking strategies using AI suggestions
✅ Eliminates manual scraping and analysis work
✅ Enables scalable content audits for large URL datasets
✅ Enhances visibility in AI-driven search systems and answer engines

🧩 Features
Google Sheets integration for input + output
HTML parsing for H1–H6 extraction
GPT-4o-mini structured JSON extraction
Topic clustering engine (cluster & subcluster classification)
Internal linking recommendation generator
Batch processing for large URL datasets
Status-based updating in Google Sheets

🔐 Requirements
Google Sheets OAuth2 credentials
OpenAI API key (GPT-4o-mini)
Publicly accessible URLs (or authenticated HTML if applicable)
n8n with LangChain nodes enabled

🎯 Target Audience
SEO teams performing semantic clustering at scale
Content strategists creating AI-ready topic maps
Agencies optimizing large client URL collections
AI-search consultants building structured content libraries
Technical marketers needing automated content analysis