This workflow corresponds to n8n.io template #6585 — we link there as the canonical source.
This workflow follows the Apifyn8N Nodes Apify → 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": "c8tApUdT1kvPFl44",
"name": "Automated Advanced Prospect Outreach & Nurturing Campaign System with AI",
"tags": [],
"nodes": [
{
"id": "3cdd35e4-2f5a-446e-b152-a428725716d4",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7e28b2fa-b905-44c7-9246-9a59e44235b8",
"name": "LinkedIn Profile Scraper",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
224,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "90b8c4ff-f79a-4b2f-a931-edd3e14561e7",
"name": "Extract Key LinkedIn Data",
"type": "n8n-nodes-base.code",
"position": [
448,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f2c5dad3-7423-4d89-915d-7ab3404257ab",
"name": "Email Finder",
"type": "n8n-nodes-base.hunter",
"disabled": true,
"position": [
672,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "be292948-3841-4b35-bfa6-5921dc83976e",
"name": "Consolidate Prospect Data",
"type": "n8n-nodes-base.code",
"position": [
896,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "077d8121-67d5-43ac-9527-e636fb8addab",
"name": "Initial Prospect Storage",
"type": "n8n-nodes-base.googleSheets",
"position": [
1120,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "4457757f-fed0-4334-b1c2-c0b6329eed22",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "93ea6243-cb58-49e6-a97e-230ef099316e",
"name": "Retrieve Prospects for Outreach",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
320
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "bb4698c2-f114-4679-ab2d-08a6680f1601",
"name": "Prepare Data for AI Agents",
"type": "n8n-nodes-base.code",
"position": [
224,
320
],
"parameters": {},
"typeVersion": 2
},
{
"id": "85965779-2734-4c33-9547-9da018ed28c7",
"name": "Personalization Writer - Opening Line",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
448,
320
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "e3d7fea9-6a70-4e23-9d6d-ab9876e97976",
"name": "Value Proposition Tailor - Body",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
848,
320
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "935f9178-87d7-4d15-8633-7e48b8f141c4",
"name": "Subject Line & CTA Optimizer",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1248,
320
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "55514334-1bbd-40c1-bb48-a2f8d72ac26d",
"name": "Assemble Final Email",
"type": "n8n-nodes-base.code",
"position": [
1600,
320
],
"parameters": {},
"typeVersion": 2
},
{
"id": "069af889-9fe7-4558-b6a1-bcabbb9a8290",
"name": "Send Personalized Email",
"type": "n8n-nodes-base.gmail",
"position": [
0,
640
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "3b50c55d-7785-446d-aba2-875b494bb2df",
"name": "Update Email Sent Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
224,
640
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "e693a3cf-f811-4b4f-813a-ffdb0b7258dd",
"name": "For Engagement Tracking",
"type": "n8n-nodes-base.wait",
"position": [
432,
640
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "c4331b02-19d3-4b0d-8a51-d8407cbf36d3",
"name": "Retrieve Prospect for Follow-up",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
912
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "b8da47e4-ce9b-4f2f-b3b1-c6103b8d64cc",
"name": "Check for Reply",
"type": "n8n-nodes-base.if",
"position": [
208,
912
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "966cef84-3b54-4a4a-86f1-fc3c7d240cbe",
"name": "Notify Sales Team",
"type": "n8n-nodes-base.slack",
"position": [
432,
1136
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "d77ca7ae-5098-4fd1-8773-779ec5ab1d60",
"name": "Check Follow-up Limit",
"type": "n8n-nodes-base.if",
"position": [
432,
912
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c2ea3eaf-0ece-4d0f-8ef3-c7bd81642d8b",
"name": "Archive Prospect",
"type": "n8n-nodes-base.googleSheets",
"position": [
752,
1152
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "6c414883-32b9-4577-aa81-59f90fea0fc5",
"name": "Follow-up Email Generator",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
672,
912
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "a6aede10-bc56-4bdd-8c6d-cb3465fe7291",
"name": "Send Follow-up Email",
"type": "n8n-nodes-base.gmail",
"position": [
1024,
912
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "c5d11419-7996-4124-b43f-7d2fd8e500ff",
"name": "Update Follow-up Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
1232,
912
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "851e65a7-155c-4953-8d4e-d47082b4f82c",
"name": "For Next Follow-up or Nurture",
"type": "n8n-nodes-base.wait",
"position": [
1440,
912
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "ad6b2dab-8ad2-4963-a7f9-493f2d93ae50",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1648,
912
],
"parameters": {},
"typeVersion": 3
},
{
"id": "4f99f058-65fd-4073-85d0-f93c3ecd34b3",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
224
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "33aa6722-6ac0-4ee2-84c8-c3fbb11748e0",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
592
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bd65062a-e895-48f4-a130-a4efc7dcaa5f",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
864
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "920116ab-3696-4d7a-a845-c66afb0e6d6a",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1392,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "863a3143-14ff-488d-ac21-e3347c18c51b",
"connections": {
"Email Finder": {
"main": [
[
{
"node": "Consolidate Prospect Data",
"type": "main",
"index": 0
}
]
]
},
"Check for Reply": {
"main": [
[
{
"node": "Check Follow-up Limit",
"type": "main",
"index": 0
}
],
[
{
"node": "Notify Sales Team",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Retrieve Prospect for Follow-up",
"type": "main",
"index": 0
}
]
]
},
"Assemble Final Email": {
"main": [
[
{
"node": "Send Personalized Email",
"type": "main",
"index": 0
}
]
]
},
"Send Follow-up Email": {
"main": [
[
{
"node": "Update Follow-up Status",
"type": "main",
"index": 0
}
]
]
},
"Check Follow-up Limit": {
"main": [
[
{
"node": "Follow-up Email Generator",
"type": "main",
"index": 0
}
],
[
{
"node": "Archive Prospect",
"type": "main",
"index": 0
}
]
]
},
"For Engagement Tracking": {
"main": [
[
{
"node": "Retrieve Prospect for Follow-up",
"type": "main",
"index": 0
}
]
]
},
"Send Personalized Email": {
"main": [
[
{
"node": "Update Email Sent Status",
"type": "main",
"index": 0
}
]
]
},
"Update Follow-up Status": {
"main": [
[
{
"node": "For Next Follow-up or Nurture",
"type": "main",
"index": 0
}
]
]
},
"Initial Prospect Storage": {
"main": [
[
{
"node": "Retrieve Prospects for Outreach",
"type": "main",
"index": 0
}
]
]
},
"LinkedIn Profile Scraper": {
"main": [
[
{
"node": "Extract Key LinkedIn Data",
"type": "main",
"index": 0
}
]
]
},
"Update Email Sent Status": {
"main": [
[
{
"node": "For Engagement Tracking",
"type": "main",
"index": 0
}
]
]
},
"Consolidate Prospect Data": {
"main": [
[
{
"node": "Initial Prospect Storage",
"type": "main",
"index": 0
}
]
]
},
"Extract Key LinkedIn Data": {
"main": [
[
{
"node": "Email Finder",
"type": "main",
"index": 0
}
]
]
},
"Follow-up Email Generator": {
"main": [
[
{
"node": "Send Follow-up Email",
"type": "main",
"index": 0
}
]
]
},
"Prepare Data for AI Agents": {
"main": [
[
{
"node": "Personalization Writer - Opening Line",
"type": "main",
"index": 0
}
]
]
},
"Subject Line & CTA Optimizer": {
"main": [
[
{
"node": "Assemble Final Email",
"type": "main",
"index": 0
}
]
]
},
"For Next Follow-up or Nurture": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Prospect for Follow-up": {
"main": [
[
{
"node": "Check for Reply",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Prospects for Outreach": {
"main": [
[
{
"node": "Prepare Data for AI Agents",
"type": "main",
"index": 0
}
]
]
},
"Value Proposition Tailor - Body": {
"main": [
[
{
"node": "Subject Line & CTA Optimizer",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "LinkedIn Profile Scraper",
"type": "main",
"index": 0
}
]
]
},
"Personalization Writer - Opening Line": {
"main": [
[
{
"node": "Value Proposition Tailor - Body",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Imagine a relentless, intelligent sales assistant working for you 24/7. That's exactly what this system is. It takes the grueling, manual work of outreach and transforms it into a precision-guided, automated process that wins clients. Your Target Identified & Profiled: You…
Source: https://n8n.io/workflows/6585/ — 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.
Complete AI-powered sales system Automates lead capture, qualification, and follow-up from multiple channels. AI INTELLIGENCE:
Overview
Consultants, agencies, freelancers, and professional service firms who need to create customized proposals and contracts quickly and efficiently.
A fully automated, AI-powered email assistant built in n8n that reads incoming emails, understands their intent and sentiment, classifies them by category, drafts intelligent context-aware replies, an
Small teams, solo operators, and security-conscious individuals who receive email attachments from external senders. Useful for freelancers, agencies, HR teams, and anyone handling CVs, invoices, or d