A zero-cost, end-to-end automation system built in one day to handle lead capture, instant acknowledgement, daily follow-ups, and basic lead classification.
This project was built as a personal learning and demonstration project to understand how real-world automation systems are designed, implemented, and made reliable from scratch.
Most small teams and founders lose leads due to delayed responses and inconsistent follow-ups.
This project solves that problem by creating a simple, reliable automation pipeline that:
- Captures incoming leads
- Sends instant acknowledgement emails
- Automatically follows up after a defined time
- Tracks lead state to avoid duplicates
- Maintains a clear, auditable record of activity
No paid tools were used.
- Form-based lead capture
- Automatic thank-you email on submission
- Time-based follow-up email automation
- Lead status tracking (
New,Followed-Up) - Safety checks to prevent duplicate emails
- Manual AI-assisted lead classification (learning-focused)
- Built to be reusable and client-ready
- User submits a form
- Lead is stored in Google Sheets
- Auto-reply email is sent instantly
- Lead is marked as
New - After 24 hours:
- Follow-up email is sent
- Status is updated to
Followed-Up - Processed flag is set to prevent re-sending
- Google Forms (lead capture)
- Google Sheets (lead tracking / CRM)
- Google Apps Script (automation logic)
- Gmail (email delivery)
- ChatGPT (manual lead classification for learning)
This project intentionally keeps the structure minimal:
- All automation logic is contained in Google Apps Script
- Google Sheet acts as the central data store
- Triggers control when automation runs
The system includes multiple safeguards:
- Header-based column access (safe against column reordering)
Processedflag to ensure idempotency- Null and empty-value checks
- Safe execution even if scripts are run manually
These patterns mirror real production automation systems.
This is not a client delivery.
This project was created to:
- Learn automation fundamentals deeply
- Understand event-driven systems
- Practice building reliable workflows
- Prove end-to-end delivery capability
- Build confidence before working with real clients
- Not a no-code tool demo
- Not a tutorial copy
- Not dependent on paid automation platforms
- Not over-engineered
- Fully automate lead classification using OpenAI API
- Add WhatsApp-based follow-ups
- Extend to multiple lead sources
- Add monitoring and alerting
Built by Pranauv Shrinaath (QuantumBay)
As a one-day deep-dive into real-world automation systems.