n8n Webhook Lead Collector to Store Leads in Data Tables

Capture website & form leads instantly—store every submission in an n8n Data Table via a webhook

This n8n Webhook Lead Collector workflow accepts lead data through an HTTP POST, normalizes the fields, saves each lead as a new row in the free_leads n8n Data Table, and returns a clean JSON confirmation—including the stored lead_id.

What this workflow does

• Receives lead submissions at the free-lead-collector webhook endpoint using an HTTP POST request.
• Normalizes incoming fields including: lead_id, name, email, phone, message, and source.
• Applies defaults such as status=NEW and sets created_at to the current time.
• Stores each lead by inserting the normalized record into the free_leads n8n Data Table.
• Responds with JSON to confirm success and return the stored lead_id to the caller.

Use cases

• Turn a simple landing page or embedded form into a lead capture pipeline by POSTing JSON to the webhook.
• Collect leads from SaaS tools or internal systems that can send HTTP requests—no external credentials required.
• Centralize incoming submissions for later review, enrichment, or CRM routing by using the Data Table as your system of record.

Technical details

• Webhook node to expose the free-lead-collector endpoint for lead intake.
• Set node to normalize fields and apply defaults (status, created_at).
• Data Table node to insert leads into the free_leads table.
• Manual Trigger for one-time setup to create the Data Table if it doesn’t exist.
• Respond to Webhook to return a JSON success payload with the stored lead_id.
• Requirements: an n8n instance with Data Tables support enabled.

Want to tailor it? You can rename the Data Table, add/remove lead fields, change the default status, or connect additional nodes for delivery or downstream workflows.