This workflow follows the Google Sheets → OpenAI 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 →
{
"name": "Content Intelligence",
"nodes": [
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"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": {}
},
"id": "5e6ab1d0-1170-4159-a3d1-433bc05f2333",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1280,
1440
],
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"parameters": {
"options": {
"reset": false
}
},
"id": "3f9eca5f-e132-4f80-85b0-86abe6d911e4",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
816,
1024
],
"retryOnFail": true,
"typeVersion": 3
},
{
"parameters": {},
"id": "8da051bc-0296-4840-a6d2-15fed6db6328",
"name": "HDW Get Company Website",
"type": "n8n-nodes-hdw.hdwLinkedin",
"position": [
1152,
1296
],
"notesInFlow": true,
"retryOnFail": true,
"typeVersion": 1,
"waitBetweenTries": 5000,
"credentials": {},
"onError": "continueRegularOutput"
},
{
"parameters": {
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"options": {}
},
"id": "899ea38d-35af-44fb-8580-007e7d1531fd",
"name": "Google Sheets4",
"type": "n8n-nodes-base.googleSheets",
"position": [
1648,
912
],
"executeOnce": true,
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"parameters": {},
"id": "841a252c-999e-44e3-98a5-7badf53ddd61",
"name": "HDW Get User Posts",
"type": "n8n-nodes-hdw.hdwLinkedin",
"position": [
2384,
784
],
"retryOnFail": true,
"typeVersion": 1,
"alwaysOutputData": true,
"credentials": {}
},
{
"parameters": {
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "text"
},
{
"fieldToAggregate": "repost.text",
"renameField": true,
"outputFieldName": "repost"
}
]
},
"options": {}
},
"id": "a01759ea-c61b-443a-aba4-860e77889a0b",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"position": [
2544,
784
],
"retryOnFail": true,
"typeVersion": 1,
"alwaysOutputData": true
},
{
"parameters": {
"options": {}
},
"id": "408d081d-a7b4-45e7-a6c9-e2d73a620bd2",
"name": "Loop Over Items2",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2240,
656
],
"retryOnFail": true,
"typeVersion": 3
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"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": {}
},
"id": "3679893e-55e4-4fe2-9b60-9b7be2f31f09",
"name": "Google Sheets5",
"type": "n8n-nodes-base.googleSheets",
"position": [
3072,
784
],
"retryOnFail": true,
"typeVersion": 4.5,
"onError": "continueRegularOutput"
},
{
"parameters": {
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"options": {}
},
"id": "1f61579f-9a77-4f95-b878-88d1afc180ca",
"name": "Google Sheets6",
"type": "n8n-nodes-base.googleSheets",
"position": [
1744,
1232
],
"executeOnce": true,
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"parameters": {
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "description"
}
]
},
"options": {}
},
"id": "91cb3b22-6673-444c-bf9d-c906a0c593be",
"name": "Aggregate1",
"type": "n8n-nodes-base.aggregate",
"position": [
2576,
1248
],
"typeVersion": 1
},
{
"parameters": {
"options": {}
},
"id": "b860ac8b-efa2-4a67-880a-a58210e0ac31",
"name": "Loop Over Items3",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2240,
1056
],
"retryOnFail": true,
"typeVersion": 3
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"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": {}
},
"id": "10642f10-4a60-4ea9-8ffb-e1403dca1ad5",
"name": "Google Sheets7",
"type": "n8n-nodes-base.googleSheets",
"position": [
3104,
1232
],
"retryOnFail": true,
"typeVersion": 4.5,
"onError": "continueRegularOutput"
},
{
"parameters": {
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"options": {}
},
"id": "5debfe8d-af72-4d1f-82e0-14c381318c36",
"name": "Google Sheets8",
"type": "n8n-nodes-base.googleSheets",
"position": [
1744,
1504
],
"executeOnce": true,
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"parameters": {
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "text"
}
]
},
"options": {}
},
"id": "8458898b-a026-4ab7-aa27-f63368ad7158",
"name": "Aggregate2",
"type": "n8n-nodes-base.aggregate",
"position": [
2576,
1648
],
"typeVersion": 1
},
{
"parameters": {
"options": {}
},
"id": "1904c091-70fc-4920-b935-201675855f37",
"name": "Loop Over Items4",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2288,
1488
],
"retryOnFail": true,
"typeVersion": 3
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"mode": "list",
"value": "19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit?usp=drivesdk",
"cachedResultName": "HDW_OutReach"
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19n84gbJPp-VmAUz6fElLSQcMajh5btPvI7Lhf20u7hs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"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": {}
},
"id": "3060dfa0-375c-4f2e-9aed-ecebc46bf481",
"name": "Google Sheets9",
"type": "n8n-nodes-base.googleSheets",
"position": [
3104,
1648
],
"retryOnFail": true,
"typeVersion": 4.5,
"onError": "continueRegularOutput"
},
{
"parameters": {},
"id": "8f64e608-bbc2-4bfe-9a4f-8f3174e17726",
"name": "HDW Get Company News",
"type": "n8n-nodes-hdw.hdwLinkedin",
"position": [
2400,
1232
],
"retryOnFail": true,
"typeVersion": 1,
"alwaysOutputData": true,
"credentials": {}
},
{
"parameters": {},
"id": "15e27cbc-8d36-4a16-af3b-b1c1bc2166c7",
"name": "HDW Get Company Posts",
"type": "n8n-nodes-hdw.hdwLinkedin",
"position": [
2400,
1648
],
"retryOnFail": true,
"typeVersion": 1,
"alwaysOutputData": true,
"credentials": {},
"onError": "continueRegularOutput"
},
{
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"messages": {
"values": [
{
"content": "=Make summary of this text:\n {{ $json.text }}\n{{ $json.repost }}"
}
]
},
"options": {}
},
"id": "cfc354d3-f387-4546-a7b7-d07365b403d7",
"name": "Summarise user posts",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
2736,
784
],
"retryOnFail": true,
"typeVersion": 1.8
},
{
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"messages": {
"values": [
{
"content": "=Make summary of this news:\n{{ $json.description }}"
}
]
},
"options": {}
},
"id": "1db3c686-8d0c-4923-b7d0-06b7ff441255",
"name": "Summarise company news",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
2752,
1248
],
"retryOnFail": true,
"typeVersion": 1.8
},
{
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"messages": {
"values": [
{
"content": "=Make summary of this company posts:\n{{ $json.text }}"
}
]
},
"options": {}
},
"id": "a66130c7-b211-482f-b6a6-e14d00c875bd",
"name": "Summarise company posts",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
2752,
1648
],
"retryOnFail": true,
"typeVersion": 1.8
},
{
"parameters": {
"content": "You can modify the prompt here so that at this stage the search corresponds to your product. \nFor example, you can explicitly mark mentions of certain topics, locations, or other entities.",
"height": 100,
"width": 360,
"color": 5
},
"id": "73fc5955-f409-46ec-861f-47b9cd2a086b",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
2672,
624
],
"typeVersion": 1
},
{
"parameters": {
"content": "You can modify the prompt here so that at this stage the search corresponds to your product. \nFor example, you can explicitly mark mentions of certain topics, locations, or other entities.",
"height": 100,
"width": 360,
"color": 5
},
"id": "570bbced-6f3b-472e-bef3-da05e8122411",
"name": "Sticky Note14",
"type": "n8n-nodes-base.stickyNote",
"position": [
2576,
1120
],
"typeVersion": 1
},
{
"parameters": {
"content": "You can modify the prompt here so that at this stage the search corresponds to your product. \nFor example, you can explicitly mark mentions of certain topics, locations, or other entities.",
"height": 100,
"width": 360,
"color": 5
},
"id": "3a4504f9-13dc-486f-afe8-04155ded5682",
"name": "Sticky Note15",
"type": "n8n-nodes-base.stickyNote",
"position": [
2688,
1504
],
"typeVersion": 1
},
{
"parameters": {
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3f21375a-b09c-464d-a82a-b37f7b6de87b",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.URN }}",
"rightValue": ""
},
{
"id": "96105806-c0b8-461d-8cc1-975d8936814c",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json[\"Posts summary\"] }}",
"rightValue": ""
}
]
},
"options": {}
},
"id": "35bac78c-38bb-40b7-ab21-2ec3f49924c5",
"name": "Post summary is empty",
"type": "n8n-nodes-base.if",
"position": [
1936,
912
],
"typeVersion": 2.2
},
{
"parameters": {
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3f21375a-b09c-464d-a82a-b37f7b6de87b",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.URN }}",
"rightValue": ""
},
{
"id": "96105806-c0b8-461d-8cc1-975d8936814c",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json[\"Company News\"] }}",
"rightValue": ""
}
]
},
"options": {}
},
"id": "2028871a-6cd5-49f5-af70-9bd656f518c2",
"name": "Company news is empty",
"type": "n8n-nodes-base.if",
"position": [
1984,
1232
],
"typeVersion": 2.2
},
{
"parameters": {
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3f21375a-b09c-464d-a82a-b37f7b6de87b",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json[\"Company URN\"] }}",
"rightValue": ":"
},
{
"id": "96105806-c0b8-461d-8cc1-975d8936814c",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json[\"Company post summary\"] }}",
"rightValue": ""
},
{
"id": "44880d26-6f7d-4ee6-a71c-1cee7733368a",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json[\"Company URN\"] }}",
"rightValue": ""
}
]
},
"options": {}
},
"id": "fd4f51ec-a0ee-4efa-a485-f2468fa48879",
"name": "Company post is empty",
"type": "n8n-nodes-base.if",
"position": [
2000,
1504
],
"typeVersion": 2.2
},
{
"parameters": {
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "4d0c7d09-934f-4327-9eed-e1c04b773166",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Website }}",
"rightValue": ""
}
]
},
"options": {}
},
"id": "8f3217e3-edaf-4f09-83e6-6cf5788997f3",
"name": "If4",
"type": "n8n-nodes-base.if",
"position": [
976,
1168
],
"typeVersion": 2.2
},
{
"parameters": {
"numberInputs": 4
},
"id": "c0990b89-e98f-40d0-8d1c-32d0369d57c5",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
3280,
992
],
"typeVersion": 3.1
}
],
"connections": {
"Google Sheets2": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Google Sheets4",
"type": "main",
"index": 0
},
{
"node": "Google Sheets6",
"type": "main",
"index": 0
},
{
"node": "Google Sheets8",
"type": "main",
"index": 0
}
],
[
{
"node": "If4",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets4": {
"main": [
[
{
"node": "Post summary is empty",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Summarise user posts",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items2": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Google Sheets5": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets6": {
"main": [
[
{
"node": "Company news is empty",
"type": "main",
"index": 0
}
]
]
},
"Aggregate1": {
"main": [
[
{
"node": "Summarise company news",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items3": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Google Sheets7": {
"main": [
[
{
"node": "Loop Over Items3",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets8": {
"main": [
[
{
"node": "Company post is empty",
"type": "main",
"index": 0
}
]
]
},
"Aggregate2": {
"main": [
[
{
"node": "Summarise company posts",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items4": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 3
}
]
]
},
"Google Sheets9": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Summarise user posts": {
"main": [
[
{
"node": "Google Sheets5",
"type": "main",
"index": 0
}
]
]
},
"Summarise company news": {
"main": [
[
{
"node": "Google Sheets7",
"type": "main",
"index": 0
}
]
]
},
"Summarise company posts": {
"main": [
[
{
"node": "Google Sheets9",
"type": "main",
"index": 0
}
]
]
},
"Post summary is empty": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"Company news is empty": {
"main": [
[
{
"node": "Loop Over Items3",
"type": "main",
"index": 0
}
]
]
},
"Company post is empty": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"If4": {
"main": [
[],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"availableInMCP": false
},
"versionId": "fa5e16dd-74a6-4d13-9eeb-3b0fa1d808ba",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "URsKYgfWqnnWgjxh",
"tags": []
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Content Intelligence. Uses googleSheets, n8n-nodes-hdw, openAi. Manual trigger; 29 nodes.
Source: https://github.com/anshwysmcbel2710/ai-linkedin-lead-generation-machine/blob/main/workflows/03-content-intelligence.json — 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.
Use cases are many: Perfect for freelancers managing client invoices, small businesses handling supplier bills, accounting departments processing high invoice volumes, or anyone who wants to eliminate
OpenAI, Google Drive, Google Sheets +3
Supercharge your sales and marketing efforts with this powerful automation that transforms a list of LinkedIn profiles into a fully enriched, personalized outreach campaign. This workflow is designed
HTTP Request, OpenAI, Google Sheets
AI Reel Factory - RSS Feed Monitor. Uses rssFeedRead, openAi, googleSheets. Manual trigger; 6 nodes.
RSS Feed Read, OpenAI, Google Sheets
Lead Scoring. Uses googleSheets, openAi. Manual trigger; 6 nodes.
Google Sheets, OpenAI
Openai Twitter. Uses googleSheets, openAi, twitter. Manual trigger; 5 nodes.
Google Sheets, OpenAI, Twitter