8
n8n Deutschamn8n.com

Die Bereicherung von Marketing-Lead aus Google Tabellen

Fortgeschritten

Dies ist ein Lead Generation-Bereich Automatisierungsworkflow mit 12 Nodes. Hauptsächlich werden If, Code, Wait, Gmail, Filter und andere Nodes verwendet. 🚀 Automatisierung der Kontaktreichtung bei LinkedIn mit Surfe, Google Sheets und HubSpot

Voraussetzungen
  • •Google-Konto + Gmail API-Anmeldedaten
  • •HubSpot API Key
  • •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • •Google Sheets API-Anmeldedaten
  • •Google Drive API-Anmeldedaten

Verwendete Nodes (12)

If
Code
Wait
Gmail
Filter
Hubspot
HttpRequest
GoogleSheets
SplitInBatches
GoogleDriveTrigger

Kategorie

Lead-Generierung
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
{
  "id": "GepE6tB2olhDRCxP",
  "meta": {
    "instanceId": "1c6299b01fe56ad80280bbb1a8394f761ca72a9606abe611a4617f9adc407187",
    "templateCredsSetupCompleted": true
  },
  "name": "Enrich Marketing Leads From A Google Sheet",
  "tags": [],
  "nodes": [
    {
      "id": "0796ab84-bf14-4f51-906e-db01486b2c76",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -460,
        580
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-4gGB9cugFdrutFYdlaPwMT737ODxPnizWqLODoDfmo/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.id }}"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "0cf2212f-e1f3-4616-ad6b-6c8c00bfe237",
      "name": "Google Drive Trigger",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -760,
        580
      ],
      "parameters": {
        "event": "fileCreated",
        "options": {
          "fileType": "application/vnd.google-apps.spreadsheet"
        },
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFolder",
        "folderToWatch": {
          "__rl": true,
          "mode": "list",
          "value": "1C4ccbMW84VWzgGMsNTVEUUm3i_MH3Rlm",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1C4ccbMW84VWzgGMsNTVEUUm3i_MH3Rlm",
          "cachedResultName": "folder-n8n-listener"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c3e28407-7bb4-4d2a-8009-0621f236efa3",
      "name": "Filter: Telefonnummer UND E-Mail",
      "type": "n8n-nodes-base.filter",
      "position": [
        1240,
        440
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "4f8f9bec-6eee-4e62-8d5f-e8f5b85620d6",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.phone }}",
              "rightValue": ""
            },
            {
              "id": "007f5a66-4e2a-42bc-bbed-0fb2b2f39ae7",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "23fdf067-cd74-4b04-96df-9241a86570cf",
      "name": "Liste von Personen aus der Surfe API-Antwort extrahieren",
      "type": "n8n-nodes-base.code",
      "position": [
        1020,
        440
      ],
      "parameters": {
        "jsCode": "const people = $json.people || [];\n\nreturn people.map(person => {\n  return {\n    json: {\n      id: person.id || '',\n      firstName: person.firstName || '',\n      lastName: person.lastName || '',\n      email: person.emails?.[0]?.email || '',\n      phone: person.mobilePhones?.[0]?.mobilePhone || '',\n      jobTitle: person.jobTitle || '',\n      companyName: person.companyName || '',\n      companyWebsite: person.companyWebsite || '',\n      linkedinUrl: person.linkedinUrl || '',\n      country: person.country || '',\n      status: person.status || ''\n    }\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "1b84d64f-85ea-4914-96e2-3321c3ed389d",
      "name": "Ist die Anreicherung abgeschlossen?",
      "type": "n8n-nodes-base.if",
      "position": [
        800,
        480
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "65a670df-84e8-4c87-956c-96758b8d8d26",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.status }}",
              "rightValue": "COMPLETED"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "735abd1e-66df-4e0c-92e4-803c08edd307",
      "name": "Surfe Bulk Enrichments API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        340,
        580
      ],
      "parameters": {
        "url": "https://api.surfe.com/v2/people/enrich",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "={{ $json }}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer XXXXXXXXXXXXXXXXXXXXXXXX"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "976ebf8c-8838-41c1-bb8f-f817a9b60ae9",
      "name": "Surfe Anreicherungsstatus prüfen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        560,
        580
      ],
      "parameters": {
        "url": "=https://api.surfe.com/v2/people/enrich/{{ $json.enrichmentID }}",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "{\n  \"enrichmentType\": \"emailAndMobile\",\n  \"listName\": \"listName\",\n  \"people\": [\n    {\n      \"firstName\": \"\",\n      \"lastName\": \"\",\n      \"companyName\": \"\",\n      \"companyWebsite\": \"\",\n      \"externalID\": \"\",\n      \"linkedinUrl\": \"[YOUR LINKEDIN URL]/\"\n    }\n  ]\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer XXXXXXXXXXXXXXXXXXXXXXXX"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "94417a70-a873-491e-88e6-262dcadde94f",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "notes": "Notify end of all batches",
      "position": [
        120,
        340
      ],
      "webhookId": "b46c028e-8212-40fe-b4d5-0f7c1890585e",
      "parameters": {
        "sendTo": "{YOUR EMAIL ADDRESS}",
        "message": "Your batch csv enrichment is done.",
        "options": {},
        "subject": "Your batch csv enrichment is done."
      },
      "executeOnce": true,
      "notesInFlow": true,
      "typeVersion": 2.1
    },
    {
      "id": "ad49f2c1-a9a0-49fa-8853-aef4dc63a453",
      "name": "Batch aufteilen - 500",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -160,
        580
      ],
      "parameters": {
        "options": {},
        "batchSize": 500
      },
      "notesInFlow": false,
      "typeVersion": 3,
      "alwaysOutputData": false
    },
    {
      "id": "b1c2c48c-5ba6-4a42-ab17-bf69400aa0ac",
      "name": "HubSpot: Erstellen oder Aktualisieren",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        1380,
        1100
      ],
      "parameters": {
        "email": "={{ $json.email }}",
        "options": {
          "resolveData": false
        },
        "authentication": "appToken",
        "additionalFields": {
          "country": "={{ $json.country }}",
          "jobTitle": "={{ $json.jobTitle }}",
          "lastName": "={{ $json.lastName }}",
          "firstName": "={{ $json.firstName }}",
          "websiteUrl": "={{ $json.linkedinUrl }}",
          "companyName": "={{ $json.companyName }}",
          "phoneNumber": "={{ $json.phone }}",
          "mobilePhoneNumber": "={{ $json.phone }}"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "5e689b8d-5539-4593-9e18-903b172f4c73",
      "name": "30 Sekunden warten",
      "type": "n8n-nodes-base.wait",
      "position": [
        780,
        940
      ],
      "webhookId": "faddf14b-4e33-4108-a141-c1a172e0a5d1",
      "parameters": {
        "amount": 30
      },
      "typeVersion": 1.1
    },
    {
      "id": "b6b81b03-77b5-4868-91f6-12d4d9c248d9",
      "name": "JSON-Payload für Anreicherungsanfrage vorbereiten",
      "type": "n8n-nodes-base.code",
      "position": [
        120,
        580
      ],
      "parameters": {
        "jsCode": "const items = $input.all();\n\nreturn [\n  {\n    json: {\n    \"include\": {\n      \"email\": true,\n      \"linkedInUrl\": false,\n      \"mobile\": true\n    },\n    \"notificationOptions\": {\n      \"webhookUrl\": \"\"\n    },\n      people: items.map((item) => ({\n        firstName: \"\",\n        lastName: \"\",\n        companyName: \"\",\n        companyWebsite: \"\",\n        externalID: \"\",\n        linkedinUrl: item.json.linkedin_url,\n      })),\n    },\n  },\n];\n"
      },
      "typeVersion": 2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "eb0be05b-a13d-453a-ae04-6800bce9699a",
  "connections": {
    "0796ab84-bf14-4f51-906e-db01486b2c76": {
      "main": [
        [
          {
            "node": "ad49f2c1-a9a0-49fa-8853-aef4dc63a453",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5e689b8d-5539-4593-9e18-903b172f4c73": {
      "main": [
        [
          {
            "node": "976ebf8c-8838-41c1-bb8f-f817a9b60ae9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ad49f2c1-a9a0-49fa-8853-aef4dc63a453": {
      "main": [
        [
          {
            "node": "94417a70-a873-491e-88e6-262dcadde94f",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "b6b81b03-77b5-4868-91f6-12d4d9c248d9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0cf2212f-e1f3-4616-ad6b-6c8c00bfe237": {
      "main": [
        [
          {
            "node": "0796ab84-bf14-4f51-906e-db01486b2c76",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c3e28407-7bb4-4d2a-8009-0621f236efa3": {
      "main": [
        [
          {
            "node": "b1c2c48c-5ba6-4a42-ab17-bf69400aa0ac",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1b84d64f-85ea-4914-96e2-3321c3ed389d": {
      "main": [
        [
          {
            "node": "23fdf067-cd74-4b04-96df-9241a86570cf",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "5e689b8d-5539-4593-9e18-903b172f4c73",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b1c2c48c-5ba6-4a42-ab17-bf69400aa0ac": {
      "main": [
        [
          {
            "node": "ad49f2c1-a9a0-49fa-8853-aef4dc63a453",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "735abd1e-66df-4e0c-92e4-803c08edd307": {
      "main": [
        [
          {
            "node": "976ebf8c-8838-41c1-bb8f-f817a9b60ae9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "976ebf8c-8838-41c1-bb8f-f817a9b60ae9": {
      "main": [
        [
          {
            "node": "1b84d64f-85ea-4914-96e2-3321c3ed389d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b6b81b03-77b5-4868-91f6-12d4d9c248d9": {
      "main": [
        [
          {
            "node": "735abd1e-66df-4e0c-92e4-803c08edd307",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "23fdf067-cd74-4b04-96df-9241a86570cf": {
      "main": [
        [
          {
            "node": "c3e28407-7bb4-4d2a-8009-0621f236efa3",
            "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-Generierung

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

N8N-Workflow: Anreicherung der Kaufgruppe
Automatische Entdeckung und Anreicherung von HubSpot-Kaufgruppen mit Surfe und Google Tabellen
If
Code
Wait
+
If
Code
Wait
22 Nodesgo-surfe
Lead-Generierung
Lead-Liste erstellen
Ziel-Lead-Liste erstellen: Leads mit Surfe zu HubSpot finden und anreichern
If
Code
Wait
+
If
Code
Wait
13 Nodesgo-surfe
Lead-Generierung
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
n8n-Knoten in der visuellen Referenzbibliothek erkunden
Erkundung von n8n-Knoten in der visuellen Referenzbibliothek
If
Ftp
Set
+
If
Ftp
Set
113 NodesI versus AI
Sonstiges
KI-gestütztes Abrufen von Google Maps-Geschäftsdaten und Export in Tabellen
KI-basierte Extraktion von Geschäftsdaten aus Google Maps mit Datenanreicherung und Export in Tabellen
If
Code
Wait
+
If
Code
Wait
25 NodesMsaid Mohamed el hadi
Lead-Generierung
KI-Lead-Mining-Agent
Automatisierte Lead-Generierung und Kalt-E-Mail-Versand unter Verwendung von Apify, KI und Gmail
If
Set
Wait
+
If
Set
Wait
20 NodesRakin Jakaria
Lead-Generierung
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes12
Kategorie1
Node-Typen10
Schwierigkeitsbeschreibung

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

Autor
go-surfe

go-surfe

@go-surfe

Save time and sell more with Surfe's API via n8n workflows. - Accurate data you can trust - Results in milliseconds - Scalable and versatile - Full automation For more check out: 💻 https://www.surfe.com?utm_source=n8n 🔗 https://www.linkedin.com/company/surfe/ 👾 https://github.com/surfe/api-examples

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