{
  "name": "My workflow 17",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 30
            }
          ]
        }
      },
      "id": "2e85c1bf-70c5-49bd-9595-3fbb56bef2b6",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.1,
      "position": [
        208,
        -176
      ]
    },
    {
      "parameters": {
        "jsCode": "// Define your lead list with their LinkedIn usernames\\nconst leads = [\\n  {\\n    name: \\"John Doe\\",\\n    username: \\"johndoe\\",\\n    company: \\"Tech Corp\\",\\n    role: \\"CEO\\"\\n  },\\n  {\\n    name: \\"Jane Smith\\", \\n    username: \\"janesmith\\",\\n    company: \\"Marketing Inc\\",\\n    role: \\"CMO\\"\\n  }\\n  // Add more leads here\\n];\\n\\n// Generate RSS URLs for each lead\\nconst rssFeeds = leads.map(lead => ({\\n  name: lead.name,\\n  company: lead.company,\\n  role: lead.role,\\n  rss_url: `https://www.linkedin.com/in/${lead.username}/recent-activity/.rss`,\\n  username: lead.username\\n}));\\n\\nreturn rssFeeds;"
      },
      "id": "cec2d637-99cd-45f7-947f-0a64d33ac1db",
      "name": "Lead List Setup",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        432,
        -176
      ]
    },
    {
      "parameters": {
        "conditions": {
          "options": {
            "caseSensitive": true,
            "leftValue": "",
            "typeValidation": "strict"
          },
          "conditions": [
            {
              "id": "filter-new-posts",
              "leftValue": "={{ $json.isoDate }}",
              "rightValue": "={{ $now.minus({hours: 2}).toISO() }}",
              "operator": {
                "type": "dateTime",
                "operation": "after",
                "singleValue": true
              }
            }
          ],
          "combinator": "and"
        },
        "options": {}
      },
      "id": "90ab20bf-f6d0-415f-a2aa-bd26b07165f7",
      "name": "Filter Recent Posts",
      "type": "n8n-nodes-base.filter",
      "typeVersion": 2,
      "position": [
        880,
        -176
      ]
    },
    {
      "parameters": {
        "documentId": {
          "__rl": true,
          "value": "YOUR_GOOGLE_SHEET_ID",
          "mode": "list",
          "cachedResultName": "LinkedIn Lead Tracker"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list",
          "cachedResultName": "Sheet1"
        },
        "options": {}
      },
      "id": "5ce9f773-0701-4022-bf2e-517346cb5ab1",
      "name": "Check Tracking Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.4,
      "position": [
        208,
        496
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "6O83kTVaFHV53Inr",
          "name": "Google Sheets account"
        }
      }
    },
    {
      "parameters": {
        "conditions": {
          "options": {
            "caseSensitive": true,
            "leftValue": "",
            "typeValidation": "strict"
          },
          "conditions": [
            {
              "id": "not-already-processed",
              "leftValue": "={{ $json.processed }}",
              "rightValue": "true",
              "operator": {
                "type": "string",
                "operation": "notEquals",
                "singleValue": true
              }
            }
          ],
          "combinator": "and"
        },
        "options": {}
      },
      "id": "86121c0d-823e-42b3-a25e-250e0a114def",
      "name": "Filter Unprocessed Posts",
      "type": "n8n-nodes-base.filter",
      "typeVersion": 2,
      "position": [
        1328,
        -176
      ]
    },
    {
      "parameters": {
        "authentication": "oAuth2",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "value": "YOUR_SLACK_CHANNEL_ID",
          "mode": "list",
          "cachedResultName": "#linkedin-alerts"
        },
        "text": "=⚠️ WINDOW CLOSING SOON {{ $json.authorName }} posted 2hrs ago 42 people already engaging Your AI-crafted responses: [suggestions]",
        "otherOptions": {}
      },
      "id": "b7960e21-b660-4d75-afbd-883f250b1e33",
      "name": "Send Slack Notification",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2.1,
      "position": [
        208,
        272
      ],
      "webhookId": "adbf2181-931d-4555-a6ed-e17628bb714d",
      "credentials": {
        "slackOAuth2Api": {
          "id": "c32B7jtW6wsQq0NF",
          "name": "Slack account 4"
        }
      }
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "YOUR_GOOGLE_SHEET_ID",
          "mode": "list",
          "cachedResultName": "LinkedIn Lead Tracker"
        },
        "sheetName": {
          "__rl": true,
          "value": "gid=0",
          "mode": "list",
          "cachedResultName": "Sheet1"
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "matchingColumns": [],
          "schema": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {}
      },
      "id": "3468a7e4-9358-4ad7-975a-5f5c6e2e9678",
      "name": "Log to Tracking Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.4,
      "position": [
        432,
        272
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "6O83kTVaFHV53Inr",
          "name": "Google Sheets account"
        }
      }
    },
    {
      "parameters": {
        "jsCode": "// Clean and format the post data\\nconst items = $input.all();\\n\\nreturn items.map(item => {\\n  const data = item.json;\\n  \\n  return {\\n    json: {\\n      ...data,\\n      // Extract clean content without HTML tags\\n      cleanContent: data.contentSnippet ? data.contentSnippet.replace(/<[^>]*>/g, '').substring(0, 200) : '',\\n      // Format date\\n      formattedDate: new Date(data.pubDate).toLocaleString(),\\n      // Extract author name\\n      authorName: data.creator || 'Unknown',\\n      // Generate unique ID for tracking\\n      postId: Buffer.from(data.link).toString('base64').substring(0, 10)\\n    }\\n  };\\n});"
      },
      "id": "a2f4623d-67a4-4cac-ba07-2255b888e300",
      "name": "Format Post Data",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        1104,
        -176
      ]
    },
    {
      "parameters": {
        "url": "<https://api.phantombuster.com/api/v2/agents/linkedin-post-likers/output>",
        "options": {}
      },
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        656,
        -176
      ],
      "id": "49160a67-ab95-4e9e-8294-1b8334a0fde8",
      "name": "LinkedIn Post Scraper"
    },
    {
      "parameters": {
        "modelId": {
          "__rl": true,
          "value": "models/gemini-1.5-flash",
          "mode": "list",
          "cachedResultName": "models/gemini-1.5-flash"
        },
        "messages": {
          "values": [
            {
              "content": "=Create 3 LinkedIn comment options for this post. Each should be 15-30 words, add value (not just praise), and start a conversation:\\n\\nPOST: {{ $json.content || $json.title || $json.contentSnippet }}\\n\\nFormat: \\n1. [analytical insight]\\n2. [personal connection] \\n3. [strategic question]"
            }
          ]
        },
        "options": {}
      },
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "typeVersion": 1,
      "position": [
        208,
        48
      ],
      "id": "5501a4fe-bf8b-4495-8b55-49511e7f4ce8",
      "name": "Message a model",
      "credentials": {
        "googlePalmApi": {
          "id": "9c4vlojBjrnkdeQK",
          "name": "Google Gemini(PaLM) Api account 2"
        }
      }
    }
  ],
  "pinData": {},
  "connections": {
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Lead List Setup",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Lead List Setup": {
      "main": [
        [
          {
            "node": "LinkedIn Post Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Recent Posts": {
      "main": [
        [
          {
            "node": "Format Post Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Post Data": {
      "main": [
        [
          {
            "node": "Filter Unprocessed Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Slack Notification": {
      "main": [
        [
          {
            "node": "Log to Tracking Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LinkedIn Post Scraper": {
      "main": [
        [
          {
            "node": "Filter Recent Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "4ea96bb9-ddf6-4a44-86e8-127166856f3b",
  "meta": {
    "templateCredsSetupCompleted": true,
    "instanceId": "7d020be849f9ba16b7ca29501c92aff75d0716e38c47c340a1ae2ea6cd82f384"
  },
  "id": "jaitxUzIdS0w7UNT",
  "tags": []
}