{
  "name": "Schedule approved LinkedIn page posts from Google Sheets with precise timing",
  "nodes": [
    {
      "id": "c3e34a88-f780-405c-9f56-e6a609d394ef",
      "name": "Run Every Hour",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1312,
        16
      ]
    },
    {
      "id": "30d3dec6-7680-4018-bca6-be912c72d5cb",
      "name": "Load LinkedIn Organization Credentials",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1104,
        16
      ]
    },
    {
      "id": "313dc714-48f6-462b-9a86-a4b010dd4932",
      "name": "Fetch Approved LinkedIn Posts",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -896,
        16
      ]
    },
    {
      "id": "d08ff1e5-0996-49a3-b2d1-d355fc50e347",
      "name": "Filter Posts Scheduled for Today",
      "type": "n8n-nodes-base.code",
      "position": [
        -688,
        16
      ]
    },
    {
      "id": "0e655bcd-51ca-4504-911a-a976bf997e8b",
      "name": "Process First Post Only",
      "type": "n8n-nodes-base.code",
      "position": [
        -480,
        16
      ]
    },
    {
      "id": "d4d889cc-29fd-452e-8edf-f765db5ac590",
      "name": "Route by Post Type",
      "type": "n8n-nodes-base.switch",
      "position": [
        -272,
        16
      ]
    },
    {
      "id": "f868aab4-b455-413e-8973-55255732bb7c",
      "name": "Mark as Scheduled in Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "e9a9ffc0-6bbb-45dc-a1ab-528fbc9ba61d",
      "name": "Wait Until Scheduled Time",
      "type": "n8n-nodes-base.wait",
      "position": [
        192,
        0
      ]
    },
    {
      "id": "00e87b7f-873e-4061-8e09-ee101e3e5f04",
      "name": "Prepare Post Data",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        400,
        0
      ]
    },
    {
      "id": "bd94dd58-f3f1-415c-9192-efd08f3a5a3c",
      "name": "Download Image from Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        608,
        0
      ]
    },
    {
      "id": "00b7c4b1-8d89-484d-87d5-283b7be98c01",
      "name": "Publish Creative Post to LinkedIn",
      "type": "n8n-nodes-base.linkedIn",
      "position": [
        880,
        0
      ]
    },
    {
      "id": "aaaa6703-293b-483d-b13c-b0dfe1e71bfd",
      "name": "Save Post URL & Mark Published",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1168,
        0
      ]
    },
    {
      "id": "0f1d3405-1bc5-4803-9b11-f175140a9ea5",
      "name": "Mark Article as Scheduled",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        544
      ]
    },
    {
      "id": "4f41f744-eee1-47d7-adc2-5dce7035e2cc",
      "name": "Wait Until Article Scheduled Time",
      "type": "n8n-nodes-base.wait",
      "position": [
        256,
        544
      ]
    },
    {
      "id": "3c53407e-0d38-4317-843d-c2df3907ca5f",
      "name": "Prepare Article Data",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        464,
        544
      ]
    },
    {
      "id": "8543dd4c-ec1c-45f2-a1cd-55a1dfbcb2e1",
      "name": "Publish Article Link to LinkedIn",
      "type": "n8n-nodes-base.linkedIn",
      "position": [
        688,
        544
      ]
    },
    {
      "id": "a02fadd8-013f-4ac4-a674-863398cb8bb6",
      "name": "Save Article URL & Mark Published",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        944,
        544
      ]
    },
    {
      "id": "b542a43b-5ca7-46ca-a888-95a299a6678f",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1792,
        -400
      ],
      "parameters": {
        "width": 432,
        "height": 976,
        "content": "# Schedule and auto-publish LinkedIn posts from Google Sheets\n\nAutomate LinkedIn organization page posting with precise time scheduling, Google Drive media management, and smart status tracking. Runs "
      }
    },
    {
      "id": "4ad19b59-37e8-47cc-b52c-c2212cb7bf86",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1296,
        -160
      ],
      "parameters": {
        "width": 496,
        "height": 224,
        "content": "## Trigger & Data Loading\n\nRuns 4 times daily at :45 minutes (9-12 AM), loads LinkedIn credentials, fetches approved posts filtered by platform and approval status, then filters for today's scheduled "
      }
    },
    {
      "id": "b56fde7b-08ca-4f5d-a556-0b229a95e383",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        -160
      ],
      "parameters": {
        "width": 304,
        "height": 224,
        "content": "## Post Type Routing\n\nProcesses first pending post and routes to appropriate publishing branch based on post type (Creative Post with image or Article with link)"
      }
    },
    {
      "id": "3b2cdc27-c567-44ca-81ef-5ef92a8e58ec",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        -192
      ],
      "parameters": {
        "width": 400,
        "height": 240,
        "content": "## Creative Post Publishing (Image)\n\nMarks as scheduled, waits until exact time, downloads image from Google Drive, publishes to LinkedIn organization page, saves live URL and updates status to Publis"
      }
    },
    {
      "id": "57f75d04-2020-4dda-afb6-3209e62e4259",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        48,
        352
      ],
      "parameters": {
        "width": 304,
        "height": 240,
        "content": "## Article Post Publishing (Link)\n\nMarks article as scheduled, waits until exact time, publishes article link to LinkedIn organization page, saves post URL and marks as Published"
      }
    }
  ],
  "connections": {
    "Run Every Hour": {
      "main": [
        [
          {
            "node": "Load LinkedIn Organization Credentials",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Post Data": {
      "main": [
        [
          {
            "node": "Download Image from Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route by Post Type": {
      "main": [
        [
          {
            "node": "Mark as Scheduled in Sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Mark Article as Scheduled",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Article Data": {
      "main": [
        [
          {
            "node": "Publish Article Link to LinkedIn",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process First Post Only": {
      "main": [
        [
          {
            "node": "Route by Post Type",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark Article as Scheduled": {
      "main": [
        [
          {
            "node": "Wait Until Article Scheduled Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait Until Scheduled Time": {
      "main": [
        [
          {
            "node": "Prepare Post Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark as Scheduled in Sheet": {
      "main": [
        [
          {
            "node": "Wait Until Scheduled Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Approved LinkedIn Posts": {
      "main": [
        [
          {
            "node": "Filter Posts Scheduled for Today",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Image from Google Drive": {
      "main": [
        [
          {
            "node": "Publish Creative Post to LinkedIn",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Posts Scheduled for Today": {
      "main": [
        [
          {
            "node": "Process First Post Only",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Publish Article Link to LinkedIn": {
      "main": [
        [
          {
            "node": "Save Article URL & Mark Published",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Publish Creative Post to LinkedIn": {
      "main": [
        [
          {
            "node": "Save Post URL & Mark Published",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait Until Article Scheduled Time": {
      "main": [
        [
          {
            "node": "Prepare Article Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Load LinkedIn Organization Credentials": {
      "main": [
        [
          {
            "node": "Fetch Approved LinkedIn Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}