Cluster webpage topics from Google Sheets to Google Sheets for AI discovery
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 21 nodes and runs on a schedule (every week). Along the way it connects Google Sheets and OpenAI Chat Model.
How it runs
Trigger: On a schedule (every week).
- Fetch URL List from Google Sheets (Google Sheets): uses Google Sheets
- Split URLs In Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch HTML from URL (HTTP Request): calls an HTTP API
- Extract Headings (H1-H6) (HTML): parses or builds HTML
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; memory: Memory Buffer; output parser: Structured JSON Parser
- Format Extracted Data (Edit Fields (Set)): sets 5 fields: title, entities, keywords…
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; memory: Memory Buffer for Clustering; output parser: Cluster JSON Parser
- Format Cluster Data (Edit Fields (Set)): sets 2 fields: cluster, subcluster
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; memory: Memory Buffer for Links; output parser: Link Suggestions JSON Parser
- Prepare Sheet Update (Edit Fields (Set)): sets 9 fields: title, entities, keywords…
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
📊 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,…