Technology Stack: n8n, OpenAI, Google Sheets, Webhook, Basic LLM Chain
This intelligent automation system captures incoming leads via a Webhook, processes and refines the data using an LLM Chain powered by OpenAI, and stores the results in Google Sheets for easy access and analysis. It acts as a smart middle layer — analyzing user-submitted form inputs or chatbot responses to extract key lead information such as name, email, interest, and intent.
The Edit Field node cleans and formats the input, while the LLM chain uses GPT to interpret vague or free-form responses (e.g., “I’m interested in AI tools” → “Product Category: AI Automation”). Finally, it sends a confirmation or success message back using the Respond to Webhook node.
Use Case Highlights:
- Captures and auto-qualifies sales leads from web forms, chatbots, or marketing campaigns
- GPT-based enrichment for extracting structured data from free-text input
- Logs everything in real time to Google Sheets for easy CRM integration
- Can be extended to email responders, Slack alerts, or lead scoring
