{
  "name": "Lead generation automate on LinkedIn - personalisation, enrichment",
  "nodes": [
    {
      "id": "4cab7c48-1c69-479e-83ce-fe4d3974b5ce",
      "name": "On form submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        220,
        140
      ]
    },
    {
      "id": "5ed7d147-f2a2-4a9e-911f-45f5ca0bafdb",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        660,
        140
      ]
    },
    {
      "id": "6851151e-6b2a-42b7-8e0a-729c650da6c4",
      "name": "OpenAI1",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        740,
        380
      ]
    },
    {
      "id": "f1a9b0fb-f9a8-48f5-b369-f52516214503",
      "name": "Google Sheets Trigger2",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        20,
        580
      ]
    },
    {
      "id": "4c198be2-a508-4269-ad59-0e490caafd60",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        -60
      ],
      "parameters": {
        "width": 1820,
        "height": 1020,
        "content": "## Automated Lead Generation and Enrichment Workflow\n\nDescription: This workflow automates lead generation by collecting job title, location, and lead count via a form, using Apollo.io to fetch leads,"
      }
    },
    {
      "id": "4db87428-54a3-4110-bb3e-16ac2a64927b",
      "name": "Clean Data",
      "type": "n8n-nodes-base.set",
      "position": [
        880,
        140
      ]
    },
    {
      "id": "a34921c3-cdae-4db0-9c7b-cd857d0cd552",
      "name": "Add Linkedin Username",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1080,
        380
      ]
    },
    {
      "id": "be0a482f-69be-4906-a944-ae480bddc445",
      "name": "Get Pending Username Row",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        500,
        380
      ]
    },
    {
      "id": "f87ef1f1-ba4a-4104-9c4b-f6d93f770ede",
      "name": "Add Email Address",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1340,
        500
      ]
    },
    {
      "id": "1f9cb0e4-2b26-4948-9294-82d8abfab4eb",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        1000,
        580
      ]
    },
    {
      "id": "d539aec1-0584-4d04-8d6c-0492d0ead4dd",
      "name": "Mark Invalid Email",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1340,
        700
      ]
    },
    {
      "id": "08fd30c9-acfe-4775-81fa-ccc3153160b8",
      "name": "Confirm Email Validity",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        740,
        580
      ]
    },
    {
      "id": "37ac82ac-ee91-42ed-8d62-9b5ba959fb25",
      "name": "Get Pending Email Statuses",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        260,
        580
      ]
    },
    {
      "id": "5f5cfd40-520b-4abc-a073-bfa2aa89afb5",
      "name": "Google Sheets Trigger3",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -40,
        1060
      ]
    },
    {
      "id": "4fe13d3a-553d-45e1-88d6-b75d53b4f58c",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -180,
        960
      ],
      "parameters": {
        "width": 1320,
        "height": 700,
        "content": "## LinkedIn Profile Summary Enrichment Workflow\nThis workflow automates the enrichment of lead data by fetching LinkedIn profile details for records marked as \"pending\" in a Google Sheets document, us"
      }
    },
    {
      "id": "f00b7fe0-1bb8-44b9-b19e-cca7576bd7fe",
      "name": "Get Profile Posts",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        640,
        1900
      ]
    },
    {
      "id": "102398c4-8760-4cc7-8664-293b5de3c460",
      "name": "Get About Profile",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        760,
        1060
      ]
    },
    {
      "id": "747e0b11-839f-4335-bf62-f695575372b1",
      "name": "Get Pending About and Posts Rows",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        220,
        1060
      ]
    },
    {
      "id": "f5e0160c-2602-4e62-a230-4b4a73136b88",
      "name": "Clean Profile Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -60,
        1360
      ]
    },
    {
      "id": "470a2381-fdcc-4e62-bda2-9ef81db3acb0",
      "name": "Google Sheets Trigger4",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -80,
        1900
      ]
    },
    {
      "id": "b19f9d0d-b0fa-409a-b3e1-d9b2f52f25e8",
      "name": "Get Pending About and Posts Rows1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        160,
        1900
      ]
    },
    {
      "id": "3d42dfba-2a1c-4457-bc16-e868c597a381",
      "name": "Clean Posts Data",
      "type": "n8n-nodes-base.code",
      "position": [
        920,
        1900
      ]
    },
    {
      "id": "afa569d3-3fbc-4b16-b869-3461e442a740",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        1680
      ],
      "parameters": {
        "width": 2420,
        "height": 560,
        "content": "## LinkedIn Posts Scraping and Lead Enrichment Workflow\nThis workflow retrieves recent LinkedIn posts for leads marked \"unscraped\" in a Google Sheet, using the LinkedIn Data API, and summarizes them w"
      }
    },
    {
      "id": "31928be6-191f-4ec3-a88d-dbd7f613f1aa",
      "name": "Google Sheets Trigger5",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        1200,
        2420
      ]
    },
    {
      "id": "f0c78b3d-be0c-4113-8392-2d91c4f707d7",
      "name": "Schedule Trigger2",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        2120,
        340
      ]
    },
    {
      "id": "0661680e-a4d0-4595-aef7-e832fc812f0e",
      "name": "get invalid email rows",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2360,
        1180
      ]
    },
    {
      "id": "d1da0dbc-85f8-4b95-88b4-7cf68e59560a",
      "name": "update_to_pending",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2580,
        1180
      ]
    },
    {
      "id": "2f87a52a-83fa-4a57-90c3-7b9cf658091d",
      "name": "get_failed_profile_summary_rows",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2340,
        340
      ]
    },
    {
      "id": "3ba33190-7e23-4b61-a12c-b014e04dec27",
      "name": "update_to_pending1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2560,
        340
      ]
    },
    {
      "id": "c84a23f2-c19b-4752-8195-6bb03dc2c3f4",
      "name": "Schedule Trigger3",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        2180,
        800
      ]
    },
    {
      "id": "7dd1874a-3be3-4c8f-8118-d2f0881f06ba",
      "name": "get_failed_posts_summary_rows1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2400,
        800
      ]
    },
    {
      "id": "2ebf97c9-381f-4823-8a08-c9943c1abf80",
      "name": "Posts AI Summarizer",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1560,
        1820
      ]
    },
    {
      "id": "6dbcfab2-e3fe-46ed-9fa5-9301f0762815",
      "name": "AI Profile Summarizer",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        420,
        1280
      ]
    },
    {
      "id": "a03e2002-840c-4792-a4aa-35b4a1886584",
      "name": "Update Profile Summary",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        900,
        1280
      ]
    },
    {
      "id": "a259f9ad-4e43-4d96-8d37-7312e7658fc2",
      "name": "Update Posts Summary",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2020,
        1820
      ]
    },
    {
      "id": "1e27ce31-3f74-458b-bdd1-b8aaa6cc709a",
      "name": "Get Completely Enriched Profiles",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1420,
        2420
      ]
    },
    {
      "id": "80ee87ce-8f6b-4dda-a065-888fe5f485fc",
      "name": "update_to_unscraped",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2600,
        800
      ]
    },
    {
      "id": "5f39b0e9-da20-48d1-b169-57252c514f36",
      "name": "Append to Enriched Leads Database",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1620,
        2420
      ]
    },
    {
      "id": "3c2ced03-2b9d-4cae-8ce2-3d280575448e",
      "name": "update status to failed",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        200,
        1440
      ]
    },
    {
      "id": "e23649fb-6414-46e1-86ff-040e69896c0b",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1320,
        1980
      ]
    },
    {
      "id": "7b086a49-f227-4883-9391-25e5acb8780a",
      "name": "Stringify Profile Data1",
      "type": "n8n-nodes-base.code",
      "position": [
        200,
        1280
      ]
    },
    {
      "id": "608eb567-2f5f-4113-acb8-d2ef2a2990e5",
      "name": "Stringify Posts Data",
      "type": "n8n-nodes-base.code",
      "position": [
        1320,
        1820
      ]
    },
    {
      "id": "a873dbe2-c2fd-41ab-bad7-7e058446ffc2",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        2140,
        1180
      ]
    },
    {
      "id": "e6a3abf6-bb85-4b7e-9498-5490d1d9a3b4",
      "name": "Generate Leads with Apollo.io1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        460,
        140
      ]
    },
    {
      "id": "ddc7ed41-4be8-4daf-85ef-0cdb706f3003",
      "name": "Add Leads to Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1080,
        140
      ]
    },
    {
      "id": "836386bd-a5c4-4cb1-8ba6-8ce2310fcc96",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        520,
        5040
      ]
    },
    {
      "id": "ed3b325d-80a5-491a-9f1d-165df1d5b0ec",
      "name": "Get Email from Apollo11",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        480,
        580
      ]
    },
    {
      "id": "f9b631b7-d5ad-49be-9a84-c8eceaedb264",
      "name": "Limit",
      "type": "n8n-nodes-base.limit",
      "position": [
        440,
        1060
      ]
    },
    {
      "id": "91810b86-6b72-402a-a11f-fea6c6d79b80",
      "name": "Limit1",
      "type": "n8n-nodes-base.limit",
      "position": [
        380,
        1900
      ]
    },
    {
      "id": "302e4c03-82bc-42f6-bb17-e03db2f50a4a",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1060,
        2300
      ],
      "parameters": {
        "width": 960,
        "height": 360,
        "content": "## Update Completely Enriched Profile to Final Database"
      }
    },
    {
      "id": "630174c3-35a3-424f-aa93-6b679cf21624",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2040,
        660
      ],
      "parameters": {
        "width": 800,
        "height": 360,
        "content": "## Update posts summary status from failed back to pending"
      }
    },
    {
      "id": "c689c67c-5169-4d7d-a1e8-70b986cd1a47",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2040,
        1100
      ],
      "parameters": {
        "width": 800,
        "height": 360,
        "content": "## Update Contact Scrape Status from Invalid back to Pending"
      }
    },
    {
      "id": "c27398fd-76d0-470f-b8c8-969e5a1c6a87",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        260,
        380
      ]
    },
    {
      "id": "427f85ab-7b49-4b6d-89a2-dbe0bc3e0534",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2000,
        220
      ],
      "parameters": {
        "width": 820,
        "height": 360,
        "content": "## Update profile summary status from failed back to pending"
      }
    },
    {
      "id": "0dc99522-a422-4321-b51e-676a70936c8b",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1720,
        40
      ],
      "parameters": {
        "width": 1280,
        "height": 1540,
        "content": "## Scheduled Lead Status Reset Workflow\nThis workflow runs on a schedule every four weeks to identify Google Sheets rows with invalid email addresses or failed post summary scrapes. It updates the sta"
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Add Email Address",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Mark Invalid Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "Get About Profile",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit1": {
      "main": [
        [
          {
            "node": "Get Profile Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI1": {
      "main": [
        [
          {
            "node": "Add Linkedin Username",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Clean Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clean Data": {
      "main": [
        [
          {
            "node": "Add Leads to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        []
      ]
    },
    "Clean Posts Data": {
      "main": [
        [
          {
            "node": "Stringify Posts Data",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get About Profile": {
      "main": [
        [
          {
            "node": "Clean Profile Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Profile Posts": {
      "main": [
        [
          {
            "node": "Clean Posts Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "get invalid email rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger2": {
      "main": [
        [
          {
            "node": "get_failed_profile_summary_rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger3": {
      "main": [
        [
          {
            "node": "get_failed_posts_summary_rows1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clean Profile Data": {
      "main": [
        [
          {
            "node": "Stringify Profile Data1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "update status to failed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Generate Leads with Apollo.io1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Posts AI Summarizer": {
      "main": [
        [
          {
            "node": "Update Posts Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Stringify Posts Data": {
      "main": [
        [
          {
            "node": "Posts AI Summarizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Profile Summarizer": {
      "main": [
        [
          {
            "node": "Update Profile Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "Get Pending Username Row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Confirm Email Validity": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger2": {
      "main": [
        [
          {
            "node": "Get Pending Email Statuses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger3": {
      "main": [
        [
          {
            "node": "Get Pending About and Posts Rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger4": {
      "main": [
        [
          {
            "node": "Get Pending About and Posts Rows1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger5": {
      "main": [
        [
          {
            "node": "Get Completely Enriched Profiles",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get invalid email rows": {
      "main": [
        [
          {
            "node": "update_to_pending",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Email from Apollo11": {
      "main": [
        [
          {
            "node": "Confirm Email Validity",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Stringify Profile Data1": {
      "main": [
        [
          {
            "node": "AI Profile Summarizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Pending Username Row": {
      "main": [
        [
          {
            "node": "OpenAI1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Pending Email Statuses": {
      "main": [
        [
          {
            "node": "Get Email from Apollo11",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Leads with Apollo.io1": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get_failed_posts_summary_rows1": {
      "main": [
        [
          {
            "node": "update_to_unscraped",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get_failed_profile_summary_rows": {
      "main": [
        [
          {
            "node": "update_to_pending1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Completely Enriched Profiles": {
      "main": [
        [
          {
            "node": "Append to Enriched Leads Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Pending About and Posts Rows": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Pending About and Posts Rows1": {
      "main": [
        [
          {
            "node": "Limit1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}