Webhook lead scoring with OpenAI

OpenAI scores webhook leads, logs them, alerts Slack. This n8n template receives lead details from a form or website through a POST webhook. It normalizes the payload into name, email, company and message fields, then sends the lead text to OpenAI and parses the reply into JSON with a score, tier, reason and next step. The original fields and the AI result are combined and appended to a Google Sheets worksheet. When the score meets the hot-lead threshold, a formatted alert is posted to a Slack channel. The webhook caller receives a JSON response with the computed tier. It suits teams whose form tool can send a POST request.

n8nRead on 2026-11-167 steps

Steps

  1. Trigger: Receives a POST request on a webhookWebhook
    Lead details from a form or website.
  2. Normalizes the incoming payload
    Name, email, company and message fields.
  3. Sends the normalized lead text to OpenAIOpenAI
    Score, tier, reason and next step in JSON.
  4. Combines the lead fields with AI results
  5. Output: Appends the lead record to Google SheetsGoogle Sheets
  6. Output: Posts a formatted alert to SlackSlack
    When the score meets the hot-lead threshold.
  7. Output: Returns a JSON webhook responseWebhook
    Includes the computed tier.

Limits

  • Needs a form tool that can send a POST payload.
  • The Google Sheet needs a Leads tab with the listed columns.

What it does well

  • Returns the computed tier to the form that sent the lead.
  • Stores the AI reason and next step next to each lead.

Before you import

After the import, add OpenAI, Google Sheets and Slack credentials, create a Leads tab, and point your form tool at the webhook URL.

Similar templates