This workflow corresponds to n8n.io template #8356 — we link there as the canonical source.
This workflow follows the Chainllm → Google Sheets 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 →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "e747e3a1-c579-45cf-90a3-ce1eca7bcbcd",
"name": "Create a post",
"type": "n8n-nodes-base.wordpress",
"position": [
4224,
3048
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a7b69718-35eb-407d-af24-8353aa262d49",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
384,
3048
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c6ca0aa3-bd60-44d9-8915-9e9b038837cc",
"name": "Google Gemini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
616,
3272
],
"parameters": {},
"typeVersion": 1
},
{
"id": "10e96f6d-ffa9-4931-99d5-3f239ebeafce",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
744,
3272
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "393f36da-77d1-4691-bed5-645823c65875",
"name": "Google Gemini Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2760,
3272
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d4bcb587-56fd-4a16-8da7-1e1e34fc505f",
"name": "Structured Output Parser1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2888,
3272
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "d84285a1-5794-4e5b-971b-7e129a81ec29",
"name": "Upload Media to Wordpress",
"type": "n8n-nodes-base.httpRequest",
"position": [
4000,
3048
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "e2e139fd-1d9e-4f0d-afca-ab6bb6660702",
"name": "Get Existing Categories",
"type": "n8n-nodes-base.httpRequest",
"position": [
2080,
3048
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2110baac-ad2a-439a-9676-1bfc87e89e80",
"name": "If1",
"type": "n8n-nodes-base.if",
"position": [
3328,
3048
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "e0d9bc92-c6c0-4b42-a238-a27447b521aa",
"name": "Create Category in Wordpress",
"type": "n8n-nodes-base.httpRequest",
"position": [
3552,
3120
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "68a44727-00d0-4ffd-b11a-8d4554f4c9e5",
"name": "Get Articles on Topics",
"type": "n8n-nodes-base.httpRequest",
"position": [
960,
2976
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "65f4b4e2-2a9b-4c6a-ad82-b53b07b684e8",
"name": "URLs Extractor",
"type": "n8n-nodes-base.code",
"position": [
1408,
2976
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0e5e2dd1-3b7a-4172-ba3b-009582d723b2",
"name": "Confirm Article to Confirm",
"type": "n8n-nodes-base.telegram",
"position": [
1632,
2976
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "59b363e1-65cf-4de3-8195-4a8eb5348afe",
"name": "If Article Not None",
"type": "n8n-nodes-base.if",
"position": [
1856,
3048
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "8207e110-6077-4df9-b8e3-2aba2956b8b5",
"name": "Aggregate Categories",
"type": "n8n-nodes-base.aggregate",
"position": [
2304,
3048
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7b9cd83a-8cfd-4db9-a336-9fede02362d1",
"name": "Generate an Image Gemini",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
3776,
3048
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8bd77619-d80c-4bb7-9c9e-4304b2b7d346",
"name": "Generate an Image OpenAI",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
3776,
2816
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "d15e4afe-9d26-4ecb-a301-a86a841ef5c6",
"name": "Final Telegram Message",
"type": "n8n-nodes-base.telegram",
"position": [
5792,
3048
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "5745c673-75ce-4b52-9722-a11430b9dc31",
"name": "Change the Author",
"type": "n8n-nodes-base.httpRequest",
"position": [
4896,
3048
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f1f2a2d1-2ccf-4b3f-9945-57920beba6bf",
"name": "Add Excerpt on the Post",
"type": "n8n-nodes-base.httpRequest",
"position": [
4448,
3048
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7cc5bf92-cb01-49a9-b81d-aeac023c708a",
"name": "Add the Featured Media on Post",
"type": "n8n-nodes-base.httpRequest",
"position": [
4672,
3048
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2b1d872b-ac15-4d09-9878-121b6f0ace6c",
"name": "Get Formatted Date & Time",
"type": "n8n-nodes-base.code",
"position": [
5120,
3048
],
"parameters": {},
"typeVersion": 2
},
{
"id": "37f5fa97-b4b4-4f5b-aff1-e0dc91a440ed",
"name": "Structure for the Post Content",
"type": "n8n-nodes-base.set",
"position": [
5344,
3048
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c6c4f627-a4ea-47c4-ad60-a6b0922e54f4",
"name": "Append Post Data in the Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
5568,
3048
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "1c0e6c33-af52-49b7-b360-c6a3e0b9a2f3",
"name": "Generate the Topic using LLM",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
608,
3048
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "60b4ff17-a30a-4356-8b11-3092bee18c9a",
"name": "Write Content for the Post",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
2752,
3048
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.7
},
{
"id": "c1dcd79d-6bf9-4126-82b9-742ae9f152af",
"name": "Structure Selected Post",
"type": "n8n-nodes-base.set",
"position": [
2528,
3048
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d2dece02-38e4-412b-bd41-dce313b35183",
"name": "Structure Tavily Results",
"type": "n8n-nodes-base.set",
"position": [
1184,
2976
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "921c88fe-1d56-4fae-8cb9-55ba325a1ea5",
"name": "Structure Post Content",
"type": "n8n-nodes-base.set",
"position": [
3104,
3048
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4b120cc5-79a6-436d-af9a-4a1133be97d6",
"name": "Get All the Users",
"type": "n8n-nodes-base.httpRequest",
"position": [
4896,
2832
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "c0c4928b-c9e5-4263-845c-26bfe3a3fa34",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-176,
2912
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2dc43d23-9ee0-4acc-9c56-55df5cd9396f",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
608,
2720
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "588909f8-e45b-4a5c-9c85-b418d96e46cf",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
2768
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e67a4163-20c1-43a4-940d-e1b8fc6d68c9",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2368,
2816
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5ff37c0b-5713-472f-82b4-4adf5dacdb53",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3392,
2848
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1e9740b2-03ec-4a9b-a17b-5f6d62cadd74",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
4256,
2800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "678fbffe-6014-4505-afed-3e292cbbf122",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
5504,
2848
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "01fb5fd8-8c53-48c7-824a-72ea469f2217",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-368,
2352
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"connections": {
"If1": {
"main": [
[
{
"node": "Generate an Image Gemini",
"type": "main",
"index": 0
}
],
[
{
"node": "Create Category in Wordpress",
"type": "main",
"index": 0
}
]
]
},
"Create a post": {
"main": [
[
{
"node": "Add Excerpt on the Post",
"type": "main",
"index": 0
}
]
]
},
"URLs Extractor": {
"main": [
[
{
"node": "Confirm Article to Confirm",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Generate the Topic using LLM",
"type": "main",
"index": 0
}
]
]
},
"Change the Author": {
"main": [
[
{
"node": "Get Formatted Date & Time",
"type": "main",
"index": 0
}
]
]
},
"If Article Not None": {
"main": [
[
{
"node": "Get Existing Categories",
"type": "main",
"index": 0
}
],
[
{
"node": "Generate the Topic using LLM",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Categories": {
"main": [
[
{
"node": "Structure Selected Post",
"type": "main",
"index": 0
}
]
]
},
"Final Telegram Message": {
"main": [
[]
]
},
"Get Articles on Topics": {
"main": [
[
{
"node": "Structure Tavily Results",
"type": "main",
"index": 0
}
]
]
},
"Structure Post Content": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Add Excerpt on the Post": {
"main": [
[
{
"node": "Add the Featured Media on Post",
"type": "main",
"index": 0
}
]
]
},
"Get Existing Categories": {
"main": [
[
{
"node": "Aggregate Categories",
"type": "main",
"index": 0
}
]
]
},
"Structure Selected Post": {
"main": [
[
{
"node": "Write Content for the Post",
"type": "main",
"index": 0
}
]
]
},
"Generate an Image Gemini": {
"main": [
[
{
"node": "Upload Media to Wordpress",
"type": "main",
"index": 0
}
]
]
},
"Generate an Image OpenAI": {
"main": [
[]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Generate the Topic using LLM",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structure Tavily Results": {
"main": [
[
{
"node": "URLs Extractor",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Generate the Topic using LLM",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Get Formatted Date & Time": {
"main": [
[
{
"node": "Structure for the Post Content",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model1": {
"ai_languageModel": [
[
{
"node": "Write Content for the Post",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "Write Content for the Post",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Upload Media to Wordpress": {
"main": [
[
{
"node": "Create a post",
"type": "main",
"index": 0
}
]
]
},
"Confirm Article to Confirm": {
"main": [
[
{
"node": "If Article Not None",
"type": "main",
"index": 0
}
]
]
},
"Write Content for the Post": {
"main": [
[
{
"node": "Structure Post Content",
"type": "main",
"index": 0
}
]
]
},
"Create Category in Wordpress": {
"main": [
[
{
"node": "Generate an Image Gemini",
"type": "main",
"index": 0
}
]
]
},
"Generate the Topic using LLM": {
"main": [
[
{
"node": "Get Articles on Topics",
"type": "main",
"index": 0
}
]
]
},
"Append Post Data in the Sheet": {
"main": [
[
{
"node": "Final Telegram Message",
"type": "main",
"index": 0
}
]
]
},
"Add the Featured Media on Post": {
"main": [
[
{
"node": "Change the Author",
"type": "main",
"index": 0
}
]
]
},
"Structure for the Post Content": {
"main": [
[
{
"node": "Append Post Data in the Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Effortlessly generate, review, and publish SEO-optimized blog posts to WordPress using AI and automation.
Source: https://n8n.io/workflows/8356/ — 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.
Most blogs publish words. This system publishes experiences.
Automate Blog Creation and Publishing with Ultra-Low Cost AI
Complete PostgreSQL-backed system: Keyword scoring → AI research → Multi-part content generation → fal.ai Nano Banana image generation → WordPress publishing
This workflow is for beauty salons who want consistent, high‑quality social media content without writing every post manually. It also suits agencies and automation builders who manage multiple beauty
This automation is designed to help you generate AI-powered music tracks, cover art, and fully rendered music videos — all triggered from a simple Telegram chat and managed via Google Sheets.