Create & publish SEO content with AI agents & Google Sheets tracking
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 62 nodes and runs when a chat message arrives. Along the way it connects Google Sheets, Gmail, Slack and OpenAI Chat Model.
How it runs
Trigger: When a chat message arrives.
- AI Agent: runs an AI agent, with model: Content Classifier Model; 3 tools (Get Data from Content Version, Get Data from Conversion Logs, Get Reference from Content Items); memory: Simple Memory; output parser: Structured Output Parser
- format data for subworkflows (Edit Fields (Set)): sets 4 fields: intent, topic, content_id…
- Intent Router (Switch): routes items into 6 branches
- Format Intent Payload (Edit Fields (Set)): sets 4 fields: intent, topic, content…
- Format Intent Payload Brief (Edit Fields (Set)): sets 4 fields: intent, topic, content…
- Format Intent Payload Draft (Edit Fields (Set)): sets 5 fields: intent, topic, content…
- Format Payload Data Optimizer (Edit Fields (Set)): sets 4 fields: intent, topic, content…
- Prepare Publishing Metadata (Edit Fields (Set)): sets 4 fields: intent, topic, content_id…
- Prepare MetaData Monitor (Edit Fields (Set)): sets 4 fields: intent, topic, content_id…
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 1 tool (Get row(s) in sheet in Google Sheets For Reference); memory: Short-Term Memory Chat Composer; output parser: Output Parser (JSON Enforcement) Chat Composer
…plus 17 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 (13)
- Respond to Webhook
n8n-nodes-base.respondToWebhook - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets
From the author
📊 Description Enhance your support, onboarding, and internal knowledge workflows with an intelligent RAG-powered chatbot that responds using live data stored in Google Sheets. 🤖📚 Built for teams that rely on structured datasets, this workflow fetches sheet…