All Projects
Operations

Airtable Operations Hub for Dog Grooming

Centralized operations platform managing appointments, client records, and inventory for a dog grooming business.

Scheduling accuracy

Zero double-books

Tools
Airtablen8nGoogle CalendarSMS API

The Client's Problem

My Approach

The Workflow Breakdown

1

Linked Airtable tables: Clients, Pets (with temperament/photos), Appointments, Groomers, Invoices 2. Daily route view per groomer with address clustering for drive time optimization 3. Automated Twilio reminders 24 hours before each appointment with pet name and service 4. n8n integration pushing completed appointments to Square POS for invoicing 5. 6-week rebooking automation flagging overdue clients with personalized outreach text

Results & Impact

  • Replaced 4 disconnected tools with 1 Airtable hub
  • Safety incidents went from 1 bite ($4,100 claim) to zero since deployment
  • Admin time per week dropped from 12+ hours to under 2 hours
  • Rebooking outreach went from none (forgot clients) to automatic at 6 weeks
  • Revenue from rebooking: $3,400/month recovered
  • Revenue visibility went from unknown to dashboard by groomer and ZIP

Technical Highlights