Automatisierte Lead-Erweiterung-Pipeline mit Apollo.io und Google Tabellen
Experte
Dies ist ein Lead Generation, AI Summarization-Bereich Automatisierungsworkflow mit 33 Nodes. Hauptsächlich werden If, Code, Wait, Webhook, SplitOut und andere Nodes verwendet. Automatisierte Lead-Enrichment-Pipeline für LinkedIn mit Apollo.io und Google Sheets
Voraussetzungen
- •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google Sheets API-Anmeldedaten
- •Google Gemini API Key
Verwendete Nodes (33)
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
{
"meta": {
"instanceId": "67dd1445921862780ac74448aef33eb969db12b9a6ce95248c7ae86a887cb653",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ee7ba99a-a412-4389-af47-e12a8070a9a1",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
2032,
1296
],
"webhookId": "4584ccbb-4256-4da7-a8df-bee1f3b27084",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "d913c122-3f4a-4fa3-aab3-79c6319ac12e",
"name": "Aufteilen",
"type": "n8n-nodes-base.splitOut",
"position": [
2240,
1296
],
"parameters": {},
"typeVersion": 1
},
{
"id": "41a6dc80-fe9e-4cde-b47b-b03ae98feb7f",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2832,
1504
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "0bda86e3-84ab-4b9f-9c74-b871a658bdc6",
"name": "Google Gemini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2512,
1504
],
"parameters": {},
"typeVersion": 1
},
{
"id": "65af8ed4-cec3-4937-963e-4623473f5b57",
"name": "Über Elemente iterieren",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2448,
1296
],
"parameters": {},
"typeVersion": 3
},
{
"id": "54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed",
"name": "Zeile(n) in Tabelle abrufen",
"type": "n8n-nodes-base.googleSheets",
"position": [
2224,
2016
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ea21290c-588d-443b-b401-d7329063e9bb",
"name": "Zeitplan-Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2048,
2016
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"name": "Über Elemente iterieren1",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2720,
2016
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2e9a8548-a8bf-47e3-8fe1-93072276cd9d",
"name": "Zeile in Tabelle aktualisieren",
"type": "n8n-nodes-base.googleSheets",
"position": [
3440,
2032
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ed8a4414-e31d-46d7-9ad6-836faee1a3ac",
"name": "Zeitplan-Trigger1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
2672
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6951d857-278a-4633-be22-f06937dacb98",
"name": "Über Elemente iterieren2",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2752,
2656
],
"parameters": {},
"typeVersion": 3
},
{
"id": "bb781af1-7246-4bf7-9f77-1f7eb17637ef",
"name": "Warten",
"type": "n8n-nodes-base.wait",
"position": [
3648,
2032
],
"webhookId": "e5a3db76-aa67-42c7-8ad1-e916509b7c13",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5127d065-bc43-454c-bc64-02402c23143a",
"name": "Warten1",
"type": "n8n-nodes-base.wait",
"position": [
3440,
2656
],
"webhookId": "69d23d48-e9fd-4f7d-bc70-fa2400658e62",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "65efcc77-b567-4fff-a2e8-31b8e0e29f4e",
"name": "Zeile(n) in Tabelle abrufen1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
2672
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "71fb0b9d-d8b2-490b-8a55-a515c56fe10e",
"name": "Zeile in Tabelle aktualisieren1",
"type": "n8n-nodes-base.googleSheets",
"position": [
3648,
2656
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "5a81a696-1155-4fbb-966c-82baec8219fe",
"name": "Wenn",
"type": "n8n-nodes-base.if",
"position": [
2496,
2672
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca",
"name": "Wenn1",
"type": "n8n-nodes-base.if",
"position": [
2432,
2032
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "bfa61ebd-bdf8-4356-8807-579ea74a06cd",
"name": "Zeitplan-Trigger2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
3136
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "a3dfff36-07c3-49c6-b7fb-718638854507",
"name": "Warten2",
"type": "n8n-nodes-base.wait",
"position": [
3712,
3120
],
"webhookId": "69d23d48-e9fd-4f7d-bc70-fa2400658e62",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "59e93cf6-cf15-4a92-b344-bac485607e07",
"name": "Zeile in Tabelle aktualisieren2",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
3920,
3120
],
"parameters": {},
"typeVersion": 4.7,
"alwaysOutputData": false
},
{
"id": "098cf0b1-6c13-428a-aedf-53f5a4ace309",
"name": "Wenn2",
"type": "n8n-nodes-base.if",
"position": [
2464,
3136
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "69cc889b-3692-412b-9265-8b6ed4df7a49",
"name": "Code",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"position": [
2928,
3120
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "37e8ea98-60d5-413e-922d-e5fed98e96ef",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
1776,
2528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1ab50ec4-c5f0-4888-8f2c-0b16c518e6ea",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1792,
1856
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9bb1bf69-b5f4-4471-a98e-e4728062391c",
"name": "Haftnotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1808,
3072
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
3456,
3120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"name": "Über Elemente iterieren4",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2704,
3088
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723",
"name": "Zeile(n) in Tabelle abrufen3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
3136
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"name": "Linkedin Scraped Formater",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
2656,
1296
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"name": "Werte speichern",
"type": "n8n-nodes-base.googleSheets",
"position": [
3008,
1296
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "a3e862b8-9f95-46ad-be2d-a7b06f15a1f0",
"name": "Unternehmensname zu Domain",
"type": "n8n-nodes-base.httpRequest",
"position": [
3232,
2032
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "835de11e-aa6d-4e4e-9f2d-7e008155d1db",
"name": "Personensuche",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
3024,
2656
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "bfed2a87-6446-4484-aad5-56f4ee3a566e",
"name": "E-Mail-Finder",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
3184,
3120
],
"parameters": {},
"typeVersion": 4.2
}
],
"pinData": {},
"connections": {
"5a81a696-1155-4fbb-966c-82baec8219fe": {
"main": [
[
{
"node": "6951d857-278a-4633-be22-f06937dacb98",
"type": "main",
"index": 0
}
]
]
},
"72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca": {
"main": [
[
{
"node": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"type": "main",
"index": 0
}
]
]
},
"098cf0b1-6c13-428a-aedf-53f5a4ace309": {
"main": [
[
{
"node": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"type": "main",
"index": 0
}
]
]
},
"69cc889b-3692-412b-9265-8b6ed4df7a49": {
"main": [
[
{
"node": "bfed2a87-6446-4484-aad5-56f4ee3a566e",
"type": "main",
"index": 0
}
]
]
},
"bb781af1-7246-4bf7-9f77-1f7eb17637ef": {
"main": [
[
{
"node": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"type": "main",
"index": 0
}
]
]
},
"1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d": {
"main": [
[
{
"node": "a3dfff36-07c3-49c6-b7fb-718638854507",
"type": "main",
"index": 0
}
]
]
},
"5127d065-bc43-454c-bc64-02402c23143a": {
"main": [
[
{
"node": "71fb0b9d-d8b2-490b-8a55-a515c56fe10e",
"type": "main",
"index": 0
}
]
]
},
"a3dfff36-07c3-49c6-b7fb-718638854507": {
"main": [
[
{
"node": "59e93cf6-cf15-4a92-b344-bac485607e07",
"type": "main",
"index": 0
}
]
]
},
"ee7ba99a-a412-4389-af47-e12a8070a9a1": {
"main": [
[
{
"node": "d913c122-3f4a-4fa3-aab3-79c6319ac12e",
"type": "main",
"index": 0
}
]
]
},
"d913c122-3f4a-4fa3-aab3-79c6319ac12e": {
"main": [
[
{
"node": "65af8ed4-cec3-4937-963e-4623473f5b57",
"type": "main",
"index": 0
}
]
]
},
"bfed2a87-6446-4484-aad5-56f4ee3a566e": {
"main": [
[
{
"node": "1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d",
"type": "main",
"index": 0
}
]
]
},
"3f428a31-7eb0-4e78-b574-bf0b968b652e": {
"main": [
[
{
"node": "65af8ed4-cec3-4937-963e-4623473f5b57",
"type": "main",
"index": 0
}
]
]
},
"835de11e-aa6d-4e4e-9f2d-7e008155d1db": {
"main": [
[
{
"node": "5127d065-bc43-454c-bc64-02402c23143a",
"type": "main",
"index": 0
}
]
]
},
"65af8ed4-cec3-4937-963e-4623473f5b57": {
"main": [
[],
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "main",
"index": 0
}
]
]
},
"748e2b43-e51a-417d-92ff-df0704cef2a9": {
"main": [
[],
[
{
"node": "a3e862b8-9f95-46ad-be2d-a7b06f15a1f0",
"type": "main",
"index": 0
}
]
]
},
"6951d857-278a-4633-be22-f06937dacb98": {
"main": [
[],
[
{
"node": "835de11e-aa6d-4e4e-9f2d-7e008155d1db",
"type": "main",
"index": 0
}
]
]
},
"3fdb7f62-3fad-4067-b6c8-d2e07984370f": {
"main": [
[],
[
{
"node": "69cc889b-3692-412b-9265-8b6ed4df7a49",
"type": "main",
"index": 0
}
]
]
},
"ea21290c-588d-443b-b401-d7329063e9bb": {
"main": [
[
{
"node": "54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed",
"type": "main",
"index": 0
}
]
]
},
"ed8a4414-e31d-46d7-9ad6-836faee1a3ac": {
"main": [
[
{
"node": "65efcc77-b567-4fff-a2e8-31b8e0e29f4e",
"type": "main",
"index": 0
}
]
]
},
"bfa61ebd-bdf8-4356-8807-579ea74a06cd": {
"main": [
[
{
"node": "abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723",
"type": "main",
"index": 0
}
]
]
},
"54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed": {
"main": [
[
{
"node": "72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca",
"type": "main",
"index": 0
}
]
]
},
"2e9a8548-a8bf-47e3-8fe1-93072276cd9d": {
"main": [
[
{
"node": "bb781af1-7246-4bf7-9f77-1f7eb17637ef",
"type": "main",
"index": 0
}
]
]
},
"65efcc77-b567-4fff-a2e8-31b8e0e29f4e": {
"main": [
[
{
"node": "5a81a696-1155-4fbb-966c-82baec8219fe",
"type": "main",
"index": 0
}
]
]
},
"abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723": {
"main": [
[
{
"node": "098cf0b1-6c13-428a-aedf-53f5a4ace309",
"type": "main",
"index": 0
}
]
]
},
"71fb0b9d-d8b2-490b-8a55-a515c56fe10e": {
"main": [
[
{
"node": "6951d857-278a-4633-be22-f06937dacb98",
"type": "main",
"index": 0
}
]
]
},
"59e93cf6-cf15-4a92-b344-bac485607e07": {
"main": [
[
{
"node": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"type": "main",
"index": 0
}
]
]
},
"a3e862b8-9f95-46ad-be2d-a7b06f15a1f0": {
"main": [
[
{
"node": "2e9a8548-a8bf-47e3-8fe1-93072276cd9d",
"type": "main",
"index": 0
}
]
]
},
"0bda86e3-84ab-4b9f-9c74-b871a658bdc6": {
"ai_languageModel": [
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"41a6dc80-fe9e-4cde-b47b-b03ae98feb7f": {
"ai_outputParser": [
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"d83f2237-6fe7-4eb4-b2d7-deba7c26e54e": {
"main": [
[
{
"node": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"type": "main",
"index": 0
}
],
[
{
"node": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"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-Generierung, KI-Zusammenfassung
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
Tägliche intelligente Analyse der WhatsApp-Gruppen: GPT-4.1-Analyse und Transkription von Sprachnachrichten
Tägliche intelligente Analyse von WhatsApp-Gruppen: GPT-4.1-Analyse und Transkription von Sprachnachrichten
If
Set
Code
+
If
Set
Code
52 NodesDaniel Lianes
Verschiedenes
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
Haustierladen 4
🐥 KI-Terminassistent für Tierbedarfsgeschäfte
If
Set
Code
+
If
Set
Code
187 NodesBruno Dias
Künstliche Intelligenz
AI Candidate Screening Pipeline_ LinkedIn to Telegram with Gemini & Apify
If
Set
Code
+
If
Set
Code
55 NodesDean Pike
Personalwesen
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes33
Kategorie2
Node-Typen13
Autor
Rahi Uppal
@rahiuppalAI and Automation Consultant with over 1000 hours of experience building, deploying, and solving marketing and sales automation problems. I ship AI products faster by combining business acumen with AI & automation expertise and an engineering mindset. Connect with me on LinkedIn to chat.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen