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 →
{
"id": "piapgd2e6zmzFxAq",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "HDW Lead Gel\u00e4ndewagen",
"tags": [],
"nodes": [
{
"id": "8fab1dcf-f454-4155-be32-a4e007a79ab0",
"name": "When chat message received",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-540,
280
],
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "c4791561-6919-46a9-8ee0-4328aac9bfa0",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-260,
520
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "gpt-4o"
},
"options": {}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
},
{
"id": "c82903df-8b58-4789-987a-116c11c78215",
"name": "Simple Memory",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
-120,
520
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "c65f5035-804f-4e50-948e-ab863e800393",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"notes": "For changing limits use \"count\"",
"position": [
20,
520
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"salesNavigatorParams\": {\n \"keywords\": \"additional keywords important to search but not mentioned in other fields\",\n \"current_titles\": \"title1, title2\",\n \"current_companies\": \"company1, company2\",\n \"location\": \"location1\",\n \"industry\": \"industry1\",\n \"company_sizes\": [\"Self-employed\", \"1-10\", \"11-50\", \"51-200\", \"201-500\", \"501-1,000\", \"1,001-5,000\", \"5,001-10,000\", \"10,001+\"]\n },\n \"count\": 50\n },\n {\n \"salesNavigatorParams\": {\n \"keywords\": \"additional keywords important to search but not mentioned in other fields\",\n \"current_titles\": \"title1, title2\",\n \"current_companies\": \"company1, company2\",\n \"location\": \"location2\",\n \"industry\": \"industry2\",\n \"company_sizes\": [\"Self-employed\", \"1-10\", \"11-50\", \"51-200\", \"201-500\", \"501-1,000\", \"1,001-5,000\", \"5,001-10,000\", \"10,001+\"]\n },\n \"count\": 50\n }\n]"
},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "fd939b62-927d-4532-96cd-36e91fdc2835",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
680,
140
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.url }}",
"URN": "={{ $json.urn.type }}:{{ $json.urn.value }}",
"img": "={{ $json.image }}",
"Date": "={{ $json.current_companies[0].joined }}",
"Name": "={{ $json.name }}",
"Headline": "={{ $json.headline }}",
"Industry": "={{ $json.current_companies[0].company.industry }}",
"Position": "={{ $json.current_companies[0].position }}",
"location": "={{ $json.location }}",
"is premium": "={{ $json.is_premium }}",
"Company URN": "={{ $json.current_companies[0].company.urn.type }}:{{ $json.current_companies[0].company.urn.value }}",
"Description": "={{ $json.current_companies[0].description }}",
"Current company": "={{ $json.current_companies[0].company.name }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"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": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "img",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "img",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Headline",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Headline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is premium",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is premium",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Current company",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Current company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company URN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company URN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"URN"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"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": "c98a9320-ca25-4a8d-a1a0-e7fd421976b7",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"maxTries": 5,
"position": [
980,
260
],
"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>"
}
},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "073214f0-b41c-41b0-af0f-136688bbbf24",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
1580
],
"parameters": {
"columns": {
"value": {
"URN": "={{ $('Google Sheets1').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": "307cc492-0b47-4824-95da-8f4b531626b7",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
780,
1300
],
"parameters": {
"options": {
"reset": false
}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "768f5782-f5fa-48ac-ad21-d8ec4912cce0",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
-240
],
"parameters": {
"color": 4,
"width": 1320,
"content": "Find leads in LinkedIn"
},
"typeVersion": 1
},
{
"id": "3dff0b52-fea3-486f-a605-f02b2e5e7b0b",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
860,
-240
],
"parameters": {
"color": 4,
"width": 980,
"content": "Get company website "
},
"typeVersion": 1
},
{
"id": "867138af-ad26-4fab-9c41-b3f99d8b70dc",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1880,
-780
],
"parameters": {
"color": 4,
"width": 1520,
"content": "Research company website"
},
"typeVersion": 1
},
{
"id": "f536cefc-27d3-474f-97d8-f3ae4ec55742",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3440,
-240
],
"parameters": {
"color": 4,
"width": 980,
"content": "Score data"
},
"typeVersion": 1
},
{
"id": "9aefe55c-4e03-46ae-98bd-628ca6d18694",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
4460,
-240
],
"parameters": {
"color": 4,
"width": 1860,
"content": "Communicate with leads"
},
"typeVersion": 1
},
{
"id": "7a1e6bbc-3b1a-46b5-a9b1-a2f381bf787c",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1880,
-600
],
"parameters": {
"color": 4,
"width": 1520,
"content": "Research lead LN post"
},
"typeVersion": 1
},
{
"id": "807e12e1-2cc2-46a6-bdac-2cc2e6ebe762",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1880,
-240
],
"parameters": {
"color": 4,
"width": 1520,
"content": "Research company LN post"
},
"typeVersion": 1
},
{
"id": "068b0826-d343-4882-b8c9-0666d0ac5b4b",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1880,
-420
],
"parameters": {
"color": 4,
"width": 1520,
"content": "Research company News"
},
"typeVersion": 1
},
{
"id": "fbd1394d-194c-47bd-81f4-2d7ff4a7dcb6",
"name": "HDW LinkedIn SN",
"type": "n8n-nodes-hdw.hdwLinkedin",
"onError": "continueRegularOutput",
"position": [
680,
340
],
"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 }}",
"current_companies": "={{ $json.output.salesNavigatorParams.current_companies }}"
}
},
"credentials": {
"hdwLinkedinApi": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 1
},
{
"id": "a9bca5e9-0fd0-4cd0-b24a-0114d958ba7f",
"name": "HDW Get Company Website",
"type": "n8n-nodes-hdw.hdwLinkedin",
"onError": "continueRegularOutput",
"position": [
940,
1480
],
"parameters": {
"company": "={{ $json[\"Company URN\"] }}",
"resource": "company"
},
"credentials": {
"hdwLinkedinApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"retryOnFail": true,
"typeVersion": 1,
"waitBetweenTries": 5000
},
{
"id": "99bc33ab-ef1c-4c61-a2b9-7306b104aacc",
"name": "Google Sheets3",
"type": "n8n-nodes-base.googleSheets",
"position": [
1900,
100
],
"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>"
}
},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "23a65054-34f2-4935-a764-a1c8cc530cc9",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2420,
80
],
"parameters": {
"options": {}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "f268ace9-4444-46ff-ad8a-0ceb453fff6f",
"name": "Google Sheets4",
"type": "n8n-nodes-base.googleSheets",
"position": [
1920,
640
],
"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>"
}
},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "6ddc37b0-061f-4307-be42-83d690897602",
"name": "HDW Get User Posts",
"type": "n8n-nodes-hdw.hdwLinkedin",
"position": [
2560,
680
],
"parameters": {
"urn": "={{ $('Post summary is empty').item.json.URN }}",
"operation": "getPosts"
},
"credentials": {
"hdwLinkedinApi": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "08f9365a-9efb-4927-84a1-7a5e8e9a0c49",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"position": [
2740,
680
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "text"
},
{
"renameField": true,
"outputFieldName": "repost",
"fieldToAggregate": "repost.text"
}
]
}
},
"retryOnFail": true,
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "5ca5128c-4313-4ea0-be08-347627ccd9bb",
"name": "Loop Over Items2",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2400,
520
],
"parameters": {
"options": {}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "828b2f34-aa9d-42e7-ac2e-9760da6aadc7",
"name": "Google Sheets5",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueRegularOutput",
"position": [
3240,
680
],
"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": "4d5f6214-f970-45b2-9c98-c1af5456f534",
"name": "Google Sheets6",
"type": "n8n-nodes-base.googleSheets",
"position": [
1920,
1100
],
"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>"
}
},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "9f3f1a52-01c0-4a87-808d-a268d7a6a7d0",
"name": "Aggregate1",
"type": "n8n-nodes-base.aggregate",
"position": [
2740,
1100
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "description"
}
]
}
},
"typeVersion": 1
},
{
"id": "805cfdc4-2413-45a1-b93f-b38cd84652b8",
"name": "Loop Over Items3",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2400,
940
],
"parameters": {
"options": {}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "7c19dbc2-8367-40d1-b8ea-b957cc9bf17d",
"name": "Google Sheets7",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueRegularOutput",
"position": [
3260,
1100
],
"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": "65d72d34-1908-4605-84ae-2047378ebab9",
"name": "Google Sheets8",
"type": "n8n-nodes-base.googleSheets",
"position": [
1920,
1600
],
"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>"
}
},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "99578141-b52e-400c-971c-d67da39825f9",
"name": "Aggregate2",
"type": "n8n-nodes-base.aggregate",
"position": [
2740,
1600
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "text"
}
]
}
},
"typeVersion": 1
},
{
"id": "4daa3a70-cb04-4b82-a424-cd726d196b05",
"name": "Loop Over Items4",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2400,
1460
],
"parameters": {
"options": {}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "c40d6767-46ae-48ba-9850-bb0c75c83279",
"name": "Google Sheets9",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueRegularOutput",
"position": [
3260,
1600
],
"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": "04175e5f-dba4-4462-9dcc-a07ec87b13f8",
"name": "HDW Get Company News",
"type": "n8n-nodes-hdw.hdwLinkedin",
"position": [
2560,
1100
],
"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": "4fe3c8cf-4376-4530-8bb3-9a3b63790bd4",
"name": "HDW Get Company Posts",
"type": "n8n-nodes-hdw.hdwLinkedin",
"onError": "continueRegularOutput",
"position": [
2560,
1600
],
"parameters": {
"urn": "={{ $('Google Sheets8').item.json[\"Company URN\"] }}",
"resource": "company",
"operation": "getCompanyPosts"
},
"credentials": {
"hdwLinkedinApi": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "34fd2f1e-f552-4680-960b-9d0a3708095e",
"name": "Loop Over Items5",
"type": "n8n-nodes-base.splitInBatches",
"position": [
460,
280
],
"parameters": {
"options": {}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "e8fcd801-4036-478d-8190-5c7a64a3b53f",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
240,
280
],
"parameters": {
"include": "allOtherFields",
"options": {},
"fieldToSplitOut": "output"
},
"retryOnFail": true,
"typeVersion": 1
},
{
"id": "26442be2-04bf-4c93-9b9f-8447ed0d8ca5",
"name": "OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2620,
340
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "gpt-4o"
},
"options": {}
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
},
{
"id": "5b36ec97-5b22-49bd-973f-6e42a3515f89",
"name": "Google Sheets10",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueRegularOutput",
"position": [
3220,
80
],
"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",
"defaultMat
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.
googleSheetsOAuth2ApihdwLinkedinApiopenAiApi
About this workflow
HDW Lead Geländewagen. Uses chatTrigger, lmChatOpenAi, memoryBufferWindow, outputParserStructured. Chat trigger; 92 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →