8
n8n Deutschamn8n.com

Automatisierter Massen-Cold-Email-Versender mit Gmail, SMTP und Google Sheets

Fortgeschritten

Dies ist ein Lead Nurturing-Bereich Automatisierungsworkflow mit 12 Nodes. Hauptsächlich werden If, Wait, Gmail, Limit, EmailSend und andere Nodes verwendet. Automatisierter Massenversand von Kalt-E-Mails mit Gmail, SMTP und Google Sheets

Voraussetzungen
  • •Google-Konto + Gmail API-Anmeldedaten
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (12)

If
Wait
Gmail
Limit
EmailSend
StickyNote
GoogleSheets
SplitInBatches
ScheduleTrigger

Kategorie

Lead-Pflege
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "meta": {
    "instanceId": "28099d2544433ae0f39c65315a4d4c531947fcb0f060a94d6047d7be5df31063",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
      "name": "Elemente durchlaufen",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -560,
        160
      ],
      "parameters": {
        "options": {},
        "batchSize": "=1"
      },
      "typeVersion": 3
    },
    {
      "id": "c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2",
      "name": "Limit",
      "type": "n8n-nodes-base.limit",
      "position": [
        -760,
        360
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "630c46c1-bf9a-4634-8ce2-a5bd054d1813",
      "name": "Wenn",
      "type": "n8n-nodes-base.if",
      "position": [
        -380,
        260
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "8dc5b028-6f5d-4d76-8852-99180bfb4591",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json['Email Address '] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "f6834735-f169-4ba4-86de-9ed5c7221628",
      "name": "Datensätze aktualisieren",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        60,
        260
      ],
      "parameters": {
        "columns": {
          "value": {
            "Sent on": "={{ $now }}",
            "Message Id": "={{ $json.id }}",
            "Email Sent ": "Yes",
            "Email Address ": "={{ $('If').first().json['Email Address '] }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Address ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email Address ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Sender Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Sender Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Subject",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Subject",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Body",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Body",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Sent ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Sent ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Sent on",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Sent on",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message Id",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Message Id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email Address "
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit?usp=drivesdk",
          "cachedResultName": "Bulk Sender Template"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "NdBpgqV7UHdZ3CZc",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "6dd38853-6493-4677-8db2-0df6497aee42",
      "name": "E-Mail senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -140,
        260
      ],
      "webhookId": "2add08f1-0af8-4951-af47-721d2c4302ec",
      "parameters": {
        "sendTo": "={{ $json['Email Address '] }}",
        "message": "={{ $json['Email Body'] }}",
        "options": {},
        "subject": "={{ $json['Email Subject'] }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "Fd6oTce3HQiRi3dG",
          "name": "electrabot.info@gmail.com"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "6f4402a7-7519-444f-81a6-fc2600f936cd",
      "name": "E-Mails abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -940,
        360
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "No",
              "lookupColumn": "Email Sent "
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit?usp=drivesdk",
          "cachedResultName": "Bulk Sender Template"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "NdBpgqV7UHdZ3CZc",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "bdf30635-0665-40cd-bfee-b507c3a67f49",
      "name": "Timer setzen",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1120,
        360
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 6
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6",
      "name": "Warten",
      "type": "n8n-nodes-base.wait",
      "position": [
        280,
        340
      ],
      "webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
      "parameters": {
        "amount": 10
      },
      "typeVersion": 1.1
    },
    {
      "id": "e69107b7-6e00-4854-81cf-17da9b09b5af",
      "name": "connect",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -1120,
        160
      ],
      "webhookId": "49772db0-f2ab-4f5a-9b20-5b4f097f301c",
      "parameters": {
        "text": "={{ $json['Email body'] }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "={{ $json['Email subject'] }}",
        "toEmail": "={{ $json['Email Address '] }}",
        "fromEmail": "={{ $json['Sender email '] }}",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "PnCWFLAx6sFw8ynW",
          "name": "team@electrabot.space"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "960aca19-606e-409b-b187-b1269bfdc907",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1180,
        -40
      ],
      "parameters": {
        "width": 1660,
        "height": 620,
        "content": "# Email Sender"
      },
      "typeVersion": 1
    },
    {
      "id": "85ac89d1-f0b8-4899-98d0-495db2f0018c",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1480,
        -40
      ],
      "parameters": {
        "width": 300,
        "height": 620,
        "content": "## 1. Setup Guide\n*  ### Configure the timer node to your desired execution frequency.\n* ### Duplicate the provided [Google Sheet Template](https://docs.google.com/spreadsheets/d/1TjXelyGPg5G8lbPDI9_XOReTzmU1o52z2R3v8dYaoQM/edit?usp=sharing).\n* ### Link the duplicated sheet within both the \"Get Emails\" and \"Update Record\" nodes.\n* ### Select your preferred email sending node and use the \"Limit\" node to manage the volume of emails dispatched.\n\n## 2. Help\n* ### For detailed instructions, please refer to our [Detailed Setup Guide](https://drive.google.com/file/d/1o95RjqpwH_FZc28ajgxJJj5j3u6IyO0w/view?usp=sharing).\n* ### If you require further assistance, contact us via Email at [info.gainflow@gmail.com](mailto:info.gainflow@gmail.com).\n* ### Discover additional practical workflows by clicking [HERE](https://docs.google.com/document/d/1RACo90h-QwKA4hEZSlOQZsyw4iB5-43JM2l0s4lpuoY/edit?usp=sharing)."
      },
      "typeVersion": 1
    },
    {
      "id": "e6679e6b-cb5f-4b31-a05d-87b31dfe018e",
      "name": "Notiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1160,
        60
      ],
      "parameters": {
        "color": 3,
        "width": 320,
        "height": 260,
        "content": "## Utilize this node for non-Google email services."
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "630c46c1-bf9a-4634-8ce2-a5bd054d1813": {
      "main": [
        [
          {
            "node": "6dd38853-6493-4677-8db2-0df6497aee42",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6": {
      "main": [
        [
          {
            "node": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2": {
      "main": [
        [
          {
            "node": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bdf30635-0665-40cd-bfee-b507c3a67f49": {
      "main": [
        [
          {
            "node": "6f4402a7-7519-444f-81a6-fc2600f936cd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6f4402a7-7519-444f-81a6-fc2600f936cd": {
      "main": [
        [
          {
            "node": "c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6dd38853-6493-4677-8db2-0df6497aee42": {
      "main": [
        [
          {
            "node": "f6834735-f169-4ba4-86de-9ed5c7221628",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f6834735-f169-4ba4-86de-9ed5c7221628": {
      "main": [
        [
          {
            "node": "ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6afb72ca-c815-4fca-9125-f77d78bc46aa": {
      "main": [
        [],
        [
          {
            "node": "630c46c1-bf9a-4634-8ce2-a5bd054d1813",
            "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?

Fortgeschritten - 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

E-Mail-Outreach-Automatisierung
Kostenlose E-Mail-Folge-Sequenz mit Google Sheets und Gmail
If
Set
Html
+
If
Set
Html
18 NodesGerald Denor
Lead-Pflege
Automatisierte WhatsApp-Begrüßungsnachrichten aus Google Sheets mit Rapiwa API
Automatisierte WhatsApp-Begrüßungsnachrichten für Sales-Leads mit Google Sheets und Rapiwa
If
Code
Wait
+
If
Code
Wait
17 NodesSpaGreen Creative
Lead-Pflege
Lead-Generierung und E-Mail-Arbeitsabläufe
Automatisierung der B2B-Lead-Generierung und E-Mail-Marketing mit Google Maps, SendGrid und KI
If
Set
Code
+
If
Set
Code
141 NodesEzema Kingsley Chibuzo
Lead-Generierung
Kalte E-Mail-Generierung
Automatisierung der B2B-Lead-Generierung und personalisierter Kalt-E-Mails mit Apollo, Apify und GPT
If
Wait
Gmail
+
If
Wait
Gmail
24 NodesMirai
Apollo-Daten-Scraping und Kontakt-Workflow 1 ✅
Automatisierte Lead-Generierung mit Apollo, AI-Analyse und zeitgesteuerter E-Mail-Nachfassaktion
If
Code
Wait
+
If
Code
Wait
39 NodesDeniz
Content-Erstellung
Automatisierung der Veröffentlichung von RSS-Inhalten als Blogbeiträge mit GPT-4o, WordPress und LinkedIn
Automatisierung der Veröffentlichung von RSS-Inhalten als Blogartikel auf WordPress und LinkedIn durch KI
If
Set
Code
+
If
Set
Code
40 NodesImmanuel
Künstliche Intelligenz
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes12
Kategorie1
Node-Typen9
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Autor
Gain FLow AI

Gain FLow AI

@gain-flow

GainFlow AI is your go-to AI automation agency, specializing in Python and no-code solutions to eliminate repetitive tasks for individuals and businesses. Free up your time and boost efficiency. For inquiries, Fill this form - https://docs.google.com/forms/d/e/1FAIpQLSfIiXdw4HMcI2HM-Obng13j_RFiKv7X-mjOVm_mcy2ucRA8EA/viewform or reach out to us at info.gainflow@gmail.com.

Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34