🤖 AI-Powered Direct Lead Generation Agent | Google Sheets, OpenAI & GoHighLevel Automation

In this project, we developed an advanced AI-powered Direct Lead Generation Agent for Econosurance, designed to fully automate lead processing, enrichment, validation, and CRM integration.

This workflow intelligently collects leads from Google Sheets, enriches business information using AI, validates contact details through external APIs, and automatically uploads qualified leads into GoHighLevel.

🎥 Project Video:

🚀 Workflow Features

⏰ Automated Scheduling

• Runs automatically every day at 4 AM
• Fetches pending leads from Google Sheets

📊 Lead Processing & Filtering

• Retrieves leads with “Pending” status
• Removes duplicate leads using email matching
• Processes leads one by one using loop automation

🤖 AI-Powered Business Analysis

Using OpenAI GPT-4o-mini, the system:

• Analyzes company websites
• Extracts business activities
• Identifies commercial auto services
• Detects annual revenue
• Finds NAICS codes
• Generates structured enriched JSON data

📞 Lead Enrichment & Validation

• Email verification through external APIs
• Mobile number lookup and validation
• Contact enrichment and formatting
• JSON parsing using custom JavaScript logic

🔄 CRM Integration

• Automatically uploads validated leads into GoHighLevel
• Updates lead status dynamically

📋 Google Sheets Automation

• Updates processing status:
  • ✅ Done
  • ❌ Error
• Stores validation and enrichment results

⚡ Additional Features

• Conditional workflow handling
• Merge and data formatting nodes
• Wait timers for API safety
• REST API integrations
• Fully automated lead pipeline

🧰 Technologies Used

• OpenAI GPT-4o-mini
• Google Sheets API
• GoHighLevel CRM
• JavaScript
• HTTP APIs
• AI Workflow Automation
• REST APIs

🚀 Looking to build custom AI automation, lead generation systems, or CRM integrations?
📩 Contact us at https://encoderit.net