AutomationFlowsAI & RAG › Draft Linkedin Posts From RSS Feeds with Openai, Google Sheets and Slack

Draft Linkedin Posts From RSS Feeds with Openai, Google Sheets and Slack

ByOperstead @operstead on n8n.io

This workflow runs daily at 7am, reads an RSS feed, uses OpenAI to score articles for niche relevance and draft LinkedIn posts, then appends approved candidates to a Google Sheets review queue and notifies a Slack channel. Runs every day at 7:00 AM on a scheduled trigger. Reads…

Cron / scheduled trigger★★★★☆ complexityAI-powered15 nodesRSS Feed ReadOpenAIGoogle SheetsSlack
AI & RAG Trigger: Cron / scheduled Nodes: 15 Complexity: ★★★★☆ AI nodes: yes Added:

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

This workflow follows the Google Sheets → OpenAI 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": "75e4e0a3-0554-47af-8bff-96b855a27e05",
  "meta": {
    "templateCredsSetupCompleted": false
  },
  "name": "RSS \u2192 AI LinkedIn Draft Pipeline \u2014 by Operstead",
  "tags": [],
  "nodes": [
    {
      "id": "fea8b925-e22e-4e35-b3da-f613d244147e",
      "name": "Daily Trigger (7am)",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        290,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "cd2d8b21-3015-45d7-a64f-9ae8a0a63c7b",
      "name": "Read RSS Feeds",
      "type": "n8n-nodes-base.rssFeedRead",
      "position": [
        530,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "17c62c5e-0df8-4bc2-af2e-cf5fc2566203",
      "name": "Only Last 24h",
      "type": "n8n-nodes-base.filter",
      "position": [
        770,
        420
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "d7fb6f3a-fa99-4a51-bed7-33309b958784",
      "name": "Take Top 5",
      "type": "n8n-nodes-base.limit",
      "position": [
        1070,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "38c480c9-887b-48d7-b9cd-3cfd0b4dce63",
      "name": "Score Relevance to Your Niche",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1350,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "22ee9a97-16dd-4d6e-92d8-782203398618",
      "name": "Attach Score",
      "type": "n8n-nodes-base.set",
      "position": [
        1590,
        420
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "c14c7670-47c8-4f48-8c9e-0ed6a026ea9d",
      "name": "Only Relevance >= 7",
      "type": "n8n-nodes-base.filter",
      "position": [
        1830,
        420
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "63bd1d6b-488c-45d8-bb7e-aa3ea34f0ed7",
      "name": "Draft LinkedIn Post (Your Voice)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        2130,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "df4636aa-c346-4b26-9cfd-b1f077880cbc",
      "name": "Append Draft to Review Queue",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2370,
        420
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "d7732a74-940b-4d47-a720-be134fcac4ac",
      "name": "Slack: Drafts Ready",
      "type": "n8n-nodes-base.slack",
      "position": [
        2610,
        420
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "2ef6d48b-cb05-4413-9025-5c02ce21efbd",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        200,
        -520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b4c6d009-71ed-4a1c-97f8-796f9620e93c",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        210,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ac805b04-8798-4ddd-83b2-dc90b9a3960c",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        990,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "aa6948d5-5c25-431e-b53c-58755b840cb8",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1270,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "sticky-4",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2035,
        180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "36c472c6-5936-406a-8a63-d644759ee82f",
  "connections": {
    "Take Top 5": {
      "main": [
        [
          {
            "node": "Score Relevance to Your Niche",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Attach Score": {
      "main": [
        [
          {
            "node": "Only Relevance >= 7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Only Last 24h": {
      "main": [
        [
          {
            "node": "Take Top 5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read RSS Feeds": {
      "main": [
        [
          {
            "node": "Only Last 24h",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Trigger (7am)": {
      "main": [
        [
          {
            "node": "Read RSS Feeds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Only Relevance >= 7": {
      "main": [
        [
          {
            "node": "Draft LinkedIn Post (Your Voice)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append Draft to Review Queue": {
      "main": [
        [
          {
            "node": "Slack: Drafts Ready",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Score Relevance to Your Niche": {
      "main": [
        [
          {
            "node": "Attach Score",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Draft LinkedIn Post (Your Voice)": {
      "main": [
        [
          {
            "node": "Append Draft to Review Queue",
            "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 runs daily at 7am, reads an RSS feed, uses OpenAI to score articles for niche relevance and draft LinkedIn posts, then appends approved candidates to a Google Sheets review queue and notifies a Slack channel. Runs every day at 7:00 AM on a scheduled trigger. Reads…

Source: https://n8n.io/workflows/16924/ — 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

This workflow automatically collects the latest technology news, filters for emerging topics, and uses AI to score relevance and generate clean, ready-to-share content. It helps you focus on high-impa

RSS Feed Read, OpenAI, Google Sheets +1
AI & RAG

This workflow automatically creates a daily market intelligence brief for your stock portfolio. Instead of checking prices, news, and social media separately, it brings everything together into one cl

HTTP Request, RSS Feed Read, Google Sheets +2
AI & RAG

Imagine a dedicated financial expert tirelessly working behind the scenes, sifting through every transaction, every investment move, and every accounting entry. That's exactly what this automated syst

HTTP Request, Google Sheets, OpenAI +3
AI & RAG

News Automation - Main Workflow. Uses rssFeedRead, postgres, openAi, httpRequest. Scheduled trigger; 28 nodes.

RSS Feed Read, Postgres, OpenAI +4
AI & RAG

(n8n + Google Sheets + OpenAI + Slack)

Google Sheets, Slack, OpenAI