Crawl websites & answer questions with GPT-5 nano and Google Sheets
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 33 nodes and runs when a chat message arrives. Along the way it connects OpenAI Chat Model, Google Sheets, OpenAI and HTTP Request.
How it runs
Trigger: When a chat message arrives.
- Get data schema (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 2 tools (HTTP Request, Get row(s) in sheet in Google Sheets); memory: Simple Memory
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Respond to Chat (Chat): uses Chat
- If: checks a condition and branches into true / false
- OPTIONS (Edit Fields (Set)): sets 4 fields: scan_pages, scan_posts, category…
- Respond to Chat (Chat): uses Chat
- UA Rotativo (Code): runs custom JavaScript code
- Req robots (HTTP Request): calls an HTTP API
…plus 15 more steps. 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 (19)
- AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - XML
n8n-nodes-base.xml - Code
n8n-nodes-base.code - Stop and Error
n8n-nodes-base.stopAndError - Edit Fields (Set)
n8n-nodes-base.set - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Chat
@n8n/n8n-nodes-langchain.chat - OpenAI
@n8n/n8n-nodes-langchain.openAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Http Request Tool
n8n-nodes-base.httpRequestTool - Split Out
n8n-nodes-base.splitOut - Markdown
n8n-nodes-base.markdown
From the author
Web Consultation & Crawling Chatbot with Google Sheets Memory Who is this workflow for? This workflow is designed for SEO analysts, content creators, marketing agencies, and developers who need to index a website and then interact with its content as if it…