H & L Holiday Lighting
H & L Holiday Lighting designs and installs holiday lights for homes and businesses across Southern Illinois, with an all-inclusive service: installation, maintenance, takedown and storage.
Product context
Every inquiry should reach the owner, and stay organised.
A seasonal business lives on fast replies in a short window. The site had to sell the look, make asking for an estimate effortless, and put every request somewhere the owner can work from.
COET's contribution
Web design
A warm, photo-led site built around the company's own job photos, from the first glow to the estimate.
Lead workflow
The estimate form captures name, phone, timing, address and budget, plus the gallery photo a customer liked.
Spreadsheet integration
Each inquiry is written to the owner's private Google Sheet, with a link to the chosen photo.
Automated emails
A formatted notification email goes out for every new inquiry, with a fallback if the sheet isn't connected.
The site
Real homes, remarkable glow.
The company's own installations carry the story, and each one has a "Get this look" link straight into an estimate.
The estimate
Tell us about your home.
One short form. Timing and budget are choices, not essays, and the photo a customer picked travels with the request.
Behind the form
A sheet the owner already knows, and an email the moment it matters.
A Google Apps Script receives each inquiry, adds it to the owner's private sheet and sends the notification. The owner's admin link opens that sheet directly.
Key features
- 01
Get this look
Any gallery photo starts an estimate.
- 02
Estimate form
Contact, timing, address and budget.
- 03
Google Sheets
Every lead in the owner's private sheet.
- 04
Email alerts
A formatted email for each inquiry.
- 05
Fallback
Email delivery even without the sheet.
- 06
Owner admin
One link to the leads sheet.
