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
- Lead form submitted
- Set sheet and scoring rules
- Normalise and validate email
- Keep valid emails
- Look up email in sheet
- Flag duplicates
- Keep new leads only
- Score lead
- Append lead to sheet
- Notify team in Slack
Ähnliche Automatisierungen
Lead-Generierung & AnreicherungFormular-Leads in Google Sheets speichern, Slack benachrichtigen und per Gmail automatisch antworten7 SchritteLead-Generierung & AnreicherungSales-Navigator-Leads mit Evaboot, OpenAI und Slack in lemlist überführen15 SchritteLead-Generierung & AnreicherungLeads aus dem Website-Formular in Google Sheets speichern und Gmail-Autoreplies senden7 SchritteLead-Generierung & AnreicherungLokale Unternehmen ohne Website mit Apify finden und Leads in Google Sheets speichern14 Schritte