This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "YOUR_WORKFLOW_ID",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Automated Content Generation & Publishing - Wordpress",
"tags": [],
"nodes": [
{
"id": "9cd63357-19dc-4420-baa9-1e1389c7120f",
"name": "Create posts on Wordpress",
"type": "n8n-nodes-base.wordpress",
"position": [
1180,
280
],
"parameters": {
"title": "={{ $('Save to Sheet').item.json['title'] }}",
"additionalFields": {
"status": "publish",
"content": "=<img src=\"{{ $('Automated Image Retrieval from Pexels').item.json.photos[0].src.landscape }}\" alt=\"image text\" style=\"width:100%; height:auto;\"><br><br>\n<br><br>\n{{ $node['Save to Sheet'].json['content'] }}"
}
},
"credentials": {
"wordpressApi": {
"name": "<your credential>"
}
},
"typeVersion": 1,
"alwaysOutputData": false
},
{
"id": "65f62f19-d10f-4ca1-a853-9cedb3506743",
"name": "Processing Delay",
"type": "n8n-nodes-base.code",
"position": [
180,
580
],
"parameters": {
"jsCode": "const delay = Math.floor(Math.random() * (6 * 60 * 60 * 1000)); // random delay 0-6 hour\nreturn {\n json: {\n delay: delay,\n delay_minutes: Math.round(delay / 60000), // to minutes\n delay_hours: (delay / 3600000).toFixed(2) // to hours\n }\n};\n"
},
"typeVersion": 2
},
{
"id": "193d2876-c50e-4b9e-8856-9fd11baa025e",
"name": "Random Wait",
"type": "n8n-nodes-base.wait",
"position": [
180,
760
],
"parameters": {
"amount": "={{$json[\"delay\"] / 1000}}"
},
"typeVersion": 1.1
},
{
"id": "cf510c21-7c19-4e84-a43a-62d170277cdf",
"name": "Save to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
780,
280
],
"parameters": {
"columns": {
"value": {
"title": "={{ $json.message.content.title }}",
"content": "={{ $json.message.content.content }}",
"Image search keyword": "={{ $json.message.content.keywords.join(\"+\") }}"
},
"schema": [
{
"id": "title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "content",
"type": "string",
"display": true,
"required": false,
"displayName": "content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image search keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Image search keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": []
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "YOURDOCUMENT_URL"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "1778f649-c09e-4ef9-b153-4160eed6805c",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-220,
0
],
"parameters": {
"width": 607.503259452412,
"height": 892.7656453715782,
"content": "## Automated Article Scheduling\n\n**1. Fast Bulk Article Generation**\nQuickly create multiple AI-generated articles.\nEfficiently streamline content creation.\nReduces manual effort while maintaining quality.\n\n**2. Workflow Testing Before Execution**\nManually test the workflow for debugging.\nEnsure each step runs as expected.\nOptimize before full automation.\n\n**3. Automated & Randomized Publishing**\nSchedule posts at predefined intervals.\nIntroduce random delays for a natural posting pattern.\nPrevents overly predictable publishing behavior."
},
"typeVersion": 1
},
{
"id": "6f385e8c-b3e6-4456-9738-e85ea2cbbea1",
"name": "1. Auto Start",
"type": "n8n-nodes-base.scheduleTrigger",
"disabled": true,
"position": [
180,
20
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes",
"minutesInterval": 1
}
]
}
},
"typeVersion": 1.2
},
{
"id": "6d7712e8-9033-453b-ad52-09f718bcb701",
"name": "2. When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"disabled": true,
"position": [
180,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0fd8fe8f-a0d5-42d9-b728-53340c6e4233",
"name": "3. Schedule Your Posts",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
180,
380
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
2,
4,
0
],
"triggerAtHour": "={{ 12 }}"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "16c26c36-fb8e-4903-a64c-57803fac83b9",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
440
],
"parameters": {
"width": 351.77682676671327,
"height": 271.4285686334568,
"content": "## AI Content Generating\n\n**Automatic Content & Keyword Generation\n\n- Use your own prompt to start\n- ChatGPT generates full-length articles with structured headings.\n- Extracts relevant image search keywords for visual enhancement.\n- To implement this, add the following prompt (green note) below your workflow:\n"
},
"typeVersion": 1
},
{
"id": "921173fb-ae10-4f88-a1ab-15f063cd623f",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
740
],
"parameters": {
"color": 4,
"width": 349.47344203333904,
"height": 1277.4269457977707,
"content": "(YOUR PROMPT)\n\n**Image Search Keywords (For Visual Alignment)**\n\n- Automatically generates 3-5 English keywords for image searches based on the article content.\n- Keywords should be specific objects, locations, or atmospheres rather than abstract concepts.\n\n**Article Formatting Requirements**\n\n1\ufe0f\u20e3 Title (H1): Ensure unique and trend-driven headlines.\n2\ufe0f\u20e3 H2 / H3 Subheadings: Structure content in an SEO-optimized format.\n3\ufe0f\u20e3 Article Structure (Enhanced Readability)\n\n** Introduction **\n- Go straight to the point, avoiding excessive background.\n- Use question hooks or market trend data to engage readers.\n\n** Core Content **\n- Include at least three knowledge points to ensure depth.\n- Balance short and long sentences for better flow.\n\n** Conclusion **\n- Avoid generic AI-style summaries; instead, provide insights or actionable takeaways.\n- Optionally include a CTA (Call to Action).\n\n** HTML Formatting **\nEnsure the article is properly structured in HTML format:\n- Headings: Use <h1>, <h2>, <h3> appropriately.\n- Paragraphs: Enclose text within <p>.\n- Emphasized Words: Use <strong> to highlight key terms.\n- Lists: Use <ul> and <li> for bullet points.\n\nEnsure a clean, well-structured output instead of plain text.\n\n### **Final JSON Format\nEnsure the output follows this structure:\n\n{\n \"title\": \"{Generate an H1 title that aligns with market trends, ensures high click-through rates, and follows keyword strategy}\",\n \"content\": \"{Generate a complete HTML article including H1, H2, H3 headings, paragraphs, lists, etc.}\",\n \"keywords\": [\"{Image search keyword 1}\", \"{Image search keyword 2}\", \"{Image search keyword 3}\", \"{Image search keyword 4}\", \"{Image search keyword 5}\"]\n}"
},
"typeVersion": 1
},
{
"id": "364b1ee1-4685-4b10-b988-1704dc65592b",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
440
],
"parameters": {
"width": 367.1064142931126,
"height": 267.17005729996885,
"content": "## Google Sheet Setting\n**You need to set up these in your sheet column** \n- title\n- content\n- image search keyword\n\n**Mapping \"Values to Send\"**\n- {{ $json.message.content.title }}\n- {{ $json.message.content.content }}\n- {{ $json.message.content.keywords.join(\"+\") }}"
},
"typeVersion": 1
},
{
"id": "26876b53-aa27-4e16-991e-c3618e751c17",
"name": "Automated Image Retrieval from Pexels",
"type": "n8n-nodes-base.httpRequest",
"position": [
980,
280
],
"parameters": {
"url": "=https://api.pexels.com/v1/search?per_page=1&orientation=landscape&query={{ $json[\"Image search keyword\"] }}\n",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "query",
"value": "={{ $json['Image search keyword'] }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "YOUR_PEXELS_API_KEY"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "769638be-ee38-4e40-a508-f998b09ce1f4",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-220,
-240
],
"parameters": {
"color": 3,
"width": 608.0701163493336,
"height": 211.65896369815192,
"content": "## Introduction: WordPress automatically publishes posts and inserts the first image\n\nIt is **highly recommended to install the Featured Image from URL (FIFU) plugin** and enable:\n\n**Auto > Set Featured Media Automatically from Content.** before you generate contents."
},
"typeVersion": 1
},
{
"id": "37f3606f-f110-49d2-bcf5-1edc27149fee",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
229.99235545929986
],
"parameters": {
"width": 348.08256103956126,
"height": 170.00764454070014,
"content": "Add your API credential"
},
"typeVersion": 1
},
{
"id": "2399a40d-4b79-400c-9e96-df7e683fd666",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
228.00611563256007
],
"parameters": {
"width": 150,
"height": 170.00764454070008,
"content": "Add your API credential"
},
"typeVersion": 1
},
{
"id": "45e479a6-2eea-44a1-9096-9895a18904fd",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
226.01987580582022
],
"parameters": {
"width": 201.97095074533956,
"height": 172.00917344884022,
"content": "Add your API credential"
},
"typeVersion": 1
},
{
"id": "e0489552-a7b5-4161-9553-95e23605a9d5",
"name": "Generate AI Content",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
440,
280
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"options": {},
"messages": {
"values": [
{
"content": "(YOUR PROMPT)\n(YOUR PROMPT)\n\n**Image Search Keywords (For Visual Alignment)**\n\n- Automatically generates 3-5 English keywords for image searches based on the article content.\n- Keywords should be specific objects, locations, or atmospheres rather than abstract concepts.\n\n**Article Formatting Requirements**\n\n1\ufe0f\u20e3 Title (H1): Ensure unique and trend-driven headlines.\n2\ufe0f\u20e3 H2 / H3 Subheadings: Structure content in an SEO-optimized format.\n3\ufe0f\u20e3 Article Structure (Enhanced Readability)\n\n** Introduction **\n- Go straight to the point, avoiding excessive background.\n- Use question hooks or market trend data to engage readers.\n\n** Core Content **\n- Include at least three knowledge points to ensure depth.\n- Balance short and long sentences for better flow.\n\n** Conclusion **\n- Avoid generic AI-style summaries; instead, provide insights or actionable takeaways.\n- Optionally include a CTA (Call to Action).\n\n** HTML Formatting **\nEnsure the article is properly structured in HTML format:\n- Headings: Use <h1>, <h2>, <h3> appropriately.\n- Paragraphs: Enclose text within <p>.\n- Emphasized Words: Use <strong> to highlight key terms.\n- Lists: Use <ul> and <li> for bullet points.\n\nEnsure a clean, well-structured output instead of plain text.\n\n### **Final JSON Format\nEnsure the output follows this structure:\n\n{\n \"title\": \"{Generate an H1 title that aligns with market trends, ensures high click-through rates, and follows keyword strategy}\",\n \"content\": \"{Generate a complete HTML article including H1, H2, H3 headings, paragraphs, lists, etc.}\",\n \"keywords\": [\"{Image search keyword 1}\", \"{Image search keyword 2}\", \"{Image search keyword 3}\", \"{Image search keyword 4}\", \"{Image search keyword 5}\"]\n}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.6
}
],
"active": false,
"settings": {
"timezone": "Asia/Taipei",
"callerPolicy": "workflowsFromSameOwner",
"executionOrder": "v1",
"executionTimeout": -1,
"saveManualExecutions": true
},
"versionId": "YOUR_VERSION_ID",
"connections": {
"Random Wait": {
"main": [
[
{
"node": "Generate AI Content",
"type": "main",
"index": 0
}
]
]
},
"Save to Sheet": {
"main": [
[
{
"node": "Automated Image Retrieval from Pexels",
"type": "main",
"index": 0
}
]
]
},
"Processing Delay": {
"main": [
[
{
"node": "Random Wait",
"type": "main",
"index": 0
}
]
]
},
"Generate AI Content": {
"main": [
[
{
"node": "Save to Sheet",
"type": "main",
"index": 0
}
]
]
},
"3. Schedule Your Posts": {
"main": [
[
{
"node": "Processing Delay",
"type": "main",
"index": 0
}
]
]
},
"Automated Image Retrieval from Pexels": {
"main": [
[
{
"node": "Create posts on Wordpress",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApiopenAiApiwordpressApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
Streamline your content creation by automatically generating and publishing blog posts to WordPress, saving hours of manual effort and ensuring consistent output for busy marketers or bloggers. This workflow leverages OpenAI to craft engaging articles from prompts stored in Google Sheets, then seamlessly posts them to your site while logging details for easy tracking. The key step involves the AI node intelligently producing tailored content before the WordPress integration handles the publishing, making it ideal for scaling your online presence without constant oversight.
Use this workflow when you need regular, hands-off content updates, such as weekly blog schedules or seasonal promotions, especially if you're managing multiple sites. Avoid it for one-off posts requiring heavy customisation or when real-time approvals are essential, as it's designed for automated batches. Common variations include swapping OpenAI for another AI tool or adding email notifications post-publishing to alert your team.
About this workflow
Automated Content Generation & Publishing - Wordpress. Uses wordpress, googleSheets, stickyNote, scheduleTrigger. Scheduled trigger; 17 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Description: This workflow fully automates your blog publishing process using n8n, AI, and WordPress. It pulls blog data from Google Sheets, generates SEO-optimized content with AI, creates feature im
XML, WordPress, Google Sheets +4
Automatically convert your WordPress articles into multilingual voiceovers with professional-quality audio. Want to add audio versions of your WordPress posts? Looking for a workflow that is fully aut
WordPress, Google Sheets, OpenAI +2
This workflow provides complete blog automation from trend detection to publication. It eliminates manual content research, writing, and publishing by using AI agents, Google Trends analysis, and Word
HTTP Request, OpenAI, Google Sheets +1
This n8n workflow automates the entire process of content generation, image selection, and scheduled publishing to a self-hosted WordPress website. It is designed for bloggers, marketers, and business
WordPress, Google Sheets, HTTP Request +1
Automated Content Generation & Publishing - Wordpress. Uses wordpress, googleSheets, httpRequest, openAi. Scheduled trigger; 17 nodes.
WordPress, Google Sheets, HTTP Request +1