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

CLINICAINTEGRAL_secretary. Uses postgres, mcpClientTool, googleDriveTool, toolWorkflow. Webhook trigger; 89 nodes.

Postgres, Mcp Client Tool, Google Drive Tool +14
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