Automated Lead Capture and Personalized Email Follow-Up System

Created an automated lead management workflow that captures inquiries, generates personalized responses, and notifies the team instantly.

Case Study

Objective

The client needed a faster way to manage new leads by removing manual data entry and automating personalized follow-up communication.

Process

I built an automation workflow using Make.com that connects Google Forms, Google Sheets, Google Gemini, Gmail, and Slack. New lead submissions are automatically captured, organized, processed by AI to generate a personalized email response, sent to the lead, and reported to the team through Slack notifications.

Outcome

The business gained a faster and more organized lead response process. New inquiries are handled automatically, follow-ups are sent without delays, and the team stays updated without manually checking submissions.

Standout Features

  • Automated lead capture from Google Forms

  • AI-generated personalized email responses using Google Gemini

  • Automatic email delivery through Gmail

  • Real-time team notifications through Slack

  • Eliminated manual lead data entry

  • Faster response time for new inquiries

  • Structured data handling between automation steps

  • End-to-end lead management workflow using Make.com

More Projects

© 2026 Pepito Aguelo

Designed in Figma

Build in Framer

Create a free website with Framer, the website builder loved by startups, designers and agencies.