8
n8n Deutschamn8n.com

Massenhafte Anreicherung von bis zu 1500 E-Mail-Adressen pro Stunde mit Dropcontact

Fortgeschritten

Dies ist ein Sales, Support, Product, Marketing-Bereich Automatisierungsworkflow mit 12 Nodes. Hauptsächlich werden Code, Wait, Slack, Postgres, SplitOut und andere Nodes verwendet. Massenanreichung von bis zu 1500 E-Mails pro Stunde mit Dropcontact

Voraussetzungen
  • •Slack Bot Token oder Webhook URL
  • •PostgreSQL-Datenbankverbindungsdaten
  • •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich

Verwendete Nodes (12)

Code
Wait
Slack
Postgres
SplitOut
Aggregate
StickyNote
HttpRequest
SplitInBatches
ScheduleTrigger

Kategorie

Vertrieb
Support
Produkt
Marketing
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": "a2435d996b378e3a6fdef0468d70285e3aa0fbd0004de817bfc80e80afee4e7b"
  },
  "nodes": [
    {
      "id": "5fa5ccd8-81be-45a2-ac00-7ef28148c0c7",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        700,
        460
      ],
      "parameters": {
        "width": 1767.817629414989,
        "height": 470.03830555074103,
        "content": "## DROPCONTACT 250 BATCH ASYNCHRONOUSLY \n## 1500/HOUR REQUESTS\n**Double click** to edit me. [Guide](https://docs.n8n.io/workflows/sticky-notes/)"
      },
      "typeVersion": 1
    },
    {
      "id": "9c6826a3-ec94-4ff4-92a6-0ff7fa22349e",
      "name": "Aggregieren",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1000,
        620
      ],
      "parameters": {
        "options": {},
        "fieldsToAggregate": {
          "fieldToAggregate": [
            {
              "fieldToAggregate": "first_name"
            },
            {
              "fieldToAggregate": "last_name"
            },
            {
              "fieldToAggregate": "domain"
            },
            {
              "fieldToAggregate": "phantom_linkedin"
            },
            {
              "fieldToAggregate": "full_name"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c0d5b884-de58-42f3-bc50-0c7e6ca5e576",
      "name": "PROFILES QUERY",
      "type": "n8n-nodes-base.postgres",
      "position": [
        560,
        600
      ],
      "parameters": {
        "query": "select first_name, last_name, domain, full_name\nfrom accounts a \nleft join profiles p on a.company_id = p.company_id \nwhere title = 'Bestuurder' and p.email is null and a.domain != ''\nand domain NOT IN ('gmail.com', 'hotmail.com', 'hotmail.be', 'hotmail%','outlook.com','telenet.be', 'live.be', 'skynet.be','SKYNET%', 'yahoo.com' , 'yahoo%', 'msn%', 'hotmail', 'belgacom%') and dropcontact_found is null \nlimit 1000\n",
        "options": {},
        "operation": "executeQuery"
      },
      "credentials": {
        "postgres": {
          "id": "pYryZTyzA44MBOiN",
          "name": "Postgres account"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "ddf11e8d-f1db-406c-9c2a-ab5a510fee47",
      "name": "BULK DROPCONTACT REQUESTS",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "maxTries": 3,
      "position": [
        1360,
        620
      ],
      "parameters": {
        "url": "https://api.dropcontact.io/batch",
        "method": "POST",
        "options": {},
        "jsonBody": "={{ $json.toJsonString()}}\n",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "authentication": "predefinedCredentialType",
        "headerParameters": {
          "parameters": [
            {
              "name": "X-Access-Token",
              "value": "apiKey"
            }
          ]
        },
        "nodeCredentialType": "dropcontactApi"
      },
      "credentials": {
        "dropcontactApi": {
          "id": "kUzEc345AiEZDjK7",
          "name": "Dropcontact Willow account"
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.2,
      "waitBetweenTries": 600
    },
    {
      "id": "606e2898-eb44-46c2-9576-8e3cc1bd2578",
      "name": "Über Elemente schleifen2",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        780,
        600
      ],
      "parameters": {
        "options": {},
        "batchSize": 250
      },
      "typeVersion": 3
    },
    {
      "id": "ace20caa-3c9b-432a-a572-6bad48181347",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "onError": "continueRegularOutput",
      "position": [
        1940,
        600
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "data"
      },
      "typeVersion": 1
    },
    {
      "id": "2c581721-a399-4d48-98a1-cee82246c4f4",
      "name": "Postgres",
      "type": "n8n-nodes-base.postgres",
      "onError": "continueErrorOutput",
      "maxTries": 2,
      "position": [
        2100,
        600
      ],
      "parameters": {
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "profiles",
          "cachedResultName": "profiles"
        },
        "schema": {
          "__rl": true,
          "mode": "list",
          "value": "public"
        },
        "columns": {
          "value": {
            "email": "={{ $json.email[0].email }}",
            "phone": "={{ $json.phone }}",
            "full_name": "={{ $json.custom_fields.full_name }}",
            "dropcontact_found": "={{ true }}",
            "email_qualification": "={{ $json.email[0].qualification }}"
          },
          "schema": [
            {
              "id": "company_id",
              "type": "number",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "company_id",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "create_date",
              "type": "dateTime",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "create_date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "first_name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "first_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "last_name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "last_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "title",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "start_date_raw",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "start_date_raw",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "full_name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "full_name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "seniority",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "seniority",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email_qualification",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "email_qualification",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "dropcontact_found",
              "type": "boolean",
              "display": true,
              "required": false,
              "displayName": "dropcontact_found",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "full_name"
          ]
        },
        "options": {
          "replaceEmptyStrings": true
        },
        "operation": "update"
      },
      "credentials": {
        "postgres": {
          "id": "pYryZTyzA44MBOiN",
          "name": "Postgres account"
        }
      },
      "retryOnFail": true,
      "typeVersion": 2.3,
      "alwaysOutputData": true
    },
    {
      "id": "7e94c87d-3f83-4fd1-877d-3463dce3cdd1",
      "name": "BULK DROPCONTACT DOWNLOAD",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        1740,
        620
      ],
      "parameters": {
        "url": "=https://api.dropcontact.io/batch/{{ $json.request_id }}",
        "options": {},
        "authentication": "predefinedCredentialType",
        "nodeCredentialType": "dropcontactApi"
      },
      "credentials": {
        "dropcontactApi": {
          "id": "kUzEc345AiEZDjK7",
          "name": "Dropcontact Willow account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "17aab456-72dc-482d-b5e3-b3dfb3a3b3f7",
      "name": "Warten2",
      "type": "n8n-nodes-base.wait",
      "position": [
        1540,
        620
      ],
      "webhookId": "de669d58-95c5-480e-9acc-17c396859fcf",
      "parameters": {
        "amount": 600
      },
      "typeVersion": 1.1
    },
    {
      "id": "148cec0c-985b-4c82-8835-fff8eacf6e38",
      "name": "DATA TRANSFORMATION",
      "type": "n8n-nodes-base.code",
      "position": [
        1180,
        620
      ],
      "parameters": {
        "mode": "runOnceForEachItem",
        "language": "python",
        "pythonCode": "import json\n\n## Load & access the existing JSON data\nfor item in _input.all():\n  data = item.json \n\n  # Define the output data structure\n  output_data = {\"data\": [], \"siren\": True}\n\n  # Unpack data from the single element list\n  first_names = data[\"first_name\"]\n  last_names = data[\"last_name\"]\n  domain = data[\"domain\"]\n  full_name = data[\"full_name\"]\n\n    # Combine data into a list of dictionaries\n  transformed_data = []\n  for i, (first_name, last_name, domain_name, full_name_value) in enumerate(zip(first_names, last_names, domain, full_name)):\n    transformed_data.append({\n      \"first_name\": first_name,\n      \"last_name\": last_name,\n      \"website\": domain_name,\n      \"custom_fields\": {\n        \"full_name\": full_name_value}\n    })\n\n  output_data[\"data\"] = transformed_data\n\n  return output_data \n\n"
      },
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "b233abfe-cfae-474a-b86d-29e56e1f3ac7",
      "name": "Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        1740,
        820
      ],
      "parameters": {
        "text": "Dropcontact Credits issue: url ",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "select": "user",
        "otherOptions": {}
      },
      "typeVersion": 2.1
    },
    {
      "id": "d4e90677-89c9-418b-b618-f751b797d395",
      "name": "Zeitplan-Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        380,
        600
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.1
    }
  ],
  "pinData": {},
  "connections": {
    "Wait2": {
      "main": [
        [
          {
            "node": "7e94c87d-3f83-4fd1-877d-3463dce3cdd1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2c581721-a399-4d48-98a1-cee82246c4f4": {
      "main": [
        [
          {
            "node": "Loop Over Items2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "148cec0c-985b-4c82-8835-fff8eacf6e38",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ace20caa-3c9b-432a-a572-6bad48181347": {
      "main": [
        [
          {
            "node": "2c581721-a399-4d48-98a1-cee82246c4f4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c0d5b884-de58-42f3-bc50-0c7e6ca5e576": {
      "main": [
        [
          {
            "node": "Loop Over Items2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items2": {
      "main": [
        null,
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "c0d5b884-de58-42f3-bc50-0c7e6ca5e576",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "148cec0c-985b-4c82-8835-fff8eacf6e38": {
      "main": [
        [
          {
            "node": "ddf11e8d-f1db-406c-9c2a-ab5a510fee47",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7e94c87d-3f83-4fd1-877d-3463dce3cdd1": {
      "main": [
        [
          {
            "node": "ace20caa-3c9b-432a-a572-6bad48181347",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "b233abfe-cfae-474a-b86d-29e56e1f3ac7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ddf11e8d-f1db-406c-9c2a-ab5a510fee47": {
      "main": [
        [
          {
            "node": "Wait2",
            "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 - Vertrieb, Support, Produkt, Marketing

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

Anreicherung von Verkäuferdaten mithilfe von Bright Data und Google-Suche über E-Mail-Adresse und Domain
Anreichung von Verkäuferdaten mit E-Mail- und Domain-Suchen über Bright Data und Google-Suche
If
Set
Code
+
If
Set
Code
32 NodesCyril Nicko Gaspar
Vertrieb
[Template] KI-Haustierladen v8
🐥 KI-Assistent für Tiernahrungsshops - Integriert GPT-4o, Google Kalender und WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 NodesAmanda Benks
Vertrieb
HDW-Lead-Jeep
Automatisierte LinkedIn-Lead-Generierung, -Bewertung und -Kommunikation mit KI-Agenten
If
Code
Sort
+
If
Code
Sort
86 NodesAndrey
Vertrieb
AI-Personalized Multi-Product Email Outreach with SMTP Rotation (GPT-4o-o3-mini)
If
Code
Wait
+
If
Code
Wait
41 NodesBadr
Vertrieb
Lead-Generierung mit Google Maps - AlexK1919
Potenzielle Kunden mit Google Maps generieren
If
Set
Code
+
If
Set
Code
42 NodesAlex Kim
Vertrieb
KI-gesteuerte Informationsüberwachung mit OpenAI, Google Sheets, Jina AI und Slack
Eine KI-gesteuerte Informationsüberwachung, die OpenAI, Google Sheets, Jina AI und Slack integriert
If
Set
Code
+
If
Set
Code
31 NodesDataki
Vertrieb
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes12
Kategorie4
Node-Typen10
Schwierigkeitsbeschreibung

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

Autor
victor de coster

victor de coster

@vliegendepater
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