I designed and built an AI-powered lead management automation using
Make.com to streamline the process of receiving, analyzing, organizing, and communicating lead information.
The workflow starts with a custom webhook that receives incoming data, then searches Google Sheets to check existing records. OpenAI analyzes and classifies the information, while JSON parsing converts the AI response into structured data for reliable processing.
Using conditional logic, the system automatically determines whether a lead is new or already existing. New leads are added to Google Sheets, while existing records are updated. Automated Gmail notifications are then triggered, and the results are merged and sent to Slack for team visibility.
Key Features