n8n AI Lead Qualification: OpenAI + PostgreSQL + Email Approval

Automatically qualify B2B leads with n8n AI—then require human email approval before outreach

This n8n workflow receives B2B lead submissions via webhook, stores them in PostgreSQL, and uses an OpenAI-powered AI Agent to score and draft next steps. Low-confidence results are sent for manual review, and any approval-required actions wait for human email approval before outreach or conversion.

What this workflow does

• Webhook intake: Accepts a POST request with required lead details (email and message). Invalid payloads are rejected with HTTP 400.
• Normalize, validate, and persist: Upserts the lead into PostgreSQL and prepares lead history for the AI assessment.
• OpenAI AI Agent qualification: Runs an OpenAI AI Agent that looks up prior lead history, applies a deterministic policy calculator, and saves the assessment + activity log back to PostgreSQL.
• Reliability check & manual review: If the structured decision is unreliable, the workflow marks the lead for manual review, emails the reviewer, and returns HTTP 202.
• No action vs action: If the policy result is no_action, it logs the outcome and returns HTTP 200. If approval is required, it creates an approval record in PostgreSQL and returns HTTP 202 with an approval ID.
• Human email approval gate: The reviewer receives a draft to approve or reject. Approved leads proceed to follow-up email via SMTP (and are logged), or are converted into a client record in PostgreSQL (and are logged).
• Safe handling on rejection/timeout: Rejected or timed-out cases record the rejection and take no sensitive action.

Use cases

• SaaS lead intake from your website/contact form with automated qualification and audit trails in PostgreSQL.
• Sales ops workflows that require human approval before any outreach or conversion.
• Teams managing high-volume B2B submissions where AI drafts next steps but reviewers control final action.

Technical details

• Nodes/logic: if, set, code, no op, webhook, postgres
• AI: OpenAI AI Agent with Postgres-backed memory for prior lead history
• Approval workflow: Approval records in PostgreSQL + reviewer email for approve/reject
• Outreach: Follow-up email via SMTP (logged) and/or conversion to client record in PostgreSQL