Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

Bibliothek / Lead-Generierung & Anreicherung

Lead-Generierung & Anreicherung

Form-Leads in Google Sheets mit Duplikatprüfung und Slack-Benachrichtigungen qualifizieren

Läuft bei jeder n8n-Formularübermittlung, prüft die E-Mail-Adresse, überspringt Duplikate, bewertet den Lead als heiß, warm oder kalt, protokolliert ihn in Google Sheets und sendet eine Slack-Benachrichtigung.

Was sie bewirkt

## Qualify form leads in Google Sheets with a duplicate guard and Slack alerts ### How it works 1. A visitor submits the built-in n8n form (name, email, company, budget, message). 2. A Code node tidies the fields, validates the email and builds a match key. The key ignores capitals, +tags and, for Gmail, dots. 3. Invalid emails stop here. 4. The workflow looks that key up in your Google Sheet. If the lead is already there, it stops, so nobody is logged or announced twice. 5. New leads get a simple score with the reasons spelled out, and a tier: hot, warm or cold. 6. The lead is appended to the sheet and posted to a Slack channel. ### Setup 1. Open Set sheet and scoring rules and paste your Google Sheet URL. 2. Add a tab named Leads with this header row: submittedAt, name, email, emailKey, emailDomain, company, budget, message, score, tier, scoreReasons. 3. Add your Google Sheets credential to both Sheets nodes, and your Slack credential and channel to Notify team in Slack. 4. Submit the test form once, check the row and the Slack message, then activate. ### Customization tips - Change the points in Score lead and the tier thresholds in the Set node. - Swap Slack for Telegram, Gmail or Send Email. - Replace the form trigger with a Webhook to use your own website form.

Die Schritte

  1. Lead form submitted
  2. Set sheet and scoring rules
  3. Normalise and validate email
  4. Keep valid emails
  5. Look up email in sheet
  6. Flag duplicates
  7. Keep new leads only
  8. Score lead
  9. Append lead to sheet
  10. Notify team in Slack

Ähnliche Automatisierungen