January 22, 2026

Google Trends to WordPress, drafts ready to review

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your blog calendar looks fine on paper. Then the week gets busy, trending topics move on, and you are stuck choosing between “publish something” and “publish something good.” Meanwhile, the same steps repeat every time: find a keyword, outline, write, grab an image, upload, format, and hope you didn’t miss basic SEO fields.

Content managers feel it when the backlog goes stale. Solo founders feel it when writing steals from selling. And marketing teams at small agencies feel it when client blogs need fresh drafts weekly. This Google Trends automation turns trends into WordPress drafts you can review, which means consistency without living in Google tabs.

Below, you’ll see exactly what the workflow does, what you get out of it, and how to make it fit your niche and brand voice without overengineering anything.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Trends to WordPress, drafts ready to review

Click to explore

flowchart LR

    subgraph sg0["Schedule Flow"]
        direction LR
        n0@{ icon: "mdi:swap-vertical", form: "rounded", label: "Main Config", pos: "b", h: 48 }
        n1["<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/>GoogleTrends"]
        n2@{ icon: "mdi:cog", form: "rounded", label: "XML", pos: "b", h: 48 }
        n3["<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/>Filter Scraped Keywords"]
        n4@{ icon: "mdi:database", form: "rounded", label: "Append or update row in sheet", pos: "b", h: 48 }
        n5@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
        n6@{ icon: "mdi:robot", form: "rounded", label: "AI Agent", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "Structured Output Parser", pos: "b", h: 48 }
        n8@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n9["<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/>Grab one random keyword"]
        n10@{ icon: "mdi:database", form: "rounded", label: "Update row in sheet", 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 Pexels Image"]
        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/wordpress.svg' width='40' height='40' /></div><br/>Create posts on Wordpress"]
        n13@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
        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/httprequest.dark.svg' width='40' height='40' /></div><br/>Set image ID for the post"]
        n15["<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/>Cleanup the AI"]
        n16["<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/>Update image metadata"]
        n17@{ icon: "mdi:database", form: "rounded", label: "Get row in sheet", pos: "b", h: 48 }
        n18["<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/>Upload media"]
        n19["<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/>Add watermark to image"]
        n2 --> n3
        n6 --> n10
        n0 --> n1
        n1 --> n2
        n18 --> n14
        n15 --> n12
        n5 --> n17
        n5 --> n4
        n17 --> n9
        n13 --> n0
        n8 -.-> n6
        n11 --> n15
        n10 --> n11
        n19 --> n18
        n3 --> n5
        n9 --> n6
        n7 -.-> n6
        n12 --> n19
        n14 --> n16
        n4 --> 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 n13 trigger
    class n6,n7 ai
    class n8 aiModel
    class n4,n10,n17 database
    class n1,n11,n14,n16,n18,n19 api
    class n3,n9,n15 code
    classDef customIcon fill:none,stroke:none
    class n1,n3,n9,n11,n12,n14,n15,n16,n18,n19 customIcon

The Problem: Trending topics don’t wait for your writing time

Staying consistent with content is hard enough. Staying consistent while chasing trends is worse. You find a topic on Google Trends, then you copy it into a doc, then a sheet, then you try to shape it into a post that won’t embarrass your brand. Images turn into another time sink: search, download, resize, upload, and then you still need alt text and a featured image set correctly. A single missed detail can derail the whole “quick draft” idea, so drafts don’t ship and the calendar slips.

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

You end up spending about an hour just to get from “trend” to “draft,” and that’s before edits.
Keywords get tracked inconsistently, so you can’t tell what was used, what’s pending, or what performed.
Images get treated as an afterthought, which leads to unbranded visuals and missing SEO metadata.
Publishing becomes an all-or-nothing task, so busy weeks quietly become zero-post weeks.

The Solution: Turn Google Trends into branded WordPress drafts

This workflow runs on a schedule and pulls trending search terms from Google Trends, then turns one of those terms into a clean WordPress draft you can review. First, it fetches the Trends feed, converts the XML into JSON, and filters the list down to terms that match what you actually want to write about. Those keywords are logged in Google Sheets, so you have a lightweight content queue and you can see what’s already been used. From there, the workflow selects a keyword, asks OpenAI to generate structured blog content, and then cleans the output so it’s formatted and usable. Finally, it finds a matching stock image on Pexels, applies a watermark for branding, uploads the media to WordPress, sets it as the featured image, and saves the post as a draft.

The workflow starts with a scheduled trigger and a few “primary settings” you control (like region and filtering behavior). Then it cycles through trend keywords, picks one at random, generates the post, and marks that keyword as done in your Google Sheet so it doesn’t get reused accidentally. WordPress gets a draft with text, featured image, and updated media details, ready for your final human review.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It fetches Google Trends data on a schedule and converts it into usable keyword records.
It writes and updates a Google Sheets tracker so your keyword queue stays organized.
It generates a structured post draft with OpenAI, then cleans the output for readability.
It finds a relevant Pexels image, applies a watermark, uploads it, and assigns it in WordPress.

Most teams go from “no idea what to post” to a reviewable draft in about 10 minutes of hands-on time.
Your blog cadence becomes predictable because drafts show up even during hectic weeks.
Keyword reuse drops sharply because each term is tracked and marked done.
Featured images stay on-brand thanks to watermarking and consistent media handling.
You get a simple content pipeline you can scale without hiring a full writing team immediately.

Example: What This Looks Like

Say you want 5 trend-based drafts per week. Manually, a typical cycle is roughly 20 minutes to find and vet a topic, about an hour to draft, and another 20 minutes to find and prep an image, so call it about 2 hours per post (around 10 hours weekly). With this workflow, you spend maybe 10 minutes total per draft doing quick review and edits because the keyword, text, and featured image are already waiting in WordPress. That’s most of a workday back each week.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for keyword queue tracking.
WordPress to create drafts via API access.
OpenAI API key (get it from your OpenAI dashboard).
Pexels API key (get it from the Pexels API page).

Skill level: Intermediate. You’ll connect accounts, add API keys, and verify WordPress permissions, but you won’t be writing code unless you want deeper filtering.

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

How It Works

A scheduled run kicks things off. n8n starts on a timer (daily, hourly, whatever you choose) and loads your primary settings, like the Trends region you care about.

Google Trends gets fetched and filtered. The workflow pulls the Trends feed via HTTP Request, parses the XML into JSON, then filters terms using a small logic step so you don’t clutter your pipeline with irrelevant topics.

Keywords are tracked in Google Sheets. New terms are appended or updated in your sheet, then the workflow selects a single keyword to work on and marks it done after the draft is generated.

OpenAI creates the draft and WordPress receives it. The AI agent generates structured content, a cleanup step removes weird formatting, and WordPress gets a fresh draft. After publishing the draft, the workflow searches Pexels, applies your watermark, uploads the image, sets it as featured, and updates media details for SEO.

You can easily modify the keyword filtering to focus on your niche, or adjust the prompt to match your brand voice and formatting rules. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Schedule Trigger

This workflow starts on a recurring schedule and then initializes global settings for trend filtering.

Open Scheduled Automation Trigger and set the interval rule to run every 25 minutes.
Connect Scheduled Automation Trigger to Primary Settings exactly as shown in the flow.
In Primary Settings, set min_traffic to 500 to filter low-traffic trends.

Step 2: Fetch and Filter Google Trends Data

These nodes pull the trending RSS feed, parse it, and filter by traffic threshold before batching.

In Google Trends Fetch, set URL to https://trends.google.it/trending/rss and keep Send Query enabled.
In Google Trends Fetch, add a query parameter geo with value US.
In XML Parse, keep normalize as false and explicitArray as false.
In Filter Trend Keywords, keep the JavaScript as provided, which reads $('Primary Settings').first().json.min_traffic and filters the RSS items.
Connect Filter Trend Keywords to Batch Iterate Records to begin iterative processing.

Step 3: Connect Google Sheets for Keyword Tracking

Google Sheets stores trend keywords and tracks processing status. This workflow uses multiple Sheets nodes, so connect credentials once and apply them to all Sheets nodes.

Open Retrieve Sheet Rows and select the document Primary Sheet with sheet Keyword Tracker.
In Retrieve Sheet Rows, set the filter to Status equals processing.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Sheet Rows, Append/Update Sheet Row, and Mark Sheet Row Done.
In Append/Update Sheet Row, confirm the field mappings use expressions like {{ $json.trending_keyword }} and {{Math.floor(Math.random()*999999999)}}.
In Mark Sheet Row Done, keep operation set to update and ensure Status is set to done with Keyword mapped to {{ $('Select Random Keyword').item.json.Keyword }}.

Step 4: Set Up AI Content Generation

The AI agent creates the article JSON, which is parsed and later cleaned before publishing.

In Select Random Keyword, keep the JavaScript logic that filters for Status === "processing" and randomly selects one item.
In AI Content Agent, keep the Text prompt and ensure expressions are preserved, such as {{ $json.Keyword }} and {{ $json['Example Title 1'] }}.
Open OpenAI Chat Engine and select model gpt-4.1-mini.
Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine.
Open Structured Output Reader and confirm the JSON schema example matches the expected fields.
Note: Structured Output Reader is an AI sub-node—add credentials on OpenAI Chat Engine, not on Structured Output Reader.

Step 5: Configure Media and WordPress Publishing

This stage fetches a Pexels image, applies a watermark, uploads media, and publishes a WordPress draft with a featured image.

In Pexels Image Lookup, keep the request URL expression https://api.pexels.com/v1/search?query={{ encodeURIComponent($('AI Content Agent').item.json.output.images_query)}}&per_page=1.
Credential Required: Connect your httpHeaderAuth credentials in Pexels Image Lookup.
In Apply Image Watermark, keep URL as https://quickchart.io/watermark and set mainImageUrl to {{ $('Pexels Image Lookup').item.json.photos[0].src.landscape }}.
In Apply Image Watermark, update markImageUrl to your own watermark file, replacing [CONFIGURE_YOUR_API_KEY].
In Upload Media Asset, keep URL as https://clipmint.pro/wp-json/wp/v2/media and Content-Disposition as attachment; filename="{{ $('AI Content Agent').item.json.output.images_query }}.jpg".
Credential Required: Connect your wordpressApi credentials in Publish WordPress Draft, Upload Media Asset, Assign Featured Image, and Update Media Details.
In Publish WordPress Draft, set Title to {{ $('AI Content Agent').item.json.output.title }}, Status to draft, and Content to {{ $json.output.content }}.
In Assign Featured Image, keep the post URL expression https://clipmint.pro/wp-json/wp/v2/posts/{{ $('Publish WordPress Draft').item.json.id }} and set featured_media to {{ $json.id }}.
In Update Media Details, keep the JSON body mapping for title, alt_text, and description using AI outputs.

⚠️ Common Pitfall: The watermark URL contains a placeholder ([CONFIGURE_YOUR_API_KEY]). Replace it with your actual asset path to avoid failed watermarking requests.

Step 6: Test and Activate Your Workflow

Run a manual test to verify data pulls, AI generation, and WordPress drafts before activating the schedule.

Click Execute Workflow to run a manual test from Scheduled Automation Trigger.
Confirm Append/Update Sheet Row adds trend keywords and Retrieve Sheet Rows returns rows with Status set to processing.
Verify AI Content Agent returns structured JSON that Structured Output Reader can parse.
Check WordPress for a new draft created by Publish WordPress Draft and verify the featured image is set by Assign Featured Image.
When everything succeeds, toggle the workflow to Active so Scheduled Automation Trigger runs every 25 minutes.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

WordPress credentials can expire or need specific permissions. If things break, check your WordPress Application Passwords (or user role capabilities) 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 Google Trends automation automation?

About 45 minutes if you already have API keys and WordPress access.

Do I need coding skills to automate Google Trends automation?

No. You’ll mostly paste API keys and connect accounts in n8n. The only “code-like” parts are optional filters you can leave as-is.

Is n8n free to use for this Google Trends 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 costs (usually a few cents per draft, depending on length) and Pexels (free, but requires an API key).

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 Google Trends automation workflow for a specific niche and tone?

Yes, and you should. Update the prompt inside the AI Content Agent to include your audience, examples of your voice, and any formatting rules (like headings, FAQs, or a standard intro). Many teams also tweak the Filter Trend Keywords logic to exclude off-brand topics, and adjust the Pexels query terms so images match your style better.

Why is my WordPress connection failing in this workflow?

Usually it’s an application password issue or the WordPress user doesn’t have permission to create posts and upload media. Regenerate the application password, confirm the site URL is correct (including https), and then re-test the WordPress node. If it fails only on media steps, check that your hosting or security plugin isn’t blocking REST API media uploads. Rate limiting can also show up if you run the schedule too aggressively.

How many drafts can this Google Trends automation automation handle?

On n8n Cloud, it depends on your plan’s monthly executions, and on self-hosting it mostly depends on your server. Practically, most small sites run this once or a few times per day and stay well within limits. If you batch lots of keywords at once, expect OpenAI and WordPress API calls to be the real throttle points.

Is this Google Trends automation automation better than using Zapier or Make?

It can be, especially if you want branching logic, cleanup steps, and tighter control over how content and media get handled. n8n is also easier to scale cheaply because self-hosting removes the “every step costs more” feeling once volume increases. Zapier or Make are fine for simpler flows, but this one benefits from having code steps, structured output parsing, and multiple HTTP requests in a single run. If you’re unsure, map your desired output first (draft quality, image handling, tracking) and then pick the tool that won’t force compromises. Talk to an automation expert and we’ll help you choose quickly.

Once this is running, drafts show up even when you’re busy. Honestly, that’s the whole win: less scrambling, more publishing, and a calendar you can trust.

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": "8a40a8e194afd5f32c38c42e7255bd56fbaee01fae34b8872f83ca4cfb0a3ef3",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Trend Content Publisher",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-8296",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1296,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "1c1ddb04-e797-47a0-98a4-440a0e7cf7dc",
"name": "Scheduled Automation Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1196,
120
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes",
"minutesInterval": 25
}
]
}
},
"typeVersion": 1.2
},
{
"id": "2d730ee3-48d6-4732-9cc3-39d250c6acbc",
"name": "Primary Settings",
"type": "n8n-nodes-base.set",
"notes": "",
"position": [
980,
170
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "25d7e553-9678-40ad-bb69-e4eb4bce4d11",
"name": "min_traffic",
"type": "number",
"value": 500
}
]
}
},
"typeVersion": 3.4
},
{
"id": "da1376eb-342b-4628-aa80-4b738ec5e3a8",
"name": "Google Trends Fetch",
"type": "n8n-nodes-base.httpRequest",
"position": [
742,
142
],
"parameters": {
"url": "https://trends.google.it/trending/rss",
"options": [],
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "geo",
"value": "US"
}
]
}
},
"executeOnce": true,
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "b8244b2e-0110-4754-b062-463bdfd33489",
"name": "XML Parse",
"type": "n8n-nodes-base.xml",
"position": [
548,
182
],
"parameters": {
"options": {
"normalize": false,
"explicitArray": false
}
},
"executeOnce": true,
"typeVersion": 1
},
{
"id": "e1f20a6f-2569-4aa4-8e26-430414f12e20",
"name": "Filter Trend Keywords",
"type": "n8n-nodes-base.code",
"position": [
322,
146
],
"parameters": {
"jsCode": "const min_traffic = $('Primary Settings').first().json.min_traffic;\n\nconst items = $('XML Parse').first().json.rss.channel.item;\nconst trafficKey = Object.keys(items[0]).find(key => key.includes(\"approx_traffic\"));\nconst parseTraffic = (traffic) => parseInt(traffic.replace('+', ''), 10);\n\nconst newItems = items.map(item => {\n    const links = Array.isArray(item[\"ht:news_item\"]) ? item[\"ht:news_item\"].slice(0, 3) : [];\n\n    const flattenedLinks = links.reduce((acc, news, index) => {\n        acc[`title_${index + 1}`] = news[\"ht:news_item_title\"];\n        return acc;\n    }, {});\n\n    return {\n        trending_keyword: item.title,\n        approx_traffic: parseTraffic(item[trafficKey]),\n        pubDate: item.pubDate,\n        ...flattenedLinks,\n    };\n})\n// Filter by min_traffic AND check if not already in sheet\n.filter(item => \n    item.approx_traffic >= min_traffic\n);\n\nlet sortedItems = newItems.sort((a, b) => b.approx_traffic - a.approx_traffic);\nreturn sortedItems;"
},
"typeVersion": 2,
"alwaysOutputData": false
},
{
"id": "a94ac3fe-f896-4339-928a-762cd88b15f9",
"name": "Batch Iterate Records",
"type": "n8n-nodes-base.splitInBatches",
"position": [
176,
368
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "4f0d2e31-38a9-425b-add0-31e1f6909493",
"name": "Retrieve Sheet Rows",
"type": "n8n-nodes-base.googleSheets",
"position": [
382,
406
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupValue": "processing",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Keyword Tracker"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "Primary Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "537693df-e3f0-4119-b0b0-a800b794dd93",
"name": "Select Random Keyword",
"type": "n8n-nodes-base.code",
"position": [
582,
368
],
"parameters": {
"jsCode": "const allItems = $input.all();\nconst processingItems = allItems.filter(item => \n    item.json.Status === \"processing\" && \n    item.json.Keyword && item.json.Keyword.trim() !== \"\" &&\n    item.json['Example Title 1'] && item.json['Example Title 1'].trim() !== \"\"\n);\n\nlet selectedItem = null;\nif (processingItems.length > 0) {\n    const randomIndex = Math.floor(Math.random() * processingItems.length);\n    selectedItem = processingItems[randomIndex];\n}\n\nreturn selectedItem ? [selectedItem] : [];"
},
"typeVersion": 2
},
{
"id": "74be89ac-e914-462d-acd4-c39f97e7d16c",
"name": "AI Content Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
792,
402
],
"parameters": {
"text": "=You are a seasoned content writer and SEO expert specializing in crafting compelling, human-like blog posts for WordPress. Your goal is to produce articles that feel authentic, conversational, and engaging, as if written by a passionate human author with a unique voice. Generate a high-quality, SEO-optimized article based on these inputs:\n\nKeyword: {{ $json.Keyword }}\nDate: {{ $json.Date }}\nExample Titles: \n1. {{ $json['Example Title 1'] }}\n2. {{ $json['Example Title 2'] }}\n3. {{ $json['Example Title 3'] }}\n\nBest Practices and Guidelines:\n- Adopt a natural, relatable tone: Write like you're chatting with a friend use contractions (e.g., \"you're\" instead of \"you are\"), varied sentence lengths, rhetorical questions, personal anecdotes or hypothetical scenarios to draw readers in, and subtle humor where it fits. Avoid stiff, robotic phrasing; make it flow like everyday conversation while staying professional.\n- Craft a magnetic, SEO-friendly title: Draw inspiration from the example titles, incorporating the main keyword naturally near the beginning. Aim for 50-60 characters to encourage clicks, and make it benefit-oriented or curiosity-driven (e.g., \"How [Keyword] Can Transform Your [Benefit] in 2025\").\n- Create a meta description: Write a concise, enticing summary around 140-160 characters that includes the keyword, highlights key benefits, and ends with a call-to-action to subscribe on our newsletter \n- Hook with an introduction: Start with 2-3 engaging sentences that pose a problem, share a surprising fact, or tell a quick story related to the keyword and date for timeliness.\n- Structure for readability and SEO: Organize into logical sections with H2 headings (use <h2> tags) that include variations of the keyword or related terms. Use H3 subheadings (<h3> tags) for deeper breakdowns. Incorporate short paragraphs (3-5 sentences max), bullet points (<ul> or <ol>), bold (<strong>) or italic (<em>) text for emphasis, and numbered lists where helpful.\n- Optimize for SEO without stuffing: Weave the main keyword naturally (aim for 1-2% density), plus related long-tail variations, in the intro, headings, and conclusion. If relevant, do not include any image.\n- Enhance engagement: Add calls-to-action (e.g., \"What do you think? Share in the comments!\"), questions to prompt reflection, and transitions like \"But wait, there's more...\" to keep readers scrolling. Ensure the content is original, insightful, and backed by logical reasoning or general knowledge avoid fluff or repetition.\n- Word count: Target 800-1,200 words for in-depth value, making it comprehensive yet skimmable.\n- WordPress optimization: Output the content as clean, valid HTML ready for the WordPress editor. Use semantic tags like <p> for paragraphs, <ul>/<li> for lists, and avoid unnecessary divs or styles WordPress will handle themes.\n- Do not include any image.\n- Do not include any refer to another website.\n- Do not use \u2014, \u201c\u201d, \u2018\u2019 or any non human writing.\n\nGenerate the full article without any code blocks or extraneous notes.\n\nOutput Format:\n{\n\t\"title\": \"Your Catchy Title Here (50-60 characters)\",\n    \"description\": \"Engaging meta description here (140-160 characters)\",\n\t\"content\": \"The full HTML body content of the article, starting with the intro <p> and including all headings, paragraphs, lists, and links.\",\n    \"images_query\": \"The query string to search images based on article. Max 3-4 words\"\n}",
"options": [],
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "ac744a00-645a-4054-ac7a-5ec389908bb3",
"name": "OpenAI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
758,
228
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "ba329d0d-06bc-4fac-a31c-2e64b4b45d4e",
"name": "Structured Output Reader",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
930,
232
],
"parameters": {
"jsonSchemaExample": "{\n\t\"title\": \"Title of article 50 characters\",\n    \"description\": \"Description around 140 characters\",\n\t\"content\": \"The html body content of article\",\n    \"images_query\": \"The query string to search images based on article. Max 3-4 words\"\n}"
},
"typeVersion": 1.3
},
{
"id": "2cf7053e-ea11-4766-a9ad-36b4d329b594",
"name": "Mark Sheet Row Done",
"type": "n8n-nodes-base.googleSheets",
"position": [
1002,
370
],
"parameters": {
"columns": {
"value": {
"Status": "done",
"Keyword": "={{ $('Select Random Keyword').item.json.Keyword }}"
},
"schema": [
{
"id": "ID",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Traffic",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Traffic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Example Title 1",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Example Title 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Example Title 2",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Example Title 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Example Title 3",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Example Title 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Keyword"
],
"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": "Keyword Tracker"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "Primary Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "32cfda7c-0176-4043-87c5-3fd03ed72306",
"name": "Pexels Image Lookup",
"type": "n8n-nodes-base.httpRequest",
"position": [
1184,
408
],
"parameters": {
"url": "=https://api.pexels.com/v1/search?query={{ encodeURIComponent($('AI Content Agent').item.json.output.images_query)}}&per_page=1",
"options": [],
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "abbd05e2-f704-44da-bb07-4aa6bc1f4435",
"name": "Clean AI Output",
"type": "n8n-nodes-base.code",
"position": [
1048,
612
],
"parameters": {
"jsCode": "// List of common \"extra\" characters writers add\nconst cleanupChars = [\n  '\u2014',  // em dash\n  '\u2013',  // en dash\n  '\u2014',\n  '\u2026',  // ellipsis\n  '\u201c', '\u201d', '\u2018', '\u2019',  // fancy quotes\n  '\\u200B', // zero-width space\n  '\\u00A0', // non-breaking space\n];\n\n// Function to clean HTML content but keep tags\nfunction cleanHtml(html) {\n  if (!html) return html;\n  \n  let cleaned = html;\n\n  // Remove unwanted characters\n  cleanupChars.forEach(char => {\n    cleaned = cleaned.split(char).join('');\n  });\n\n  // Collapse multiple spaces/newlines (but preserve tags)\n  cleaned = cleaned.replace(/>\\s+</g, '><') // remove spaces between tags\n                   .replace(/\\s{2,}/g, ' ') // collapse multiple spaces\n                   .trim();\n\n  return cleaned;\n}\n\n// Process each item\nreturn items.map(item => {\n  const newItem = { ...item };\n\n  // Replace this with your actual HTML field\n  const htmlContent = $('AI Content Agent').first().json.output.content;\n\n  if (htmlContent) {\n    newItem.json.output = newItem.json.output || {};\n    newItem.json.output.content = cleanHtml(htmlContent);\n  }\n\n  return newItem;\n});"
},
"typeVersion": 2
},
{
"id": "2353d1f9-93d4-4260-a32e-046360ecaf04",
"name": "Publish WordPress Draft",
"type": "n8n-nodes-base.wordpress",
"position": [
830,
628
],
"parameters": {
"title": "={{ $('AI Content Agent').item.json.output.title }}",
"additionalFields": {
"status": "draft",
"content": "={{ $json.output.content }}",
"categories": [
4
],
"pingStatus": "open"
}
},
"credentials": {
"wordpressApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1,
"alwaysOutputData": false
},
{
"id": "73410038-05fe-47b5-ac04-7a058c68a4fd",
"name": "Apply Image Watermark",
"type": "n8n-nodes-base.httpRequest",
"position": [
628,
596
],
"parameters": {
"url": "https://quickchart.io/watermark",
"method": "POST",
"options": [],
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "mainImageUrl",
"value": "={{ $('Pexels Image Lookup').item.json.photos[0].src.landscape }}"
},
{
"name": "markImageUrl",
"value": "https://clipmint.pro/wp-[CONFIGURE_YOUR_API_KEY]-300x68.png"
},
{
"name": "markRatio",
"value": "0.25"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "04b604e7-8abb-4e93-9ff1-10e357bae66e",
"name": "Upload Media Asset",
"type": "n8n-nodes-base.httpRequest",
"position": [
430,
632
],
"parameters": {
"url": "https://clipmint.pro/wp-json/wp/v2/media",
"method": "POST",
"options": [],
"sendBody": true,
"contentType": "binaryData",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "Content-Disposition",
"value": "=attachment; filename=\"{{ $('AI Content Agent').item.json.output.images_query }}.jpg\""
}
]
},
"inputDataFieldName": "data",
"nodeCredentialType": "wordpressApi"
},
"credentials": {
"wordpressApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "cc9a4bc5-77b6-4883-8b9a-e7cf11c1ad10",
"name": "Assign Featured Image",
"type": "n8n-nodes-base.httpRequest",
"position": [
228,
598
],
"parameters": {
"url": "=https://clipmint.pro/wp-json/wp/v2/posts/{{ $('Publish WordPress Draft').item.json.id }}",
"method": "POST",
"options": [],
"sendQuery": true,
"authentication": "predefinedCredentialType",
"queryParameters": {
"parameters": [
{
"name": "featured_media",
"value": "={{ $json.id }}"
}
]
},
"nodeCredentialType": "wordpressApi"
},
"credentials": {
"wordpressApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "7c370688-3048-4e1d-b4ad-b6baa62d9dee",
"name": "Update Media Details",
"type": "n8n-nodes-base.httpRequest",
"position": [
0,
628
],
"parameters": {
"url": "=https://clipmint.pro/wp-json/wp/v2/media/{{ $('Upload Media Asset').item.json.id }}",
"method": "POST",
"options": [],
"jsonBody": "={\n  \"title\": \"{{ $('AI Content Agent').item.json.output.title }}\",\n  \"alt_text\": \"{{ $('AI Content Agent').item.json.output.title }} image\",\n  \"description\": \"{{ $('AI Content Agent').item.json.output.description }}\"\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "wordpressApi"
},
"credentials": {
"wordpressApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "b26c064b-389f-4312-80dd-358b3eb24e0d",
"name": "Append/Update Sheet Row",
"type": "n8n-nodes-base.googleSheets",
"position": [
148,
566
],
"parameters": {
"columns": {
"value": {
"ID": "={{Math.floor(Math.random()*999999999)}}",
"Date": "={{ $json.pubDate }}",
"Keyword": "={{ $json.trending_keyword }}",
"Traffic": "={{ $json.approx_traffic }}",
"Example Title 1": "={{ $json.title_1 }}",
"Example Title 2": "={{ $json.title_2 }}",
"Example Title 3": "={{ $json.title_3 }}"
},
"schema": [
{
"id": "ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keyword",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Traffic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Traffic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Example Title 1",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Example Title 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Example Title 2",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Example Title 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Example Title 3",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Example Title 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Keyword"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Keyword Tracker"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "Primary Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7,
"alwaysOutputData": true
}
],
"active": true,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"XML Parse": {
"main": [
[
{
"node": "Filter Trend Keywords",
"type": "main",
"index": 0
}
]
]
},
"AI Content Agent": {
"main": [
[
{
"node": "Mark Sheet Row Done",
"type": "main",
"index": 0
}
]
]
},
"Primary Settings": {
"main": [
[
{
"node": "Google Trends Fetch",
"type": "main",
"index": 0
}
]
]
},
"Google Trends Fetch": {
"main": [
[
{
"node": "XML Parse",
"type": "main",
"index": 0
}
]
]
},
"Upload Media Asset": {
"main": [
[
{
"node": "Assign Featured Image",
"type": "main",
"index": 0
}
]
]
},
"Clean AI Output": {
"main": [
[
{
"node": "Publish WordPress Draft",
"type": "main",
"index": 0
}
]
]
},
"Batch Iterate Records": {
"main": [
[
{
"node": "Retrieve Sheet Rows",
"type": "main",
"index": 0
}
],
[
{
"node": "Append/Update Sheet Row",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Sheet Rows": {
"main": [
[
{
"node": "Select Random Keyword",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Automation Trigger": {
"main": [
[
{
"node": "Primary Settings",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "AI Content Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Pexels Image Lookup": {
"main": [
[
{
"node": "Clean AI Output",
"type": "main",
"index": 0
}
]
]
},
"Mark Sheet Row Done": {
"main": [
[
{
"node": "Pexels Image Lookup",
"type": "main",
"index": 0
}
]
]
},
"Apply Image Watermark": {
"main": [
[
{
"node": "Upload Media Asset",
"type": "main",
"index": 0
}
]
]
},
"Filter Trend Keywords": {
"main": [
[
{
"node": "Batch Iterate Records",
"type": "main",
"index": 0
}
]
]
},
"Select Random Keyword": {
"main": [
[
{
"node": "AI Content Agent",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Reader": {
"ai_outputParser": [
[
{
"node": "AI Content Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Publish WordPress Draft": {
"main": [
[
{
"node": "Apply Image Watermark",
"type": "main",
"index": 0
}
]
]
},
"Assign Featured Image": {
"main": [
[
{
"node": "Update Media Details",
"type": "main",
"index": 0
}
]
]
},
"Append/Update Sheet Row": {
"main": [
[
{
"node": "Batch Iterate Records",
"type": "main",
"index": 0
}
]
]
}
}
}