8
n8n Deutschamn8n.com

LinkedIn Lead-Erkennung und personalisierte Ansprache angetrieben von Gemini (Google Sheets)

Fortgeschritten

Dies ist ein Lead Generation, Multimodal AI-Bereich Automatisierungsworkflow mit 13 Nodes. Hauptsächlich werden SplitOut, EmailSend, FormTrigger, HttpRequest, GoogleSheets und andere Nodes verwendet. LinkedIn-Lead-Erkennung und personalisierte Ansprache durch Gemini (Google Sheets)

Voraussetzungen
  • •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (13)

SplitOut
EmailSend
StickyNote
FormTrigger
HttpRequest
GoogleSheets
SplitInBatches
GoogleGemini

Kategorie

Lead-Generierung
Multimodales KI
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": "783d2046f405cc6ecb20ef185376ed1023323a3da628b9d8156b1fb75c75e037",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "75d06417-5d15-4372-9aa5-bc9bf008cf37",
      "name": "Aufteilen",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        3472,
        -1072
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "items"
      },
      "typeVersion": 1
    },
    {
      "id": "bfcd5fd4-3ab1-44ed-ade4-c39ce5fca1e4",
      "name": "Elemente durchlaufen",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        3696,
        -1072
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "7d25973b-07b0-43b3-a067-85dc340b4d8d",
      "name": "Formular absenden",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        2768,
        -1072
      ],
      "webhookId": "1bd6594d-7541-4e65-a2fe-0311eca49001",
      "parameters": {
        "options": {},
        "formTitle": "1.0 S_LG_Find LinkedIn Accounts by keywords and Write personal message for contact",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Keywords to find Company / Professional"
            },
            {
              "fieldLabel": "Purpose of Contact"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "4106578e-1721-4da3-8ec0-a85584d32c0d",
      "name": "Boole'sche Suchstrings erstellen",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        2960,
        -1072
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "models/gemini-2.5-flash",
          "cachedResultName": "models/gemini-2.5-flash"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=You are a tool that generates Boolean search strings for Google, in order to search for companies or professionals on LinkedIn.  \n\n# Task:\n- Based on the keyword and the purpose, generate a suitable keyword string for searching on LinkedIn.  \n- Only return the keyword string, without any explanation or additional information.  \n- Always add site:linkedin.com to the keyword string.  \n\n# Input:\nKeyword: {{ $json['Keywords to find Company / Professional'] }}\nPurpose: {{ $json['Purpose of Contact'] }}"
            }
          ]
        }
      },
      "credentials": {
        "googlePalmApi": {
          "id": "Atcc45Iqep6u15qs",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e64562e8-dd4c-448d-8c8c-0d1e3cc00c87",
      "name": "Linkedin Company abrufen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        3264,
        -1072
      ],
      "parameters": {
        "url": "https://www.googleapis.com/customsearch/v1",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "key",
              "value": "xxxxxxxxx"
            },
            {
              "name": "cx",
              "value": "xxxxx"
            },
            {
              "name": "q",
              "value": "={{ $json.content.parts[0].text }}"
            },
            {
              "name": "num",
              "value": "20"
            },
            {
              "name": "hl",
              "value": "vi"
            },
            {
              "name": "gl",
              "value": "vn"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "a69b91dd-72c7-4050-82c7-418175c21d10",
      "name": "Nachricht verfassen",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        4176,
        -1056
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "models/gemini-1.5-flash",
          "cachedResultName": "models/gemini-1.5-flash"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=You are an AI that drafts outreach messages.\n\n# Requirements\nBased on the purpose: {{ $('Form submit').item.json['Purpose of Contact'] }}\nand the company information:  \nname: {{ $json.name }}  \ndescription: {{ $json.des }}  \n\nWrite a suitable and personalized outreach message for that specific company.  \n\nOnly return the outreach message, without any explanation or additional text.  \nIf some information is missing, use placeholders.  "
            }
          ]
        }
      },
      "credentials": {
        "googlePalmApi": {
          "id": "Atcc45Iqep6u15qs",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f5eefcd1-cfb8-45fc-bc4a-67f88500b2c4",
      "name": "Tabelle aktualisieren",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        4496,
        -1056
      ],
      "parameters": {
        "columns": {
          "value": {
            "message": "={{ $json.content.parts[0].text }}",
            "row_number": 0,
            "linkedin_url": "={{ $('Append row in sheet').item.json.linkedin_url }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "id",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "linkedin_url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "linkedin_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "des",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "des",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "message",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "linkedin_url"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TlZ5uDYJAWm_hx_wkI7HXvXwuOL5WBdxRIMwjQ1kpEU/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "=xxxxx"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "urlO8dciDPm5B2zv",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "5159d49c-52fb-43c6-bb1e-9becc104fdcf",
      "name": "E-Mail senden",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        3952,
        -1232
      ],
      "webhookId": "f322979e-146f-4022-9f44-bc4eb261e33c",
      "parameters": {
        "html": "[Link to sheet]",
        "options": {},
        "subject": "Your auto writing message be completed",
        "toEmail": "info@example.com",
        "fromEmail": "admin@example.com"
      },
      "credentials": {
        "smtp": {
          "id": "CmiyUJFKtSRuiioY",
          "name": "SMTP account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "1d35af31-c2cf-42c9-8e5b-e6796990925b",
      "name": "Zeile in Tabelle anhängen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3952,
        -1056
      ],
      "parameters": {
        "columns": {
          "value": {
            "des": "={{ $json.pagemap.metatags[0][\"og:description\"] }}",
            "name": "={{ $json.title }}",
            "linkedin_url": "={{ $json.link }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "id",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "linkedin_url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "linkedin_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "des",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "des",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "message",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "linkedin_url"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1TlZ5uDYJAWm_hx_wkI7HXvXwuOL5WBdxRIMwjQ1kpEU/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "=xxxxx"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "urlO8dciDPm5B2zv",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "e7a90a44-a1bb-4727-9cbd-7d86e6a7a5d0",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3840,
        -864
      ],
      "parameters": {
        "width": 352,
        "content": "## Google Sheets Mapping\n- **name** → Company/Person name  \n- **linkedin_url** → LinkedIn profile/company URL  \n- **des** → Description or tagline  \n- **message** → AI-generated outreach text  \n"
      },
      "typeVersion": 1
    },
    {
      "id": "8bf56071-28f3-4b9d-81dc-c425695ee7a0",
      "name": "Notiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3200,
        -1168
      ],
      "parameters": {
        "width": 224,
        "height": 272,
        "content": "### Update hl & gl to fit with your location"
      },
      "typeVersion": 1
    },
    {
      "id": "414c16fb-3015-489e-bbb5-f51272f45d2a",
      "name": "Notiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2768,
        -832
      ],
      "parameters": {
        "color": 3,
        "width": 448,
        "height": 240,
        "content": "## Overview\n1. Collect keywords & purpose from a form  \n2. Generate Boolean LinkedIn search queries with AI  \n3. Search LinkedIn profiles/companies via Google Custom Search  \n4. Save results (name, URL, description) into Google Sheets  \n5. Generate personalized outreach messages with AI  \n6. Update the sheet with the message and send notification email  \n"
      },
      "typeVersion": 1
    },
    {
      "id": "bbc5b875-1b07-406c-b856-ca285a73770e",
      "name": "Notiz6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2768,
        -560
      ],
      "parameters": {
        "color": 6,
        "width": 448,
        "height": 176,
        "content": "## Setup Required\n1. Configure Google Sheets OAuth2 credentials  \n2. Configure Gemini API credentials  \n3. Configure SMTP credentials (for email notifications)  \n4. Update Custom Search Engine ID (`cx`) and API Key  \n5. Adjust `hl` & `gl` parameters for your location  \n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "75d06417-5d15-4372-9aa5-bc9bf008cf37": {
      "main": [
        [
          {
            "node": "bfcd5fd4-3ab1-44ed-ade4-c39ce5fca1e4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7d25973b-07b0-43b3-a067-85dc340b4d8d": {
      "main": [
        [
          {
            "node": "4106578e-1721-4da3-8ec0-a85584d32c0d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f5eefcd1-cfb8-45fc-bc4a-67f88500b2c4": {
      "main": [
        [
          {
            "node": "bfcd5fd4-3ab1-44ed-ade4-c39ce5fca1e4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bfcd5fd4-3ab1-44ed-ade4-c39ce5fca1e4": {
      "main": [
        [
          {
            "node": "5159d49c-52fb-43c6-bb1e-9becc104fdcf",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "1d35af31-c2cf-42c9-8e5b-e6796990925b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a69b91dd-72c7-4050-82c7-418175c21d10": {
      "main": [
        [
          {
            "node": "f5eefcd1-cfb8-45fc-bc4a-67f88500b2c4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1d35af31-c2cf-42c9-8e5b-e6796990925b": {
      "main": [
        [
          {
            "node": "a69b91dd-72c7-4050-82c7-418175c21d10",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e64562e8-dd4c-448d-8c8c-0d1e3cc00c87": {
      "main": [
        [
          {
            "node": "75d06417-5d15-4372-9aa5-bc9bf008cf37",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4106578e-1721-4da3-8ec0-a85584d32c0d": {
      "main": [
        [
          {
            "node": "e64562e8-dd4c-448d-8c8c-0d1e3cc00c87",
            "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, Multimodales KI

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

Kund:innen-Persönlichkeitsanalyse (Bazi, DISC, Astrologie) mit Gemini und Google Sheets
Kundenpersönlichkeitsanalyse (Bazi, DISC, Astrologie) mit Gemini und Google Sheets
If
Code
Merge
+
If
Code
Merge
24 NodesCong Nguyen
Lead-Generierung
Automatisierte Angebotsanforderungen mit OpenAI, Google Sheets und CraftMyPDF
Automatisierte RFQ-Anfragen mit OpenAI, Google Sheets und CraftMyPDF
Code
Email Send
Form Trigger
+
Code
Email Send
Form Trigger
9 NodesCong Nguyen
Kundenbeziehungsmanagement
Automatisierter Technologie-News-Bericht über ApiFlash, Gemini Vision und Sheets zu Telegram
Automatisierter Tech-News-Bericht über ApiFlash, Gemini Vision und Sheets-zu-Telegram
Set
Code
Limit
+
Set
Code
Limit
18 NodesCong Nguyen
Marktforschung
Cold-E-Mail-Einstieg für lokale Geschäftssuche: GPT-4 und Dumpling AI
Cold-E-Mail-Einstiege basierend auf lokaler Geschäftssuche: GPT-4 und Dumpling AI
Filter
Split Out
Form Trigger
+
Filter
Split Out
Form Trigger
10 NodesYang
Lead-Generierung
AI-Powered Lead Generation System with Email Personalization and LinkedIn
If
Code
Limit
+
If
Code
Limit
51 NodesMatthieu
Lead-Generierung
AI-gestützte Lead-Generierung (Apollo, LinkedIn-Recherche und 4-stufige personalisierte E-Mails)
AI-gestützte Lead-Generierung: Nutzung von Apollo, LinkedIn-Recherche und 4-stufigen personalisierten E-Mails
If
Set
Code
+
If
Set
Code
30 NodesGain FLow AI
Lead-Generierung
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes13
Kategorie2
Node-Typen8
Schwierigkeitsbeschreibung

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

Autor
Cong Nguyen

Cong Nguyen

@cong-nguyen

I’m a developer specialized in building web and mobile applications with AI integration and intelligent automation. With a solid background in data science, I help businesses build smarter digital solutions using cutting-edge technologies.

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