n8n Lead Qualification: OpenAI GPT-5 + Sheets + Gmail Alerts

Instantly qualify leads with OpenAI, log them to Google Sheets, and alert your team by Gmail

This n8n workflow automatically receives lead submissions, uses OpenAI GPT-5 to score and categorize each lead, appends the results to Google Sheets, and sends a Gmail alert when a lead is marked Hot (lead score > 70).

What this workflow does

• Receives leads via Webhook: Listens for a POST request on the webhook endpoint containing “Name/Email/Company/Message” text fields.
• Extracts and normalizes data: Cleans and standardizes the incoming lead’s name, email, company, and message.
• AI lead qualification with OpenAI: Sends the cleaned lead information to OpenAI (GPT-5-mini) to generate structured JSON, including:
  • lead score
  • category
  • summary bullets
  • a recommended action
• Logs to Google Sheets: Appends the original lead details plus the AI scoring results to your specified spreadsheet and sheet tab.
• Hot lead detection: Checks whether the lead score is greater than 70.
• Sends Gmail alerts: If the threshold is met, sends a formatted Gmail message containing the lead details and AI summary.

Use cases

• SaaS teams routing inbound form submissions for faster follow-up on high-intent prospects.
• Automation engineers implementing lead scoring workflows inside n8n without manual spreadsheets.
• Operators capturing web leads, qualifying them with GPT-5, and notifying the right email contact for Hot leads.

Technical details (n8n + connected services)

• Webhook trigger for incoming POST requests
• OpenAI GPT-5-mini for structured lead scoring/category JSON
• Google Sheets (append rows) via OAuth2
• Gmail alert emails via OAuth2
• Nodes/settings: if, set, gmail, webhook, and a sticky note in the workflow

Set up credentials (OpenAI, Google Sheets, Gmail), configure the spreadsheet/tab for logging, set the Gmail recipient for Hot-lead alerts, then deploy the webhook URL to your lead source.