lead-enrichment-pipeline_skill

Overview

This skill automates lead capture, deduplication, scoring, storage, and team notifications using n8n workflows and Google Sheets. It delivers three production-ready pipelines for general lead tracking, lead magnet delivery, and newsletter signups. The goal is to stop manual entry, surface hot prospects quickly, and keep a single source of truth for lead activity.

How this skill works

Incoming leads arrive via n8n webhooks and are validated for required fields like name and email. The workflow checks Google Sheets for an email match and either appends a new row or updates an existing record, increments touchpoints, and recalculates a simple score based on source and engagement. For new or high-scoring leads the workflow sends notification emails to your team; optional enrichment APIs can be added between the webhook and Sheets nodes.

When to use it

• You need a low-cost, maintainable lead intake system without a full CRM.
• Multiple capture points (forms, landing pages, chatbots) feed one tracking sheet.
• You want automatic deduplication and simple intent scoring to prioritize follow-up.
• You need immediate email notifications for new or engaged leads.
• You prefer Google Sheets as a transparent, editable single source of truth.

Best practices

• Create a Google Sheet with the provided schema and enable appendOrUpdate on the email column.
• Replace all YOUR_* placeholders with your actual credentials and sheet ID before importing workflows.
• Use SMTP credentials that allow reliable delivery and set a clear FROM and notification address.
• Add an HTTP Request node for third-party enrichment only when you need richer profiles.
• Keep scoring rules simple and document any custom adjustments in the sheet or workflow notes.

Example use cases

• A freelancer captures website contact requests and auto-notifies the owner to respond quickly.
• An agency collects leads from multiple campaigns, deduplicates them, and routes high-intent leads to sales.
• A SaaS team manages a product waitlist, scoring users by engagement and converting top prospects.
• A content creator automates lead magnet delivery and stores subscribers for ongoing nurture.
• An eCommerce support pipeline captures inquiries, updates touchpoints, and alerts customer service.