To use Airtable to run a small business, move the lists you rebuild most often — enquiries, bookings, orders, volunteers — out of spreadsheets and inboxes and into one shared table. Collect new information through a form so it arrives already filed, give each person the view they need, and let automations handle the steps that happen every single time. For most small organisations, the free plan covers it.
This post explains what actually changes when your information lives in a database rather than a document, and how to make the first move without rebuilding everything you own.
Most small organisations keep information in documents, not data
Here is what running a small business usually looks like after a few years. Enquiries sit in an inbox. A spreadsheet holds the customer list, and a second version of it lives on someone's laptop. Bookings are in a calendar. Volunteer availability is in a WhatsApp thread. The details of what was agreed with a supplier are in a Word document, in a folder, named something that made sense at the time.
None of that is careless. Every one of those choices was sensible on the day it was made. The problem is what the collection becomes: information that can be read, but not counted, sorted, filtered or acted on. You can find last month's enquiries if you go looking. You cannot ask how many there were, which ones you never replied to, or which source they came from — not without an hour of manual work.
A good chunk of those hours is not the work itself. It is reassembling information you already had, because it was never stored in a form that could be used twice.
What changes when it's a table
A spreadsheet stores whatever you type into a cell. Airtable stores records with defined fields: a date is a date, a status is one of a fixed set of options, an owner is a person, a linked customer is a real link to a customer record. That sounds like a small distinction. It is the whole thing.
Because the structure is defined, four things become possible that were not possible before.
| What you get | What it replaces |
|---|---|
| Forms that feed the table directly — someone fills it in, the record appears complete and correctly formatted | Reading an email and retyping the details into a spreadsheet |
| Views — the same records shown as a list, calendar, or board, filtered per person | Separate spreadsheets and tabs for each person, drifting out of step |
| Automations — when a record changes, send the email, post the alert, create the follow-up | Remembering to do the same three steps every time, and occasionally not |
| Grouping and counting — how many, from where, how long they took, what's overdue | Counting rows by eye, or not measuring it at all |
Notice that none of these are features you turn on later. They all follow from the same thing: the information has a shape. That is why we usually start clients here rather than with an automation tool. Structure first, automation second — a tool pointed at a mess just gives you a faster mess.
What this looks like in practice
A Reading-based charity we worked with, All Yours Period Box, was processing requests by hand — around two days of someone's week spent reading emails, copying details, and sending confirmations. The fix was not clever. The requests went into an Airtable base, the request form fed it directly, and an automation sent the confirmation. The same work now takes about an hour a week.
The order mattered more than the tools. Nothing got automated until the information had somewhere to live — and once it did, setting up the automation took an afternoon.
What "free" actually covers, and where the wall is
Airtable's free plan is genuinely usable rather than a trial. At the time of writing it gives you:
- Unlimited bases, with up to 1,000 records in each
- 1GB of attachments per base
- 100 automation runs a month
- Up to 5 editors, with unlimited read-only collaborators and form submissions
Where people hit the wall, in order of likelihood: the 100 automation runs go first if you automate something high-volume; the 1,000 records go next, though it's per base, so splitting sensibly buys you a long time; and the 5-editor limit bites once more than a handful of people need to change things. The paid Team plan is $20 per editor per month billed annually — worth knowing, but most small organisations we work with are still comfortably inside the free tier a year in. If you're a registered charity, check Airtable's nonprofit pricing before you pay full price.
The honest caveats, since they matter more than the limits:
- Airtable is a US company and, on the free and Team plans, your data sits on US servers. That is fine under UK GDPR — Airtable offers a data processing agreement with standard contractual clauses, which is the normal legal mechanism for this — but it is worth knowing rather than discovering later. European data residency exists, but only on their top Enterprise tier. If keeping data in the UK or EU is a hard requirement for you, a self-hosted alternative like Baserow or NocoDB does the same job on your own terms.
- It is not accounting software, and it is not a replacement for a proper CRM if you genuinely need one.
- A badly designed base is worse than a spreadsheet, because more things now depend on it.
One further reason structure is worth the effort: AI tools can read a table and do something sensible with it. They cannot do much with the same information scattered across forty Word documents and an inbox. Whether or not AI is on your list this year, putting your information into rows and columns is the step that keeps that door open. We'll come back to that properly in a later post.
How to start without rebuilding everything
Do not migrate your business. Pick one list — the one you find yourself rebuilding most often — and move only that.
- Choose the list. Enquiries, bookings, orders, volunteers, grant deadlines. Whichever one currently lives half in a spreadsheet and half in your inbox.
- Write down the fields before you build anything. What do you actually need to know about each one? Ten fields is usually plenty. This is the step that decides whether the base is any good.
- Build the table and a form. An afternoon, no code. Send the form link out instead of asking people to email you.
- Use it for a fortnight before adding anything else. You will discover two fields you didn't need and one you did.
- Only then automate one step — the confirmation email, the reminder, the notification. One.
If after a fortnight it hasn't made your week easier, you have lost an afternoon and learned something specific about your process. That's a reasonable trade.
Do you need help with this?
Often not. Airtable is free, the interface is friendly, and there are a lot of good tutorials. If you have a clear head for how your process works, you can build the first version yourself in a day.
Where people get stuck is not the software. It is deciding what the fields should be, which steps the process actually needs, and which of the things you currently do can simply stop. That mapping is the job NorthGate Collective does with small businesses, charities and community organisations around Reading and Berkshire — and if a free tool and an afternoon is all you need, we'll say so.
Common questions
Is Airtable free for small businesses in the UK?
Yes. The free plan covers unlimited bases with up to 1,000 records each, 1GB of attachments per base, 100 automation runs a month and up to 5 editors — enough to run a real system without paying. Registered charities should check Airtable's nonprofit pricing.
What's the difference between Airtable and a spreadsheet?
A spreadsheet stores whatever you type. Airtable stores records with defined field types, which is what makes forms, filtered views, automations and reliable counting possible.
What should I use Airtable for first?
The list you rebuild most often — usually enquiries, bookings, orders or volunteers. Move one, use it for a fortnight, then add a second.
Do I need to be technical to set it up?
No. Building a table and a form takes an afternoon and no code. Deciding what the fields should be is the harder part, and it isn't a technical problem.
Not sure which list to move first?
Book a free 30-minute call and we'll talk through where your information actually lives and whether this would help. No obligation, no sales pitch.
Book a free call