From capturing lost leads via missed-call follow-ups to creating a CRM inside Google Sheets that dynamically pulls Stripe billing data, this episode is a blueprint for automating a small business into a revenue machine. Spencer’s unique combo of blue-collar grit and no-code systems thinking is a masterclass for indie hackers, SaaS founders, and operators alike.
(
0:00) - Why Zapier replaced customer support
(
0:20) - The #1 thing your funnel must capture: email
(
0:45) - Intro to Spencer Scott & Lone Star Trash
(
1:11) - From Facebook post to $15K in 10 days
(
2:05) - Operating a trash business: bins, trucks, margins
(
3:05) - Adding automations early: RingCentral & Zapier
(
4:00) - Choosing the right phone system via Zapier compatibility
(
5:15) - How one missed-call text flow drove $50K in revenue
(
6:40) - Anatomy of the missed-call Zap
(
7:30) - SMS follow-up converts elderly callers into paid customers
(
8:15) - Why they use incognito mode for manual signups
(
9:00) - Building a signup flow with ChatGPT
(
10:40) - Why capturing email first is the golden rule
(
11:35) - The full funnel: email → address → bins → merch → notes
(
12:45) - Stripe Checkout + custom thank you page
(
13:20) - Referral engine: 60% of growth from viral shares
(
14:10) - Their CRM: a real-time, Stripe-powered Google Sheet
(
15:00) - How Apps Script flags active vs. inactive customers
(
16:00) - Auto-routing & GPS tagging for trash pickups
(
17:00) - The follow-up flow for abandoned signups
(
18:20) - Personalized subject lines = sky-high email open rates
(
19:00) - No dev background? No problem: Spencer's no-code mindset
(
20:00) - Why Google Sheets is better than most CRMs for small biz
(
21:00) - Spencer’s software stack: Zapier, ChatGPT, IGPT, Cursor (
22:00) - $50K ARR from one missed-call Zap