n8n B2B Lead Scoring Workflow: Gemini, Sheets, Slack & Gmail Webhook

Instant B2B lead scoring with Gemini—then notify sales automatically

This n8n B2B Lead Scoring Workflow takes new leads from a webhook, deduplicates and enriches them in Google Sheets, scores them with Google Gemini, and then routes notifications to your team via Slack and Gmail based on the resulting lead tier (Hot/Warm/Cold).

What this workflow does

• Receives lead submissions via a POST webhook endpoint (path: lead-intake).
• Normalizes and validates inputs, ensuring required fields are present and standardizing key values like email and website.
• Deduplicates in Google Sheets by looking up the lead by email and continuing only if no existing record is found.
• Enriches contact and company data by calling external HTTP APIs and mapping the responses into structured enrichment fields.
• Scores with Google Gemini by merging the original lead data and enrichment details, then sending a scoring prompt to Gemini for a JSON response including: score, tier, summary, reasons, confidence, and recommended action.
• Parses and applies the result, merges Gemini output back into the lead profile, and routes the lead into Hot, Warm, or Cold.
• Appends tiered records to Google Sheets and notifies via Slack and Gmail for matching tiers.

Use cases

• Route inbound leads from a form/landing page webhook to the right sales outreach tier within minutes.
• Prevent duplicate follow-ups by deduplicating leads in Google Sheets using email.
• Automate enrichment + scoring for SaaS pipeline qualification, using Gemini to generate actionable summaries and reasons.

Technical details

• n8n nodes: if, set, code, merge, gmail, slack
• Integrations: Webhook (path lead-intake), Google Sheets, Google Gemini (PaLM), HTTP API enrichment, Slack notifications, Gmail notifications
• Setup highlights: configure webhook URL, Google Sheets credentials + document/sheet tabs for duplicate checks and Hot/Warm/Cold appends, and add Google Gemini (PaLM) API credentials.