Database Webhook to n8n Lead Alert System

🔍 Real-Time Webhook Payload & Node Inspector

Inspect the exact JSON payload emitted by the database's records.after.insert event trigger and transformed by n8n.

{
  "event": "records.after.insert",
  "table": "Contact Form Leads",
  "timestamp": "2026-09-15T12:00:00.000Z",
  "data": {
    "id": 1,
    "Name": "John Doe",
    "Email": "johndoe@gmail.com",
    "Phone Number": "1234567890",
    "Contact Method": "Phone",
    "Business Notes": "Database -> n8n webhook -> Send Message"
  }
}

{
  "chat_id": "YOUR_TELEGRAM_CHAT_ID",
  "parse_mode": "Markdown",
  "text": "You have a new lead!\n\nTable: Contact Form Leads\nName: John Doe\nPreferred Contact Method: Phone"
}

📖 Database Webhook Configuration Guide

Step-by-step documentation for setting up automatic database webhooks in NocoDB, Supabase, and PostgreSQL following the clue ("Visit the docs for using webhooks in your database platform").

Option A: NocoDB Table Webhooks (Challenge Replica)

1. Open NocoDB and navigate to your table: Contact Form Leads.
2. Click the table kebab menu (⋮) ➔ Webhooks.
3. Click New Webhook, name it n8n Lead Alert Dispatcher.
4. Set Event to After Insert (records.after.insert).
5. Paste your n8n Webhook Production URL: https://your-n8n.app/webhook/contact-form-lead.
6. Set HTTP Method to POST and save. Every newly created record triggers n8n immediately!

Option B: Supabase Database Webhook & pg_net SQL Trigger

-- Supabase PostgreSQL Trigger via pg_net
create or replace function notify_n8n_on_lead_insert()
returns trigger language plpgsql security definer as $$
declare
  payload jsonb;
begin
  payload := jsonb_build_object(
    'event', 'records.after.insert',
    'table', 'Contact Form Leads',
    'data', row_to_json(NEW)
  );

  perform net.http_post(
    url := 'https://your-n8n.app/webhook/contact-form-lead',
    body := payload,
    headers := '{"Content-Type": "application/json"}'::jsonb
  );

  return NEW;
end;
$$;

create trigger trigger_lead_alert_webhook
after insert on public.contact_form_leads
for each row execute function notify_n8n_on_lead_insert();