Sample setup: Missed-Lead Rescue for Bright Paws Grooming
A sample Missed-Lead Rescue setup for a made-up pet groomer: the workflow map, five test inquiries with expected results, a draft reply and the one-page handover guide.
Sample deliverable. Bright Paws Grooming and every inquiry below are fictional test data. Build your demo on your own free accounts and test form, never on a real business's.
The workflow
- Trigger: a new entry in the website contact form (Google Forms in the demo).
- Log it: add a row to the "Inquiries" Google Sheet with name, pet, service, preferred date, message and the time it arrived.
- Draft the reply: create a Gmail draft (not a sent email) using the reply template, addressed to the customer.
- Tell the owner: send the owner a one-line notification: "New inquiry from Sam (cockapoo, full groom). Draft reply is waiting."
- 24-hour nudge: if the "Replied?" column is still empty after 24 hours, send the owner a reminder.
Nothing is ever sent to a customer automatically. The owner opens the draft, edits if needed, and presses Send.
Five test inquiries (test data)
| # | Name | Pet | Service | Message | Expected result |
|---|---|---|---|---|---|
| 1 | Sam Test | Cockapoo | Full groom | "Any Saturday slots?" | Row added, draft created, owner notified |
| 2 | Priya Test | Two cats | Nail trim | "Do you do cats?" | Row added; draft uses the plural "your pets" |
| 3 | (blank name) | Labrador | Bath | "Price?" | Row added; draft opens "Hi there" |
| 4 | Lee Test | Poodle | Full groom | 900-character message | Row added; message not cut off in the sheet |
| 5 | Ana Test | Husky | De-shed | Submitted, then left unanswered | 24-hour reminder reaches the owner |
Draft reply template
Hi {{name or "there"}},
Thanks for getting in touch about {{pet}}! I'd love to help with a {{service}}. My next openings are {{owner fills in}}. Reply with the one that suits you and I'll pencil it in.
Jo, Bright Paws Grooming
One-page handover guide (what the owner keeps)
- Where inquiries go: the "Inquiries" sheet in your Google Drive. One row per inquiry.
- What you do: open Gmail Drafts, check the reply, add your available times, press Send, then type "yes" in the sheet's "Replied?" column.
- Reminders: if "Replied?" is empty after 24 hours, you'll get one reminder email.
- Turn it off: in your automation account, switch the workflow to Off. Nothing else changes.
- Who owns it: you. Every account is yours; your setup provider never had your password.
- Help: 30 days of fixes included. After that, optional upkeep.