Marth - Business Automation This workflow corresponds to n8n.io template #6971 — we link there as the canonical source.
This workflow follows the Gmail → 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": "hJ3OmlB0o6jHcpgZ",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Automated Passive Candidate Sourcing & Engagement System with Hunter.io & Google Sheet",
"tags": [],
"nodes": [
{
"id": "753cd4fd-a647-45f5-9af9-f0e98fac4884",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ee85cc2c-48d5-4f66-8530-6941c8eddd51",
"name": "Generate Search Query",
"type": "n8n-nodes-base.code",
"position": [
208,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1354a9b7-0dee-4bd7-9b56-db2f801ba1cb",
"name": "Hunter.io",
"type": "n8n-nodes-base.httpRequest",
"position": [
416,
0
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "ecdc31ae-260e-4c70-b5dc-e94ec23f5364",
"name": "Filter Candidates:",
"type": "n8n-nodes-base.code",
"position": [
624,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9e84513d-ce08-4a30-a0d3-47b9c8a0b4b0",
"name": "Log Potential Candidates",
"type": "n8n-nodes-base.googleSheets",
"notes": "Fields: name={{ $json.full_name }}, \nemail={{ $json.email }}, status=Potential",
"position": [
832,
0
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "df21181d-f8a3-4d32-90b8-f5b52d138e17",
"name": "AI Resume Analysis",
"type": "n8n-nodes-base.code",
"position": [
1040,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "95560fc5-f587-4a57-a094-a48695eff107",
"name": "Calculate Candidate Score",
"type": "n8n-nodes-base.code",
"position": [
1248,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "42ff4be5-ca37-4513-968f-470418f1a8be",
"name": "Is Score > 75?",
"type": "n8n-nodes-base.if",
"position": [
1456,
0
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "52a872f0-7fdb-4b7e-afef-dcd777a53688",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-96
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d8112584-fde6-4a5d-917a-63c2882d21db",
"name": "Send Initial Outreach Email",
"type": "n8n-nodes-base.gmail",
"position": [
0,
320
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "2c4c6435-d42b-4596-ae40-305a7f4c307b",
"name": "Update Status 'Contacted'",
"type": "n8n-nodes-base.googleSheets",
"notes": "Fields: Status=Contacted, Contacted On={{ $now }}",
"position": [
208,
320
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "7aa47a6e-3171-424c-8b8f-064b19958bb8",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
416,
320
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "4d0a9308-e24a-4929-a3f9-7e16f1d1f3d8",
"name": "No Reply?",
"type": "n8n-nodes-base.if",
"position": [
624,
320
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "dc1e39ae-2f34-4b2a-9723-f7bd1f801050",
"name": "Send Follow-up Email",
"type": "n8n-nodes-base.gmail",
"position": [
848,
320
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "4be1a313-f73b-411d-ab21-2892fab9b1de",
"name": "Update Status 'Followed Up'",
"type": "n8n-nodes-base.googleSheets",
"notes": "Fields: Status=Followed Up",
"position": [
1056,
320
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "d66946fe-5cb8-4392-8fb1-1a3cc5c9f262",
"name": "5 Days",
"type": "n8n-nodes-base.wait",
"position": [
1264,
320
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "84cdd188-181b-429e-a6f4-03b1aec93ba2",
"name": "Still No Reply?",
"type": "n8n-nodes-base.if",
"position": [
1424,
320
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "cf242598-569c-4505-8429-2a8467be5e10",
"name": "Send Final Nurture Email",
"type": "n8n-nodes-base.gmail",
"position": [
1664,
320
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "13b4948d-0368-4896-89aa-6555d448bb93",
"name": "Update Status 'Nurtured'",
"type": "n8n-nodes-base.googleSheets",
"notes": "Fields: Status=Nurtured",
"position": [
1904,
320
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "23e62c9a-1937-4ba3-91cc-f27e63c3e482",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ad178227-bc3e-41b8-958c-d719421e84fd",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1024,
-96
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "44c85110-3847-409f-a48d-62686f566094",
"connections": {
"Wait": {
"main": [
[
{
"node": "No Reply?",
"type": "main",
"index": 0
}
]
]
},
"5 Days": {
"main": [
[
{
"node": "Still No Reply?",
"type": "main",
"index": 0
}
]
]
},
"Hunter.io": {
"main": [
[
{
"node": "Filter Candidates:",
"type": "main",
"index": 0
}
]
]
},
"No Reply?": {
"main": [
[
{
"node": "Send Follow-up Email",
"type": "main",
"index": 0
}
]
]
},
"Is Score > 75?": {
"main": [
[
{
"node": "Send Initial Outreach Email",
"type": "main",
"index": 0
}
]
]
},
"Still No Reply?": {
"main": [
[
{
"node": "Send Final Nurture Email",
"type": "main",
"index": 0
}
]
]
},
"AI Resume Analysis": {
"main": [
[
{
"node": "Calculate Candidate Score",
"type": "main",
"index": 0
}
]
]
},
"Filter Candidates:": {
"main": [
[
{
"node": "Log Potential Candidates",
"type": "main",
"index": 0
}
]
]
},
"Send Follow-up Email": {
"main": [
[
{
"node": "Update Status 'Followed Up'",
"type": "main",
"index": 0
}
]
]
},
"Generate Search Query": {
"main": [
[
{
"node": "Hunter.io",
"type": "main",
"index": 0
}
]
]
},
"Log Potential Candidates": {
"main": [
[
{
"node": "AI Resume Analysis",
"type": "main",
"index": 0
}
]
]
},
"Send Final Nurture Email": {
"main": [
[
{
"node": "Update Status 'Nurtured'",
"type": "main",
"index": 0
}
]
]
},
"Calculate Candidate Score": {
"main": [
[
{
"node": "Is Score > 75?",
"type": "main",
"index": 0
}
]
]
},
"Update Status 'Contacted'": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Send Initial Outreach Email": {
"main": [
[
{
"node": "Update Status 'Contacted'",
"type": "main",
"index": 0
}
]
]
},
"Update Status 'Followed Up'": {
"main": [
[
{
"node": "5 Days",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Generate Search Query",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow is a powerful, two-phase system designed to automate the entire passive candidate sourcing and engagement cycle.
Source: https://n8n.io/workflows/6971/ — 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.
How It Works Starts with a Manual Trigger Reads lead list from Google Sheet Filter rows where email wasn’t sent Generate personalized email body (AI) Generate email subject line (AI) Merge AI outputs
Google Sheets, HTTP Request, Gmail
This workflow is built for agencies, freelancers, and local service businesses who want to automate prospecting. If you sell services to local businesses -- web design, SEO, bookkeeping, HVAC -- this
HTTP Request, Gmail
Hunter Form. Uses stickyNote, formTrigger, noOp, httpRequest. Event-driven trigger; 15 nodes.
Form Trigger, HTTP Request, Hunter +2
Hunter Form. Uses formTrigger, stickyNote, noOp, httpRequest. Event-driven trigger; 12 nodes.
Form Trigger, HTTP Request, Hunter +1
Monitor-Emails. Uses gmailTrigger, gmail, supabase, httpRequest. Event-driven trigger; 12 nodes.
Gmail Trigger, Gmail, Supabase +1