AutomationFlowsAI & RAG › Generate and Schedule Linkedin Posts with Google Sheets, Openai

Generate and Schedule Linkedin Posts with Google Sheets, Openai

BySpaGreen Creative @spagreen on n8n.io

This workflow is designed for content creators, social media managers, digital marketers, and business owners who want to automate their LinkedIn content creation and publishing process. It's especially valuable for those who struggle with consistently creating engaging content…

Cron / scheduled trigger★★★★☆ complexityAI-powered26 nodesChain LlmAgentAgent ToolGoogle SheetsLinkedInHTTP Request ToolOutput Parser StructuredOpenAI Chat
AI & RAG Trigger: Cron / scheduled Nodes: 26 Complexity: ★★★★☆ AI nodes: yes Added:

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

This workflow follows the Agent → Agenttool 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": "LDyszqha5vyMvuHd",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Automate LinkedIn Trending Content Creation & Scheduling",
  "tags": [],
  "nodes": [
    {
      "id": "451d270b-091d-4f6f-99c4-8968b8c39490",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1056,
        160
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "29ef8402-6d66-4899-ad55-ec2c308491cc",
      "name": "Content creator",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        80,
        176
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "cb8e8aa3-7af4-4e7f-a148-f6ecafed68cc",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        896,
        192
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "677cfcf1-efb2-4567-8ccd-8db5b99922e1",
      "name": "Content topic generator",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -288,
        176
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "f9216471-4683-4b29-888a-a8f3b1f978fd",
      "name": "AI Agent Tool",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        -272,
        480
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "34ae0c0b-0930-49a6-b388-a0113533cc22",
      "name": "Topic",
      "type": "n8n-nodes-base.set",
      "position": [
        -480,
        176
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "31b0ce67-7505-49c1-a8e4-212cee4dbcbd",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -880,
        160
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "643a46ac-3e55-4449-a8cb-689ecfbfc061",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -688,
        160
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "ebed277b-d744-4380-94f6-1ec0575c90fa",
      "name": "SEO",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        528,
        352
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "e6e37d50-16b4-49b7-8462-f2dc0c242a1d",
      "name": "LinkedIn page",
      "type": "n8n-nodes-base.linkedIn",
      "position": [
        1136,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4947675a-5a51-49f7-b523-c9e2c5ad7d71",
      "name": "LinkedIn profile",
      "type": "n8n-nodes-base.linkedIn",
      "position": [
        1136,
        272
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7f38fa4a-40b9-4f5b-bce5-676f8ad83171",
      "name": "HTTP (google trends)",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        -176,
        672
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "d0cf584f-9b9d-4f51-9ed8-2145a5ecb358",
      "name": "HTTP (taplio)",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        -64,
        640
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "14e05083-e0e3-4b57-ae96-b9d886891cd3",
      "name": "HTTP (google trends)1",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        624,
        496
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "c835996a-84b7-4e15-b6fe-b2125de5eb36",
      "name": "Structured Output",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        256,
        352
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "790e00c2-21cc-4765-88e1-5e78d6f89746",
      "name": "Structured Output1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -144,
        352
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "a2193064-18b7-4005-ba24-30a37e781df8",
      "name": "OpenAI Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -288,
        352
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "3ab16e55-2ef4-4e52-9027-6fec07cfcc1b",
      "name": "OpenAI Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        112,
        336
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "63d331d5-4b80-40c4-abd4-8a921a5b2389",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fd39245f-66ac-4b10-9a0e-b93f0410d7a6",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -336,
        128
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cbf0dac3-dc04-4a15-9815-6c398ade367b",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        64,
        112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1971538c-bbe7-47e6-b7ec-089b494f5566",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        16
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "005b6c0b-6091-4d21-84dc-e26c436d97b0",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1584,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c533461d-0f3e-4ec7-b3f5-95de25e7f1a8",
      "name": "Update Status row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        896,
        432
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "5641461b-b56e-443c-8c16-afba65c5d15e",
      "name": "OpenAI Chat",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -272,
        624
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "45ff9f70-79e6-4a08-9517-2daf69fdc218",
      "name": "OpenAI (Creates images for post)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        528,
        176
      ],
      "parameters": {},
      "typeVersion": 1.8
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "140e0743-93fe-48c8-ace3-5cf804002bd4",
  "connections": {
    "SEO": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "LinkedIn page",
            "type": "main",
            "index": 0
          },
          {
            "node": "LinkedIn profile",
            "type": "main",
            "index": 0
          },
          {
            "node": "Update Status row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Topic": {
      "main": [
        [
          {
            "node": "Content topic generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent Tool",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Model": {
      "ai_languageModel": [
        [
          {
            "node": "Content topic generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent Tool": {
      "ai_tool": [
        [
          {
            "node": "Content topic generator",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "HTTP (taplio)": {
      "ai_tool": [
        [
          {
            "node": "AI Agent Tool",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Model1": {
      "ai_languageModel": [
        [
          {
            "node": "SEO",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Content creator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Content creator": {
      "main": [
        [
          {
            "node": "OpenAI (Creates images for post)",
            "type": "main",
            "index": 0
          },
          {
            "node": "SEO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Topic",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output": {
      "ai_outputParser": [
        [
          {
            "node": "Content creator",
            "type": "ai_outputParser",
            "index": 0
          },
          {
            "node": "SEO",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output1": {
      "ai_outputParser": [
        [
          {
            "node": "Content topic generator",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP (google trends)": {
      "ai_tool": [
        [
          {
            "node": "AI Agent Tool",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "HTTP (google trends)1": {
      "ai_tool": [
        [
          {
            "node": "SEO",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Content topic generator": {
      "main": [
        [
          {
            "node": "Content creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI (Creates images for post)": {
      "main": [
        [
          {
            "node": "Merge",
            "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 is designed for content creators, social media managers, digital marketers, and business owners who want to automate their LinkedIn content creation and publishing process. It's especially valuable for those who struggle with consistently creating engaging content…

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

⚠️ DISCLAIMER: This workflow uses the AnySite LinkedIn community node, which is only available on self-hosted n8n instances. It will not work on n8n.cloud.

OpenAI Chat, Output Parser Structured, Google Sheets +6
AI & RAG

Most blogs publish words. This system publishes experiences.

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

This workflow automates end-to-end ESG (Environmental, Social, and Governance) sustainability reporting for enterprise sustainability teams, compliance officers, and green governance leads. It solves

Agent, OpenAI Chat, Output Parser Structured +12
AI & RAG

This workflow automates energy portfolio governance for energy managers, sustainability teams, and policy compliance officers. It eliminates the manual effort of aggregating multi-source energy data,

HTTP Request, Agent, OpenAI Chat +9
AI & RAG

Build a completely automated LinkedIn content engine using n8n, OpenAI, Google Sheets, and the LinkedIn API. This workflow reads unpublished topics from a Google Sheet, generates engaging AI-powered p

Output Parser Structured, Google Sheets, Memory Buffer Window +4