Qualify Google Sheets Leads with OpenAI & Slack Alerts in n8n

Turn every new Google Sheets lead into an AI-scored, Slack-alerted qualification—automatically

This n8n workflow watches your Google Sheets for new leads, uses OpenAI to score and categorize lead intent with structured output, writes the results back to the same row, and sends a Slack notification only when a lead is relevant and meets your configured score threshold.

What this workflow does

• Triggers every minute when a new row is added to a selected Google Sheets worksheet.
• Enriches the incoming row with workflow configuration values (including your business context and the minimum score threshold).
• Skips empty leads: if the new row’s post_text field is empty, the workflow does nothing.
• Qualifies with OpenAI: sends the lead text plus your business context to an OpenAI chat model and requests a structured response containing: relevant flag, score, category, and reason.
• Writes back to Google Sheets: updates the same row with score, category, reason, relevant, and a status (qualified).
• Alerts in Slack only when the lead is marked relevant and the score is greater than or equal to the configured threshold.

Use cases

• Automatically qualify inbound leads collected in Google Sheets and notify your sales or growth channel in Slack.
• Route only high-intent leads to a team using AI scoring—while keeping the full scoring audit trail in Google Sheets.
• Reduce manual triage by categorizing lead intent (with a clear reason) as soon as rows appear.

Technical details

• Google Sheets trigger (new row; runs every minute) and Google Sheets update action (writes back AI results).
• OpenAI chat model with structured output aligned to expected fields: relevant, score, category, reason.
• Slack node to post a formatted message for qualified leads.
• Uses nodes including if, set, filter, and sticky note (plus workflow messaging/formatting).

Ideal for n8n automation workflow builders, automation engineers, and SaaS operators who want reliable AI lead qualification with Google Sheets + Slack—without manual review.