AutomationFlowsAI & RAG › Create Weekly AI Wordpress Posts with Images From Sharepoint Topics

Create Weekly AI Wordpress Posts with Images From Sharepoint Topics

ByAI Solutions @legalgpts on n8n.io

This workflow automatically generates and publishes a full-length, SEO-optimized WordPress article on a weekly schedule. Topics are sourced from a SharePoint list. The AI agent writes the article body with embedded inline images, generates a separate featured (hero) image,…

Cron / scheduled trigger★★★★☆ complexityAI-powered27 nodesMicrosoft SharePointHTTP RequestOpenAIOpenAI ChatAgentTool WorkflowWordPressGoogle Gemini
AI & RAG Trigger: Cron / scheduled Nodes: 27 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #15102 — we link there as the canonical source.

This workflow follows the Agent → Googlegemini 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 →

Download .json
{
  "id": "czU12zlkh6Nc4aYI",
  "name": "WordPress Blog with Images - Sharepoint",
  "tags": [],
  "nodes": [
    {
      "id": "3c4f5fb3-bbe2-41de-8aa2-320cff83942a",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -208,
        16
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "6cba9c0a-b5d8-4975-84a7-6f9c23c0b0ac",
      "name": "Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -896,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3971f95a-f6d6-491b-8026-071d0210deb1",
      "name": "Section \u2014 Topic Source",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "aefdf36a-41bc-46c5-bacc-5b449f6ac462",
      "name": "Section \u2014 Category Matching",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8f32d82c-1eb7-41a0-8ba5-b4a3a2dc0131",
      "name": "Section \u2014 Article Generation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6e1a74c2-5007-4d0f-b348-5b2d9e31615f",
      "name": "Section \u2014 WP Publishing",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1664,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "271a4ac9-67f4-4f92-886f-21f35c76569e",
      "name": "Section \u2014 Notification",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2736,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "90451459-52fb-45f7-a7e0-a23a8d508ced",
      "name": "Warning \u2014 Community Nodes",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        368
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e0aad4c8-0e23-4f37-8f78-ae1e06b91f3b",
      "name": "Get Topics",
      "type": "n8n-nodes-base.microsoftSharePoint",
      "position": [
        -48,
        16
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c21a2731-2f3b-446d-a858-ef7c1ba24630",
      "name": "Fetch WP Categories",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        160,
        16
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "8413e88f-c8dd-4c97-a58d-0f929c63cf59",
      "name": "Format Categories",
      "type": "n8n-nodes-base.code",
      "position": [
        336,
        16
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "ed54cf93-94ce-47d9-ace4-f4a4a821ed05",
      "name": "Match Categories AI",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        464,
        16
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "47f655f9-23a3-41db-b022-550a033d0c61",
      "name": "Parse Category IDs",
      "type": "n8n-nodes-base.set",
      "position": [
        720,
        16
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "47c97023-3639-47b5-8f2e-2912bdf0ec45",
      "name": "LM \u2014 Article Writer",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        944,
        176
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "6c6ea83f-8a85-49fe-9fce-69cc7b4e8c0e",
      "name": "Write Article",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        944,
        16
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "55d512a6-d030-46db-b032-96ae1ee98ec3",
      "name": "Generate and Upload Image",
      "type": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "position": [
        1152,
        208
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "cd9ccf3e-c500-4bae-8c41-e72245f0d6e2",
      "name": "Strip Code Fences",
      "type": "n8n-nodes-base.code",
      "position": [
        1248,
        16
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "bde0f262-3c1a-483c-a22e-8a4e439d30ae",
      "name": "LM \u2014 Title Generator",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1344,
        192
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "d8e74803-ba74-4925-bfcf-4c4d9ddfa95d",
      "name": "Generate Title",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1392,
        16
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "dbf629ae-6b4a-4aab-9540-c34c5881386a",
      "name": "Add Draft to WP",
      "type": "n8n-nodes-base.wordpress",
      "position": [
        1696,
        16
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a3948891-7cdf-4357-aef0-bcdf5b66434f",
      "name": "Build Feature Image Prompt",
      "type": "n8n-nodes-base.set",
      "position": [
        1872,
        16
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "3bd1cda4-ddd3-472e-83b1-2a69e4326b96",
      "name": "Generate Feature Image",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        2048,
        16
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "fde32f5b-516b-4991-acd2-128032405ba3",
      "name": "Upload Feature Image",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2240,
        16
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "18d51da3-60ad-47a6-95eb-8b9a6054fe61",
      "name": "Attach Featured Media",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2416,
        16
      ],
      "parameters": {},
      "typeVersion": 4.4
    },
    {
      "id": "4b324b12-5fc4-41ad-b969-974ee88d132e",
      "name": "Update SharePoint PostID",
      "type": "n8n-nodes-base.microsoftSharePoint",
      "position": [
        2592,
        16
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "88065221-b999-469d-97bf-16fba7f0ff60",
      "name": "Build Notification Email",
      "type": "n8n-nodes-base.code",
      "position": [
        2784,
        16
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "7f574af1-f60e-4bcc-ab22-fddf8864608f",
      "name": "Send Notification",
      "type": "n8n-nodes-base.microsoftOutlook",
      "position": [
        2944,
        16
      ],
      "parameters": {},
      "typeVersion": 2
    }
  ],
  "active": false,
  "settings": {
    "binaryMode": "separate",
    "executionOrder": "v1"
  },
  "versionId": "daa261e0-dfbb-4310-852d-57705d7b7d20",
  "connections": {
    "Get Topics": {
      "main": [
        [
          {
            "node": "Fetch WP Categories",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write Article": {
      "main": [
        [
          {
            "node": "Strip Code Fences",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Title": {
      "main": [
        [
          {
            "node": "Add Draft to WP",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Draft to WP": {
      "main": [
        [
          {
            "node": "Build Feature Image Prompt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Topics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Categories": {
      "main": [
        [
          {
            "node": "Match Categories AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Strip Code Fences": {
      "main": [
        [
          {
            "node": "Generate Title",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Category IDs": {
      "main": [
        [
          {
            "node": "Write Article",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch WP Categories": {
      "main": [
        [
          {
            "node": "Format Categories",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Match Categories AI": {
      "main": [
        [
          {
            "node": "Parse Category IDs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload Feature Image": {
      "main": [
        [
          {
            "node": "Attach Featured Media",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Attach Featured Media": {
      "main": [
        [
          {
            "node": "Update SharePoint PostID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LM \u2014 Article Writer": {
      "ai_languageModel": [
        [
          {
            "node": "Write Article",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Generate Feature Image": {
      "main": [
        [
          {
            "node": "Upload Feature Image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LM \u2014 Title Generator": {
      "ai_languageModel": [
        [
          {
            "node": "Generate Title",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Build Notification Email": {
      "main": [
        [
          {
            "node": "Send Notification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update SharePoint PostID": {
      "main": [
        [
          {
            "node": "Build Notification Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate and Upload Image": {
      "ai_tool": [
        [
          {
            "node": "Write Article",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Build Feature Image Prompt": {
      "main": [
        [
          {
            "node": "Generate Feature Image",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow automatically generates and publishes a full-length, SEO-optimized WordPress article on a weekly schedule. Topics are sourced from a SharePoint list. The AI agent writes the article body with embedded inline images, generates a separate featured (hero) image,…

Source: https://n8n.io/workflows/15102/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Most blogs publish words. This system publishes experiences.

OpenAI Chat, HTTP Request, Output Parser Structured +7
AI & RAG

Complete PostgreSQL-backed system: Keyword scoring → AI research → Multi-part content generation → fal.ai Nano Banana image generation → WordPress publishing

WordPress, OpenAI, Perplexity +8
AI & RAG

We’ve released Version 4 of our AI Powered Blog Automation workflow. We heard your complains and made a complete redesign built for serious content creators.

RSS Feed Read, OpenAI Chat, Text Classifier +6
AI & RAG

The best content automation template in the market is now even better—with “deep research” on time-sensitive topics\! Unlike most n8n content automation templates that are mainly for “demo purposes,”

OpenAI, HTTP Request, XML +11
AI & RAG

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

Telegram, Google Sheets Trigger, Agent +26