Lead qualification workflow that validates inbound form submissions, uses OpenAI to classify leads against outdoor industry criteria, and routes qualified and rejected leads into separate Google Sheets tabs with error alerts on each path.
Make · workflow canvasproduction build
Context
Outdoor industry sales teams needed a consistent way to separate qualified leads from non-qualifying submissions without manual review, while keeping a clean audit trail for both outcomes.
Approach
Built a single Make.com scenario that receives leads via webhook, validates required fields, sends intake data to OpenAI for qualification scoring, parses the JSON response, and routes leads into qualified or rejected Google Sheets tabs, with dedicated error handlers for parsing failures and logging issues on both branches.
