Bill of Materials — Tech Stack
Automation
Google Apps Script (JavaScript)
Gmail — email parsing & sending
Google Sheets — data layer & config
Google Drive — PDF archiving
Edge & APIs
Cloudflare Workers (JavaScript)
NHTSA VIN Decoder API (REST)
Transport Canada Vehicle API (REST)
Twilio — SMS & voice (REST API)
TwiML — voice response XML
Booking & Payments
Square Appointments — calendar & webhooks
Square Payments — transaction processing
Parts Lookup
Playwright (Node.js) — browser automation
Parts database — authenticated session
Automation Impact — Man-Hours Saved
Quote email (per lead)~8 min
Manual: draft + send. Automated: <2 min, zero input.
ADAS classification (per job)~15 min
Manual: VIN lookup + spec check + parts DB. Automated: <30 s.
Follow-up sequence (per lead)~10 min
Manual: remember + draft + send ×2. Automated: zero.
Missed-call SMS~5 min
Manual: notice, retrieve number, text. Automated: 12 s.
Post-service email + PDF~20 min
Manual: generate warranty, attach, send receipt. Automated: trigger.
Booking note parsing~5 min
Manual: re-enter free-text into sheet columns. Automated: structured.
Est. per job (avg 2 leads/booking)~63 min saved
At 20 jobs/month~21 hrs/month
Leads Captured — Automation Effect
Avg response time (manual)4–24 hrs
Avg response time (automated)<2 min
Quote email sent before the customer checks another provider.
Follow-up contact rate (manual)~30%
Follow-up contact rate (automated)100%
Day 2 + Day 4 touchpoints fire on every unconverted quote.
Missed calls recovered~85%
Auto-SMS within 12 s captures callers before they move on.
Est. additional conversions+2–4/month
From faster response + systematic follow-up on previously lost leads.