n8n Lead Qualification: OpenAI to Slack + Google Sheets

Turn website inquiries into qualified leads—automatically send hot prospects to Slack and log the rest to Google Sheets

This n8n workflow captures new form submissions, uses OpenAI to qualify and summarize each lead, then routes results based on lead quality: hot leads go to Slack for fast team response, while cold (and any non-hot) leads are appended to Google Sheets for follow-up.

What this workflow does

• Receives inquiries from an n8n form trigger with name, email, and message fields.
• Qualifies each submission with OpenAI by classifying it as hot, cold, or spam, estimating urgency, summarizing the need, and drafting a suggested first reply.
• Parses and normalizes JSON returned by OpenAI into clean lead properties for downstream routing.
• Routes the lead by classification using a switch-based decision step.
• Sends hot leads to Slack including lead details, urgency, and the suggested reply—so your team can act immediately.
• Appends non-hot leads to Google Sheets for later follow-up and pipeline tracking.

Use cases

• Monitor inbound leads from a website form and instantly alert your sales/support team in Slack when the submission is “hot.”
• Automatically capture “cold” prospects in Google Sheets so nothing falls through the cracks.
• Use AI-generated summaries and a suggested first response to reduce manual lead triage time.

Technical details

• n8n Form Trigger to receive lead submissions (name, email, message).
• OpenAI step to classify (hot/cold/spam), estimate urgency, summarize needs, and draft a suggested reply.
• Code for extracting and normalizing OpenAI JSON into lead properties.
• Switch for routing hot vs non-hot leads.
• Slack integration for hot-lead alerts (destination channel configurable).
• Google Sheets OAuth integration to append cold/non-hot leads to a selected spreadsheet and sheet.
• Includes sticky note nodes for setup/clarification within the workflow.

Setup requirements

• Add an OpenAI API credential and confirm the model selection in the lead-classification step.
• Connect Slack and set the hot-lead destination channel.
• Connect Google Sheets OAuth, then choose the spreadsheet and sheet for follow-up logging.