This workflow follows the Agent → Chat Trigger 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 →
{
"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
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow transforms casual chats into structured leads for high-end Geländewagen sales, capturing customer interests in Mercedes-Benz's iconic off-roader and routing them directly to your CRM. It's designed for automotive dealerships or luxury car brokers who want to automate lead qualification without manual data entry, saving hours on follow-ups. The key step involves OpenAI analysing chat messages to extract details like budget and preferences, then parsing them into a clean format before appending to Google Sheets for seamless team access.
Use this when handling inbound queries via chat interfaces like WhatsApp or website bots, especially during peak seasons for vehicle enquiries. Avoid it for non-conversational leads or if you lack OpenAI API access, as it relies heavily on AI parsing. Common variations include swapping Google Sheets for HubSpot integration or adding email notifications for urgent high-value leads.
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 →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Who’s it for Creators who want to create faceless videos automatically, while keeping human oversight and quality control.
Read Write File, Agent, OpenAI Chat +7
The Best Linkedin Posting System. Uses httpRequest, lmChatOpenAi, agent, chatTrigger. Chat trigger; 49 nodes.
HTTP Request, OpenAI Chat, Agent +8
Who is this workflow for? This workflow is designed for SEO analysts, content creators, marketing agencies, and developers who need to index a website and then interact with its content as if it were
Agent, OpenAI Chat, Memory Buffer Window +10
This project is an automation workflow that generates a personalized resume and cover letter for each job listing. Generates an HTML resume from your data. Hosts it live on GitHub Pages. Converts it t
HTTP Request, Agent, OpenAI Chat +10
Are you tired of manually sifting through hundreds of LinkedIn profiles to find the right talent? Say goodbye to inefficient recruiting processes and embrace the power of AI-driven candidate selection
Chat Trigger, Agent, OpenAI Chat +5