January 22, 2026

Google Sheets to WordPress, SEO drafts ready to edit

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your SEO pipeline breaks in the boring places. Keywords sit “prioritized” in a sheet for days, competitor research lives in 12 tabs, and drafts never make it into WordPress because someone got pulled into meetings.

Content managers feel it first. A solo business owner trying to publish weekly feels it too. Same with a small marketing team that wants Sheets WordPress drafts without turning every post into a mini project. This workflow turns one click into a ready-to-edit WordPress draft and updates your sheet so you always know what’s in progress.

You’ll see how the automation pulls SERP data, creates a content brief, drafts the post, publishes it as a WordPress draft, and marks the status back in Google Sheets.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets to WordPress, SEO drafts ready to edit

Click to explore

flowchart LR

    subgraph sg0["Content Analysis Str Flow"]
        direction LR
        n0["<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/webhook.dark.svg' width='40' height='40' /></div><br/>Webhook"]
        n1@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Out", pos: "b", h: 48 }
        n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "split into different SERP re..", pos: "b", h: 48 }
        n3@{ icon: "mdi:cog", form: "rounded", label: "Aggregate", pos: "b", h: 48 }
        n4@{ icon: "mdi:brain", form: "rounded", label: "Claude Haiku 3.5 Model", pos: "b", h: 48 }
        n5@{ icon: "mdi:brain", form: "rounded", label: "Claude Sonnet 3.7", pos: "b", h: 48 }
        n6@{ icon: "mdi:robot", form: "rounded", label: "Content Analysis Structure", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "Content Brief Structure", pos: "b", h: 48 }
        n8@{ icon: "mdi:robot", form: "rounded", label: "AI Article Analysis", pos: "b", h: 48 }
        n9@{ icon: "mdi:robot", form: "rounded", label: "AI Content Brief Generator", pos: "b", h: 48 }
        n10@{ icon: "mdi:robot", form: "rounded", label: "AI Content Draft", pos: "b", h: 48 }
        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/httprequest.dark.svg' width='40' height='40' /></div><br/>Search in Google Search API1"]
        n12["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Raw Web Page"]
        n13["<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/code.svg' width='40' height='40' /></div><br/>Extract Text from Web Page"]
        n14["<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/wordpress.svg' width='40' height='40' /></div><br/>Send Draft to WordPress"]
        n15@{ icon: "mdi:database", form: "rounded", label: "Update Progress Info", pos: "b", h: 48 }
        n16@{ icon: "mdi:database", form: "rounded", label: "Update Excel Sheet", pos: "b", h: 48 }
        n0 --> n1
        n3 --> n9
        n1 --> n15
        n1 --> n11
        n10 --> n14
        n12 --> n13
        n5 -.-> n10
        n8 --> n3
        n4 -.-> n8
        n4 -.-> n9
        n7 -.-> n9
        n14 --> n16
        n9 --> n10
        n6 -.-> n8
        n13 --> n8
        n11 --> n2
        n2 --> n12
    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 n6,n7,n8,n9,n10 ai
    class n4,n5 aiModel
    class n15,n16 database
    class n0,n11,n12 api
    class n13 code
    classDef customIcon fill:none,stroke:none
    class n0,n11,n12,n13,n14 customIcon

The Problem: SEO drafting gets stuck between “idea” and “draft”

Most teams don’t fail at SEO because they lack ideas. They fail because the path from keyword to WordPress draft is messy, manual, and easy to postpone. You prioritize keywords in Google Sheets, then you “just need” to check the top results, skim competitor structure, find gaps, write a brief, then draft, then upload. That sounds linear. In real life, it’s interruptions, context switching, and re-checking the same SERPs three different times because things changed or you forgot what you saw.

The friction compounds. A few minutes here, a few tabs there, and suddenly publishing consistently feels weirdly hard.

Manual SERP review pulls you into 10 tabs per keyword, and you still miss patterns like content type shifts or “hidden” subtopics.
Briefs end up inconsistent, which means drafts get rewritten and deadlines slip.
Copying drafts into WordPress is repetitive work, and small formatting mistakes are annoyingly common.
Status tracking turns into guesswork when the sheet isn’t updated the moment work starts and finishes.

The Solution: One-click keyword → SERP → brief → WordPress draft

This n8n workflow gives you a simple habit: keep your keyword list in Google Sheets, mark rows as “prioritized,” then click “Prepare Content.” That click triggers n8n through a webhook, and the workflow takes over. It pulls the top Google results for the keyword, grabs page content for those listings, and uses AI to analyze what competitors are doing (tone, structure, content type, and what they missed). From that analysis it generates a content brief you can actually work from, then drafts the article based on the brief. Finally, it publishes the result into WordPress as a draft (not live), and updates your Google Sheet so the keyword row shows that processing started and completed.

The flow starts in Google Sheets, then Google Search results get collected and split into individual listings. Those pages are fetched and parsed into readable text, then AI produces structured analysis and a brief. The draft gets created and sent straight to WordPress, while the sheet is updated so you can manage content like a pipeline instead of a pile.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Watches for “prioritized” keywords sent from Google Sheets via webhook.
Pulls the top 10 SERP results and retrieves competitor page content automatically.
Uses Claude AI to generate a structured content brief and a full draft from it.
Uploads the draft post to WordPress and updates Google Sheets status fields.

Turn one keyword into a WordPress draft in about 10–20 minutes of machine time.
Fewer “blank page” days because the brief is created for you, consistently.
Less tab juggling, which honestly keeps your team moving instead of stalling.
Cleaner handoffs when multiple people touch the same content queue.
A sheet that reflects reality, so you can prioritize and publish faster.

Example: What This Looks Like

Say you prioritize 5 keywords each week. Manually, a “quick” pass often looks like 10 SERP clicks at maybe 5 minutes each (about 50 minutes), plus 30 minutes to turn notes into a brief, plus about 2 hours for a first draft, plus another 10 minutes to create a WordPress draft. That’s roughly 3 hours per keyword, or about 15 hours a week. With this workflow, you click “Prepare Content,” wait about 10–20 minutes per keyword for SERP pull, brief, and draft creation, then open a ready-to-edit WordPress draft. You still edit (you should), but you stop doing the repetitive setup work.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets to store keywords and statuses
WordPress to receive the draft posts
Google Custom Search API key (get it from Google Cloud Console)
Claude AI API key (get it from Anthropic Console)

Skill level: Intermediate. You’ll connect accounts, add API keys, and test a webhook from the sheet.

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

How It Works

A Google Sheets click triggers the workflow. Your sheet sends prioritized keyword rows to n8n through an incoming webhook, then n8n immediately marks those rows as “processing started.”

Search results and competitor pages get collected. n8n calls Google Search, splits the top 10 results into individual items, pulls each webpage’s HTML, and parses it into plain text your AI model can actually analyze.

AI turns competitor noise into a usable plan. Claude generates structured analysis (what’s ranking, the angles they take, what’s missing), then it produces a content brief and a draft blog article based on that brief.

Your draft lands in WordPress, and the sheet updates. The workflow publishes a draft post in WordPress and marks the keyword row as “processing complete,” which means your queue stays trustworthy.

You can easily modify the content brief format to match your template or client SOP based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Webhook Trigger

Set up the entry point that receives keyword rows and starts the pipeline.

Add the Incoming Webhook Trigger node and set HTTP Method to POST.
Set Path to 208f9a1a-60ce-40d8-ac20-1909f0ac4257 so external systems can call the workflow.
Connect Incoming Webhook Trigger to Distribute Rows to split incoming rows into individual items.

Tip: Test the webhook with a sample payload that includes body.rows to match the downstream split logic.

Step 2: Connect Google Sheets

Update processing status in your keyword tracking sheet at the start and end of the run.

Open Mark Processing Started and set Operation to update.
Set Document to [YOUR_ID] and Sheet Name to gid=0.
Map Column 1 to Started processing and row_number to {{ $json.rowNumber }}.
Open Mark Processing Complete and set Operation to update, Document to [YOUR_ID], and Sheet Name to gid=0.
Map Column 1 to processing finished and row_number to {{ $json.row_number }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in both Mark Processing Started and Mark Processing Complete.

⚠️ Common Pitfall: The matching column is row_number; ensure your incoming data includes rowNumber and later row_number so updates match the correct row.

Step 3: Configure SERP Retrieval and Parsing

Fetch top-ranking URLs for each keyword and convert HTML into clean text for analysis.

In Distribute Rows, set Field to Split Out to body.rows.
Configure Google Search Request with URL https://www.googleapis.com/customsearch/v1 and enable Send Query.
Set query parameters: q to {{ $json.keywordString }}, and provide values for key and cx.
Set Split SERP Listings to split Field to Split Out as items.
Configure Retrieve Webpage HTML with URL ={{ $json.link }}.
In Parse Webpage Text, keep Mode as runOnceForEachItem and use the provided JavaScript to extract text.

Execution Flow: Distribute Rows outputs to both Mark Processing Started and Google Search Request in parallel.

Tip: If Google Custom Search errors, verify your key and cx parameters are populated in Google Search Request.

Step 4: Set Up AI Analysis and Content Briefing

Use Claude to analyze competitor content, aggregate insights, and generate a content brief.

Configure Analyze Article Content with Text set to =This is the text:\n {{ $json.text }} and keep Prompt Type as define.
Attach Analysis Schema Parser as the output parser for Analyze Article Content; keep the JSON schema example as provided.
Configure Combine Analysis Output to aggregate the output field from all analyses.
Set Generate Content Brief Text to =The target Keyword is: AI Agent vs AI Chatbot\n\nhere are the summaries: \n{{ JSON.stringify($json.output) }}\n.
Attach Brief Schema Parser as the output parser for Generate Content Brief and keep the JSON schema example as provided.
Credential Required: Connect your anthropicApi credentials in Claude Haiku Runtime (used by both Analyze Article Content and Generate Content Brief).

⚠️ Common Pitfall: Analysis Schema Parser and Brief Schema Parser do not take credentials directly—add credentials to Claude Haiku Runtime, the parent model node.

Step 5: Draft the Article with AI

Generate a full HTML draft using the content brief and SERP summaries.

In Draft Blog Article, set Text to =This is the keyword: \n'AI Agents vs AI Chatbots'\n\nThe content brief is here:\n{{ JSON.stringify($json.output) }}\n\nThese are the summaries:\n{{ JSON.stringify($('Combine Analysis Output').item.json.output) }}.
Ensure Draft Blog Article is connected to Claude Sonnet Runtime as its language model.
Credential Required: Connect your anthropicApi credentials in Claude Sonnet Runtime.

Tip: The prompt requests HTML output only. Confirm the generated content is valid HTML before publishing.

Step 6: Configure Output to WordPress

Publish the drafted HTML as a WordPress draft and update the processing status.

In Publish Draft to WordPress, set Title to Testtest.
Set Content (additional field) to ={{ $json.text }} to publish the generated HTML.
Credential Required: Connect your wordpressApi credentials in Publish Draft to WordPress.
Confirm the flow: Draft Blog Article → Publish Draft to WordPress → Mark Processing Complete.

⚠️ Common Pitfall: If the post appears empty, verify that Draft Blog Article outputs HTML in $json.text.

Step 7: Test and Activate Your Workflow

Validate the end-to-end pipeline and then enable it for production use.

Click Execute Workflow and send a POST request to the Incoming Webhook Trigger URL with a body.rows array.
Watch for successful branching: Distribute Rows should run to Mark Processing Started and Google Search Request in parallel.
Confirm that Publish Draft to WordPress creates a draft post and Mark Processing Complete updates the spreadsheet status.
When satisfied, switch the workflow Active toggle to on for production runs.

🔒

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 Google Sheets credential screen and the shared sheet 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 Sheets WordPress drafts automation?

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

Do I need coding skills to automate Sheets WordPress drafts?

No. You’ll mostly paste API keys, connect WordPress, and test the webhook from Google Sheets.

Is n8n free to use for this Sheets WordPress 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 Claude API usage and Google Custom Search API costs.

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 Sheets WordPress drafts workflow for a different brief format?

Yes, and it’s one of the best tweaks to make. Update the “Generate Content Brief” node prompt to match your outline template (sections, headings, FAQs, internal link targets), then keep the “Draft Blog Article” node aligned so it writes from that structure. Many teams also adjust the analysis to focus on intent (commercial vs informational), add a “brand voice” paragraph, and enforce word count or reading level.

Why is my WordPress connection failing in this workflow?

Usually it’s incorrect WordPress credentials or missing permissions for the user you connected in n8n. Also check if your site blocks XML-RPC or REST requests via a security plugin, which can silently break draft publishing. If it fails only sometimes, rate limiting or hosting firewalls can be the culprit, especially when you’re drafting multiple keywords in a batch.

How many keywords can this Sheets WordPress drafts automation handle?

Most small teams run batches of 5–20 keywords at a time without issues, then scale up once they’re confident.

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

It depends on how “hands off” you want the SERP analysis and drafting to be. Zapier and Make can move data around quickly, but this workflow leans on multi-step AI chains, structured parsing, and looping through multiple SERP URLs, which is where n8n feels more natural. You can also self-host n8n, which keeps costs predictable when you run lots of keywords. If you’re only pushing a finished Google Doc into WordPress, Zapier might be simpler. If you want the full keyword → SERP → brief → draft pipeline, n8n is a better fit. Talk to an automation expert if you want help picking the cleanest route.

Set it up once, then let your sheet become a real content queue instead of a parking lot. The workflow handles the repetitive parts so you can spend your time editing, improving, and publishing.

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": "f4437d6ec3fe254b7d8ac300d662bbeb51ddf9ebfcec028eb9ab2d23c7061049",
"templateId": null,
"templateCredsSetupCompleted": null
},
"name": "Automated Keyword Content Pipeline",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-7503",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1396,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "2e9c1ed9-1b06-4a81-af44-0a97364480f9",
"name": "Incoming Webhook Trigger",
"type": "n8n-nodes-base.webhook",
"position": [
1096,
150
],
"webhookId": "208f9a1a-60ce-40d8-ac20-1909f0ac4257",
"parameters": {
"path": "208f9a1a-60ce-40d8-ac20-1909f0ac4257",
"options": [],
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "c9e9048c-1b4b-4afe-9740-0698000f3e4c",
"name": "Distribute Rows",
"type": "n8n-nodes-base.splitOut",
"position": [
836,
206
],
"parameters": {
"options": [],
"fieldToSplitOut": "body.rows"
},
"typeVersion": 1
},
{
"id": "c07308e8-1ab0-4ce7-82f7-c1ca34dbe19f",
"name": "Split SERP Listings",
"type": "n8n-nodes-base.splitOut",
"position": [
384,
348
],
"parameters": {
"options": [],
"fieldToSplitOut": "items"
},
"typeVersion": 1
},
{
"id": "ac323545-015f-4eb7-8a79-5483f5ff8473",
"name": "Combine Analysis Output",
"type": "n8n-nodes-base.aggregate",
"position": [
440,
540
],
"parameters": {
"options": [],
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "output"
}
]
}
},
"typeVersion": 1
},
{
"id": "adc61223-1536-4871-8415-1050360ade36",
"name": "Claude Haiku Runtime",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
212,
606
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-3-5-haiku-20241022",
"cachedResultName": "Claude Haiku 3.5"
},
"options": []
},
"credentials": {
"anthropicApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.3
},
{
"id": "8346dd6f-4da9-44ff-b8cb-896581286a28",
"name": "Claude Sonnet Runtime",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
936,
610
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-3-7-sonnet-20250219",
"cachedResultName": "Claude Sonnet 3.7"
},
"options": []
},
"credentials": {
"anthropicApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.3
},
{
"id": "6076d8f4-f732-43b9-8f31-f081796a637f",
"name": "Analysis Schema Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
22,
480
],
"parameters": {
"jsonSchemaExample": "{\n  \"contentFormat\": \"listicle | how-to | guide | comparison | opinion | review | other\",\n  \"contentType\": \"informational | commercial | transactional | navigational\",\n  \"intentClues\": [\n    \"e.g. how to\", \n    \"best tools\", \n    \"buy\", \n    \"guide\", \n    \"vs\", \n    \"tutorial\", \n    \"top 10\"\n  ],\n  \"averageWordCount\": 0,\n  \"headings\": [\n    \"H1 Title Example\",\n    \"H2 Subtopic One\",\n    \"H2 Subtopic Two\",\n    \"H3 Nested Topic\"\n  ],\n  \"subtopics\": [\n    \"Definition of X\",\n    \"Benefits of Y\",\n    \"How to do Z\",\n    \"Common mistakes\"\n  ],\n  \"summaryTakeaways\": [\n    \"Key takeaway 1\",\n    \"Key takeaway 2\",\n    \"Key takeaway 3\"\n  ],\n  \"answeredQuestions\": [\n    \"What is X?\",\n    \"How does Y work?\",\n    \"Why is Z important?\"\n  ],\n  \"uniqueAngles\": [\n    \"Case study from a startup using X\",\n    \"Comparison to real-world analogy\",\n    \"Includes visuals that others don\u2019t\"\n  ],\n  \"contentGaps\": [\n    \"No examples of practical implementation\",\n    \"Missed current 2024 data updates\",\n    \"Lacked pros and cons comparison\"\n  ]\n}"
},
"typeVersion": 1.3
},
{
"id": "7f0ff7a4-aab7-4692-9565-e36e72858289",
"name": "Brief Schema Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
474,
448
],
"parameters": {
"jsonSchemaExample": "{\n  \"targetKeyword\": \"your keyword here\",\n  \"searchIntent\": \"informational | commercial | etc.\",\n  \"recommendedFormat\": \"how-to | listicle | etc.\",\n  \"idealLength\": \"1200\u20131500 words\",\n  \"targetAudience\": \"e.g. SaaS founders, content creators\",\n  \"titleSuggestion\": \"Best Tools for Automating Content Repurposing in 2024\",\n  \"metaDescription\": \"Discover the top tools and workflows to repurpose YouTube content into blogs, social posts, and more.\",\n  \"outline\": [\n    \"Introduction\",\n    \"Why Content Repurposing Matters\",\n    \"Top Tools to Use\",\n    \"How to Set Up an Automation Flow\",\n    \"Common Mistakes to Avoid\",\n    \"Conclusion\"\n  ],\n  \"mustIncludeSubtopics\": [\n    \"Benefits of content repurposing\",\n    \"Overview of tools like Repurpose.io, Zapier, n8n\",\n    \"Step-by-step setup guide\"\n  ],\n  \"answeredQuestions\": [\n    \"How do I turn a YouTube video into a blog post?\",\n    \"What tools automate content repurposing?\"\n  ],\n  \"uniqueAngle\": \"Focus on a solo creator\u2019s use case using free/low-cost tools\",\n  \"contentGapsToFill\": [\n    \"Most competitors don\u2019t explain setup steps clearly\",\n    \"None include a downloadable automation template\"\n  ],\n  \"ctaSuggestion\": \"Download the free workflow template + join my newsletter\"\n}"
},
"typeVersion": 1.3
},
{
"id": "5d8ddcda-34e3-4de2-b7d3-ec7d2973f2fb",
"name": "Analyze Article Content",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
208,
494
],
"parameters": {
"text": "=This is the text:\n {{ $json.text }}",
"batching": [],
"messages": {
"messageValues": [
{
"message": "You are a seasonsed SEO professional and Text Analyser with some deep insights into helpful content. Whenever you get a text, I want you to analyse and understand the text.  Then, I want you to extract the following from each text: \n1. the ContentFormat,  which is either a listicle, how-to, guide, comparision, opinion, review, or other. \n2. the ContentType, which is either informational, commercial, transactional or navigational\n3. the IntentClues, which can be how-to, best tools, buy, guide, vs, tutorial, ranking, top 10,\n4. the AverageWordCount, which is the average word length of the text\n5. all the headings, h1,h2,h3, up to h6 if necessary. And, if possible, also Add the hX tag before the heading\n6. all the subtopics: definitions of x, benefits of y, how to do.. and so on\n7. a list of key-takeaways.\n8. a list of answered questions in the text\n9. the UniqueAngles of the text. for example case studies, comparisons to real-world scenarios, etc.\n10. a list of contentGaps that you see in the text."
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"executeOnce": false,
"typeVersion": 1.7
},
{
"id": "cac3d12d-5777-4929-87aa-a2739592160a",
"name": "Generate Content Brief",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
630,
514
],
"parameters": {
"text": "=The target Keyword is: AI Agent vs AI Chatbot\n\nhere are the summaries: \n{{ JSON.stringify($json.output) }}\n",
"batching": [],
"messages": {
"messageValues": [
{
"message": "You are an expert SEO content strategist. Your task is to analyze a list of SERP summaries (from top-ranking pages for a keyword) and generate a high-quality content brief to guide the writing of a new blog post that is more useful and competitive than existing content.  \n\nEach SERP summary is structured in JSON and contains insights about a competing article, including content format, content type, headings, subtopics, summary takeaways, answered questions, unique angles, and content gaps.  \n\nUse this information to: \n- Identify the dominant content format and intent \n- Suggest a competitive and original structure \n- Fill in the content gaps identified across competitors \n- Highlight what to include and what to improve \n- Suggest a title, meta description, outline, subtopics, and CTA \n- Focus on user value and differentiation  \n\nReturn the output as a single JSON object with the following structure:  {   \"targetKeyword\": \"string\",   \"searchIntent\": \"string\",   \"recommendedFormat\": \"string\",   \"idealLength\": \"string\",   \"targetAudience\": \"string\",   \"titleSuggestion\": \"string\",   \"metaDescription\": \"string\",   \"outline\": [\"h2 header one\", \"h2 header two\",\"h3 sub-header two-one\", \"...\"],   \"mustIncludeSubtopics\": [\"topic 1\", \"topic 2\", \"...\"],   \"answeredQuestions\": [\"question 1\", \"question 2\", \"...\"],   \"uniqueAngle\": \"string\",   \"contentGapsToFill\": [\"gap 1\", \"gap 2\", \"...\"],   \"ctaSuggestion\": \"string\" }  Use clear, specific language in your output. Be strategic, not generic."
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "f54e0944-b55e-4409-bacf-18db8471af2e",
"name": "Draft Blog Article",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
920,
490
],
"parameters": {
"text": "=This is the keyword: \n'AI Agents vs AI Chatbots'\n\nThe content brief is here:\n{{ JSON.stringify($json.output) }}\n\nThese are the summaries:\n{{ JSON.stringify($('Combine Analysis Output').item.json.output) }}",
"batching": [],
"messages": {
"messageValues": [
{
"message": "You are a seasoned SEO blog writer and technical content creator. Your writing style is warm, human, and easy to understand \u2014 like you're explaining things to a curious and smart 16-year-old. You combine technical depth with clarity and a dash of quirkiness. You're speaking to solopreneurs, developers, and technically minded professionals. The goal is to educate, inform, and sometimes lightly entertain.\n\nYou will receive:\n- A main keyword\n- A content brief in JSON format\n- A list of summarized top-ranking articles from the first page of Google (also in JSON format)\n- A preferred content structure, such as \u201chow-to guide\u201d or \u201clisticle\u201d\n\nYou must understand the content brief and all provided article summaries before drafting anything.\n\nYour tasks:\n\n1. Generate a fresh, SEO-friendly title, primarily based on the brief, but also informed by top articles.\n\n2. Create an outline using <h2> and <h3> headers. Make sure each section is relevant to the keyword and useful for the reader.\n- If a header doesn\u2019t make sense, leave it out.\n- Follow the format and tone requested in the structure parameter (e.g., how-to guide, opinion, etc.)\n\n3. For each <h2> and <h3>:\n- List a few bullet points on what should be covered and from what angle.\n- Write a draft paragraph for each bullet point.\n\n4. Whenever appropriate, include examples, data, or references.\n- If you can\u2019t find any directly, add a placeholder like [add example here] or [research link for XYZ] \u2014 this helps the human editor finish the post efficiently.\n\n\nImportant notes:\n\n\ud83d\udd1a Final Output Format (IMPORTANT)\nOutput only the HTML text\n\nDo NOT return markdown, YAML, or any explanation.\nDo NOT include \"output\" or \"response\" keys.\nDo NOT return a code block. just the raw html text"
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "f6fbe74d-8efa-4cc6-9671-4dcb479adcdc",
"name": "Google Search Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
640,
316
],
"parameters": {
"url": "https://www.googleapis.com/customsearch/v1",
"options": [],
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "{{ $json.keywordString }}"
},
{
"name": "key"
},
{
"name": "cx"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "ffa72fee-3e14-45cd-bf75-ddce5cdbdba7",
"name": "Retrieve Webpage HTML",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
198,
338
],
"parameters": {
"url": "={{ $json.link }}",
"options": []
},
"typeVersion": 4.2
},
{
"id": "96c04d4a-148c-4832-ab16-1758abd09cb3",
"name": "Parse Webpage Text",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"position": [
0,
384
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const data = $json.data;\n\nfunction extractTextWithHeaders(html) {\n  let cleanedHTML = html\n    .replace(/<script[\\s\\S]*?>[\\s\\S]*?<\\/script>/gi, '')\n    .replace(/<style[\\s\\S]*?>[\\s\\S]*?<\\/style>/gi, '');\n\n  cleanedHTML = cleanedHTML.replace(/<(h[1-6])[^>]*>(.*?)<\\/\\1>/gi, (match, tag, content) => {\n    return `\\n\\n[${tag.toUpperCase()}] ${content.trim()} [/${tag.toUpperCase()}]\\n\\n`;\n  });\n\n  cleanedHTML = cleanedHTML.replace(/<[^>]+>/g, '');\n\n  cleanedHTML = cleanedHTML.replace(/\\s+/g, ' ').trim();\n\n  return cleanedHTML;\n}\n\nconst extractedText = extractTextWithHeaders(data);\n\nconsole.log(extractedText);\n\n// Return as output\nreturn { text: extractedText };\n"
},
"typeVersion": 2
},
{
"id": "3012bb4f-7f50-4bf1-aba6-bf8098415b80",
"name": "Publish Draft to WordPress",
"type": "n8n-nodes-base.wordpress",
"position": [
1114,
536
],
"parameters": {
"title": "Testtest",
"additionalFields": {
"content": "={{ $json.text }}"
}
},
"credentials": {
"wordpressApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "ee44cee8-60ce-48d2-90a7-6064752c6486",
"name": "Mark Processing Started",
"type": "n8n-nodes-base.googleSheets",
"position": [
612,
120
],
"parameters": {
"columns": {
"value": {
"Column 1": "Started processing",
"row_number": "={{ $json.rowNumber }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Parent",
"type": "string",
"display": true,
"required": false,
"displayName": "Parent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Info",
"type": "string",
"display": true,
"required": false,
"displayName": "Info",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comment",
"type": "string",
"display": true,
"required": false,
"displayName": "Comment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "post type",
"type": "string",
"display": true,
"required": false,
"displayName": "post type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword type",
"type": "string",
"display": true,
"required": false,
"displayName": "keyword type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Prioritized",
"type": "string",
"display": true,
"required": false,
"displayName": "Prioritized",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Processed",
"type": "string",
"display": true,
"required": false,
"displayName": "Processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "written",
"type": "string",
"display": true,
"required": false,
"displayName": "written",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "published",
"type": "string",
"display": true,
"required": false,
"displayName": "published",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "internal links added everywhere",
"type": "string",
"display": true,
"required": false,
"displayName": "internal links added everywhere",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 1",
"type": "string",
"display": true,
"required": false,
"displayName": "Column 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "ContentSheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "798de9a5-94ad-4488-96a8-fddde3969095",
"name": "Mark Processing Complete",
"type": "n8n-nodes-base.googleSheets",
"position": [
1296,
330
],
"parameters": {
"columns": {
"value": {
"Column 1": "processing finished",
"row_number": "={{ $json.row_number }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Parent",
"type": "string",
"display": true,
"required": false,
"displayName": "Parent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Info",
"type": "string",
"display": true,
"required": false,
"displayName": "Info",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comment",
"type": "string",
"display": true,
"required": false,
"displayName": "Comment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "post type",
"type": "string",
"display": true,
"required": false,
"displayName": "post type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword type",
"type": "string",
"display": true,
"required": false,
"displayName": "keyword type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Prioritized",
"type": "string",
"display": true,
"required": false,
"displayName": "Prioritized",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Processed",
"type": "string",
"display": true,
"required": false,
"displayName": "Processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "written",
"type": "string",
"display": true,
"required": false,
"displayName": "written",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "published",
"type": "string",
"display": true,
"required": false,
"displayName": "published",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "internal links added everywhere",
"type": "string",
"display": true,
"required": false,
"displayName": "internal links added everywhere",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 1",
"type": "string",
"display": true,
"required": false,
"displayName": "Column 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "ContentSheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Incoming Webhook Trigger": {
"main": [
[
{
"node": "Distribute Rows",
"type": "main",
"index": 0
}
]
]
},
"Combine Analysis Output": {
"main": [
[
{
"node": "Generate Content Brief",
"type": "main",
"index": 0
}
]
]
},
"Distribute Rows": {
"main": [
[
{
"node": "Mark Processing Started",
"type": "main",
"index": 0
},
{
"node": "Google Search Request",
"type": "main",
"index": 0
}
]
]
},
"Draft Blog Article": {
"main": [
[
{
"node": "Publish Draft to WordPress",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Webpage HTML": {
"main": [
[
{
"node": "Parse Webpage Text",
"type": "main",
"index": 0
}
]
]
},
"Claude Sonnet Runtime": {
"ai_languageModel": [
[
{
"node": "Draft Blog Article",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Analyze Article Content": {
"main": [
[
{
"node": "Combine Analysis Output",
"type": "main",
"index": 0
}
]
]
},
"Claude Haiku Runtime": {
"ai_languageModel": [
[
{
"node": "Analyze Article Content",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Generate Content Brief",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Brief Schema Parser": {
"ai_outputParser": [
[
{
"node": "Generate Content Brief",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Publish Draft to WordPress": {
"main": [
[
{
"node": "Mark Processing Complete",
"type": "main",
"index": 0
}
]
]
},
"Generate Content Brief": {
"main": [
[
{
"node": "Draft Blog Article",
"type": "main",
"index": 0
}
]
]
},
"Analysis Schema Parser": {
"ai_outputParser": [
[
{
"node": "Analyze Article Content",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Parse Webpage Text": {
"main": [
[
{
"node": "Analyze Article Content",
"type": "main",
"index": 0
}
]
]
},
"Google Search Request": {
"main": [
[
{
"node": "Split SERP Listings",
"type": "main",
"index": 0
}
]
]
},
"Split SERP Listings": {
"main": [
[
{
"node": "Retrieve Webpage HTML",
"type": "main",
"index": 0
}
]
]
}
}
}