This workflow follows the Agent → Google Sheets 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": "Company Enrichment",
"nodes": [
{
"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": "1f77cdfc-ec9e-44ed-bcb2-ad1ac777c1b7",
"name": "Google Sheets3",
"type": "n8n-nodes-base.googleSheets",
"position": [
3056,
736
],
"executeOnce": true,
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"parameters": {
"options": {}
},
"id": "77e8bfd8-bdd7-4bd7-9221-5629f44199db",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
3584,
720
],
"retryOnFail": true,
"typeVersion": 3
},
{
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "gpt-4o"
},
"options": {}
},
"id": "8996b019-923b-4ce8-96d4-0c47bbba749d",
"name": "OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3792,
976
],
"typeVersion": 1.2
},
{
"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": "={{ $('Website is not empty').item.json.URN }}",
"Product Summary": "={{ $json.output }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "img",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "img",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Headline",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Headline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is premium",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "is premium",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Current company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Current company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company URN",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company URN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Posts summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Posts summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Product Summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Product Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company News",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company News",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"URN"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"id": "2abd4bcb-2bc1-4a8c-a696-cdfe4519430c",
"name": "Google Sheets10",
"type": "n8n-nodes-base.googleSheets",
"position": [
4384,
720
],
"retryOnFail": true,
"typeVersion": 4.5,
"onError": "continueRegularOutput"
},
{
"parameters": {},
"id": "d2818f93-e080-40c0-ad67-7ce178b0a6c2",
"name": "HDW Site-map",
"type": "n8n-nodes-hdw.hdwWebParserTool",
"position": [
4112,
976
],
"typeVersion": 1,
"credentials": {}
},
{
"parameters": {},
"id": "066b42f5-89df-45ec-8da5-24da264cfa2e",
"name": "HDW Parser",
"type": "n8n-nodes-hdw.hdwWebParserTool",
"position": [
4272,
976
],
"typeVersion": 1,
"credentials": {}
},
{
"parameters": {
"promptType": "define",
"text": "=Research company website {{ $json.Website }} and get summary about business and products\n1. Get site-map with the tool\n2. Define what links may contain data about company business and products\n3. Scrape data for every links\n4. Summarize info from website ",
"options": {}
},
"id": "60165c8a-1dea-4504-baa7-0e7c9d559f70",
"name": "Summarise company website",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
3872,
720
],
"retryOnFail": true,
"typeVersion": 1.8
},
{
"parameters": {
"content": "At this stage, the presence of the company name in the lead's profile is verified, and a website search is performed for each company",
"height": 120,
"width": 320,
"color": 7
},
"id": "9db15072-0e06-4c91-b911-df5ffd3fbdcb",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
2944,
544
],
"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": "e19504a5-7608-4224-80de-80d2f44020a9",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
3792,
576
],
"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.Website }}",
"rightValue": ""
},
{
"id": "96105806-c0b8-461d-8cc1-975d8936814c",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json[\"Product Summary\"] }}",
"rightValue": ""
}
]
},
"options": {}
},
"id": "9c01b8e2-a6e0-4b4f-af46-47d10aa1554b",
"name": "Website is not empty",
"type": "n8n-nodes-base.if",
"position": [
3280,
736
],
"typeVersion": 2.2
}
],
"connections": {
"Google Sheets3": {
"main": [
[
{
"node": "Website is not empty",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "Summarise company website",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Summarise company website",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Google Sheets10": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Summarise company website": {
"main": [
[
{
"node": "Google Sheets10",
"type": "main",
"index": 0
}
]
]
},
"Website is not empty": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"availableInMCP": false
},
"versionId": "32c56b44-4d33-4cb5-b323-a3b30247d591",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "u44RUCBu9hvRv0gh",
"tags": []
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Company Enrichment. Uses googleSheets, lmChatOpenAi, n8n-nodes-hdw, agent. Manual trigger; 10 nodes.
Source: https://github.com/anshwysmcbel2710/ai-linkedin-lead-generation-machine/blob/main/workflows/02-company-enrichment.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.
Lead Discovery. Uses lmChatOpenAi, outputParserStructured, n8n-nodes-hdw, agent. Manual trigger; 10 nodes.
OpenAI Chat, Output Parser Structured, N8N Nodes Hdw +2
⚠️ DISCLAIMER: This workflow uses the AnySite LinkedIn community node, which is only available on self-hosted n8n instances. It will not work on n8n.cloud.
OpenAI Chat, Output Parser Structured, Google Sheets +6
HDW Lead Geländewagen. Uses chatTrigger, lmChatOpenAi, memoryBufferWindow, outputParserStructured. Chat trigger; 92 nodes.
Chat Trigger, OpenAI Chat, Memory Buffer Window +5
This workflow automates your entire sales outreach process across LinkedIn, Email, and WhatsApp using AI to create hyper-personalized messages for each prospect. Instead of spending hours crafting ind
Google Sheets, Gmail, Agent +4
LEAD RESEARCH ENRICHMENT. Uses stickyNote, toolSerpApi, lmChatOpenAi, outputParserStructured. Manual trigger; 19 nodes.
Tool Serp Api, OpenAI Chat, Output Parser Structured +3