Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Lead Generation & Enrichment

Lead Generation & Enrichment

Qualify form leads in Google Sheets with duplicate checks and Slack alerts

Runs on each n8n form submission, validates the email, skips duplicates, scores the lead as hot, warm or cold, logs it to Google Sheets and posts a Slack alert.

What it does

## 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.

The steps

  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

Similar automations