January 22, 2026

Perplexity to WordPress, posts published and logged

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your content plan usually doesn’t fail because of “ideas.” It fails because turning an idea into a published post takes too many little steps, and they always land on the same already-full week. Perplexity WordPress automation fixes that.

Marketing managers feel it when “weekly posting” becomes a monthly scramble. A solo founder feels it when publishing slips behind product and sales. And an agency lead? They feel it every time a client asks, “What went live this week?”

This workflow researches a topic, writes the article, generates a featured image, publishes to WordPress, and logs the result in Google Sheets. You’ll see what it does, what you need, and where teams usually tweak it.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Perplexity to WordPress, posts published and logged

Click to explore

flowchart LR

    subgraph sg0["Schedule Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", 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/>Research Topic- Perplexity"]
        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/httprequest.dark.svg' width='40' height='40' /></div><br/>Crear Post en Wordpress"]
        n3@{ icon: "mdi:robot", form: "rounded", label: "Message a model", pos: "b", h: 48 }
        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 Wordpress"]
        n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n6@{ icon: "mdi:cog", form: "rounded", label: "Wait", pos: "b", h: 48 }
        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/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Leonardo Image Status"]
        n8["<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 Leonardo Image"]
        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/httprequest.dark.svg' width='40' height='40' /></div><br/>Agregar ALT a la Imagen"]
        n10@{ icon: "mdi:database", form: "rounded", label: "Publicaciones Wordpress Star..", 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/>Leonardo: Create Post 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/code.svg' width='40' height='40' /></div><br/>Get Title, Content, and Imag.."]
        n5 --> n8
        n5 --> n6
        n6 --> n7
        n3 --> n11
        n0 --> n1
        n8 --> n4
        n9 --> n2
        n2 --> n10
        n7 --> n5
        n4 --> n9
        n1 --> n12
        n11 --> n7
        n12 --> n3
    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 n3 ai
    class n5 decision
    class n10 database
    class n1,n2,n4,n7,n8,n9,n11 api
    class n12 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n4,n7,n8,n9,n11,n12 customIcon

The Problem: Weekly publishing dies in the handoff

Publishing consistently sounds simple until you do the whole chain yourself. You research a topic, collect sources, outline, draft, find an image, rename it, upload it, add alt text, format HTML so it doesn’t break, then finally hit publish. And after that, you still need a place to track what went live, which category it used, and what URL to share. Miss one step and you either ship something sloppy or you delay again. Honestly, it’s the switching between tools that drains you.

It’s rarely one big blocker. The friction compounds.

Topic research gets repeated because last week’s notes are scattered across tabs, docs, and messages.
Formatting and uploading to WordPress takes about 30 minutes per post, even when the writing is already done.
Featured images become a mini-project, which means posts sit “almost ready” for days.
Tracking happens after the fact, so you lose links, categories, and publishing history when you need it most.

The Solution: Perplexity research → AI draft → WordPress publish + Sheets log

This n8n workflow runs on a schedule every Monday morning and builds a complete blog post end-to-end. It starts by calling Perplexity to pull a timely startup topic (and the supporting context you’d normally hunt down manually). Then it extracts the key fields it needs and uses GPT to generate an SEO-friendly article in structured HTML, so WordPress formatting is less of a gamble. Next, it creates an image prompt, requests a cinematic featured image from Leonardo AI, waits until the render is ready, and downloads the final asset. Finally, it uploads the image to WordPress, applies alt text, publishes the post in your chosen category, and logs the URL and metadata into Google Sheets so you have a clean history.

The workflow begins with a weekly CRON trigger. From there, Perplexity + GPT handle the research and writing while Leonardo produces the image in the background. WordPress receives a finished post and Google Sheets becomes your tracking dashboard, automatically.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

A scheduled weekly run that starts your publishing cycle automatically.
Perplexity-based topic research pulled into the workflow via HTTP requests.
GPT-generated article output in structured HTML for WordPress.
Leonardo AI image generation, plus upload and alt text on WordPress.

One publish-ready post per week without the Monday scramble.
About 2 hours back each week that would have gone to formatting, uploading, and image handling.
More consistent SEO cadence because “publish day” isn’t dependent on someone remembering.
A Google Sheets log that doubles as your editorial record and sharing list.
Fewer last-minute errors like missing featured images, broken formatting, or forgotten categories.

Example: What This Looks Like

Say you publish one SEO post every week. Manually, you might spend about 45 minutes researching, about 60 minutes turning a draft into clean WordPress HTML, and another 20 minutes finding or generating an image, uploading it, and setting alt text. That’s roughly 2 hours per post, plus the annoying context switching. With this workflow, you spend about 10 minutes reviewing the draft and tweaking the category or headline, then it publishes and logs the URL automatically.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Perplexity API for topic research and sources
OpenAI API to generate the HTML article
Leonardo AI token (get it from your Leonardo account settings)
WordPress credentials (Basic Auth from your WordPress setup)
Google Sheets access to log published posts

Skill level: Intermediate. You will connect APIs, paste keys, and verify WordPress endpoints, but you won’t be writing an app.

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

How It Works

A weekly schedule triggers the run. Every Monday at 6:00 AM, n8n starts the workflow automatically, so content production isn’t stuck behind meetings or inbox triage.

Perplexity pulls a trend-worthy topic. An HTTP request asks Perplexity for trending startup ideas and returns research context you can build on instead of starting from a blank page.

The workflow turns research into a publishable post. A code step extracts the fields you care about, then GPT generates a structured HTML article. Another AI step creates a strong image prompt, and Leonardo renders the featured image while n8n checks status and waits if it’s not ready yet.

WordPress gets the final assets and Google Sheets gets the record. The workflow uploads the image, applies alt text, publishes the post in your chosen category, then logs key details to a Sheets row so you can track output over time.

You can easily modify the publishing day to match your editorial calendar based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Scheduled Trigger

Set the weekly schedule that starts the pipeline.

Add the Scheduled Automation Start node as your trigger.
Set the cron expression to 0 6 * * 1 in the rule interval to run every Monday at 06:00.
Connect Scheduled Automation Start to Retrieve Topic via Perplexity.

Tip: If you change the cron schedule, keep the format consistent with standard cron syntax to avoid silent misfires.

Step 2: Connect Perplexity for Article Generation

Pull a fresh, structured article in JSON format from Perplexity.

Select the Retrieve Topic via Perplexity node.
Credential Required: Connect your perplexityApi credentials.
Credential Required: Connect your httpHeaderAuth credentials.
Set URL to https://api.perplexity.ai/chat/completions and Method to POST.
Set JSON Body to the provided JSON prompt payload that returns title and content in strict JSON.
Connect Retrieve Topic via Perplexity to Extract Article Fields.

⚠️ Common Pitfall: If the response is not valid JSON, Extract Article Fields will fail to parse it. Ensure the Perplexity prompt enforces strict JSON output.

Step 3: Parse the Article and Generate the Image Prompt

Transform the Perplexity output into structured fields and prepare an editorial image prompt.

Open Extract Article Fields and keep the JavaScript that parses choices[0].message.content and builds image_filename.
Confirm the output fields are title, content, and image_filename.
Open Generate Image Prompt and set the model to gpt-4.1-mini.
Credential Required: Connect your openAiApi credentials.
Ensure the prompt references {{ $json.title }} and {{ $json.content }} to build the image description.
Connect Extract Article Fields to Generate Image Prompt.

Tip: The image prompt should be single-line and output only the prompt text to work reliably with Leonardo.

Step 4: Generate and Retrieve the Leonardo Image

Request the image, poll for completion, and download the final asset.

In Request Leonardo Image, set URL to https://cloud.leonardo.ai/api/rest/v1/generations and keep the JSON body with "prompt": "{{ $json.message.content }}".
Credential Required: Connect your httpBearerAuth credentials in Request Leonardo Image and Check Leonardo Status.
In Check Leonardo Status, set the URL to =https://cloud.leonardo.ai/api/rest/v1/generations/{{ $json.sdGenerationJob.generationId }}.
Configure Status Branch Check to check {{ $json.generations_by_pk.status }} equals COMPLETE.
Ensure Status Branch Check routes to Fetch Leonardo Image when complete, and to Delay Interval when not complete.
Connect Delay Interval back to Check Leonardo Status to create the polling loop.
In Fetch Leonardo Image, set the URL to ={{ $json.generations_by_pk.generated_images[0].url }}.

⚠️ Common Pitfall: If Delay Interval is too short, you may exceed API rate limits during status polling.

Step 5: Publish to WordPress and Log to Sheets

Upload the image, set alt text, publish the post, and record it in Google Sheets.

In Upload Media to WordPress, set URL to https://cristiantala.com/wp-json/wp/v2/media and Content Type to binaryData.
Set the header Content-Disposition to =attachment; filename="{{ $('Extract Article Fields').item.json.image_filename }}" and Content-Type to image/jpeg.
Credential Required: Connect your httpBasicAuth credentials for Upload Media to WordPress, Apply Image Alt Text, and Publish WordPress Post.
In Apply Image Alt Text, set URL to =https://cristiantala.com/wp-json/wp/v2/media/{{ $json.id }} and set alt_text to {{ $('Generate Image Prompt').item.json.message.content }}.
In Publish WordPress Post, set the JSON body to include "title": "{{ $('Extract Article Fields').item.json.title }}", "content": "{{ $('Extract Article Fields').item.json.content }}", "status": "publish", "categories": [916], and "featured_media": {{ $('Upload Media to WordPress').item.json.id }}.
In Log Post to Sheets, set Operation to appendOrUpdate, select the spreadsheet [YOUR_ID], and map columns like URL, Topic, and Fecha del Posteo.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Log Post to Sheets.

Step 6: Test and Activate Your Workflow

Run a manual execution to verify the full pipeline before letting it run on schedule.

Click Execute Workflow and confirm that Retrieve Topic via Perplexity returns JSON with title and content.
Verify Request Leonardo Image and Check Leonardo Status loop until Status Branch Check routes to Fetch Leonardo Image.
Confirm Upload Media to WordPress returns a media id and that Publish WordPress Post returns a published post.
Open the Google Sheet to verify Log Post to Sheets appended or updated the row with the new post URL and image URL.
Toggle the workflow to Active so Scheduled Automation Start runs it automatically every week.

🔒

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 password or Basic Auth settings 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 Perplexity WordPress automation?

About an hour if you already have all API keys.

Do I need coding skills to automate Perplexity WordPress publishing?

No coding required. You’ll mainly connect accounts, paste API keys, and test a manual run.

Is n8n free to use for this Perplexity WordPress 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 Perplexity, OpenAI, and Leonardo API usage costs.

Where can I host n8n to run this Perplexity WordPress 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 Perplexity WordPress automation workflow for Spanish posts?

Yes, but you’ll want to change it in the prompts, not at the end. Update the “Retrieve Topic via Perplexity” request to fetch Spanish-language sources, then adjust the GPT prompt so it writes in Spanish with your preferred tone. If you need Spanish alt text too, keep that instruction in the image/alt-text part of the workflow so it stays consistent. Category IDs in WordPress can also be swapped to route Spanish posts into a dedicated category.

Why is my WordPress connection failing in this workflow?

Usually it’s invalid Basic Auth credentials or an endpoint mismatch. Regenerate your WordPress application password (or confirm Basic Auth is allowed), then update the credentials used in the HTTP requests for media upload and post publishing. Also check that your site blocks XML-RPC/REST requests from unknown IPs, which can silently fail on some hosts. If media uploads work but publishing fails, it’s often a permissions issue for the user role tied to the credentials.

How many posts can this Perplexity WordPress automation handle?

Practically, it can handle as many as your n8n plan and API quotas allow.

Is this Perplexity WordPress automation better than using Zapier or Make?

Often, yes, because this workflow needs waiting, branching, and multi-step HTTP calls that get clunky (and pricey) in simpler tools. n8n handles the Leonardo “check status, wait, retry” loop cleanly, and you can self-host if you want unlimited executions. The trade-off is a bit more setup time up front. If your process is just “take text, create a draft,” Zapier or Make might be fine. If you want the full pipeline with images, publishing, and logging, n8n is a better fit. Talk to an automation expert if you want a quick recommendation based on your stack.

Once this is running, “weekly publishing” stops being a recurring task and becomes a scheduled outcome. The workflow handles the repetitive parts so you can focus on what to say next.

Need Help Setting This Up?

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

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "ec21c3686fce20beb0adb7ed0dea9b51b33164a265698103d2350004f6a9068f",
"templateId": "",
"templateCredsSetupCompleted": null
},
"name": "Automated Blog Publishing Pipeline",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-6067",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1218,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "cc9b1e41-aaeb-43fb-a283-e3faf397cc73",
"name": "Scheduled Automation Start",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
930,
120
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 6 * * 1"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "01d0a3b7-66db-4032-b7d7-7a7b273920a7",
"name": "Retrieve Topic via Perplexity",
"type": "n8n-nodes-base.httpRequest",
"position": [
559,
130
],
"parameters": {
"url": "https://api.perplexity.ai/chat/completions",
"method": "POST",
"options": [],
"jsonBody": "={\n  \"model\": \"sonar-pro\",\n  \"messages\": [\n    {\n      \"role\": \"system\",\n      \"content\": \"Eres un asistente experto en generar art\u00edculos SEO en espa\u00f1ol neutro sobre startups tecnol\u00f3gicas. El tono debe ser educativo, pr\u00e1ctico, reflexivo e inspirador.\"\n    },\n    {\n      \"role\": \"user\",\n      \"content\": \"Redacta un art\u00edculo basado en la tendencia m\u00e1s relevante del ecosistema de startups tecnol\u00f3gicas hispanohablantes del d\u00eda.\\n\\nDevuelve la respuesta estrictamente en formato JSON con esta estructura:\\n{\\n  \\\"title\\\": \\\"[t\u00edtulo atractivo en una sola l\u00ednea]\\\",\\n  \\\"content\\\": \\\"[cuerpo del art\u00edculo en HTML limpio, sin caracteres escapados, sin markdown, sin saltos \\\\n, y sin comentarios externos. Usar solo etiquetas est\u00e1ndar de HTML como <p>, <h2>, <ul>, <li>, <strong> y <em>. No uses etiquetas personalizadas ni scripts.]\\\"\\n}\\n\\nEl art\u00edculo debe:\\n- Tener entre 1000 y 1500 palabras.\\n- Incluir subt\u00edtulos usando <h2>.\\n- Iniciar con un gancho atractivo de m\u00e1ximo 3 frases dentro de <p>.\\n- Incluir al menos 2 datos estad\u00edsticos actuales con fuente (en texto).\\n- Ofrecer m\u00ednimo 3 consejos \u00fatiles, en formato de lista con <ul> y <li>.\\n- Terminar con una reflexi\u00f3n motivadora e invitaci\u00f3n a sumarse a la comunidad (sin enlaces).\\n- Usar naturalmente palabras clave como: startups tecnol\u00f3gicas, innovaci\u00f3n, emprendimiento, inversi\u00f3n, comunidad.\\n\\nNo agregues ning\u00fan texto ni explicaci\u00f3n fuera del objeto JSON.\"\n    }\n  ]\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "perplexityApi"
},
"credentials": {
"perplexityApi": {
"id": "credential-id",
"name": ""
},
"httpHeaderAuth": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "c8e83410-b334-4c2e-8095-0d424dd8455f",
"name": "Extract Article Fields",
"type": "n8n-nodes-base.code",
"position": [
299,
135
],
"parameters": {
"jsCode": "const data = JSON.parse($input.first().json.choices[0].message.content);\n\n// Funci\u00f3n para generar slug SEO-friendly\nfunction toSlug(text) {\n  return text\n    .toLowerCase()\n    .normalize(\"NFD\")                   // elimina acentos\n    .replace(/[\\u0300-\\u036f]/g, \"\")   // elimina diacr\u00edticos\n    .replace(/[^a-z0-9\\s-]/g, \"\")      // elimina caracteres especiales\n    .replace(/\\s+/g, \"-\")              // reemplaza espacios por guiones\n    .replace(/-+/g, \"-\")               // evita guiones dobles\n    .replace(/^-|-$/g, \"\");            // quita guiones iniciales y finales\n}\n\nconst imageName = toSlug(data.title) + \".jpg\";\n\nreturn [\n  {\n    json: {\n      title: data.title,\n      content: data.content,\n      image_filename: imageName\n    }\n  }\n];\n"
},
"typeVersion": 2
},
{
"id": "b306aff7-c8b0-4bf7-9eb1-d8eeee45da6e",
"name": "Generate Image Prompt",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
0,
125
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": [],
"messages": {
"values": [
{
"content": "=Generate a single-line English description of an editorial-style image to visually represent the following article.\n\nThe image must follow these rules:\n- Cinematic, editorial look (not cartoonish or abstract).\n- No visible text or logos.\n- Must work for a blog post featured image in Google News and Discover (ideal size: 1200x628 px).\n- The article title is: \"{{ $json.title }}\"\n- Article content: {{ $json.content }}.\n\nOutput just the English prompt, without quotes or formatting."
},
{
"role": "system",
"content": "You are an expert in crafting AI image generation prompts for editorial and news images. You help generate cinematic, editorial-style prompts for blog images that perform well in Google News and Google Discover. Avoid any text or logos in the result."
}
]
}
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "ce87f8ee-3d53-462c-9df5-921fdc42d17c",
"name": "Request Leonardo Image",
"type": "n8n-nodes-base.httpRequest",
"position": [
65,
320
],
"parameters": {
"url": "https://cloud.leonardo.ai/api/rest/v1/generations",
"method": "POST",
"options": [],
"jsonBody": "={\n  \"prompt\": \"{{ $json.message.content }}\",\n  \"modelId\": \"6bef9f1b-29cb-40c7-b9df-32b51c1f67d3\",\n  \"width\": 1280,\n  \"height\": 720,\n  \"sd_version\": \"v2\",\n  \"num_images\": 1,\n  \"promptMagic\": true,\n  \"promptMagicStrength\": 0.5,\n  \"public\": false,\n  \"scheduler\": \"LEONARDO\",\n  \"guidance_scale\": 7\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBearerAuth",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpBearerAuth": {
"id": "credential-id",
"name": ""
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "072b61c5-7494-42cd-808f-bb311605f4a3",
"name": "Check Leonardo Status",
"type": "n8n-nodes-base.httpRequest",
"position": [
364,
355
],
"parameters": {
"url": "=https://cloud.leonardo.ai/api/rest/v1/generations/{{ $json.sdGenerationJob.generationId }}",
"options": [],
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpBearerAuth",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpBearerAuth": {
"id": "credential-id",
"name": ""
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "bd779c40-a90d-4412-935a-7adc30e431fc",
"name": "Status Branch Check",
"type": "n8n-nodes-base.if",
"position": [
611,
330
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "132de601-8ca1-46b4-9ae3-67baa33f28ad",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.generations_by_pk.status }}",
"rightValue": "COMPLETE"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "24b8ff73-0eff-41ce-b99b-27d4210838ac",
"name": "Delay Interval",
"type": "n8n-nodes-base.wait",
"position": [
852,
370
],
"webhookId": "d14af83a-15dc-4387-adf9-0f8b785faa0c",
"parameters": [],
"typeVersion": 1.1
},
{
"id": "da14ecc4-ca0f-445e-9c87-0148a602bfc2",
"name": "Fetch Leonardo Image",
"type": "n8n-nodes-base.httpRequest",
"position": [
1118,
600
],
"parameters": {
"url": "={{ $json.generations_by_pk.generated_images[0].url }}",
"options": []
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "e3786cd7-baac-4e9e-bd45-63ec3b5cfd5e",
"name": "Upload Media to WordPress",
"type": "n8n-nodes-base.httpRequest",
"position": [
845,
550
],
"parameters": {
"url": "https://cristiantala.com/wp-json/wp/v2/media",
"method": "POST",
"options": [],
"sendBody": true,
"contentType": "binaryData",
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"headerParameters": {
"parameters": [
{
"name": "Content-Disposition",
"value": "=attachment; filename=\"{{ $('Extract Article Fields').item.json.image_filename }}\""
},
{
"name": "Content-Type",
"value": "image/jpeg"
}
]
},
"inputDataFieldName": "data"
},
"credentials": {
"httpBasicAuth": {
"id": "credential-id",
"name": ""
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "02b052f2-0771-42b3-b4e8-526375654118",
"name": "Apply Image Alt Text",
"type": "n8n-nodes-base.httpRequest",
"position": [
559,
595
],
"parameters": {
"url": "=https://cristiantala.com/wp-json/wp/v2/media/{{ $json.id }}",
"method": "PUT",
"options": [],
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "alt_text",
"value": "={{ $('Generate Image Prompt').item.json.message.content }}"
}
]
},
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "credential-id",
"name": ""
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "f70d8187-0f57-4680-8155-420d060536f0",
"name": "Publish WordPress Post",
"type": "n8n-nodes-base.httpRequest",
"position": [
312,
555
],
"parameters": {
"url": "https://cristiantala.com/wp-json/wp/v2/posts",
"method": "POST",
"options": [],
"jsonBody": "={\n  \"title\": \"{{ $('Extract Article Fields').item.json.title }}\",\n  \"content\": \"{{ $('Extract Article Fields').item.json.content }}\",\n  \"status\": \"publish\",\n  \"categories\": [\n    916\n  ],\n  \"featured_media\": {{ $('Upload Media to WordPress').item.json.id }}\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth"
},
"credentials": {
"httpBasicAuth": {
"id": "credential-id",
"name": ""
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "07078bdd-6d8e-485e-9581-e359361feba9",
"name": "Log Post to Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
65,
610
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.guid.raw }}",
"Tipo": "Post WP",
"Topic": "={{ $json.title.rendered }}",
"Status": "Posted",
"URL Imagen": "={{ $('Upload Media to WordPress').item.json.guid.rendered }}",
"Contenido AI": "={{ $json.content.raw }}",
"Fecha del Posteo": "={{ $json.date }}"
},
"schema": [
{
"id": "Topic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tipo",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Tipo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contenido AI",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Contenido AI",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Fecha del Posteo",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Fecha del Posteo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL Imagen",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL Imagen",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Topic"
],
"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": "Hoja 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "Publicaciones RRSS"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
}
],
"active": true,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Status Branch Check": {
"main": [
[
{
"node": "Fetch Leonardo Image",
"type": "main",
"index": 0
}
],
[
{
"node": "Delay Interval",
"type": "main",
"index": 0
}
]
]
},
"Delay Interval": {
"main": [
[
{
"node": "Check Leonardo Status",
"type": "main",
"index": 0
}
]
]
},
"Generate Image Prompt": {
"main": [
[
{
"node": "Request Leonardo Image",
"type": "main",
"index": 0
}
]
]
},
"Scheduled Automation Start": {
"main": [
[
{
"node": "Retrieve Topic via Perplexity",
"type": "main",
"index": 0
}
]
]
},
"Fetch Leonardo Image": {
"main": [
[
{
"node": "Upload Media to WordPress",
"type": "main",
"index": 0
}
]
]
},
"Apply Image Alt Text": {
"main": [
[
{
"node": "Publish WordPress Post",
"type": "main",
"index": 0
}
]
]
},
"Publish WordPress Post": {
"main": [
[
{
"node": "Log Post to Sheets",
"type": "main",
"index": 0
}
]
]
},
"Check Leonardo Status": {
"main": [
[
{
"node": "Status Branch Check",
"type": "main",
"index": 0
}
]
]
},
"Upload Media to WordPress": {
"main": [
[
{
"node": "Apply Image Alt Text",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Topic via Perplexity": {
"main": [
[
{
"node": "Extract Article Fields",
"type": "main",
"index": 0
}
]
]
},
"Request Leonardo Image": {
"main": [
[
{
"node": "Check Leonardo Status",
"type": "main",
"index": 0
}
]
]
},
"Extract Article Fields": {
"main": [
[
{
"node": "Generate Image Prompt",
"type": "main",
"index": 0
}
]
]
}
}
}