January 22, 2026

Google Sheets + Slack: review-ready SEO drafts

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

SEO drafts don’t die because the writer is “bad.” They die in the messy middle: scattered notes, unclear feedback, and five versions of the same doc floating around.

This Sheets Slack drafts automation hits content leads first. But marketing managers chasing approvals and agency operators juggling client edits feel it too. You get a cleaner review loop, fewer rewrites, and a version trail you can actually trust.

You’ll see how this workflow turns a rough draft into an SEO-upgraded version, routes it for human approval in Slack, then saves the approved draft back to Google Sheets with metadata and history intact.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets + Slack: review-ready SEO drafts

Click to explore

flowchart LR

    subgraph sg0["Chat Workflow Flow"]
        direction LR
        n0@{ icon: "mdi:memory", form: "rounded", label: "Short-Term Memory", pos: "b", h: 48 }
        n1@{ icon: "mdi:robot", form: "rounded", label: "Enforce JSON Output Structure", pos: "b", h: 48 }
        n2@{ icon: "mdi:database", form: "rounded", label: "Retrieve Context from Google..", pos: "b", h: 48 }
        n3@{ icon: "mdi:database", form: "rounded", label: "Save Approved Draft to Sheet", pos: "b", h: 48 }
        n4@{ icon: "mdi:brain", form: "rounded", label: "OpenAI GPT-4o Mini Model", pos: "b", h: 48 }
        n5@{ icon: "mdi:robot", form: "rounded", label: "AI Content Optimization Agent", pos: "b", h: 48 }
        n6@{ icon: "mdi:swap-vertical", form: "rounded", label: "Set Input Parameters", pos: "b", h: 48 }
        n7@{ icon: "mdi:wrench", form: "rounded", label: "SerpAPI Competitor Analysis", pos: "b", h: 48 }
        n8@{ icon: "mdi:play-circle", form: "rounded", label: "Chat Workflow Trigger", pos: "b", h: 48 }
        n9@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Check Human Approval Status", pos: "b", h: 48 }
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Send Success Notification to.."]
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Request Human Approval via S.."]
        n12@{ icon: "mdi:cube-outline", form: "rounded", label: "Query Company Knowledge Base", pos: "b", h: 48 }
        n13@{ icon: "mdi:vector-polygon", form: "rounded", label: "OpenAI Embeddings for Vector..", pos: "b", h: 48 }
        n0 -.-> n5
        n6 --> n5
        n8 --> n6
        n4 -.-> n5
        n9 --> n10
        n7 -.-> n5
        n12 -.-> n5
        n5 --> n3
        n5 --> n11
        n1 -.-> n5
        n11 --> n9
        n13 -.-> n12
        n2 -.-> n5
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n8 trigger
    class n1,n5 ai
    class n4 aiModel
    class n7 ai
    class n0 ai
    class n12 ai
    class n13 ai
    class n9 decision
    class n2,n3 database
    classDef customIcon fill:none,stroke:none
    class n10,n11 customIcon

The Problem: SEO drafts get stuck in rewrite hell

Most “SEO editing” is really rework caused by missing context. A writer submits a draft without past versions, the reviewer asks for changes that already happened last month, and someone else drops competitor headings into Slack with no source. Then you try to merge all of it back into one document. It’s slow, mentally exhausting, and honestly a little demoralizing. And because nothing is versioned cleanly, you can’t easily answer basic questions like “What changed?” or “Which meta description did we approve?”

The friction compounds. Here’s where it breaks down in real teams.

Drafts bounce between tools, so reviewers never see the same “current” version.
SEO improvements get applied inconsistently because the team forgets what worked in earlier posts.
Competitor insights are gathered ad hoc, which means you miss patterns in headings, intent, and FAQs.
Approvals happen in DMs or threads, so you lose an audit trail the second someone is OOO.

The Solution: AI-optimized drafts with Slack approval + Sheets versioning

This workflow starts when you trigger an optimization (via n8n chat or a manual run) and pass in a topic, content ID, and a few preferences like tone or target keywords. It pulls your existing context first, including prior versions from Google Sheets and company knowledge from a Pinecone vector index, so the rewrite stays consistent with your brand and avoids repeating old mistakes. Next, it gathers real SERP intelligence using SerpAPI, so the draft reflects what’s ranking right now, not what someone “thinks Google wants.” Then an OpenAI-powered agent rewrites the content without starting from scratch, improving structure, clarity, and keyword coverage while preserving the original meaning. Finally, it sends the improved draft to Slack for a human approve/reject decision and, once approved, writes a new version back to Google Sheets with SEO metadata and a clean history.

The workflow kicks off from a chat-based trigger, then merges three inputs: your draft + your internal context + competitor SERP signals. After the Slack review gate, the approved draft is saved in Sheets and a success message posts back into Slack.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It pulls previous draft versions from Google Sheets so edits have context.
It retrieves brand and product knowledge from Pinecone to keep tone consistent.
It fetches competitor headings, snippets, and PAA questions via SerpAPI.
It routes the upgraded draft to Slack and waits for approval before saving.

Most teams save about 2–4 hours per draft on research, cleanup, and rewrites.
Reviews get faster because the draft arrives with sources and structure already improved.
You stop losing “final” versions since every approval creates a new row/version in Sheets.
SEO updates become repeatable, not dependent on one editor’s personal checklist.
You get clearer accountability because Slack decisions map to a stored, approved version.

Example: What This Looks Like

Say your team refreshes 5 existing blog posts a week. Manually, a typical update might take about 45 minutes to pull the old version, another hour to scan SERPs and competitor headings, then 30 minutes of back-and-forth to get approval in Slack or email. Call it roughly 2–3 hours per post. With this workflow, you trigger the run in a minute or two, let the SERP + rewrite processing happen in the background (often around 10–20 minutes), then approve in Slack and have the new version saved to Google Sheets automatically. That’s usually a couple hours back per post, without sacrificing review quality.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for draft versions and metadata storage
Slack to run approvals and send confirmations
OpenAI API key (get it from your OpenAI dashboard)
SerpAPI key (get it from your SerpAPI account settings)
Pinecone API key (get it from the Pinecone console)

Skill level: Intermediate. You’ll connect accounts, paste a few IDs (sheet, channel), and do a basic test run to confirm outputs.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A chat trigger starts the run. You kick things off by sending a topic/content ID (and any preferences) through the workflow’s chat entry trigger, or by running it manually when you’re testing.

Context gets collected before anything is rewritten. The workflow pulls prior versions from Google Sheets and retrieves relevant internal knowledge from Pinecone, which means the AI has your history and brand facts up front.

SERP intelligence is blended in. It calls SerpAPI to collect competitor signals like headings, snippets, and “People Also Ask” questions, then merges those insights into the optimization request.

The draft is rewritten and held for human approval. An OpenAI agent (GPT-4o-mini) produces a structured JSON output (title, meta, sections, keywords), then sends the upgraded draft to Slack and waits for approve/reject.

Approved versions land back in Sheets. Once approved, the workflow writes a new version row to your Google Sheets “content_versions” sheet and posts a Slack confirmation. You can easily modify the approval rules and where versions are stored based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Chat Trigger

Set up the incoming chat entry that starts the workflow and routes data to the input preparation step.

Add the Chat Entry Trigger node to your workflow.
Keep Options empty unless you need custom chat handling.
Connect Chat Entry Trigger to Define Input Fields.

Step 2: Connect Google Sheets

Provide context for optimization and store approved drafts in your content versioning sheet.

Open Fetch Sheet Context and set Document ID to [Your Google Sheet ID] and Sheet Name to content_versions.
Credential Required: Connect your Google Sheets credentials (add credentials to SEO Optimization Agent because Fetch Sheet Context is an AI tool).
Open Write Approved Draft and confirm Operation is appendOrUpdate.
Set Matching Columns to content_id and keep Mapping Mode as defineBelow.
Map key fields such as topic to {{ $json.output.optimized_draft.title }}, meta_desc to {{ $json.output.optimized_draft.meta_description }}, and version_id to {{ $json.output.metadata.version_id }}.
Credential Required: Connect your Google Sheets credentials for Write Approved Draft.

Step 3: Set Up the Processing and AI Nodes

Define inputs, configure the AI agent, and attach the AI tools, memory, and output parser.

In Define Input Fields, add assignments for intent to optimize, topic to AI SEO basics, content to C001, and parameter to {}.
Connect Define Input Fields to SEO Optimization Agent.
In OpenAI Mini Chat Model, set Model to gpt-4o-mini and connect it to SEO Optimization Agent as the language model.
Credential Required: Connect your OpenAI credentials for OpenAI Mini Chat Model.
In SEO Optimization Agent, set Text to =Topic: {{ $json.topic }} Intent: {{ $json.intent }} Content ID: {{ $json.content }} Optimization Goal: {{ $json.parameter.goal || 'Improve SEO, tone, and readability' }} Focus Keywords: {{ $json.parameter.focus_keywords ? $json.parameter.focus_keywords.join(', ') : 'N/A' }} Context (from Sheets or memory): {{ $json.context || $memory || 'No context found' }} Using the content retrieved from Sheets, optimize the article to follow the tone and outline guidelines. Ensure it aligns with the optimization goal while maintaining factual accuracy and original intent. Return the optimized article in structured JSON format..
Attach Structured Output Guard as the output parser and keep the JSON schema example as provided.
Attach Session Buffer Memory and keep Session Key as optimize-writer-session with Context Window Length set to 7.
Add tools to SEO Optimization Agent: Fetch Sheet Context, SERP Competitor Insights, and Lookup Knowledge Base.
Credential Required: Connect your SerpAPI credentials on SEO Optimization Agent for SERP Competitor Insights.
Credential Required: Connect your Pinecone credentials on SEO Optimization Agent for Lookup Knowledge Base.
In Lookup Knowledge Base, confirm Mode is retrieve-as-tool, Top K is 5, and Pinecone Index is whatsappchatbot.
Connect Vector Embeddings Builder as the embedding provider for Lookup Knowledge Base and keep Dimensions set to 512.
Credential Required: Connect your OpenAI credentials on Lookup Knowledge Base because Vector Embeddings Builder is an AI sub-node.

⚠️ Common Pitfall: If the AI tools are not connected as AI Tool/Memory/Output Parser links, SEO Optimization Agent will not receive context or structured output.

Step 4: Configure Output and Approval Routing

Send the optimized draft for approval, gate the approval decision, and deliver success notifications.

Confirm the parallel output from SEO Optimization Agent: SEO Optimization Agent outputs to both Write Approved Draft and Slack Approval Request in parallel.
In Slack Approval Request, set Operation to sendAndWait and Message to =Here the Details :- Title:- {{ $json.output.optimized_draft.title }} Description:-{{ $json.output.optimized_draft.meta_description }} MetaData:-{{ $json.output.metadata }}.
Credential Required: Connect your Slack credentials for Slack Approval Request.
Connect Slack Approval Request to Approval Decision Check.
In Approval Decision Check, set the condition to equals with Left Value {{ $json.data.approved }} and Right Value true.
In Slack Success Alert, set Text to =Your {{ $('SEO Optimization Agent').item.json.output.optimized_draft.title }} has been Successfully Optimized..
Credential Required: Connect your Slack credentials for Slack Success Alert.

Tip: Use the same Slack channel ID in both Slack Approval Request and Slack Success Alert to keep approval conversations centralized.

Step 5: Test and Activate Your Workflow

Validate that chat inputs trigger optimization, approvals are captured, and results are stored.

Click Execute Workflow and send a test message to Chat Entry Trigger.
Verify Define Input Fields outputs intent, topic, and content as expected.
Confirm SEO Optimization Agent returns structured JSON matching Structured Output Guard.
Check that Slack Approval Request posts the approval message and waits for approval.
Approve the message and confirm Approval Decision Check routes to Slack Success Alert.
Open your Google Sheet to confirm Write Approved Draft appended or updated the row.
Toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials page and confirm the Google account still has access to the target spreadsheet.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Sheets Slack drafts automation?

About 30–60 minutes if your accounts and keys are ready.

Do I need coding skills to automate Sheets Slack drafts?

No. You’ll mostly connect credentials and paste in IDs for your Sheet and Slack channel.

Is n8n free to use for this Sheets Slack drafts workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI, SerpAPI, and Pinecone usage costs.

Where can I host n8n to run this Sheets Slack drafts automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Sheets Slack drafts workflow for landing pages instead of blog posts?

Yes, but you’ll want to adjust the input fields and the optimizer instructions. In n8n, update the “Define Input Fields” step to include the page type, offer, and conversion goal, then tweak the “SEO Optimization Agent” prompt to prioritize messaging, sections, and FAQs that fit a landing page. Common customizations include switching the Slack channel for approvals, storing versions in a different Google Sheet tab, and changing the structured output to include CTA variations.

Why is my Slack connection failing in this workflow?

Most of the time it’s a missing permission on the Slack bot token (chat:write is the usual culprit) or the bot not being invited to the channel you’re posting into. Double-check the channel ID too, because a renamed channel can lead to the wrong destination. If you’re using a “send and wait” approval message, make sure interactive messages are allowed in your Slack app configuration. Finally, if approvals never come back, confirm the workflow can receive the interaction callback and isn’t blocked by network rules.

How many drafts can this Sheets Slack drafts automation handle?

On a typical setup, teams run dozens of drafts per week without issues. On n8n Cloud, your limit is tied to the plan’s monthly executions, while self-hosting is mainly constrained by your server and API rate limits from OpenAI/SerpAPI. If you plan to process a big backlog, throttle runs and batch by content ID so you don’t hit external API caps.

Is this Sheets Slack drafts automation better than using Zapier or Make?

Often, yes. This workflow relies on richer logic (merging context, structured outputs, an approval wait state, and multiple AI/tools), and n8n handles that without turning every branch into a pricing upgrade. Zapier or Make can still work if you’re doing a simple “rewrite text and post to Slack” flow, but the moment you add SERP pulls, version history, and approvals, it gets awkward fast. If you want maximum control, self-hosting is also a big deal. Talk to an automation expert if you want a quick recommendation for your exact setup.

Once this is running, drafts stop feeling fragile. The workflow handles the repetitive SEO cleanup and the version trail, so your team can focus on ideas and decisions.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "e313c1879c16f3e3fff3b8a0b29ecd5b6e0617b0c95fce7c7dcf4faebdcdecec",
"templateId": null,
"templateCredsSetupCompleted": null
},
"name": "Automated SEO Draft Optimization Flow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-10832",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
50,
-20
],
"parameters": {
"color": 7,
"width": 1190,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "089a9fcd-09c2-4c8a-a3a0-0feada6b9dcb",
"name": "Session Buffer Memory",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
640,
470
],
"parameters": {
"sessionKey": "optimize-writer-session",
"sessionIdType": "customKey",
"contextWindowLength": 7
},
"typeVersion": 1.3
},
{
"id": "09eeb2cc-61d5-41ae-8ddd-a252d04cf499",
"name": "Structured Output Guard",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
800,
430
],
"parameters": {
"jsonSchemaExample": "{\n  \"optimized_draft\": {\n    \"title\": \"AI SEO Basics: How Artificial Intelligence Transforms Search Optimization\",\n    \"meta_description\": \"Discover how AI improves SEO strategies by automating keyword insights, readability, and tone optimization.\",\n    \"sections\": [\n      {\n        \"heading\": \"Introduction\",\n        \"content\": \"AI is reshaping SEO by automating keyword research and enhancing content tone to match user intent.\"\n      },\n      {\n        \"heading\": \"Benefits of AI in SEO\",\n        \"content\": \"AI tools can analyze trends, optimize tone, and generate SEO-friendly drafts faster than manual editing.\"\n      }\n    ],\n    \"word_count\": 1150,\n    \"keywords_used\": [\"AI SEO\", \"content optimization\", \"search ranking\"],\n    \"improvements\": [\"Enhanced meta description\", \"Improved readability\", \"Better keyword placement\"]\n  },\n  \"metadata\": {\n    \"content_id\": \"CNT-1701255487715\",\n    \"version_no\": 4,\n    \"version_id\": \"VER-004\",\n    \"timestamp\": 1701259999999\n  }\n}\n"
},
"typeVersion": 1.3
},
{
"id": "09c157c9-709d-4afc-8056-986a1f566320",
"name": "Fetch Sheet Context",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
520,
440
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2120745354,
"cachedResultName": "content_versions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[Your Google Sheet ID]",
"cachedResultName": "SEO Content Automation"
}
},
"typeVersion": 4.7
},
{
"id": "9ceb6f73-cd2e-4ff9-8f79-dbf9e4f8f072",
"name": "Write Approved Draft",
"type": "n8n-nodes-base.googleSheets",
"position": [
430,
380
],
"parameters": {
"columns": {
"value": {
"tone": "={{ $json.output.optimized_draft.improvements }}",
"topic": "={{ $json.output.optimized_draft.title }}",
"section": "={{ $json.output.optimized_draft.sections }}",
"keywords": "={{ $json.output.optimized_draft.keywords_used }}",
"meta_desc": "={{ $json.output.optimized_draft.meta_description }}",
"timestamp": "={{ $json.output.metadata.timestamp }}",
"content_id": "={{ $json.output.metadata.content_id }}",
"meta_title": "={{ $json.output.optimized_draft.title }}",
"version_id": "={{ $json.output.metadata.version_id }}",
"version_no": "={{ $json.output.metadata.version_no }}",
"word_count": "={{ $json.output.optimized_draft.word_count }}",
"context_used": "={{ $json.output.metadata.content_id }}"
},
"schema": [
{
"id": "content_id",
"type": "string",
"display": true,
"required": false,
"displayName": "content_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "version_no",
"type": "string",
"display": true,
"required": false,
"displayName": "version_no",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "version_id",
"type": "string",
"display": true,
"required": false,
"displayName": "version_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "topic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "meta_title",
"type": "string",
"display": true,
"required": false,
"displayName": "meta_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "meta_desc",
"type": "string",
"display": true,
"required": false,
"displayName": "meta_desc",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "outline",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "outline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keywords",
"type": "string",
"display": true,
"required": false,
"displayName": "keywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tone",
"type": "string",
"display": true,
"required": false,
"displayName": "tone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "word_count",
"type": "string",
"display": true,
"required": false,
"displayName": "word_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cta_ideas",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "cta_ideas",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "context_used",
"type": "string",
"display": true,
"required": false,
"displayName": "context_used",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "section",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "section",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"content_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2120745354,
"cachedResultName": "content_versions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[Your Google Sheet ID]",
"cachedResultName": "SEO Content Automation"
}
},
"typeVersion": 4.7
},
{
"id": "20607468-137d-4eb8-9de9-a148cce556eb",
"name": "OpenAI Mini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
640,
120
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "gpt-4o-mini"
},
"options": []
},
"typeVersion": 1.2
},
{
"id": "21b368ff-b668-46ac-8dac-d3ffbe03dc8c",
"name": "SEO Optimization Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
700,
200
],
"parameters": {
"text": "=Topic: {{ $json.topic }}\nIntent: {{ $json.intent }}\nContent ID: {{ $json.content }}\nOptimization Goal: {{ $json.parameter.goal || 'Improve SEO, tone, and readability' }}\nFocus Keywords: {{ $json.parameter.focus_keywords ? $json.parameter.focus_keywords.join(', ') : 'N/A' }}\n\nContext (from Sheets or memory): {{ $json.context || $memory || 'No context found' }}\n\nUsing the content retrieved from Sheets, optimize the article to follow the tone and outline guidelines. \nEnsure it aligns with the optimization goal while maintaining factual accuracy and original intent.\nReturn the optimized article in structured JSON format.\n",
"options": {
"systemMessage": "=You are \"Optimization Agent\", a senior content optimizer AI inside an automation system.\n\nYour job:\nImprove the provided draft WITHOUT rewriting it from scratch by using:\n1. The existing draft text from the workflow input\n2. Historical versions from Google Sheets (\"content_versions\")\n3. SERP intelligence from SerpAPI (competitors, headings, snippets, PAA, related searches)\n4. Brief or metadata passed from the previous stage\n\nYou must produce a refined, SEO-optimized, well-structured and factually consistent version of the draft.\n\n--------------------------------\n\ud83d\udcce HOW TO USE SERP DATA\n--------------------------------\nYou receive SERP data via upstream tools (SerpAPI). Use it to:\n\n- Identify missing topical sections compared to competitors.\n- Enhance keyword coverage and semantic depth.\n- Improve H2/H3 section clarity and completeness.\n- Strengthen meta description using competitor insight.\n- Suggest improvements based on PAA questions (People Also Ask).\n- Add missing angles/topics found across rankings.\n- Improve EEAT signals (expertise, trustworthiness) when relevant.\n- DO NOT output any raw SERP JSON.\n\nSERP data should influence optimization decisions, but never override the original meaning of the draft.\n\n--------------------------------\n\ud83d\udcdd OPTIMIZATION RULES\n--------------------------------\n1. **Never rewrite from scratch.** Always keep the core meaning and structure.\n2. **Preserve tone** from the original draft or brief.\n3. **Preserve factual accuracy** \u2013 no hallucinations.\n4. **Only improve**, refine, reorganize, expand, clarify, or SEO-enhance.\n5. **Use keywords naturally**, avoid keyword stuffing.\n6. **If brief or previous versions exist**, align with them.\n7. **If SERP data suggests missed content**, incorporate it softly into relevant sections.\n8. **If the draft is messy**, reorganize into sections while preserving original paragraphs as much as possible.\n9. **Never expose intermediate reasoning** or tool data.\n\n--------------------------------\n\ud83e\uddfe VERSIONING LOGIC\n--------------------------------\nUse Google Sheets context to determine versioning:\n\n- If content_id already exists:\n  - Increment version_no (ex: 2 \u2192 3)\n  - Create new version_id as \"VER-00X\"_\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.1
},
{
"id": "6708ac6e-356b-470f-82ac-5c5fd79e1fb6",
"name": "Define Input Fields",
"type": "n8n-nodes-base.set",
"position": [
920,
230
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "06b7c645-7355-413c-8dfe-29b3109eaffb",
"name": "intent",
"type": "string",
"value": "=optimize"
},
{
"id": "ac8d353d-63bb-4e4a-bc9d-03db4a75059c",
"name": "topic",
"type": "string",
"value": "=AI SEO basics"
},
{
"id": "495c9583-b542-47c5-a9ed-d03df149dfc9",
"name": "content",
"type": "string",
"value": "=C001"
},
{
"id": "69e216f5-01f7-417f-9212-9b3fe2d42489",
"name": "parameter",
"type": "object",
"value": "={}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "76e9e9bc-e342-4598-a774-a525cf5e95be",
"name": "SERP Competitor Insights",
"type": "@n8n/n8n-nodes-langchain.toolSerpApi",
"position": [
520,
140
],
"parameters": {
"options": []
},
"typeVersion": 1
},
{
"id": "ebf1039f-cb11-45d5-b10a-2eaaaf8e7e7a",
"name": "Chat Entry Trigger",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
1140,
160
],
"webhookId": "0475035d-9e46-42a9-980c-fa215beb8e40",
"parameters": {
"options": []
},
"typeVersion": 1.3
},
{
"id": "58886d1f-f68e-4c1e-a871-a3297f6338c6",
"name": "Approval Decision Check",
"type": "n8n-nodes-base.if",
"position": [
210,
120
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3c7c4382-eb2a-4fc8-9239-b0b6e212cd9c",
"operator": {
"type": "boolean",
"operation": "equals"
},
"leftValue": "={{ $json.data.approved }}",
"rightValue": true
}
]
}
},
"typeVersion": 2.2
},
{
"id": "95802a7b-0c6c-4a90-9d55-6a1e4f609764",
"name": "Slack Success Alert",
"type": "n8n-nodes-base.slack",
"position": [
50,
160
],
"webhookId": "efbcf266-598a-4839-9b33-e1bee96f4be7",
"parameters": {
"text": "=Your {{ $('SEO Optimization Agent').item.json.output.optimized_draft.title }}  has been Successfully Optimized.",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "[Your Slack Channel ID]",
"cachedResultName": "general-information"
},
"otherOptions": []
},
"typeVersion": 2.3
},
{
"id": "b6595610-3187-4459-83f8-2570a8a7952c",
"name": "Slack Approval Request",
"type": "n8n-nodes-base.slack",
"position": [
430,
80
],
"webhookId": "b1b7b91f-9fe2-41f2-bd9c-e610c63f56b4",
"parameters": {
"select": "channel",
"message": "=Here the Details :-\nTitle:- {{ $json.output.optimized_draft.title }}\nDescription:-{{ $json.output.optimized_draft.meta_description }} \n\nMetaData:-{{ $json.output.metadata }}\n",
"options": [],
"channelId": {
"__rl": true,
"mode": "list",
"value": "[Your Slack Channel ID]",
"cachedResultName": "general-information"
},
"operation": "sendAndWait"
},
"typeVersion": 2.3
},
{
"id": "4c989a89-34ef-4df8-afed-6aa9e38d9925",
"name": "Lookup Knowledge Base",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
360,
320
],
"parameters": {
"mode": "retrieve-as-tool",
"topK": 5,
"options": [],
"pineconeIndex": {
"__rl": true,
"mode": "list",
"value": "whatsappchatbot",
"cachedResultName": "whatsappchatbot"
},
"toolDescription": "Retrieve data from the Pinecone knowledge base and use it to answer user queries about the company, products, or projects in a well-structured, human-like manner"
},
"typeVersion": 1.3
},
{
"id": "61bdcc12-7c9d-4972-b469-bbbfd843988c",
"name": "Vector Embeddings Builder",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
340,
520
],
"parameters": {
"options": {
"dimensions": 512
}
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Session Buffer Memory": {
"ai_memory": [
[
{
"node": "SEO Optimization Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"Define Input Fields": {
"main": [
[
{
"node": "SEO Optimization Agent",
"type": "main",
"index": 0
}
]
]
},
"Chat Entry Trigger": {
"main": [
[
{
"node": "Define Input Fields",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Mini Chat Model": {
"ai_languageModel": [
[
{
"node": "SEO Optimization Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Approval Decision Check": {
"main": [
[
{
"node": "Slack Success Alert",
"type": "main",
"index": 0
}
]
]
},
"SERP Competitor Insights": {
"ai_tool": [
[
{
"node": "SEO Optimization Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Lookup Knowledge Base": {
"ai_tool": [
[
{
"node": "SEO Optimization Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"SEO Optimization Agent": {
"main": [
[
{
"node": "Write Approved Draft",
"type": "main",
"index": 0
},
{
"node": "Slack Approval Request",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Guard": {
"ai_outputParser": [
[
{
"node": "SEO Optimization Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Slack Approval Request": {
"main": [
[
{
"node": "Approval Decision Check",
"type": "main",
"index": 0
}
]
]
},
"Vector Embeddings Builder": {
"ai_embedding": [
[
{
"node": "Lookup Knowledge Base",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Fetch Sheet Context": {
"ai_tool": [
[
{
"node": "SEO Optimization Agent",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}