Most small service businesses I speak to are tracking leads in one of three ways. A spreadsheet that hasn’t been properly updated since March. A notes app on someone’s phone. Or, and this is the most common one, a vague mental list that lives entirely in the founder’s head and occasionally falls out at inconvenient moments.
None of these are systems. They’re coping mechanisms. And the problem with a coping mechanism is that it works just well enough to stop you from doing something better.
If you’ve been meaning to sort your lead tracking out but keep bouncing off expensive CRM tools that feel like they were built for a sales team of forty, this one’s for you. Because you can build something genuinely useful, using Airtable and Make.com, in an afternoon, without touching a line of code or paying a developer.
Start with the logic, not the tools
Before you open either platform, you need to be clear on what you’re actually trying to do. Not in a grand strategic sense. Just practically: what does a lead look like in your business, what needs to happen after one comes in, and where are they currently coming from?
For most small service businesses, the flow looks something like this. Someone fills in a contact form, sends you a DM, or drops you an email. You mean to follow up quickly. Life intervenes. Three days pass. You follow up late, or not at all, and the lead goes cold. You never really know how many leads you’ve had, how many converted, or where the good ones came from.
The system we’re building fixes that loop. It captures incoming leads, puts them somewhere organised, and triggers a follow-up reminder so nothing slips. That’s it. Not complicated. Just reliable.
Airtable as your lead database
Think of Airtable as a spreadsheet that’s been to university. It looks familiar but it behaves much more intelligently, and it’s far easier to build views and automations on top of.
Your first job is to create a base (Airtable’s word for a project workspace) with a table called something obvious, like Leads. The fields you want to start with are straightforward: name, email, phone if relevant, where the lead came from, the service they’re interested in, the date they came in, their current status (something like New, Contacted, Proposal Sent, Won, Lost), and a notes field for any context.
That’s your whole database. You’re not building Salesforce here. You’re building something you’ll actually use.
The status field is the one that does the heavy lifting. It turns a flat list of names into something you can see at a glance, filter, and act on. Switch to Airtable’s Kanban view and suddenly you’ve got a proper pipeline, with leads moving across columns as they progress. It takes about thirty seconds to set up and it genuinely changes how you see your own business.
Make.com as your automation layer
This is where the system stops being passive and starts doing things for you. Make.com is a no-code automation platform that connects your apps together and runs tasks automatically based on triggers you define. If Airtable is the filing cabinet, Make.com is the assistant who keeps it updated.
The first automation worth building is the one that catches incoming leads. If your contact form runs through something like Typeform, JotForm, or even a Google Form, Make.com can watch for new submissions and automatically create a new record in your Airtable base, pulling the name, email, and any other fields across without you doing anything.
The second automation is the follow-up reminder. You set a rule: if a lead has been sitting in the New status for more than 24 hours, send yourself an email or a Slack message flagging it. Simple, but it’s the thing that stops leads going cold while you’re buried in client work.
A third, slightly more advanced step, is sending a personalised acknowledgement email to the lead themselves the moment they come in. Not a cold autoresponder, but something warm and specific to your business, so they know their message landed and you’re on it. That alone changes how people perceive you before you’ve even had a conversation.
The bit most people skip
Here’s what separates a workflow automation that actually gets used from one that gets built and abandoned: you have to keep the human bits human.
Automation handles the capturing, the reminding, the logging. But the follow-up message you send? That should still sound like you. The decision about whether to chase a lead or let it go? Still yours. The system is there to make sure nothing falls through the floor, not to replace your judgement.
This is something we think about a lot at Avocado AI. The ethos we build everything around is AI-assisted automation with human checkpoints. The machine does the repetitive, time-sensitive stuff. You stay in control of the decisions that actually matter.
What you end up with
A simple lead tracking system built this way costs you almost nothing in tools (both Airtable and Make.com have free tiers that cover this comfortably) and perhaps a few hours of setup time on a quiet afternoon. In return you get a clear picture of every lead that comes into your business, a pipeline you can actually see, and a process that follows up for you even when you’re heads-down on a project.
It won’t replace a proper CRM if you’re managing hundreds of leads a month. But for most UK small businesses, this kind of lean, well-connected setup is more than enough. And more importantly, it’s the kind of thing you’ll actually maintain, because you built it around how you work rather than how a software company thinks you should work.
The best system is the one that runs quietly in the background and makes you look more on top of things than you probably feel.
