AutomationFlowsAI & RAG › Automated Linkedin Lead Generation, Scoring & Communication with Ai-agent

Automated Linkedin Lead Generation, Scoring & Communication with Ai-agent

ByAndrey @kulia on n8n.io

⚠️ 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.

Cron / scheduled trigger★★★★★ complexityAI-powered96 nodesOpenAI ChatOutput Parser StructuredGoogle SheetsN8N Nodes HdwOpenAIAgentMemory Buffer WindowChain Llm
AI & RAG Trigger: Cron / scheduled Nodes: 96 Complexity: ★★★★★ AI nodes: yes Added:
Automated Linkedin Lead Generation, Scoring & Communication with Ai-agent — n8n workflow card showing OpenAI Chat, Output Parser Structured, Google Sheets integration

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

This workflow follows the Agent → Chainllm 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": "orrlMUaAvSsvAOgm",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "HDW Lead Gel\u00e4ndewagen",
  "tags": [],
  "nodes": [
    {
      "id": "bd3fe9aa-d16e-4ee8-a2c9-8ac2e0a98c66",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -2320,
        1260
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1",
          "cachedResultName": "gpt-4.1"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "e4f4a3df-1544-4afa-9aae-81f17d642f95",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "notes": "For changing limits use \"count\"",
      "position": [
        -2120,
        1260
      ],
      "parameters": {
        "jsonSchemaExample": "[\n  {\n    \"salesNavigatorParams\": {\n      \"current_titles\": \"title1\",\n      \"current_companies\": \"company1\",\n      \"location\": \"location1\",\n      \"industry\": \"industry1\",\n      \"company_sizes\": [\n        \"Self-employed\",\n        \"1-10\",\n        \"11-50\",\n        \"51-200\",\n        \"201-500\",\n        \"501-1,000\",\n        \"1,001-5,000\",\n        \"5,001-10,000\",\n        \"10,001+\"\n      ]\n    },\n    \"count\": 10\n  },\n  {\n    \"salesNavigatorParams\": {\n      \"current_titles\": \"title2\",\n      \"current_companies\": \"company2\",\n      \"location\": \"location2\",\n      \"industry\": \"industry2\",\n      \"company_sizes\": [\n        \"Self-employed\",\n        \"1-10\",\n        \"11-50\",\n        \"51-200\",\n        \"201-500\",\n        \"501-1,000\",\n        \"1,001-5,000\",\n        \"5,001-10,000\",\n        \"10,001+\"\n      ]\n    },\n    \"count\": 10\n  }\n]"
      },
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "3084f957-886b-466a-96d1-2918b9448c63",
      "name": "Google Sheets2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -400,
        2080
      ],
      "parameters": {
        "columns": {
          "value": {
            "URN": "={{ $('Read companies').item.json.URN }}",
            "Website": "={{ $json.website }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URN",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "img",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "img",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Headline",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Headline",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "location",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "is premium",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "is premium",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Current company",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Current company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company URN",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Industry",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Position",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Position",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Posts summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Posts summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Product Summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Product Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company News",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company News",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company post summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company post summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Lead Score",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Lead Score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Contact Request",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Contact Request",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Connected",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Connected",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message Sent",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Message Sent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "URN"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.5,
      "waitBetweenTries": 5000
    },
    {
      "id": "a64188c8-f976-41e5-a8e5-b49e3c50e458",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -900,
        1680
      ],
      "parameters": {
        "options": {
          "reset": false
        }
      },
      "retryOnFail": true,
      "typeVersion": 3
    },
    {
      "id": "d5cd8de3-b1ec-442d-a026-9adc411b8b49",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2400,
        540
      ],
      "parameters": {
        "color": 4,
        "width": 1320,
        "content": "Find leads in LinkedIn"
      },
      "typeVersion": 1
    },
    {
      "id": "f9b7b200-4dec-43ee-8e00-e60914f1949d",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1020,
        540
      ],
      "parameters": {
        "color": 4,
        "width": 980,
        "content": "Get company website "
      },
      "typeVersion": 1
    },
    {
      "id": "3d2e343a-a81c-4754-a852-c43d7f592417",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 4,
        "width": 1520,
        "content": "Research company website"
      },
      "typeVersion": 1
    },
    {
      "id": "1c9b4718-bd53-4c3f-b94c-371adea118c1",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1560,
        540
      ],
      "parameters": {
        "color": 4,
        "width": 980,
        "content": "Score data"
      },
      "typeVersion": 1
    },
    {
      "id": "6c3b801e-838e-4c03-9f04-b7c27bb9cd59",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2580,
        540
      ],
      "parameters": {
        "color": 4,
        "width": 1860,
        "content": "Communicate with leads"
      },
      "typeVersion": 1
    },
    {
      "id": "412f6d55-6d36-4602-b6db-ae5c449602e3",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        180
      ],
      "parameters": {
        "color": 4,
        "width": 1520,
        "content": "Research lead LN post"
      },
      "typeVersion": 1
    },
    {
      "id": "ed07b5b5-4b36-4cff-9dd4-150a8378967b",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        540
      ],
      "parameters": {
        "color": 4,
        "width": 1520,
        "content": "Research company LN post"
      },
      "typeVersion": 1
    },
    {
      "id": "8199980a-42d2-414a-a387-8faab1193a5c",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        360
      ],
      "parameters": {
        "color": 4,
        "width": 1520,
        "content": "Research company News"
      },
      "typeVersion": 1
    },
    {
      "id": "bde206ab-617e-425f-9cd9-df4da03c7146",
      "name": "HDW LinkedIn SN",
      "type": "n8n-nodes-hdw.hdwLinkedin",
      "onError": "continueRegularOutput",
      "position": [
        -1800,
        1060
      ],
      "parameters": {
        "count": "={{ $json.output.count }}",
        "keywords": "={{ $json.output.salesNavigatorParams.keywords }}",
        "resource": "search",
        "additionalFilters": {
          "industry": "={{ $json.output.salesNavigatorParams.industry }}",
          "location": "={{ $json.output.salesNavigatorParams.location }}",
          "company_sizes": "={{ $json.output.salesNavigatorParams.company_sizes }}",
          "current_titles": "={{ $json.output.salesNavigatorParams.current_titles }}",
          "company_keyword": "={{ $json.output.salesNavigatorParams.current_companies }}"
        }
      },
      "credentials": {
        "hdwLinkedinApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "79da9bcd-01df-41a3-9627-dff9ac226e3a",
      "name": "HDW Get Company Website",
      "type": "n8n-nodes-hdw.hdwLinkedin",
      "onError": "continueRegularOutput",
      "position": [
        -540,
        1940
      ],
      "parameters": {
        "company": "={{ $json[\"Company URN\"] }}",
        "resource": "company"
      },
      "credentials": {
        "hdwLinkedinApi": {
          "name": "<your credential>"
        }
      },
      "notesInFlow": true,
      "retryOnFail": true,
      "typeVersion": 1,
      "waitBetweenTries": 5000
    },
    {
      "id": "d6263cff-7a21-462a-81a4-e09dfacc10a4",
      "name": "Google Sheets3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        20,
        880
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "executeOnce": true,
      "retryOnFail": true,
      "typeVersion": 4.5,
      "waitBetweenTries": 5000
    },
    {
      "id": "719377c5-150f-4819-968a-b69d75eb70ad",
      "name": "Loop Over Items1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        540,
        860
      ],
      "parameters": {
        "options": {}
      },
      "retryOnFail": true,
      "typeVersion": 3
    },
    {
      "id": "0d88ce35-4fa3-4cef-87ef-23f6992e1855",
      "name": "Google Sheets4",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        40,
        1420
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "executeOnce": true,
      "retryOnFail": true,
      "typeVersion": 4.5,
      "waitBetweenTries": 5000
    },
    {
      "id": "cd54b602-8fbc-4b29-869f-e2fcec4e1fbd",
      "name": "HDW Get User Posts",
      "type": "n8n-nodes-hdw.hdwLinkedin",
      "position": [
        680,
        1460
      ],
      "parameters": {
        "urn": "={{ $('Post summary is empty').item.json.URN }}",
        "operation": "getPosts"
      },
      "credentials": {
        "hdwLinkedinApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "69135673-0acc-43a1-bdb9-9b927839d896",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        860,
        1460
      ],
      "parameters": {
        "options": {},
        "fieldsToAggregate": {
          "fieldToAggregate": [
            {
              "fieldToAggregate": "text"
            },
            {
              "renameField": true,
              "outputFieldName": "repost",
              "fieldToAggregate": "repost.text"
            }
          ]
        }
      },
      "retryOnFail": true,
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "499a0e1f-d0f2-49f3-9f76-b6c8e8a6f11c",
      "name": "Loop Over Items2",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        520,
        1300
      ],
      "parameters": {
        "options": {}
      },
      "retryOnFail": true,
      "typeVersion": 3
    },
    {
      "id": "afbd8a72-e766-4ce1-8231-6ea3b75389fd",
      "name": "Google Sheets5",
      "type": "n8n-nodes-base.googleSheets",
      "onError": "continueRegularOutput",
      "position": [
        1360,
        1460
      ],
      "parameters": {
        "columns": {
          "value": {
            "URN": "={{ $('Post summary is empty').item.json.URN }}",
            "Posts summary": "={{ $json.message.content }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URN",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "img",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "img",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Headline",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Headline",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "location",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "is premium",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "is premium",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Current company",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Current company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company URN",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Industry",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Position",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Position",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Posts summary",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Posts summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Product Summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Product Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company News",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company News",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "URN"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.5
    },
    {
      "id": "6c540033-4a12-4980-aa03-0e2129b3477d",
      "name": "Google Sheets6",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        40,
        1880
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "executeOnce": true,
      "retryOnFail": true,
      "typeVersion": 4.5,
      "waitBetweenTries": 5000
    },
    {
      "id": "8b356508-c494-421c-a88d-83f3f7808d99",
      "name": "Aggregate1",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        860,
        1880
      ],
      "parameters": {
        "options": {},
        "fieldsToAggregate": {
          "fieldToAggregate": [
            {
              "fieldToAggregate": "description"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "3c9bb26b-ce71-4625-a472-c3008bbd1bbf",
      "name": "Loop Over Items3",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        520,
        1720
      ],
      "parameters": {
        "options": {}
      },
      "retryOnFail": true,
      "typeVersion": 3
    },
    {
      "id": "fa18d1f6-545d-43d4-a6e2-27bb634d1681",
      "name": "Google Sheets7",
      "type": "n8n-nodes-base.googleSheets",
      "onError": "continueRegularOutput",
      "position": [
        1380,
        1880
      ],
      "parameters": {
        "columns": {
          "value": {
            "URN": "={{ $('Company news is empty').item.json.URN }}",
            "Company News": "={{ $json.message.content }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URN",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "img",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "img",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Headline",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Headline",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "location",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "is premium",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "is premium",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Current company",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Current company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company URN",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Industry",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Position",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Position",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Posts summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Posts summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Product Summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Product Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company News",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Company News",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "URN"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.5
    },
    {
      "id": "d8d6941c-8e43-4bb2-8767-86b211a08e34",
      "name": "Google Sheets8",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        40,
        2380
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "executeOnce": true,
      "retryOnFail": true,
      "typeVersion": 4.5,
      "waitBetweenTries": 5000
    },
    {
      "id": "111ce09c-7635-4496-ab85-bcd575c244d5",
      "name": "Aggregate2",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        860,
        2380
      ],
      "parameters": {
        "options": {},
        "fieldsToAggregate": {
          "fieldToAggregate": [
            {
              "fieldToAggregate": "text"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "8f26f598-e6b4-45be-bc9a-a47315fcdfe3",
      "name": "Loop Over Items4",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        520,
        2240
      ],
      "parameters": {
        "options": {}
      },
      "retryOnFail": true,
      "typeVersion": 3
    },
    {
      "id": "d39d0bcd-a36a-4310-b13b-65f4ebf0e5d2",
      "name": "Google Sheets9",
      "type": "n8n-nodes-base.googleSheets",
      "onError": "continueRegularOutput",
      "position": [
        1380,
        2380
      ],
      "parameters": {
        "columns": {
          "value": {
            "URN": "={{ $('Company post is empty').item.json.URN }}",
            "Company post summary": "={{ $('Summarise company posts').item.json.message.content }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URN",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "img",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "img",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Headline",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Headline",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "location",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "is premium",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "is premium",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Current company",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Current company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company URN",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Industry",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Position",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Position",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Posts summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Posts summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Product Summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Product Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company News",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company News",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company post summary",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Company post summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "URN"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.5
    },
    {
      "id": "8cfb6af5-6360-4440-b1a6-598eb443c8f5",
      "name": "HDW Get Company News",
      "type": "n8n-nodes-hdw.hdwLinkedin",
      "position": [
        680,
        1880
      ],
      "parameters": {
        "query": "={{ $('Company news is empty').item.json[\"Current company\"] }} (news OR press OR announcement OR update)",
        "resource": "google",
        "operation": "googleSearch"
      },
      "credentials": {
        "hdwLinkedinApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "2f7b9aaf-1fe1-45f9-a63e-34b8a8a2658c",
      "name": "HDW Get Company Posts",
      "type": "n8n-nodes-hdw.hdwLinkedin",
      "onError": "continueRegularOutput",
      "position": [
        680,
        2380
      ],
      "parameters": {
        "urn": "={{ $('Google Sheets8').item.json[\"Company URN\"] }}",
        "resource": "company",
        "operation": "getCompanyPosts"
      },
      "credentials": {
        "hdwLinkedinApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "efc019e2-5439-44bc-907b-b77e05833a7c",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -1980,
        1060
      ],
      "parameters": {
        "include": "allOtherFields",
        "options": {},
        "fieldToSplitOut": "output"
      },
      "retryOnFail": true,
      "typeVersion": 1
    },
    {
      "id": "89c665d7-0d0c-47ce-9e74-780a57ef582e",
      "name": "OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        740,
        1120
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o",
          "cachedResultName": "gpt-4o"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "920fe0db-bef0-4f78-a793-e406565df11a",
      "name": "Google Sheets10",
      "type": "n8n-nodes-base.googleSheets",
      "onError": "continueRegularOutput",
      "position": [
        1340,
        860
      ],
      "parameters": {
        "columns": {
          "value": {
            "URN": "={{ $('Website is not empty').item.json.URN }}",
            "Product Summary": "={{ $json.output }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URN",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "img",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "img",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Headline",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Headline",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "location",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "is premium",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "is premium",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Current company",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Current company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company URN",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company URN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Industry",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Position",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Position",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Description",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Posts summary",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Posts summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Product Summary",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Product Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company News",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company News",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "URN"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.5
    },
    {
      "id": "402b88d8-1f0c-4a13-b93f-242703a3861e",
      "name": "HDW Site-map",
      "type": "n8n-nodes-hdw.hdwWebParserTool",
      "position": [
        1060,
        1120
      ],
      "parameters": {
        "url": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('URL', `use company url to get a site-map`, 'string') }}",
        "operation": "map",
        "descriptionType": "manual",
        "toolDescription": "Get sitemap by url"
      },
      "credentials": {
        "hdwLinkedinApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "37e1f633-6e14-4ab0-a205-cdc5e88b3b7d",
      "name": "HDW Parser",
      "type": "n8n-nodes-hdw.hdwWebParserTool",
      "position": [
        1220,
        1120
      ],
      "parameters": {
        "url": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('URL', ``, 'string') }}",
        "descriptionType": "manual",
        "toolDescription": "Parse info from website by url"
      },
      "credentials": {
        "hdwLinkedinApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "91cd0c40-4f6e-417c-9139-7479ed306808",
      "name": "Summarise user posts",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1020,
        1460
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o",
          "cachedResultName": "GPT-4O"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Make summary of this text:\n {{ $json.text }}\n{{ $json.repost }}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1.8
    },
    {
      "id": "34580e4c-ac3c-48b1-bf3c-c09b4e7b0236",
      "name": "Summarise company news",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1040,
        1880
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o",
          "cachedResultName": "GPT-4O"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Make summary of this news:\n{{ $json.description }}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1.8
    },
    {
      "id": "a21ceccb-1e64-4849-a0b2-a74171f672b7",
      "name": "Summarise company posts",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1040,
        2380
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o",
          "cachedResultName": "GPT-4O"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Make summary of this company posts:\n{{ $json.text }}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1.8
    },
    {
      "id": "286996d7-510e-495d-95b6-fcfcd4fb15e5",
      "name": "Summarise company website",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        820,
        860
      ],
      "parameters": {
        "text": "=Research company website {{ $json.Website }} and get summary about business and products\n1. Get site-map with the tool\n2. Define what links may contain data about company business and products\n3. Scrape data for every links\n4. Summarize info from website ",
        "options": {},
        "promptType": "define"
      },
      "retryOnFail": true,
      "typeVersion": 1.8
    },
    {
      "id": "c660d9fe-7796-44dd-bed4-aa61f08ca485",
      "name": "Google Sheets11",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1740,
        1740
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
          "cachedResultName": "HDW_OutReach"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "executeOnce": true,
      "r

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

How this works

This workflow automatically finds and qualifies LinkedIn prospects, scores them for fit, and sends personalised messages using an AI agent. It suits sales teams and recruiters who need a steady flow of warm leads without spending hours on manual outreach. The core step is the AI agent pulling profile data through the AnySite LinkedIn node, then deciding the next action based on the score.

Use it when you run regular LinkedIn campaigns and already have a clear ideal-customer profile in Google Sheets. Skip it if you need real-time results or lack a self-hosted n8n instance, since the LinkedIn node will not work on n8n.cloud. A common variation replaces the scheduled trigger with a manual start for one-off campaigns.

About this workflow

⚠️ 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.

Source: https://n8n.io/workflows/3490/ — 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 was born out of a very real problem.

Output Parser Structured, OpenAI Chat, Memory Buffer Window +11
AI & RAG

Most blogs publish words. This system publishes experiences.

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

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 especial

Chain Llm, Agent, Agent Tool +6
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
AI & RAG

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Mailgun, OpenAI, OpenAI Chat +8