January 22, 2026

Google Sheets to WordPress, drafts with images ready

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your content pipeline probably isn’t “writing.” It’s hunting for topics, copying briefs into docs, juggling versions, then realizing you still need a featured image before anything can go live. That’s how a simple post turns into a half-day of busywork.

Content marketers feel it when the calendar slips. Agency owners feel it when clients want “more output” without more budget. Even a solo founder trying to stay visible gets stuck. This Sheets WordPress drafts automation turns trends into review-ready drafts (with images) without turning your week into tab-hopping.

You’ll see how the workflow finds a trending topic, logs it in Google Sheets, generates a full draft, then uploads an AI image and assigns it as the featured media in WordPress.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets to WordPress, drafts with images ready

Click to explore

flowchart LR

    subgraph sg0["When clicking 'Execute workflow' Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking 'Execute workf..", 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/code.svg' width='40' height='40' /></div><br/>Parse Content from string to.."]
        n2["<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 a post"]
        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/>Update name and extension of.."]
        n4["<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 image to WP media Lib.."]
        n5["<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/>Assign image to an article a.."]
        n6["<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/perplexity.dark.svg' width='40' height='40' /></div><br/>Find top trending topics"]
        n7["<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/>Select a clean trending topic"]
        n8@{ icon: "mdi:database", form: "rounded", label: "Add topic to Google Sheets", pos: "b", h: 48 }
        n9@{ icon: "mdi:database", form: "rounded", label: "Get most recent topics from ..", pos: "b", h: 48 }
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/perplexity.dark.svg' width='40' height='40' /></div><br/>Generate content and image p.."]
        n11@{ icon: "mdi:database", form: "rounded", label: "Update Google Sheet with gen..", pos: "b", h: 48 }
        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/>Generate featured image usin.."]
        n2 --> n12
        n6 --> n7
        n8 --> n9
        n7 --> n8
        n4 --> n5
        n0 --> n6
        n1 --> n11
        n3 --> n4
        n9 --> n10
        n11 --> n2
        n12 --> n3
        n10 --> n1
    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 n8,n9,n11 database
    class n4,n5,n12 api
    class n1,n3,n7 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n3,n4,n5,n6,n7,n10,n12 customIcon

The Problem: Drafting content is the easy part

Most teams don’t struggle because they can’t write. They struggle because “publish a post” is actually 15 tiny tasks spread across tools. Someone has to pick a topic that’s worth writing about, keep a backlog you can trust, generate or outline content, format it for WordPress, then deal with images and metadata. And the moment you skip any step, quality drops or things ship half-finished. Honestly, that’s where consistency dies: not in creativity, but in process.

The friction compounds, especially once you’re trying to do this every week.

Trending topics get discussed in Slack or meetings, then vanish because there’s no queue.
Drafts end up inconsistent, since every writer starts from a different template.
Featured images become a last-minute scramble, so posts sit in “almost ready” status.
Copy-paste formatting into WordPress introduces weird spacing, broken headings, and avoidable edits.

The Solution: A tracked pipeline from trend → WordPress draft

This n8n workflow creates a simple, repeatable content machine using tools you probably already understand. You launch it, and Perplexity AI scans the last day or two of developer and security news to surface a topic that’s actually trending. That topic gets cleaned up, then written into a Google Sheet so you have a living queue instead of scattered notes. Next, Perplexity generates the post itself (title, sections, keywords, and meta description), and the workflow converts that output into structured data your tools can use. From there, n8n creates a WordPress draft for review, generates a featured image via HuggingFace FLUX, uploads the image to WordPress Media, and attaches it to the draft automatically. No publishing without approval. You stay in control.

The workflow starts with trend discovery and a clean backlog in Google Sheets. Then it generates content and creates a WordPress draft. Finally, it produces an AI image, uploads it, and sets it as the featured media so the post looks complete when you open WordPress.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It discovers a fresh trending topic using Perplexity AI.
It logs the topic and generation status in Google Sheets.
It generates an SEO-structured draft (title, sections, keywords, meta).
It creates a WordPress draft and attaches an AI featured image.

Most teams get about 3–5 hours back per week once the loop is running.
You stop losing “good ideas” because the backlog lives in one sheet.
Editors review drafts that already look like real posts, not rough notes.
Posting becomes a routine, so consistency is easier to keep.
You reduce silly formatting and metadata mistakes that slow approvals down.

Example: What This Looks Like

Say you want 3 new drafts a week. Manually, a typical cycle might look like 30 minutes to find and validate a topic, about 2 hours to outline and write, then another 30 minutes to format in WordPress and hunt down an image. Call it about 3 hours per post, or roughly 9 hours a week. With this workflow, the “human time” becomes launching the run and reviewing the draft, maybe 15 minutes per post, while generation and image creation happen in the background. You still approve everything, but you’re no longer doing the mechanical parts.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for the topic queue and tracking.
WordPress to store drafts and upload media.
HuggingFace API token (get it from your HuggingFace account settings).

Skill level: Intermediate. You’ll connect accounts, edit a sheet ID and site URL, and paste API tokens.

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

How It Works

Manual launch kicks it off. You run the workflow when you want new topics and drafts generated. Some teams do this daily, others batch it twice a week.

Trend discovery and cleanup happen first. Perplexity AI finds a hot topic from the last 24–48 hours, then a small cleanup step turns it into something you’d actually want as a post headline or working title.

Google Sheets becomes your content control center. The workflow appends the topic to your sheet, pulls any pending rows, generates the full post (title, content sections, keywords, meta description), then writes that back to the same row so the status is always visible.

WordPress draft and featured image get created automatically. n8n publishes the content as a draft through the WordPress REST API, generates an image with HuggingFace FLUX, uploads it to Media, then sets that image as the featured media on the draft.

You can easily modify the Google Sheet columns to match your editorial workflow, so you can add things like “reviewer,” “category,” or “internal links” later. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

Set up the manual trigger that starts the workflow and launches the trending topic discovery process.

Add the Manual Workflow Launch node as your trigger.
Keep default settings (no parameters required).
Connect Manual Workflow Launch to Discover Trending Topics to follow the execution flow.

Tip: The Flowpast Branding sticky note is informational only and doesn’t affect execution.

Step 2: Connect Google Sheets

Configure Google Sheets to store and retrieve topics and generated content.

Open Append Topic to Sheets and set Operation to append.
Set Document to [YOUR_ID] and Sheet Name to Sheet1.
Map Topic to {{ $json.snippet }} and is_generated to 0.
Open Retrieve Pending Topics and set the filter to is_generated equals 0.
Open Update Sheet with Content and keep Operation set to update.
Ensure matching column is row_number and keep the mapped expressions such as {{ $json.data.title }} and {{ $json.data.additional_elements.meta_description }}.
Credential Required: Connect your Google Sheets credentials in Append Topic to Sheets, Retrieve Pending Topics, and Update Sheet with Content.

⚠️ Common Pitfall: If [YOUR_ID] isn’t replaced with your actual spreadsheet ID, the workflow will fail on the first Sheets operation.

Step 3: Set Up Perplexity AI Content Generation

Configure the AI steps that discover trends and generate structured blog content.

In Discover Trending Topics, keep the provided message prompt as-is to return clean JSON.
In Create Content & Image Prompt, set Model to sonar-pro and keep the message template with {{ $json.Topic }} and {{ $json.row_number }}.
Credential Required: Connect your Perplexity credentials in Discover Trending Topics and Create Content & Image Prompt.

Step 4: Configure Processing Logic

These code nodes clean and structure the AI outputs for reliable downstream use.

Keep the JavaScript in Pick Clean Trend unchanged to randomly select a trend from search_results.
Ensure Convert Text to JSON parses the AI response with return parseJSONString($input.first().json.choices[0].message.content);.
Connect the flow: Discover Trending Topics → Pick Clean Trend → Append Topic to Sheets → Retrieve Pending Topics → Create Content & Image Prompt → Convert Text to JSON.

Tip: If the AI ever wraps JSON in code fences, Convert Text to JSON removes them automatically.

Step 5: Configure WordPress Draft and Media Upload

Create a draft post and attach an AI-generated featured image via HTTP requests to WordPress.

In Generate WordPress Draft, set Title to {{ $json.title }} and Content to {{ $json.content }}; keep Status as draft and Author ID as 4.
Credential Required: Connect your WordPress credentials in Generate WordPress Draft.
In Produce Featured Image, set URL to https://router.huggingface.co/hf-inference/models/black-forest-labs/FLUX.1-schnell and keep the JSON body { "inputs": "{{ $('Convert Text to JSON').item.json.data.image_prompt }}" }.
Replace the Authorization header value in Produce Featured Image with your token: Bearer [CONFIGURE_YOUR_TOKEN].
Keep Fix Image Filename unchanged to set generated-image.jpg with image/jpeg metadata.
In Upload Image to WP Media, set URL to https://your-site.com/wp-json/wp/v2/media and keep Authentication as predefinedCredentialType with Credential Type wordpressApi.
In Set Featured Media on Post, set URL to https://your-site.com/wp-json/wp/v2/posts/{{ $('Generate WordPress Draft').item.json.id }} and keep JSON body { "featured_media": {{ $json.id }} }.
Credential Required: Connect your WordPress API credentials in Upload Image to WP Media and Set Featured Media on Post.

⚠️ Common Pitfall: If you leave https://your-site.com unchanged, media upload and featured image assignment will fail.

Step 6: Test and Activate Your Workflow

Run a full test to confirm data flows from trend discovery to WordPress draft creation.

Click Execute Workflow starting from Manual Workflow Launch.
Verify that Append Topic to Sheets adds a new row with is_generated set to 0.
Confirm Update Sheet with Content updates the same row using the row_number match.
Check WordPress for a new draft created by Generate WordPress Draft and a featured image set by Set Featured Media on Post.
Once validated, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the connected Google account and the n8n credential permissions 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.
WordPress REST API calls often fail because the user role can’t upload media. Confirm your WordPress user (the authorId you set) has Media upload permissions and that application passwords are enabled.

Frequently Asked Questions

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

About an hour if you already have the accounts and tokens.

Do I need coding skills to automate Sheets WordPress drafts?

No. You’ll mostly paste credentials and update a few values like your sheet ID and WordPress author ID.

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 Perplexity API usage and HuggingFace image generation 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 automation for a different content format?

Yes, but expect a little tweaking. The easiest place to change format is the Perplexity “Create Content & Image Prompt” step, because that’s where the structure (headings, sections, keywords, meta) is defined. You can also adjust the “Convert Text to JSON” logic if you add new fields like category, slug, or internal links. Common customizations are swapping “developer/security” for your niche, changing the section template, and writing a stricter image prompt so featured images match your brand.

Why is my WordPress connection failing in this Sheets WordPress drafts workflow?

Usually it’s an application password issue or the user doesn’t have permission to create posts or upload media. Regenerate your WordPress application password, update the credentials in n8n, and double-check the authorId points to a real user. If drafts create fine but images fail, it’s almost always a Media upload permission or a security plugin blocking REST requests.

How many drafts can this Sheets WordPress drafts automation handle?

If you self-host n8n, it mostly depends on your server and the API rate limits. On n8n Cloud, your cap depends on the plan’s monthly executions, so high-volume sites usually move up a tier. In practice, many teams run this in batches of 5–20 topics so Sheets stays clean and WordPress doesn’t fill up with low-priority drafts. If you’re generating lots of posts daily, watch Perplexity and HuggingFace limits first.

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

Often, yes. This workflow needs branching logic (only generate for pending rows), structured transformations (turn AI text into JSON fields), and multi-step media handling with the WordPress REST API, and those pieces can get awkward or expensive in simpler tools. n8n also gives you the self-hosted option, which matters once you’re doing lots of drafts. Zapier or Make can still be fine for a lightweight “Sheet row → create draft” flow, just not as comfortable for end-to-end content plus images. If you want help choosing, Talk to an automation expert.

Set this up once, and your backlog turns into drafts that are actually ready to review. The workflow handles the repetitive stuff. You handle the judgment calls.

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": "",
"name": "Automated Trend Content Publishing",
"meta": {
"instanceId": "c1cb3df6eb28c7a78415f344263c15ab06bef499dbaf38e051439215ad369424",
"templateId": null,
"templateCredsSetupCompleted": null
},
"versionId": "",
"nodes": [
{
"id": "flowpast-topbar-12386",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
45
],
"parameters": {
"color": 7,
"width": 1140,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "1bf916c9-017b-4bce-8adc-30aac2f7a10a",
"name": "Manual Workflow Launch",
"type": "n8n-nodes-base.manualTrigger",
"position": [
60,
150
],
"parameters": [],
"typeVersion": 1
},
{
"id": "1a35e95e-57cd-4e53-9430-43fd3b9d8ba7",
"name": "Discover Trending Topics",
"type": "n8n-nodes-base.perplexity",
"position": [
320,
170
],
"parameters": {
"options": [],
"messages": {
"message": [
{
"content": "=IMPORTANT:\n- Do NOT include citations, references, footnotes, or bracketed numbers like [1], [2], (1), or similar.\n- Do NOT include source markers anywhere in the output.\n- The output must be citation-free and clean JSON only.\n\nYou are a real-time trend analyzer. Search current popular and authoritative sources relevant to the specified industry, such as major news sites, community forums, social media platforms, trend aggregators, and official updates, to identify the most important topic in the last 24\u201348 hours within the given sector: [Sector of choice].\n\nReturn ONE topic ranked by:\n\nMajor breaking news or critical alerts (e.g., security incidents, regulatory changes, major product recalls)\n\nSignificant product releases, version updates, or launches\n\nHighly viral discussions or debates (e.g., >500+ mentions across authoritative platforms)\n\nFormat your answer exactly as:\n\nTopic: [Specific title]\nSector: [Sector of choice]\nWhy hot: [2 sentences with clear evidence: citations, engagement metrics, official sources]\nActionable angle: [1 sentence on what relevant stakeholders should do]\nPublish title: [SEO-optimized headline]\n\nDo not include multiple topics. Focus only on the most verifiable, urgent, and actionable trend.\n\nIMPORTANT:\n- Do NOT include citations, references, footnotes, or bracketed numbers like [1], [2], (1), or similar.\n- Do NOT include source markers anywhere in the output.\n- The output must be citation-free and clean JSON only.\n\nFinal output rules:\n- Return ONLY valid JSON\n- NO citations\n- NO bracketed numbers\n- NO references\n- NO explanations outside JSON"
}
]
},
"requestOptions": []
},
"typeVersion": 1
},
{
"id": "84b79e05-ae29-4647-ac3e-d566c2263b55",
"name": "Pick Clean Trend",
"type": "n8n-nodes-base.code",
"position": [
580,
145
],
"parameters": {
"jsCode": "// Get the input data from the previous node\nconst inputData = $input.first().json;\n\n// Extract the search_results array\nconst searchResults = inputData.search_results;\n\n// Validate that search results exist\nif (!searchResults || searchResults.length === 0) {\n  throw new Error('No search results found in input data');\n}\n\n// Select a random index from the search results\nconst randomIndex = Math.floor(Math.random() * searchResults.length);\n\n// Get the random topic\nconst selectedTopic = searchResults[randomIndex];\n\n// Return the selected topic as the output (n8n standard format)\nreturn [{ json: selectedTopic }];"
},
"typeVersion": 2
},
{
"id": "39c4fc04-9a02-45a6-be16-031c7fdc1902",
"name": "Append Topic to Sheets",
"type": "n8n-nodes-base.googleSheets",
"notes": "",
"position": [
840,
180
],
"parameters": {
"columns": {
"value": {
"Topic": "={{ $json.snippet }}",
"is_generated": "0"
},
"schema": [
{
"id": "Topic",
"type": "string",
"display": true,
"required": false,
"displayName": "Topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_generated",
"type": "string",
"display": true,
"required": false,
"displayName": "is_generated",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Sheet1",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "MyArticles"
}
},
"typeVersion": 4.7
},
{
"id": "c72691df-220a-488b-ab9f-cf28a0e78a1f",
"name": "Retrieve Pending Topics",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
155
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupValue": "0",
"lookupColumn": "is_generated"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Sheet1",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "MyArticles"
}
},
"typeVersion": 4.7
},
{
"id": "877d021b-cb3d-44de-8987-85d296cc024c",
"name": "Create Content & Image Prompt",
"type": "n8n-nodes-base.perplexity",
"position": [
1080,
350
],
"parameters": {
"model": "sonar-pro",
"options": [],
"messages": {
"message": [
{
"content": "=You are an expert content generator. Based on the topic I provide, generate a well-structured JSON object containing all the elements needed for a high-quality blog post.\n\nTopic: {{ $json.Topic }}\n\nPlease respond strictly in JSON format, with the following structure:\n\n{\n  \"row_number\": {{ $json.row_number }},\n  \"Topic\": {{ $json.Topic }}\n  \"title\": \"Action Required: Please Provide Topic\",\n  \"summary\": \"This is a template response. To generate actual blog content, please provide the specific topic you want covered in the 'Topics' field of your JSON input.\",\n  \"keywords\": [\"prompt\", \"template\", \"topic-required\"],\n  \"image_prompt\": \"A minimalist illustration showing a form with empty fields waiting to be filled, representing a prompt awaiting input parameters.\",\n  \"sections\": [\n    {\n      \"heading\": \"How to Use This Prompt\",\n      \"content\": \"<p>To generate blog content, send a JSON object with the following structure:</p><pre><code>{\\n  \\\"row_number\\\": 1,\\n  \\\"Topics\\\": \\\"Your specific topic here\\\"\\n}</code></pre><p>Replace \\\"Your specific topic here\\\" with the subject you want the blog post to cover.</p>\"\n    },\n    {\n      \"heading\": \"Example\",\n      \"content\": \"<p>For example, to get a blog post about WordPress security:</p><pre><code>{\\n  \\\"row_number\\\": 1,\\n  \\\"Topics\\\": \\\"WordPress Security Best Practices for 2026\\\"\\n}</code></pre>\"\n    }\n  ],\n  \"additional_elements\": {\n    \"call_to_action\": \"Provide your topic in the Topics field to receive your customized blog post JSON.\",\n    \"meta_description\": \"Template response for blog post generator awaiting topic input.\",\n    \"related_topics\": [\"prompt-engineering\", \"json-format\", \"content-generation\"]\n  }\n}\n\nMake sure all HTML is semantic (using <h2>, <p>, <ul>, etc.) and ready to embed on a blog platform. Avoid markdown. Do not include explanations outside the JSON object. Do not include citation counts at the end of <p> tags."
}
]
},
"requestOptions": []
},
"typeVersion": 1
},
{
"id": "8da0df60-1ffa-4735-9ad2-b7f6ee3b0515",
"name": "Convert Text to JSON",
"type": "n8n-nodes-base.code",
"position": [
820,
330
],
"parameters": {
"jsCode": "function parseJSONString(jsonString) {\n  try {\n    let cleanString = jsonString.trim()\n      .replace(/^```json\\n?/g, '')\n      .replace(/\\n?```$/g, '')\n      .trim();\n\n    \n    const parsedData = JSON.parse(cleanString);\n\n    if (typeof parsedData !== 'object' || parsedData === null) {\n      return {\n        success: false,\n        error: \"Parsed data is not a valid object\",\n        data: null\n      };\n    }\n\n    return {\n      success: true,\n      error: null,\n      data: parsedData\n    };\n  } catch (error) {\n    return {\n      success: false,\n      error: error.message,\n      data: null\n    };\n  }\n}\n\nreturn parseJSONString($input.first().json.choices[0].message.content);"
},
"typeVersion": 2,
"alwaysOutputData": false
},
{
"id": "c42fe286-494b-4654-96c3-1c8d88cc7edb",
"name": "Update Sheet with Content",
"type": "n8n-nodes-base.googleSheets",
"position": [
560,
360
],
"parameters": {
"columns": {
"value": {
"title": "={{ $json.data.title }}",
"content": "={{ $json.data.sections[0].heading }}{{ $json.data.sections[0].content }}{{ $json.data.sections[1].heading }}{{ $json.data.sections[1].content }}{{ $json.data.sections[2].heading }}{{ $json.data.sections[2].content }}{{ $json.data.sections[3].heading }}{{ $json.data.sections[3].content }}{{ $json.data.sections[4].heading }}{{ $json.data.sections[4].content }}",
"keywords": "={{ $json.data.keywords.join() }}",
"meta_title": "={{ $json.data.Topic }}",
"row_number": "={{ $json.data.row_number }}",
"meta_description": "={{ $json.data.additional_elements.meta_description }}"
},
"schema": [
{
"id": "Topic",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_generated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "is_generated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "meta_title",
"type": "string",
"display": true,
"required": false,
"displayName": "meta_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "meta_description",
"type": "string",
"display": true,
"required": false,
"displayName": "meta_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keywords",
"type": "string",
"display": true,
"required": false,
"displayName": "keywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "image_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_published",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "is_published",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"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": "Sheet1",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "MyArticles"
}
},
"typeVersion": 4.7
},
{
"id": "c5efa66e-4846-4468-80fc-97eabed55657",
"name": "Generate WordPress Draft",
"type": "n8n-nodes-base.wordpress",
"position": [
300,
335
],
"parameters": {
"title": "={{ $json.title }}",
"additionalFields": {
"status": "draft",
"content": "={{ $json.content }}",
"authorId": 4
}
},
"typeVersion": 1
},
{
"id": "5956316f-3859-4122-8443-aebf27fee08b",
"name": "Produce Featured Image",
"type": "n8n-nodes-base.httpRequest",
"position": [
60,
540
],
"parameters": {
"url": "https://router.huggingface.co/hf-inference/models/black-forest-labs/FLUX.1-schnell",
"method": "POST",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
},
"jsonBody": "={\n  \"inputs\": \"{{ $('Convert Text to JSON').item.json.data.image_prompt }}\"\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "Authorization",
"value": "Bearer [CONFIGURE_YOUR_TOKEN]"
},
{
"name": "Accept",
"value": "image/png"
}
]
}
},
"typeVersion": 4.3
},
{
"id": "e77b9ec4-6ac6-451e-aa4d-c67c805ab65e",
"name": "Fix Image Filename",
"type": "n8n-nodes-base.code",
"position": [
320,
515
],
"parameters": {
"jsCode": "// Fix FLUX binary filename/extension\nconst inputBinary = $input.first().binary.data; // Get FLUX binary\n\nif (inputBinary) {\n  // Override bad FLUX metadata\n  const newItem = {\n    json: $input.first().json, // Keep JSON data\n    binary: {\n      data: {\n        ...inputBinary, // Keep original binary content\n        fileName: 'generated-image.jpg', // Fixed name\n        fileExtension: 'jpg',            // Fixed extension\n        mimeType: 'image/jpeg'           // Fixed MIME\n      }\n    }\n  };\n  return [newItem];\n} else {\n  throw new Error('No binary data found from FLUX');\n}\n"
},
"typeVersion": 2
},
{
"id": "9b582c7e-5863-40f2-b47b-d0bb8573ec64",
"name": "Upload Image to WP Media",
"type": "n8n-nodes-base.httpRequest",
"position": [
580,
545
],
"parameters": {
"url": "=https://your-site.com/wp-json/wp/v2/media",
"method": "POST",
"options": [],
"sendBody": true,
"contentType": "binaryData",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "Content-Disposition",
"value": "=attachment; filename={{$binary.data.fileName}}.{{ $binary.data.fileExtension }}"
},
{
"name": "Content-Type",
"value": "=application/octet-stream"
}
]
},
"inputDataFieldName": "=data",
"nodeCredentialType": "wordpressApi"
},
"typeVersion": 4.3
},
{
"id": "559a37e9-e060-45e3-8d61-397920414ba1",
"name": "Set Featured Media on Post",
"type": "n8n-nodes-base.httpRequest",
"position": [
840,
525
],
"parameters": {
"url": "=https://your-site.com/wp-json/wp/v2/posts/{{ $('Generate WordPress Draft').item.json.id }}",
"method": "PUT",
"options": [],
"jsonBody": "={\n  \"featured_media\": {{ $json.id }}\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "wordpressApi"
},
"typeVersion": 4.3
}
],
"pinData": [],
"connections": {
"Generate WordPress Draft": {
"main": [
[
{
"node": "Produce Featured Image",
"type": "main",
"index": 0
}
]
]
},
"Discover Trending Topics": {
"main": [
[
{
"node": "Pick Clean Trend",
"type": "main",
"index": 0
}
]
]
},
"Append Topic to Sheets": {
"main": [
[
{
"node": "Retrieve Pending Topics",
"type": "main",
"index": 0
}
]
]
},
"Pick Clean Trend": {
"main": [
[
{
"node": "Append Topic to Sheets",
"type": "main",
"index": 0
}
]
]
},
"Upload Image to WP Media": {
"main": [
[
{
"node": "Set Featured Media on Post",
"type": "main",
"index": 0
}
]
]
},
"Manual Workflow Launch": {
"main": [
[
{
"node": "Discover Trending Topics",
"type": "main",
"index": 0
}
]
]
},
"Convert Text to JSON": {
"main": [
[
{
"node": "Update Sheet with Content",
"type": "main",
"index": 0
}
]
]
},
"Fix Image Filename": {
"main": [
[
{
"node": "Upload Image to WP Media",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Pending Topics": {
"main": [
[
{
"node": "Create Content & Image Prompt",
"type": "main",
"index": 0
}
]
]
},
"Update Sheet with Content": {
"main": [
[
{
"node": "Generate WordPress Draft",
"type": "main",
"index": 0
}
]
]
},
"Produce Featured Image": {
"main": [
[
{
"node": "Fix Image Filename",
"type": "main",
"index": 0
}
]
]
},
"Create Content & Image Prompt": {
"main": [
[
{
"node": "Convert Text to JSON",
"type": "main",
"index": 0
}
]
]
}
}
}