Cold/Warm-Email-Automatisierung
Experte
Dies ist ein Lead Nurturing-Bereich Automatisierungsworkflow mit 19 Nodes. Hauptsächlich werden If, Set, Hunter, EmailSend, GoogleSheets und andere Nodes verwendet. Automatisierte Kalt-E-Mail-Marketingkampagne mit Google Sheets, E-Mail-Validierung und SMTP
Voraussetzungen
- •Google Sheets API-Anmeldedaten
Verwendete Nodes (19)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"id": "0NUf4DsJtFfnyxnp",
"meta": {
"instanceId": "b575ae39acc98e53d75e50d1b5147e8b0922704c4aeb3230092d8e2a78247bc3"
},
"name": "Cold/Warm Email Automation",
"tags": [],
"nodes": [
{
"id": "8df39dbf-a9c7-4de0-9582-8946a312a35f",
"name": "Bei Klick auf 'Workflow ausführen'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
432,
1392
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3adc0f15-d7a2-4b23-b36d-eb0361167446",
"name": "Kurznotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1824,
2096
],
"parameters": {
"color": 7,
"height": 256,
"content": "## **Find out SMTP info for your email service provider Link** \n\nhttps://docs.google.com/document/d/1UnAYprKmGWHQ7VDpzdMndV7-iPl1sVlIIke3GY5O8e0/edit?usp=sharing"
},
"typeVersion": 1
},
{
"id": "42a71dd2-654d-48ca-9e89-619402f9b65a",
"name": "Kurznotiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
1584
],
"parameters": {
"color": 7,
"width": 272,
"height": 208,
"content": "## **Step-by-Step Tutorial YouTube Video Link** \n\n\nhttps://youtu.be/Dg68OaYPhYs?si=LVu9pdxt9JUuCrzM"
},
"typeVersion": 1
},
{
"id": "bb87b350-c396-4cd4-a266-1b58300cf261",
"name": "Kurznotiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
1584
],
"parameters": {
"color": 7,
"width": 224,
"height": 224,
"content": "## **Sample Google Sheet for Leads I used.** \n\nhttps://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=sharing \n\n\n- "
},
"typeVersion": 1
},
{
"id": "5a7e7b8a-30ef-43fa-a290-23ccff275628",
"name": "Zeitplan-Trigger um 9 Uhr",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
176,
1392
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
"name": "Lead-Tabelle - Zeilen aus Sheet abrufen",
"type": "n8n-nodes-base.googleSheets",
"position": [
640,
1392
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=drivesdk",
"cachedResultName": "Leads"
}
},
"typeVersion": 4.6
},
{
"id": "3a2a1244-2870-421b-a27b-ce9dba18eace",
"name": "GSheet aktualisieren, wenn E-Mail 'Gesendet' ist",
"type": "n8n-nodes-base.googleSheets",
"position": [
2320,
1744
],
"parameters": {
"columns": {
"value": {
"Tool Name": "={{ $('Google Sheets').item.json['Tool Name'] }}",
"Email Sent": "={{ $json.accepted[0] }}"
},
"schema": [
{
"id": "Tool Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Tool Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tool Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Tool Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Link to Apply Affiliate",
"type": "string",
"display": true,
"required": false,
"displayName": "Link to Apply Affiliate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "How to Work",
"type": "string",
"display": true,
"required": false,
"displayName": "How to Work",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Affiliate Link to Share",
"type": "string",
"display": true,
"required": false,
"displayName": "Affiliate Link to Share",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Coupon Code",
"type": "string",
"display": true,
"required": false,
"displayName": "Coupon Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reach Out Mode",
"type": "string",
"display": true,
"required": false,
"displayName": "Reach Out Mode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "How did you find?",
"type": "string",
"display": true,
"required": false,
"displayName": "How did you find?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reach Out Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Reach Out Platform",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Incoming",
"type": "string",
"display": true,
"required": false,
"displayName": "Incoming",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script",
"type": "string",
"display": true,
"required": false,
"displayName": "Script",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Sent",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Sent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Ideas",
"type": "string",
"display": true,
"required": false,
"displayName": "Ideas",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Tool Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2051398108,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit#gid=2051398108",
"cachedResultName": "AI tool reachout"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit?usp=drivesdk",
"cachedResultName": "CF Calendar"
}
},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
"name": "Prüfer - E-Mails verifiziert oder nicht?",
"type": "n8n-nodes-base.if",
"position": [
1568,
1584
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.result }}",
"rightValue": "undeliverable"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "935d4058-b2e9-43f1-a887-defb038948c3",
"name": "Kurznotiz5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
1760
],
"parameters": {
"width": 208,
"height": 192,
"content": "## **Add Email Verification API** \n\nI use hunter, https://hunter.io/api-keys\n\nYou can use any other tools"
},
"typeVersion": 1
},
{
"id": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
"name": "Feld für 'Gesendet'-Update in G Sheet1 erstellen",
"type": "n8n-nodes-base.set",
"position": [
2096,
1744
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "05814c14-4365-4c37-af55-f28bf2ee5819",
"name": "accepted[0]",
"type": "string",
"value": "Sent"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "4f251ddb-b669-4b14-8255-ab47ab062516",
"name": "Keine Aktion, nichts tun5",
"type": "n8n-nodes-base.noOp",
"position": [
1872,
1424
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
"name": "E-Mail-Verifizierung mit Hunter",
"type": "n8n-nodes-base.hunter",
"position": [
1312,
1584
],
"parameters": {
"email": "={{ $json.Email }}",
"operation": "emailVerifier"
},
"typeVersion": 1
},
{
"id": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
"name": "Prüfer - Bereits 'Gesendet' oder nicht?",
"type": "n8n-nodes-base.if",
"position": [
864,
1392
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c72a013e-7b22-4bc7-a6c6-d51e9804ece7",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json['Email Sent'] }}",
"rightValue": "Sent"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
"name": "Prüfer - Ist 'E-Mail'-Feld des Leads leer?",
"type": "n8n-nodes-base.if",
"position": [
1088,
1488
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
"name": "Keine Aktion, nichts tun",
"type": "n8n-nodes-base.noOp",
"position": [
1040,
1296
],
"parameters": {},
"typeVersion": 1
},
{
"id": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
"name": "Keine Aktion, nichts tun1",
"type": "n8n-nodes-base.noOp",
"position": [
1312,
1392
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d98f7325-01c6-4e62-acc9-ca6bee188d39",
"name": "Kurznotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
1232
],
"parameters": {
"width": 224,
"height": 128,
"content": "## **Connect with Google Sheet or CRM** "
},
"typeVersion": 1
},
{
"id": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
"name": "E-Mail via SMTP senden",
"type": "n8n-nodes-base.emailSend",
"position": [
1872,
1744
],
"webhookId": "3a2cb249-8183-4481-8df7-5fcdd2c52881",
"parameters": {
"text": "=Hello {{ $('Lead Sheet - Get Rows from the sheet').item.json['Tool Name'] }} team, \n\nWe can collborate on multiple features. Can we have a quick meet over the meet?\n\nBest regards,\nJanak",
"options": {},
"subject": "Let's collaborate!",
"toEmail": "={{ $('Lead Sheet - Get Rows from the sheet').item.json.Email }}",
"fromEmail": "support@dolphy.io",
"emailFormat": "text"
},
"executeOnce": false,
"typeVersion": 2.1
},
{
"id": "2188bf86-d2d8-48c2-9783-954d3c879089",
"name": "Kurznotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1824,
1920
],
"parameters": {
"width": 224,
"height": 128,
"content": "## **Send email using SMTP- Any Email Provider works** "
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "d5347202-25e6-43fd-aca3-2e53eef114c0",
"connections": {
"ecfd047b-fcb8-4e7b-a150-537cc96be2f2": {
"main": [
[
{
"node": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
"type": "main",
"index": 0
}
]
]
},
"d8fd0b18-6907-4466-b2f5-d5bd19293da8": {
"main": [
[
{
"node": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
"type": "main",
"index": 0
}
]
]
},
"de42e271-8e99-4a09-b189-a0af7b2bbcb2": {
"main": [
[
{
"node": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
"type": "main",
"index": 0
}
],
[
{
"node": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
"type": "main",
"index": 0
}
]
]
},
"5c58d9d4-f19c-44f1-871c-a31dde73f8c3": {
"main": [
[
{
"node": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
"type": "main",
"index": 0
}
]
]
},
"8df39dbf-a9c7-4de0-9582-8946a312a35f": {
"main": [
[
{
"node": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
"type": "main",
"index": 0
}
]
]
},
"78f8130a-26ee-4e7b-b749-2c201eb6aca2": {
"main": [
[
{
"node": "4f251ddb-b669-4b14-8255-ab47ab062516",
"type": "main",
"index": 0
}
],
[
{
"node": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
"type": "main",
"index": 0
}
]
]
},
"6a1c602a-489b-4c83-b2b8-da27bc80718f": {
"main": [
[
{
"node": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
"type": "main",
"index": 0
}
],
[
{
"node": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
"type": "main",
"index": 0
}
]
]
},
"4b8ae9a2-346c-424f-ba77-fb0aa42c4e58": {
"main": [
[
{
"node": "3a2a1244-2870-421b-a27b-ce9dba18eace",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Lead-Pflege
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
Verfolgung automatisierter LinkedIn-Einladungen mit Browserflow und Google Sheets
Tracking automatisierter LinkedIn-Einladungen mit Browserflow und Google Sheets
If
Set
Wait
+
If
Set
Wait
23 NodesStéphane Heckel
Lead-Pflege
Automatisierte Cold-Email-Marketingkampagne mit zufälligen Vorlagen und Google-Tracking
Automatisierte Kalt-E-Mail-Marketingkampagne mit zufälligen Vorlagen und Google Sheets-Tracking
If
Set
Code
+
If
Set
Code
20 NodesAnir Agram
Lead-Pflege
YouTube-SEO-Automatisierung 1
Generieren von YouTube-SEO-Inhalten und Thumbnails aus Drehbüchern mit GPT-4o und Runway
If
Set
Code
+
If
Set
Code
19 NodesJanak Patel
Content-Erstellung
KI-generierter WordPress-Artikel-Zusammenfassungsblock
Ein KI-generierter Zusammenfassungsblock für WordPress-Artikel
If
Set
Slack
+
If
Set
Slack
32 NodesDataki
Künstliche Intelligenz
Noco-Kanban mit Priorisierung durch KI
Anfragen mithilfe von KI zuordnen und Reminders über den NocoDB-Kanban-Status senden
If
Set
Slack
+
If
Set
Slack
27 NodesŁukasz
Support
Automatisierung der agilen Detailplanungsvorbereitung mit Gmail, OpenAI und Google Sheets
Automatisierung der agilen Detailplanungsvorbereitung mit Gmail, OpenAI und Google Sheets
If
Set
Gmail
+
If
Set
Gmail
51 NodesWillemijn
Produkt
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes19
Kategorie1
Node-Typen9
Autor
Janak Patel
@dolphyaiExterne Links
Auf n8n.io ansehen →
Diesen Workflow teilen