Qualify New Leads in Google Sheets via OpenAI GPT-4

This n8n workflow triggers when a new row is added to a Google Sheets document, such as from Google Forms or manual entry. It extracts lead data like name, company, and message, then sends it to OpenAI's GPT-4 with a custom prompt defining qualification criteria (e.g., budget, intent, fit). GPT-4 responds in structured JSON format indicating 'qualified' or 'not qualified' with reasoning.

The workflow parses the AI response using an Edit Fields node, merges it with the original lead data via a Merge node, and updates the original sheet row with the qualification status in a dedicated column. This enables instant sorting, filtering, and follow-up on hot leads without manual review.

Benefits include massive time savings for sales teams, reducing qualification time from hours to seconds, minimizing bias with AI consistency, and scaling effortlessly for high-volume leads. Ideal use cases: inbound form submissions, webinar signups, content downloads, or cold outreach tracking in CRM pipelines. Customize prompts for industry-specific rules like B2B tech sales or e-commerce inquiries.