January 22, 2026

OpenAI + Google Sheets, SEO strategy reports ready

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

SEO strategy work has a sneaky problem. The “thinking” part is valuable, but the “gather, copy, format, rewrite, reformat” part eats your week and still leaves you second-guessing what you missed.

This SEO report automation hits marketers first, honestly. But agency owners trying to standardize deliverables feel it too, and business owners get stuck paying for scattered recommendations they can’t act on. The outcome is simple: you generate a structured, professional SEO strategy and drop it straight into Google Sheets, ready to prioritize.

Below you’ll see what the workflow does, what you’ll need, and how to run it without turning your process into a science project.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: OpenAI + Google Sheets, SEO strategy reports ready

Click to explore

flowchart LR

    subgraph sg0["When chat message received Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "When chat message received", pos: "b", h: 48 }
        n1@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n2@{ icon: "mdi:wrench", form: "rounded", label: "Keyword Research Specialist", pos: "b", h: 48 }
        n3@{ icon: "mdi:wrench", form: "rounded", label: "Technical SEO Specialist", pos: "b", h: 48 }
        n4@{ icon: "mdi:wrench", form: "rounded", label: "Link Building Strategist", pos: "b", h: 48 }
        n5@{ icon: "mdi:wrench", form: "rounded", label: "SEO Analytics Specialist", pos: "b", h: 48 }
        n6@{ icon: "mdi:wrench", form: "rounded", label: "Local SEO Specialist", pos: "b", h: 48 }
        n7@{ icon: "mdi:wrench", form: "rounded", label: "SEO Content Writer", pos: "b", h: 48 }
        n8@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model1", pos: "b", h: 48 }
        n9@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model2", pos: "b", h: 48 }
        n10@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model3", pos: "b", h: 48 }
        n11@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model4", pos: "b", h: 48 }
        n12@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model5", pos: "b", h: 48 }
        n13@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model6", pos: "b", h: 48 }
        n14@{ icon: "mdi:robot", form: "rounded", label: "SEO Director Agent", pos: "b", h: 48 }
        n15@{ icon: "mdi:wrench", form: "rounded", label: "Think", pos: "b", h: 48 }
        n16@{ icon: "mdi:robot", form: "rounded", label: "Respond to Chat", pos: "b", h: 48 }
        n17@{ icon: "mdi:memory", form: "rounded", label: "Simple Memory", pos: "b", h: 48 }
        n18@{ icon: "mdi:wrench", form: "rounded", label: "SerpAPI", pos: "b", h: 48 }
        n15 -.-> n14
        n18 -.-> n14
        n17 -.-> n14
        n1 -.-> n14
        n8 -.-> n2
        n9 -.-> n3
        n10 -.-> n6
        n11 -.-> n4
        n12 -.-> n5
        n13 -.-> n7
        n7 -.-> n14
        n14 --> n16
        n6 -.-> n14
        n4 -.-> n14
        n5 -.-> n14
        n3 -.-> n14
        n0 --> n14
        n2 -.-> n14
    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 n0 trigger
    class n14,n16 ai
    class n1,n8,n9,n10,n11,n12,n13 aiModel
    class n2,n3,n4,n5,n6,n7,n15,n18 ai
    class n17 ai

The Problem: SEO Strategy Is Stuck in Tab Hell

Building an SEO strategy usually means bouncing between search results, competitor pages, keyword tools, half-finished docs, and whatever spreadsheet template you used last time. You start with good intentions, then you’re ten tabs deep and copying the same context into prompts over and over. Even worse, the “final” plan often reads like a pile of notes instead of a coordinated strategy, so priorities get debated instead of executed. That’s where time leaks out: the constant switching, the formatting, and the mental load of keeping everything consistent.

It adds up fast. Here’s where it breaks down in real teams:

Research lives in too many places, so the strategy becomes a collage instead of a plan.
Recommendations come out inconsistent, which means extra review cycles and awkward client revisions.
Live SERP context gets skipped because it’s annoying to collect, so you miss what competitors are actually doing.
Someone has to translate “smart ideas” into a spreadsheet that a team can track, and that’s usually a slow Friday afternoon.

The Solution: An AI SEO Agency That Writes the Plan Into Sheets

This workflow deploys a fully autonomous “AI SEO Agency” inside n8n. You send one prompt through a chat trigger, and a Director-style coordinator agent takes over. It pulls live search context using SerpApi (so it’s not guessing from stale training data), then delegates work to six specialists: keyword research, technical SEO, link building, analytics, local SEO, and content. Each specialist produces focused outputs, and the coordinator merges everything into one cohesive SEO strategy report. Finally, the workflow formats the strategy into structured fields and pushes it into Google Sheets (and can also work with Microsoft Excel 365).

The flow starts with your chat request in n8n. From there, the coordinator consults conversation memory, runs live SERP research via HTTP requests to SerpApi, then synthesizes specialist recommendations into one deliverable. The end result is a clean, paste-ready strategy that shows priorities, not just ideas.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Collecting live Google SERP and competitor context through SerpApi requests.
Delegating work across six SEO specialties instead of one giant, messy prompt.
Remembering your business details during the chat session so you repeat yourself less.
Structuring the final strategy into spreadsheet-friendly fields in Google Sheets or Excel.

Most teams get a first draft in about 5 minutes instead of half a day of tab-switching.
Plans come out consistent, so reviews are faster and client delivery feels tighter.
Clearer prioritization, which means you can assign tasks the same day.
Less “SEO theater” and more actionable work: technical fixes, content opportunities, and link targets.
A repeatable reporting format you can reuse across clients, locations, or business units.

Example: What This Looks Like

Say you create two SEO strategy reports per week. Manually, you might spend about 30 minutes collecting SERP notes, another 60 minutes pulling keyword ideas, then about 90 minutes stitching everything into a spreadsheet (roughly 3 hours per report). With this workflow, you send one prompt (a couple minutes), wait for the agents and live research to finish (about 5 minutes), then review and tweak in Google Sheets (maybe 20 minutes). That’s around 2 hours back per report, without lowering quality.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
OpenAI for the Director and specialist chat models
SerpApi to pull live Google search results
OpenAI API key (get it from your OpenAI dashboard)
SerpApi API key (get it from your SerpApi account)
Google Sheets to store the final strategy report

Skill level: Beginner. You’ll mostly paste API keys, connect Google, and test the chat prompt.

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

How It Works

A chat message triggers the workflow. You start it from n8n’s chat interface using the Incoming Chat Trigger, then describe the site, niche, and what you want the strategy to cover.

The coordinator pulls context and remembers details. Conversation Memory keeps key business notes during the session, while the coordinator uses SerpApi lookups (via HTTP tooling) to ground the strategy in real search results.

Specialists produce focused recommendations. Separate AI workers handle keyword research, technical SEO, backlinks, analytics, local SEO, and content planning, which keeps outputs cleaner and less repetitive. This is where the “agency” feel comes from.

The report is merged and written to a spreadsheet. The workflow merges specialist outputs, sets the final fields, and sends a structured plan to Google Sheets (with an Excel 365 option available if you prefer Microsoft).

You can easily modify the output fields to match your existing SEO template 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 workflow entry point so users can start the SEO strategy conversation.

Add and open Incoming Chat Trigger.
Set Public to true.
Set Initial Messages to Hello There!.
Under Options, set Title to Welcome to SEO Strategy Agent, Subtitle to Your AI SEO team is on the case. A full strategy report may take up to 90 seconds., and Response Mode to responseNodes.

Step 2: Connect the Primary AI Model

Attach the main language model that powers the coordinator’s reasoning and synthesis.

Open Primary Chat Model.
Set Model to gpt-4.1-mini.
Credential Required: Connect your openAiApi credentials.

Tip: Keep the primary model fast and cost-effective; gpt-4.1-mini is already selected for balanced quality and speed.

Step 3: Set Up Specialist Tools and Memory

Configure the specialist agent tools, memory, and reasoning components used by the coordinator.

Open Conversation Memory and set Context Window Length to 25.
Review each specialist tool and keep the input mapping as =={{ $json.chatInput }} in Keyword Research Expert, Technical SEO Expert, Backlink Strategy Lead, SEO Analytics Analyst, Local Search Expert, and SEO Content Specialist.
Open Reasoning Tool and keep default settings (no parameters required).
Open SerpAPI Lookup.
Credential Required: Connect your serpApi credentials in SerpAPI Lookup.

⚠️ Common Pitfall: Keyword Research Expert, Technical SEO Expert, Backlink Strategy Lead, SEO Analytics Analyst, Local Search Expert, SEO Content Specialist, Reasoning Tool, Conversation Memory, and SerpAPI Lookup are AI tools connected to SEO Strategy Coordinator. Credentials must be added on the parent nodes (Primary Chat Model and each specialist model engine), not on the tool sub-nodes.

Step 4: Configure Specialist Model Engines

Attach OpenAI models to the specialist tools. There are multiple model engines; configure them consistently.

Open Keyword Model Engine, Technical Model Engine, Local Model Engine, Link Model Engine, Analytics Model Engine, and Content Model Engine.
Set Model to gpt-4.1-mini for each model engine.
Set Temperature to 0.7 in each model engine that exposes this option.
Credential Required: Connect your openAiApi credentials to all model engines.

Tip: Keep all specialist engines on the same model to ensure consistent tone across Keyword Research Expert, Technical SEO Expert, Backlink Strategy Lead, SEO Analytics Analyst, Local Search Expert, and SEO Content Specialist.

Step 5: Configure the Strategy Orchestrator and Output

Finalize the coordinator and response sender to compile and deliver the SEO strategy report.

Open SEO Strategy Coordinator and confirm Text is set to =={{ $json.chatInput }} and Prompt Type is define.
Verify that Primary Chat Model is connected as the language model for SEO Strategy Coordinator.
Ensure Conversation Memory, Reasoning Tool, and SerpAPI Lookup are attached to SEO Strategy Coordinator as tools/memory.
Open Chat Response Sender and set Message to ={{ $json.output }}.
Set Wait User Reply to false in Chat Response Sender.

Execution flow: Incoming Chat Trigger → SEO Strategy Coordinator → Chat Response Sender. This is a single-path flow with no parallel branches.

Step 6: Test & Activate Your Workflow

Validate the chat experience and ensure the AI team outputs a complete SEO strategy report.

Click Execute Workflow and open the chat panel created by Incoming Chat Trigger.
Send a prompt like Build a full SEO strategy for my business: example.com in Dallas to trigger specialist analysis.
Confirm Chat Response Sender returns a structured report with sections like Executive Summary, Keyword Strategy, Technical Foundation, and Priority Action Plan.
If output is missing live data, verify SerpAPI Lookup has valid serpApi credentials and the coordinator prompt is unchanged.
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 your n8n Credentials page and your Google account access first.
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 SEO report automation automation?

About 5 minutes if you already have your API keys.

Do I need coding skills to automate SEO report automation?

No. You’ll paste keys, connect accounts, and adjust the prompt to match your business.

Is n8n free to use for this SEO report automation 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 API usage and your SerpApi plan (the free tier can work for light research).

Where can I host n8n to run this 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 SEO report automation workflow for agency-style deliverables?

Yes, and you should. You can adjust the SEO Strategy Coordinator agent’s instructions to match your house style, then map the final “Edit Fields (Set)” output into whatever columns you use in Google Sheets. Common tweaks include adding a “Priority” rule (like quick wins first), forcing a specific report structure (technical, content, links, local), and asking the Director to include a 30-day action plan your team can assign immediately.

Why is my Google Sheets connection failing in this workflow?

Usually it’s expired or missing Google permissions in n8n. Reconnect your Google Sheets credential, confirm the correct account is selected, and make sure the target spreadsheet is shared with that account. If it fails only sometimes, you may be hitting Google API limits during busy periods, so spacing executions out can help.

How many reports can this SEO report automation automation handle?

It depends on your n8n plan and your API limits, but most small teams run dozens of reports a month without issues. On self-hosted n8n there’s no execution cap; your server capacity and OpenAI/SerpApi rate limits become the bottleneck.

Is this SEO report automation automation better than using Zapier or Make?

For this workflow, n8n is usually the better fit because the agent-style logic is more complex than a typical two-step zap. You get more control over branching and orchestration, plus self-hosting if you want unlimited runs. It’s also easier to keep everything in one place: chat trigger, memory, research tool, and spreadsheet output. Zapier or Make can still work if you only want a simple “prompt to sheet” pipeline, but this agent swarm approach is harder to replicate cleanly. If you’re torn, Talk to an automation expert and get a quick recommendation.

Set it up once and your next SEO strategy stops being a formatting project. The workflow handles the repetitive parts so you can focus on 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": "",
"meta": {
"instanceId": "e40ae7c06a3b9db2a447e849aa14bd10fd13b52d0ccabee5cb7c9c708a15700f",
"templateId": null,
"templateCredsSetupCompleted": null
},
"name": "Automated SEO Strategy Workflow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11109",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1315,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "21f0d07d-8c8b-4145-98c2-67a25ce3909d",
"name": "Incoming Chat Trigger",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
1215,
170
],
"webhookId": "696a9839-f036-40e8-877f-bfe013aaf93a",
"parameters": {
"public": true,
"options": {
"title": "Welcome to SEO Strategy Agent",
"subtitle": "Your AI SEO team is on the case. A full strategy report may take up to 90 seconds.",
"responseMode": "responseNodes"
},
"initialMessages": "Hello There!"
},
"typeVersion": 1.3
},
{
"id": "a1adf74d-5ee6-420b-a29c-44164e573265",
"name": "Primary Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
840,
350
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "96c11554-e7dd-4cb4-8ec7-794747796043",
"name": "Keyword Research Expert",
"type": "@n8n/n8n-nodes-langchain.agentTool",
"position": [
1135,
635
],
"parameters": {
"text": "=={{ $json.chatInput }}",
"options": {
"systemMessage": "You are a Keyword Research Specialist with deep expertise in SEO keyword strategy.\n\nYour core responsibilities:\n- Conduct comprehensive keyword research\n- Analyze search intent (informational, navigational, commercial, transactional)\n- Perform competitor keyword gap analysis\n- Create keyword clusters and content groups\n- Estimate search volumes and keyword difficulty\n- Identify long-tail keyword opportunities\n\nWhen analyzing a request:\n1. Identify primary target keywords (high volume, high intent)\n2. Suggest secondary keywords and variations\n3. Categorize keywords by search intent\n4. Provide estimated difficulty scores (Easy/Medium/Hard)\n5. Recommend keyword implementation strategy\n6. Suggest content topics based on keyword clusters\n\nAlways structure your response with:\n- Primary Keywords (3-5)\n- Secondary Keywords (10-15)\n- Long-tail Opportunities (5-10)\n- Search Intent Breakdown\n- Implementation Priority\n\nBe specific, data-driven, and actionable in your recommendations."
},
"toolDescription": "Specialist agent focused on keyword research, search intent analysis, competitor keyword analysis, and keyword clustering for SEO campaigns."
},
"typeVersion": 2.2
},
{
"id": "d50187fb-5ec5-46d0-9e6a-dcfa611f8031",
"name": "Technical SEO Expert",
"type": "@n8n/n8n-nodes-langchain.agentTool",
"position": [
860,
645
],
"parameters": {
"text": "=={{ $json.chatInput }}",
"options": {
"systemMessage": "You are a Technical SEO Specialist with expertise in website optimization and technical infrastructure.\n\nYour core responsibilities:\n- Conduct technical SEO audits\n- Optimize site speed and Core Web Vitals\n- Implement schema markup and structured data\n- Fix crawling and indexing issues\n- Optimize site architecture and internal linking\n- Ensure mobile-friendliness and responsive design\n- Handle robots.txt, XML sitemaps, and canonical tags\n\nWhen analyzing a request:\n1. Identify critical technical issues\n2. Prioritize fixes by impact (High/Medium/Low)\n3. Provide specific implementation steps\n4. Recommend tools for monitoring\n5. Suggest performance benchmarks\n6. Consider technical scalability\n\nStructure your response with:\n- Critical Issues (immediate fixes needed)\n- Site Speed Recommendations\n- Schema Markup Opportunities\n- Crawlability Improvements\n- Mobile Optimization Steps\n- Monitoring & Maintenance Plan\n\nProvide technical but understandable recommendations with clear implementation guidance."
},
"toolDescription": "Specialist agent focused on technical SEO audits, site speed optimization, schema markup, crawlability, and technical infrastructure."
},
"typeVersion": 2.2
},
{
"id": "71e8592a-f846-4d77-aa9d-091ca9cf12a3",
"name": "Backlink Strategy Lead",
"type": "@n8n/n8n-nodes-langchain.agentTool",
"position": [
700,
600
],
"parameters": {
"text": "=={{ $json.chatInput }}",
"options": {
"systemMessage": "You are a Link Building Strategist with expertise in earning high-quality backlinks and building domain authority.\n\nYour core responsibilities:\n- Develop comprehensive link building strategies\n- Create outreach campaign plans\n- Identify link-worthy content opportunities\n- Analyze competitor backlink profiles\n- Recommend guest posting and PR opportunities\n- Build relationships with relevant websites and influencers\n\nWhen analyzing a request:\n1. Identify target link sources (blogs, news sites, directories, industry sites)\n2. Create tiered link building approach (Tier 1, 2, 3)\n3. Develop outreach messaging templates\n4. Suggest linkable asset creation (infographics, tools, research)\n5. Recommend link monitoring and reporting\n6. Provide realistic timeline and effort estimates\n\nStructure your response with:\n- Target Link Sources (20-30 prospects)\n- Outreach Strategy & Templates\n- Linkable Asset Recommendations\n- Guest Posting Opportunities\n- PR & Digital PR Tactics\n- Monthly Link Building Goals\n- Success Metrics\n\nFocus on white-hat, sustainable link building practices that build long-term authority."
},
"toolDescription": "Specialist agent focused on backlink strategy, outreach campaigns, link acquisition tactics, and authority building."
},
"typeVersion": 2.2
},
{
"id": "af888ada-f8a1-4661-b3bd-a34ca5beee83",
"name": "SEO Analytics Analyst",
"type": "@n8n/n8n-nodes-langchain.agentTool",
"position": [
320,
680
],
"parameters": {
"text": "=={{ $json.chatInput }}",
"options": {
"systemMessage": "You are an SEO Analytics Specialist with expertise in tracking, measuring, and reporting SEO performance.\n\nYour core responsibilities:\n- Set up comprehensive SEO tracking systems\n- Define and monitor key performance indicators (KPIs)\n- Analyze Google Analytics and Search Console data\n- Track keyword rankings and visibility\n- Create custom dashboards and reports\n- Provide data-driven optimization recommendations\n\nWhen analyzing a request:\n1. Define relevant SEO KPIs and success metrics\n2. Recommend analytics tools and setup\n3. Create measurement framework\n4. Design reporting structure and frequency\n5. Identify data connections and integrations\n6. Suggest A/B testing opportunities\n\nStructure your response with:\n- Core SEO KPIs to Track\n- Analytics Setup Recommendations (GA4, GSC, etc.)\n- Dashboard Requirements\n- Reporting Schedule (weekly/monthly)\n- Tracking Implementation Steps\n- Conversion Tracking Setup\n- Alert & Monitoring Rules\n\nProvide actionable insights that connect SEO efforts to business outcomes."
},
"toolDescription": "Specialist agent focused on SEO performance tracking, analytics setup, KPI monitoring, and data-driven insights."
},
"typeVersion": 2.2
},
{
"id": "921e7ed6-7b8d-4c6e-b135-90f9931dcee3",
"name": "Local Search Expert",
"type": "@n8n/n8n-nodes-langchain.agentTool",
"position": [
180,
640
],
"parameters": {
"text": "=={{ $json.chatInput }}",
"options": {
"systemMessage": "You are a Local SEO Specialist with expertise in optimizing businesses for local search and Google Maps visibility.\n\nYour core responsibilities:\n- Optimize Google Business Profile (GBP)\n- Build and manage local citations (NAP consistency)\n- Implement local schema markup\n- Create geo-targeted content strategies\n- Manage online reviews and reputation\n- Optimize for \"near me\" and local intent searches\n\nWhen analyzing a request:\n1. Assess local search opportunity and competition\n2. Provide GBP optimization checklist\n3. Identify citation building opportunities\n4. Suggest local content topics\n5. Create review generation strategy\n6. Recommend local link building tactics\n\nStructure your response with:\n- Google Business Profile Optimization Steps\n- Local Citation Building Plan (30-50 sources)\n- Local Schema Implementation\n- Geo-Targeted Content Strategy\n- Review Management Approach\n- Local Link Building Opportunities\n- Local Pack Ranking Factors\n\nFocus on strategies that improve local visibility and drive foot traffic or local conversions."
},
"toolDescription": "Specialist agent focused on local search optimization, Google Business Profile, local citations, and geo-targeted strategies."
},
"typeVersion": 2.2
},
{
"id": "2730b272-fa27-4c8a-8eeb-70fa04445569",
"name": "SEO Content Specialist",
"type": "@n8n/n8n-nodes-langchain.agentTool",
"position": [
0,
630
],
"parameters": {
"text": "=={{ $json.chatInput }}",
"options": {
"systemMessage": "You are an SEO Content Writer with expertise in creating search-optimized, high-quality content that ranks and converts.\n\nYour core responsibilities:\n- Create detailed content briefs\n- Write SEO-optimized blog posts and landing pages\n- Develop content calendars and topic clusters\n- Optimize existing content for better rankings\n- Implement on-page SEO best practices\n- Balance SEO requirements with user experience\n\nWhen analyzing a request:\n1. Develop content topic ideas based on keywords\n2. Create detailed content briefs (structure, headings, word count)\n3. Suggest content formats (how-to, listicle, guide, etc.)\n4. Provide on-page optimization checklist\n5. Recommend internal linking strategy\n6. Create content publishing schedule\n\nStructure your response with:\n- Content Topic Recommendations (10-15 topics)\n- Detailed Content Briefs (3-5 priority pieces)\n- Editorial Calendar (3-6 months)\n- On-Page Optimization Guidelines\n- Content Cluster Strategy\n- Meta Title & Description Templates\n- Internal Linking Recommendations\n\nCreate content strategies that serve both search engines and human readers, focusing on quality and relevance."
},
"toolDescription": "Specialist agent focused on creating SEO-optimized content, content briefs, editorial calendars, and on-page optimization."
},
"typeVersion": 2.2
},
{
"id": "1aba9b92-2755-4126-8ac2-807dd2ea799f",
"name": "Keyword Model Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1110,
845
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {
"temperature": 0.7
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "a462c0e1-f500-4f0b-8897-14e59248da51",
"name": "Technical Model Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
900,
800
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {
"temperature": 0.7
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "5ee429d2-b167-4ca8-ad7e-30f7cf10365b",
"name": "Local Model Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
140,
840
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {
"temperature": 0.7
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "9c72e813-69cb-4b04-8667-b01fe1c55210",
"name": "Link Model Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
680,
835
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {
"temperature": 0.7
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "d377a7be-78b6-46a0-af8c-7a5eaecc8bec",
"name": "Analytics Model Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
320,
805
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {
"temperature": 0.7
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "a700edfa-6aae-42db-8873-5eabaafef08a",
"name": "Content Model Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
20,
810
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {
"temperature": 0.7
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "94f79720-4451-4cdc-9298-7f8fbab3e31d",
"name": "SEO Strategy Coordinator",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
500,
370
],
"parameters": {
"text": "=={{ $json.chatInput }}",
"options": {
"systemMessage": "You are an SEO Strategy Director, managing an expert system of AI agents. Your primary objective is to deliver comprehensive, actionable SEO strategies tailored specifically to the user's business.\n\nWhen a user requests SEO help, you must follow this precise workflow:\n\nConsult Memory: First, use the Memory tool to check for any previous conversation history, business details, or strategies already discussed with this user.\n\nAnalyze Request: Analyze the user's new message, placing it in the context of your retrieved memories. Extract key business details: business name, niche, website URL, target audience, goals, and specific needs.\n\nGather Intelligence: If a business name or website URL is provided (either in the new query or in memory), you MUST use the SerpApi (Google Search) tool to gather real-time, external intelligence.\n\nExample searches: \"What is [User's Business Name]?\", \"top competitors for [User's Business Name]\", \"SEO audit of [user's URL]\", \"local citations for [User's Business Name] in [Location]\".\n\nFormulate Plan: Based on the user's query, your memory, and the fresh data from SerpApi, determine which specialists to consult using the Decision Matrix.\n\nDelegate to Specialists: Call the required specialist tools. You MUST pass them a rich, consolidated context including:\n\nThe user's specific question.\n\nKey business details (from memory and the query).\n\nYour key findings from the SerpApi search (e.g., \"SerpApi shows your top 3 competitors are X, Y, and Z\").\n\nSynthesize & Report: Compile all specialist insights into one cohesive, comprehensive, and actionable plan. Follow the Response Structure exactly.\n\nAvailable Tools\nYou have two types of tools available:\n\n1. Specialist Agents (Your Team)\nKeyword Research Specialist: keyword strategy, search intent, competitor analysis.\n\nTechnical SEO Specialist: technical audits, site speed, schema, crawlability.\n\nLink Building Strategist: backlink strategy, outreach, PR campaigns.\n\nSEO Analytics Specialist: tracking, KPIs, analytics setup, reporting.\n\nLocal SEO Specialist: local search, Google Business Profile, citations.\n\nSEO Content Writer: content strategy, briefs, editorial calendars.\n\n2. Data-Gathering Tools (Your Briefing)\nSerpApi (Google Search): Used to get live, real-time data from the web about the user's business, competitors, and website.\n\nMemory: Used to retrieve past conversation context and remember the user's business details.\n\nDecision Matrix\nSimple requests (1-2 topics): Call only relevant specialists.\n\nExample: \"Help with keywords\" \u2192 Call Keyword Research only.\n\nMedium requests (specific area): Call 2-4 related specialists.\n\nExample: \"Fix my slow site\" \u2192 Call Technical SEO + Analytics (and use SerpApi to run a basic speed test).\n\nComprehensive requests (full strategy): Call ALL 6 specialists.\n\nExample: \"Create full SEO strategy for my business\" \u2192 Call all specialists, Memory, and SerpApi.\n\nCRITICAL INSTRUCTIONS\nNEVER use generic examples like \"a skincare store\" or \"a local bakery\" unless the user's business is one of those.\n\nAlways base ALL recommendations on the user's ACTUAL business.\n\nUse your tools: You MUST use Memory every time. You MUST use SerpApi if a business name or URL is available.\n\nPass full context: Your specialists are only as good as the briefing you give them. Pass all relevant data (query, memory, SerpApi findings) to them.\n\nAsk for clarity: If critical information is missing (like the business name or URL for a full audit), ask the user for it before proceeding.\n\nResponse Structure\n# SEO STRATEGY REPORT FOR [USER'S ACTUAL BUSINESS NAME]\n\n(Sourced from: [User's Query, Memory, and SerpApi live search])\n\nExecutive Summary\n[2-3 sentences overview specific to their business, informed by your tool-based analysis]\n\nStrategy Components\nKeyword Strategy\n[Recommendations from Keyword specialist - specific to their niche, referencing competitors found via SerpApi]\n\nTechnical Foundation\n[Recommendations from Technical specialist - for their actual site, informed by SerpApi findings]\n\nAuthority Building\n[Link building strategy - for their specific industry]\n\nPerformance Tracking\n[Analytics setup - tailored to their goals]\n\n[Include other relevant specialist sections]\nPriority Action Plan\n[Most critical action for THEIR business]\n\n[Second priority for THEIR needs]\n\n[Third priority]\n\nTimeline & Next Steps\n[Realistic timeline and clear next actions]"
},
"promptType": "define"
},
"typeVersion": 2.2
},
{
"id": "71e2afac-47f6-4efa-94f3-f6d1c5bf35f4",
"name": "Reasoning Tool",
"type": "@n8n/n8n-nodes-langchain.toolThink",
"position": [
280,
230
],
"parameters": [],
"typeVersion": 1.1
},
{
"id": "a0b836ac-e174-4418-8e6f-55e0c8769d12",
"name": "Chat Response Sender",
"type": "@n8n/n8n-nodes-langchain.chat",
"position": [
60,
350
],
"parameters": {
"message": "={{ $json.output }}",
"options": [],
"waitUserReply": false
},
"typeVersion": 1
},
{
"id": "4b0f1128-7669-4b2f-a061-940fdefb5121",
"name": "Conversation Memory",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
910,
120
],
"parameters": {
"contextWindowLength": 25
},
"typeVersion": 1.3
},
{
"id": "6adbc9ae-2608-49e4-ace8-1fc2b2e012a3",
"name": "SerpAPI Lookup",
"type": "@n8n/n8n-nodes-langchain.toolSerpApi",
"position": [
710,
210
],
"parameters": {
"options": []
},
"credentials": {
"serpApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
}
],
"active": true,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Reasoning Tool": {
"ai_tool": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_tool",
"index": 0
}
]
]
},
"SerpAPI Lookup": {
"ai_tool": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_tool",
"index": 0
}
]
]
},
"Conversation Memory": {
"ai_memory": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_memory",
"index": 0
}
]
]
},
"Primary Chat Model": {
"ai_languageModel": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Keyword Model Engine": {
"ai_languageModel": [
[
{
"node": "Keyword Research Expert",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Technical Model Engine": {
"ai_languageModel": [
[
{
"node": "Technical SEO Expert",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Local Model Engine": {
"ai_languageModel": [
[
{
"node": "Local Search Expert",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Link Model Engine": {
"ai_languageModel": [
[
{
"node": "Backlink Strategy Lead",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Analytics Model Engine": {
"ai_languageModel": [
[
{
"node": "SEO Analytics Analyst",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Content Model Engine": {
"ai_languageModel": [
[
{
"node": "SEO Content Specialist",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"SEO Content Specialist": {
"ai_tool": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_tool",
"index": 0
}
]
]
},
"SEO Strategy Coordinator": {
"main": [
[
{
"node": "Chat Response Sender",
"type": "main",
"index": 0
}
]
]
},
"Local Search Expert": {
"ai_tool": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_tool",
"index": 0
}
]
]
},
"Backlink Strategy Lead": {
"ai_tool": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_tool",
"index": 0
}
]
]
},
"SEO Analytics Analyst": {
"ai_tool": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_tool",
"index": 0
}
]
]
},
"Technical SEO Expert": {
"ai_tool": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_tool",
"index": 0
}
]
]
},
"Incoming Chat Trigger": {
"main": [
[
{
"node": "SEO Strategy Coordinator",
"type": "main",
"index": 0
}
]
]
},
"Keyword Research Expert": {
"ai_tool": [
[
{
"node": "SEO Strategy Coordinator",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}