Dinakar Selvakumar This workflow corresponds to n8n.io template #12459 — we link there as the canonical source.
This workflow follows the Googlegemini → 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 →
{
"id": "Ho0Iwyxt3xHedful",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "9 Discover leads on LinkedIn and reach out using Google Sheets and Apify",
"tags": [],
"nodes": [
{
"id": "ee277423-dcc6-456e-8121-c9440a037b2d",
"name": "Search in Apify",
"type": "n8n-nodes-base.httpRequest",
"position": [
3584,
1712
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "ff4751b2-f4e7-4da2-99b6-527d3a3cf771",
"name": "Flatten Apify Results",
"type": "n8n-nodes-base.code",
"position": [
3840,
1712
],
"parameters": {},
"typeVersion": 2
},
{
"id": "587baaf0-2d2e-47b5-b30d-eeb3979bdb91",
"name": "Save in Database",
"type": "n8n-nodes-base.googleSheets",
"position": [
4048,
1712
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "b4f076b8-ac64-40ce-a8df-ad5c03343377",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
2784,
1568
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a34bc737-ba4d-4787-b933-569299b1e73a",
"name": "Generate LinkedIn Search Queries",
"type": "n8n-nodes-base.code",
"position": [
3072,
1728
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d3c57955-cfa2-46a5-b311-9344c45e76df",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
3328,
1728
],
"parameters": {},
"typeVersion": 3
},
{
"id": "3aea8f50-ab8e-4a6d-9a1d-65b97f776c83",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2208,
2032
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a4d3db85-18df-498e-abb8-b10bd528b3da",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2208,
1568
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aab6ee2f-761c-47dc-92e1-1fb1bcb446f4",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
3968,
1584
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "96840ffb-4900-4090-8832-325df40d68c4",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2288,
2144
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "02ba0c0d-0379-442c-8b84-0a68e031c47e",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3104,
2128
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ce384992-ea7e-4ded-ab92-3b3840a271f8",
"name": "Load Unenriched Profiles",
"type": "n8n-nodes-base.googleSheets",
"position": [
2368,
2176
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "82311881-78d8-4512-8dd8-aae4e9949a8f",
"name": "Process Each Profile",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2608,
2176
],
"parameters": {},
"typeVersion": 3
},
{
"id": "0a630adf-8437-4054-8006-5dc3d33f7a29",
"name": "Scrape LinkedIn Profile Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
2864,
2192
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "86263fea-b2b9-497d-8aac-7a147c51668c",
"name": "Generate Connection Message",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
3168,
2192
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d391e3e7-f1d4-4af8-b9fa-8d9f2d49b7cf",
"name": "Save Enriched Lead Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
3536,
2192
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "2c0f3bf2-d1a3-464a-bf9b-ec3031d9baf2",
"name": "Generate Follow-Up Message",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
3760,
2192
],
"parameters": {},
"typeVersion": 1
},
{
"id": "02bb239c-b33a-4df5-99eb-496b58185774",
"name": "Update Follow-Up in Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
4096,
2192
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "4d3822e1-9a56-401c-a1dd-c21a14152e14",
"name": "Mark Profile as Enriched",
"type": "n8n-nodes-base.googleSheets",
"position": [
4304,
2192
],
"parameters": {},
"typeVersion": 4.5
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "2a271222-25e3-4b73-88a9-2196aaa3e1ed",
"connections": {
"Loop Over Items": {
"main": [
[
{
"node": "Search in Apify",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Search in Apify": {
"main": [
[
{
"node": "Flatten Apify Results",
"type": "main",
"index": 0
}
]
]
},
"Process Each Profile": {
"main": [
[],
[
{
"node": "Scrape LinkedIn Profile Data",
"type": "main",
"index": 0
}
]
]
},
"Flatten Apify Results": {
"main": [
[
{
"node": "Save in Database",
"type": "main",
"index": 0
}
]
]
},
"Save Enriched Lead Data": {
"main": [
[
{
"node": "Generate Follow-Up Message",
"type": "main",
"index": 0
}
]
]
},
"Load Unenriched Profiles": {
"main": [
[
{
"node": "Process Each Profile",
"type": "main",
"index": 0
}
]
]
},
"Mark Profile as Enriched": {
"main": [
[
{
"node": "Process Each Profile",
"type": "main",
"index": 0
}
]
]
},
"Update Follow-Up in Sheet": {
"main": [
[
{
"node": "Mark Profile as Enriched",
"type": "main",
"index": 0
}
]
]
},
"Generate Follow-Up Message": {
"main": [
[
{
"node": "Update Follow-Up in Sheet",
"type": "main",
"index": 0
}
]
]
},
"Generate Connection Message": {
"main": [
[
{
"node": "Save Enriched Lead Data",
"type": "main",
"index": 0
}
]
]
},
"Scrape LinkedIn Profile Data": {
"main": [
[
{
"node": "Generate Connection Message",
"type": "main",
"index": 0
}
]
]
},
"Generate LinkedIn Search Queries": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This n8n template helps you discover LinkedIn profiles using Google Search, enrich them with public data, and generate personalized outreach messages — all without unsafe browser automation. Safe LinkedIn lead discovery without direct scraping Scalable batch processing using…
Source: https://n8n.io/workflows/12459/ — 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.
End-to-end lead pipeline (discovery → enrichment → outreach) Google Search–based LinkedIn discovery (safe approach) Batch processing with controlled loops AI-generated cold emails and follow-ups Googl
This n8n template automates website analysis and ecommerce URL classification using AI. It scrapes a website, extracts business intelligence, maps all internal pages, and categorises them into product
This n8n workflow automates the process of scraping LinkedIn profiles using the Apify platform and organizing the extracted data into Google Sheets for easy analysis and follow-up. Lead Generation: Ex
This workflow is Part 2 of the HR Client Acquisition system and builds on the lead discovery pipeline from the previous workflow:
Community nodes are used in this workflow. B2B Sales Teams & SDRs Recruitment Agencies & Tech Recruiters Startup Founders Growth Marketing Teams Scrape Hiring Signals: The workflow starts by using an