AI-powered SEO content optimization with SERP analysis & Slack approval workflow
Needs changesWhat this workflow does
This AI workflow has 14 nodes and runs when a chat message arrives. Along the way it connects Google Sheets, OpenAI Chat Model, SerpApi (Google Search) and Slack and 2 more.
How it runs
Trigger: When a chat message arrives.
- Set Input Parameters (Edit Fields (Set)): sets 4 fields: intent, topic, content…
- AI Content Optimization Agent (AI Agent): runs an AI agent, with model: OpenAI GPT-4o Mini Model; 3 tools (SerpAPI Competitor Analysis, Query Company Knowledge Base, Retrieve Context from Google Sheets); memory: Short-Term Memory; output parser: Enforce JSON Output Structure
- Save Approved Draft to Sheet (Google Sheets): append or update
- Request Human Approval via Slack (Slack): send and wait for a reply
- Check Human Approval Status (If): checks a condition and branches into true / false
- Send Success Notification to Slack (Slack): uses Slack
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- SerpApi (Google Search) in SerpAPI Competitor Analysis: no direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| SerpApi (Google Search) SerpAPI Competitor Analysis | No direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node |
Nodes used (13)
- Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - SerpApi (Google Search)
@n8n/n8n-nodes-langchain.toolSerpApi - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi
From the author
📊 Description Enhance content quality, SEO performance, and editorial consistency using an AI-powered optimization engine that blends OpenAI, Google Sheets history, Pinecone knowledge, and real-time SERP intelligence. This workflow transforms rough drafts…