Most small businesses I set up automations for (clinics, HVAC shops) have the same quiet leak. The website form works fine. It emails info@ or office@. And then nobody looks at that inbox until the next morning, or Monday. The lead isn't lost because the form broke. It's lost because a notification email is easy to ignore.
A typical example: someone fills in "AC not cooling, can someone come today?" at 4:50pm on a Friday. The email lands in a shared inbox, gets marked read on someone's phone without being acted on, and by the time anyone calls back on Monday they've booked another company.
Here's the setup I use to close that gap. It's two Zaps and one Zapier Table.
Zap 1: capture and alert
1. Trigger: new form submission (whatever the site uses, or Webhooks by Zapier).
2. Formatter: clean the phone number to digits only so it's easy to tap and to look up later.
3. Zapier Tables: create a record with name, phone, message, time received, and a Status field set to "New".
4. SMS by Zapier to the person on duty: "New lead: Jane, 555..., AC not cooling. Mark it handled in the table when you've called." (SMS by Zapier only sends to numbers you've verified, which is fine here because it's internal.)
Zap 2: escalate if nobody picked it up
1. Trigger: new record in that same table.
2. Delay For: 15 minutes.
3. Zapier Tables: find the record again (fresh lookup, so you get the current Status, not the one from 15 minutes ago).
4. Filter: only continue if Status is still "New".
5. Send the backup alert to the owner or second person, saying how long it's been waiting.
The part that made it actually work: marking a lead "Handled" has to take one tap. If the office has to open a laptop and edit a spreadsheet, they won't, and the owner gets escalations for leads that were already called. I added a button field in the table that flips Status to "Handled" so it can be done from a phone in a couple of seconds.
After hours I added a Paths step in Zap 2: during business hours escalate after 15 minutes; outside business hours skip the escalation and put the lead at the top of a "call first thing" list instead, so nobody gets woken at 2am for a quote request.
What changed: leads stopped sitting overnight unseen, and the owner can see in the table exactly how long each one waited before someone called.
Open question for anyone who's done something similar: how do you handle the "marked handled but never actually called" problem? I've thought about a second check that looks for a call log entry, but most small offices don't have a phone system that Zapier can see. Curious what others do.
