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.
Steps
- Trigger: Receives a POST request on a webhookWebhook
Lead details from a form or website. - Normalizes the incoming payload
Name, email, company and message fields. - Sends the normalized lead text to OpenAIOpenAI
Score, tier, reason and next step in JSON. - Combines the lead fields with AI results
- Output: Appends the lead record to Google SheetsGoogle Sheets
- Output: Posts a formatted alert to SlackSlack
When the score meets the hot-lead threshold. - 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
Lead enrichment with Bright Data MCP
Also for sales and leads, 4 steps.
Classify contacts by role with GPT
Also for sales and leads, 10 steps.
Airtable leads enriched from LinkedIn
Also for sales and leads, 7 steps.
Google Sheets and OpenAI: 24 templates compared
Same two apps, different steps.
OpenAI and Slack: 17 templates compared
Same two apps, different steps.
Google Sheets and Slack: 16 templates compared
Same two apps, different steps.
Google Sheets and Webhook: 4 templates compared
Same two apps, different steps.
OpenAI and Webhook: 3 templates compared
Same two apps, different steps.
Slack and Webhook: 2 templates compared
Same two apps, different steps.
Capture a lead
Other templates that do this task.
Notify a team
Other templates that do this task.