8
n8n Deutschamn8n.com

AI-Lead-Scoring und -Routing (Google Gemini, Sheets und Slack-Benachrichtigung)

Fortgeschritten

Dies ist ein Content Creation, Multimodal AI-Bereich Automatisierungsworkflow mit 13 Nodes. Hauptsächlich werden Set, Merge, Slack, Webhook, GoogleSheets und andere Nodes verwendet. AI-Lead-Scoring und -Routing (Google Gemini, Sheets und Slack-Benachrichtigung)

Voraussetzungen
  • •Slack Bot Token oder Webhook URL
  • •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
  • •Google Sheets API-Anmeldedaten
  • •Google Gemini API Key

Verwendete Nodes (13)

Set
Merge
Slack
Webhook
StickyNote
GoogleSheets
SentimentAnalysis
LmChatGoogleGemini

Kategorie

Content-Erstellung
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": "0a25db4fd0692af64b58f35e01611f2ef0b5bb9d6654c57ef3741021e7d8cc11",
    "templateId": "4322",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "e74de2ca-d3e1-499b-893c-972bb6bd9ad0",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1424,
        736
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "MOufOXyoLNgKIzCu",
          "name": "Google Gemini(PaLM) Api account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "01b4b86b-8798-405e-93c9-5881f3d27d20",
      "name": "Neuen Lead empfangen (Typeform)",
      "type": "n8n-nodes-base.webhook",
      "position": [
        896,
        480
      ],
      "webhookId": "20426827-714d-4a48-ab87-4a3216665bde",
      "parameters": {
        "path": "lead-webhook",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2
    },
    {
      "id": "b4007cc1-6332-42d3-a7d1-12db9bc35fec",
      "name": "Lead-Daten aufbereiten",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        480
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3.4
    },
    {
      "id": "d274436b-f5f6-4c13-948d-f1e2f822e85c",
      "name": "Stimmung klassifizieren (Gemini oder anderes AI-Modell)",
      "type": "@n8n/n8n-nodes-langchain.sentimentAnalysis",
      "position": [
        1344,
        480
      ],
      "parameters": {
        "options": {},
        "inputText": "={{$json[\"message\"] || $json[\"mensagem\"] || $json[\"resposta\"]}}\n"
      },
      "typeVersion": 1
    },
    {
      "id": "20839991-6176-4485-98fe-1d188ac552f1",
      "name": "Lead-Daten kombinieren",
      "type": "n8n-nodes-base.merge",
      "position": [
        1920,
        464
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3.1
    },
    {
      "id": "31b9506f-0537-4b58-9c51-fbdfcf05a3f0",
      "name": "Nachricht senden",
      "type": "n8n-nodes-base.slack",
      "position": [
        2144,
        480
      ],
      "webhookId": "17d27255-fdc2-4b45-ab04-b35b00fabc99",
      "parameters": {
        "text": "wefwe",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C09BP1AGRT9",
          "cachedResultName": "alle-in-meakcodes"
        },
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "BFRW6GiYcJw58eeZ",
          "name": "Slack account"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "52a61391-f621-484a-b395-e72bffed9654",
      "name": "Neutralen Lead speichern",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        480
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "4cae6f1b-e73f-4497-9ded-2cf241fb2dfd",
      "name": "Kalten Lead speichern",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        672
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "8d4b6ad0-6ba4-48c2-9662-91bcdfbf7ded",
      "name": "Heißen Lead speichern",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        288
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Full Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Full Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "First Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "First Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Last Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Last Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit#gid=0",
          "cachedResultName": "Tabellenblatt1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAA7t2lal9462X_CHmfZQ7LbAVsbrrkpGN1hpDI0p8o/edit?usp=drivesdk",
          "cachedResultName": "Founders Academy Waitlist"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cjPjcwa3RdiMAu79",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "23596639-84c4-438f-a820-1809957a6cdf",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        896,
        192
      ],
      "parameters": {
        "color": 4,
        "height": 256,
        "content": "## STEP 1 · Intake (Webhook)\n**Receive New Lead (Typeform):** POST /lead-webhook\n**Prepare Lead Data:** clean/map fields you need (name, email, message, timestamp).\nTip: Ensure the Typeform payload keys match what you reference later."
      },
      "typeVersion": 1
    },
    {
      "id": "b5c93a1c-55df-47d9-b9bc-b97831a331fa",
      "name": "Notiz 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1328,
        176
      ],
      "parameters": {
        "color": 5,
        "height": 272,
        "content": "## STEP 2 · Sentiment Classification\n**Sentiment node** analyzes message text (fallbacks: message | mensagem | resposta).\n**Gemini model** (via LLM node) powers the classifier.\nOutput branches: Hot / Neutral / Cold (used for routing)."
      },
      "typeVersion": 1
    },
    {
      "id": "c25b0dc7-9bf5-463c-bfb4-b03f5c24960d",
      "name": "Notiz 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        0
      ],
      "parameters": {
        "color": 6,
        "height": 256,
        "content": "## STEP 3 · Store by Segment (Sheets)\nEach branch writes to Google Sheets (appendOrUpdate).\nTip: Set **matchingColumns** (e.g., Email or Submitted) to avoid duplicates.\nIf no mapping is defined, enable auto-map or define column mapping explicitly."
      },
      "typeVersion": 1
    },
    {
      "id": "34e7fb02-48d3-43ff-ab15-bab12a60f3ea",
      "name": "Notiz 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1968,
        176
      ],
      "parameters": {
        "color": 7,
        "height": 256,
        "content": "## STEP 4 · Combine & Notify\n**Merge (3 inputs)** recombines Hot/Neutral/Cold.\n**Slack message** posts to the channel.\nTip: Replace placeholder text with a formatted summary (name, sentiment, link to row)."
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "8d4b6ad0-6ba4-48c2-9662-91bcdfbf7ded": {
      "main": [
        [
          {
            "node": "20839991-6176-4485-98fe-1d188ac552f1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4cae6f1b-e73f-4497-9ded-2cf241fb2dfd": {
      "main": [
        [
          {
            "node": "20839991-6176-4485-98fe-1d188ac552f1",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "20839991-6176-4485-98fe-1d188ac552f1": {
      "main": [
        [
          {
            "node": "31b9506f-0537-4b58-9c51-fbdfcf05a3f0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b4007cc1-6332-42d3-a7d1-12db9bc35fec": {
      "main": [
        [
          {
            "node": "d274436b-f5f6-4c13-948d-f1e2f822e85c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "52a61391-f621-484a-b395-e72bffed9654": {
      "main": [
        [
          {
            "node": "20839991-6176-4485-98fe-1d188ac552f1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "e74de2ca-d3e1-499b-893c-972bb6bd9ad0": {
      "ai_languageModel": [
        [
          {
            "node": "d274436b-f5f6-4c13-948d-f1e2f822e85c",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "01b4b86b-8798-405e-93c9-5881f3d27d20": {
      "main": [
        [
          {
            "node": "b4007cc1-6332-42d3-a7d1-12db9bc35fec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d274436b-f5f6-4c13-948d-f1e2f822e85c": {
      "main": [
        [
          {
            "node": "8d4b6ad0-6ba4-48c2-9662-91bcdfbf7ded",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "52a61391-f621-484a-b395-e72bffed9654",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "4cae6f1b-e73f-4497-9ded-2cf241fb2dfd",
            "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 - Content-Erstellung, 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

Automatisierte Lead-Anrufe: VAPI, Google Sheets-Protokollierung und Kalendertermine
Automatisierung der Lead-Anrufe: VAPI, Google Sheets-Protokollierung und Kalendereinbuchung
Set
Code
Webhook
+
Set
Code
Webhook
13 NodesMeak
Content-Erstellung
Automatisierte Lead-Pflege: GPT-4o mini-Analyse für Gmail, HubSpot und Slack
Automatisierung der Lead-Nachfassaktion: GPT-4o mini-Analyse für Gmail, HubSpot und Slack
If
Set
Code
+
If
Set
Code
14 NodesMeak
Content-Erstellung
Automatisierte lokale Lead-Suche und Kalt-E-Mail-Versand
Automatisches Auffinden lokaler Leads und Versenden von Kalt-E-Mails mit Apify, KI und Gmail
If
Set
Wait
+
If
Set
Wait
18 NodesMeak
Content-Erstellung
KI-basierte Lead-Qualifizierung und personalisierte Ansprache (mit Relevance AI)
KI-basierte Lead-Qualifizierung und personalisierte Ansprache: Verwendung von Relevance AI
Set
Code
Gmail
+
Set
Code
Gmail
34 NodesDiptamoy Barman
Content-Erstellung
Automatisierte Veröffentlichung von RSS auf Medium mit Groq, Gemini und Slack-Genehmigungssystem
Automatisierung des Veröffentlichungsprozesses von RSS auf Medium durch Groq, Gemini und Slack-Genehmigungssysteme
If
Set
Code
+
If
Set
Code
41 NodesObisDev
Content-Erstellung
Betrugspräventions-Lead-Erfassungs- und -Pflegesystem
Betrugsprävention: Leads durch KI-Bewertung, Tabellenverfolgung und mehrkanalige Benachrichtigungen erfassen und pflegen
If
Set
Code
+
If
Set
Code
28 NodesJitesh Dugar
Content-Erstellung
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes13
Kategorie2
Node-Typen8
Schwierigkeitsbeschreibung

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

Autor
Meak

Meak

@meak

I help people build $5k+/month online by starting their own AI agency. Without BS.

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