Background
A growing local marketing agency was receiving a steady flow of inquiries through its website. However, due to a small team and busy schedules, leads were often followed up late, sometimes after 24 hours or more. This delay resulted in missed opportunities and inconsistent client communication.
Challenge
The agency needed a reliable and efficient system that could:
- Instantly respond to new website inquiries
- Personalise replies based on form details
- Save all leads in a structured format for tracking
- Keep the owner updated daily without manual checking
Their goal was efficiency, they didn’t want a complex CRM or heavy software setup.
Our Solution
We designed and implemented a lightweight automation workflow that connects the agency’s website form directly to Google Sheets and Gmail.
Here’s how it works:
- Lead Capture: Every new website form submission automatically records in a Google Sheet for easy tracking and backup.
- Instant Personalised Reply: The lead instantly receives a customised, professional email from the agency’s Gmail, confirming receipt and sharing next steps or service details.
- Daily Owner Summary: At the end of each day, the business owner gets an automated email summarising all new inquiries, including names, emails, and service types.
No more manual data entry or delayed replies, the entire process runs 24/7 in real time.
Impact & Results
| Metric | Before | After |
|---|---|---|
| Average response time | 8–24 hours | Instant |
| Missed leads | Frequent | Zero |
| Lead management | Manual & inconsistent | Fully automated |
| Owner clarity | Needed to check inbox manually | Daily automated report |
Key Outcome:
✅ 3× faster response times
✅ Zero missed leads
✅ Stronger client impressions through instant communication
✅ Improved conversion rate without adding staff or CRM tools
The client now benefits from a professional, automated customer experience without needing extra staff or expensive software.
