This workflow corresponds to n8n.io template #6101 — we link there as the canonical source.
This workflow follows the Form Trigger → 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 →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "4e9caad2-ee4c-40a1-ae1e-b83e68bd4379",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cc1a0044-84e4-434b-937b-0c4617d448f6",
"name": "Generate Query",
"type": "n8n-nodes-base.set",
"position": [
740,
160
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c0ea2d57-8d46-4b66-8ba6-8ad43e22a4e9",
"name": "Create Apollo URL",
"type": "n8n-nodes-base.code",
"position": [
940,
160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4dee498d-5372-4853-8d95-59ee4f33da80",
"name": "Filter",
"type": "n8n-nodes-base.filter",
"position": [
1600,
160
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "6e61100a-ccc2-443d-8ce9-b97927525caa",
"name": "Save Prospects",
"type": "n8n-nodes-base.googleSheets",
"position": [
1780,
160
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "027958db-43e4-4ce8-83d0-7fda87c21f64",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "85c5a3c5-a390-439e-8ce2-cda77a2fd2cd",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
360
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1b817f0c-99f7-45a1-af8f-ae6106aa755c",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1120,
60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d0b503a3-0df0-4cf2-b37b-f1c627223d36",
"name": "Apollo Scraper (paid)",
"type": "n8n-nodes-base.httpRequest",
"position": [
2100,
160
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "1784549b-f019-48c4-99ed-f052566b4ac4",
"name": "Apollo Scraper",
"type": "n8n-nodes-base.httpRequest",
"position": [
1180,
160
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "ced2c256-baba-4576-b289-9d6e89b07681",
"name": "Extract Info",
"type": "n8n-nodes-base.set",
"position": [
1420,
160
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "94072872-68a7-4e5c-8b21-601d05873b77",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
1500,
500
],
"parameters": {},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "c0cf0744-52db-4129-b8f4-f99e7e9a36e0",
"name": "Check Time Zone",
"type": "n8n-nodes-base.code",
"position": [
1400,
780
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "277d7eff-c268-462b-a4de-c89d81d8282a",
"name": "Assign Sender Email",
"type": "n8n-nodes-base.code",
"position": [
1600,
780
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "4b2abdee-a7a0-4849-918b-e7001bd6a3cf",
"name": "Add Opt Out Token",
"type": "n8n-nodes-base.code",
"position": [
1800,
780
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "008ef762-e4c0-4416-8272-f351cd027d0e",
"name": "Save Emails",
"type": "n8n-nodes-base.googleSheets",
"position": [
2000,
780
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "24030301-9a0f-448a-a96f-6f1971bd2e3f",
"name": "Save Analysis",
"type": "n8n-nodes-base.googleSheets",
"position": [
2200,
780
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "aa7b5706-ba2b-405f-9941-a12678a5b3fb",
"name": "Generate LinkedIn Opener",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
740,
780
],
"parameters": {},
"typeVersion": 1.8,
"alwaysOutputData": true
},
{
"id": "7e40ecbc-4599-41d9-ae48-41a4e96a2fef",
"name": "Analyse Data",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
2040,
500
],
"parameters": {},
"typeVersion": 1.8,
"alwaysOutputData": true
},
{
"id": "ad2a1478-ebce-4242-8bbb-8370593b2a5f",
"name": "Genrate Emails",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1060,
780
],
"parameters": {},
"typeVersion": 1.8,
"alwaysOutputData": true
},
{
"id": "2a355964-a612-429e-9361-b89477c9ae77",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
520,
540
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "28673b4e-4070-4296-9f8c-2f8e24b905f7",
"name": "If Linkedin Exists?",
"type": "n8n-nodes-base.if",
"position": [
1100,
540
],
"parameters": {},
"typeVersion": 2.2,
"alwaysOutputData": true
},
{
"id": "cbfbb06c-0b1a-4eb5-ae3b-5da392d9e0d2",
"name": "Get Prospects",
"type": "n8n-nodes-base.googleSheets",
"position": [
700,
540
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "017e420a-0519-4f88-add0-56f4b6993787",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
880,
540
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "b5804cf2-9627-4768-bbeb-876a6b9f4359",
"name": "Linkedin Scraper",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
1320,
500
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "e90194c7-4ad4-4897-ad6a-aae2afd05d68",
"name": "Company Scraper",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
1680,
500
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "424c5674-7203-426d-ab0d-e5826e88ff23",
"name": "Organise Response",
"type": "n8n-nodes-base.code",
"position": [
540,
780
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "b66d0cb5-ecaf-4bd9-a05e-8587f578ffa1",
"name": "About You",
"type": "n8n-nodes-base.set",
"position": [
1860,
500
],
"parameters": {},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "251054db-dbd7-4def-ac70-a7d4d3ff9a67",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2040,
60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c2056d09-2472-4cad-bc92-3b15e7a88ff2",
"name": "Enter Target Audience",
"type": "n8n-nodes-base.formTrigger",
"position": [
540,
160
],
"parameters": {},
"typeVersion": 2.2
}
],
"connections": {
"Filter": {
"main": [
[
{
"node": "Save Prospects",
"type": "main",
"index": 0
}
]
]
},
"About You": {
"main": [
[
{
"node": "Analyse Data",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Company Scraper",
"type": "main",
"index": 0
}
]
]
},
"Save Emails": {
"main": [
[
{
"node": "Save Analysis",
"type": "main",
"index": 0
}
]
]
},
"Analyse Data": {
"main": [
[
{
"node": "Organise Response",
"type": "main",
"index": 0
}
]
]
},
"Extract Info": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Get Prospects": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Save Analysis": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Apollo Scraper": {
"main": [
[
{
"node": "Extract Info",
"type": "main",
"index": 0
}
]
]
},
"Generate Query": {
"main": [
[
{
"node": "Create Apollo URL",
"type": "main",
"index": 0
}
]
]
},
"Genrate Emails": {
"main": [
[
{
"node": "Check Time Zone",
"type": "main",
"index": 0
}
]
]
},
"Check Time Zone": {
"main": [
[
{
"node": "Assign Sender Email",
"type": "main",
"index": 0
}
]
]
},
"Company Scraper": {
"main": [
[
{
"node": "About You",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "If Linkedin Exists?",
"type": "main",
"index": 0
}
]
]
},
"Linkedin Scraper": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get Prospects",
"type": "main",
"index": 0
}
]
]
},
"Add Opt Out Token": {
"main": [
[
{
"node": "Save Emails",
"type": "main",
"index": 0
}
]
]
},
"Create Apollo URL": {
"main": [
[
{
"node": "Apollo Scraper",
"type": "main",
"index": 0
}
]
]
},
"Organise Response": {
"main": [
[
{
"node": "Generate LinkedIn Opener",
"type": "main",
"index": 0
}
]
]
},
"Assign Sender Email": {
"main": [
[
{
"node": "Add Opt Out Token",
"type": "main",
"index": 0
}
]
]
},
"If Linkedin Exists?": {
"main": [
[
{
"node": "Linkedin Scraper",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Enter Target Audience": {
"main": [
[
{
"node": "Generate Query",
"type": "main",
"index": 0
}
]
]
},
"Generate LinkedIn Opener": {
"main": [
[
{
"node": "Genrate Emails",
"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 workflow finds potential customers, gathers detailed info about them and their companies, and then uses AI to research them in detail and write personalized messages for LinkedIn and a series of four cold emails. All this data is organized in Google Sheets for easy tracking…
Source: https://n8n.io/workflows/6101/ — 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.
Deep Multiline Icebreaker automates high-quality, research-led outreach. Feed it a list of leads (emails + websites) and a short product brief via the built-in form; the workflow scrapes each company'
This workflow automates the creation and publishing of weekly SEO-optimized blog posts using AI and publishes them directly to WordPress — with featured images and tracking in Google Sheets.
How it works This workflow automatically collects the latest news articles from both English and Japanese sources using NewsAPI, summarizes them with OpenAI, and appends the results into a Google Shee
This workflow is designed for: Content creators and marketers E-commerce and product-based businesses Agencies producing social media visuals and videos Automation builders looking for AI-powered crea
Clone_Viral_TikToks_with_AI_Avatars___Auto_Post_to_9_Platforms_using_Perplexity___Blotato. Uses httpRequest, telegramTrigger, openAi, googleSheets. Event-driven trigger; 42 nodes.