Airtable Is Not a Spreadsheet
This is where almost every Airtable conversation starts, because almost everyone who has not used it properly assumes it is one. It looks like a spreadsheet. The rows and columns are familiar. So people use it like a spreadsheet, and they miss most of what it can actually do.
For people who understand software architecture: Airtable is three layers in one tool. A relational database layer, where you define entities, relationships, and data types with proper normalisation. An application layer, where automations process data, trigger actions, and run logic. A user interface layer, where you build views and interfaces that show the right data to the right people in the right format.
"Airtable is three layers in one tool. A relational database layer... An application layer... A user interface layer."
That combination, database plus application plus interface, usually requires three separate systems. Airtable puts them together in one platform, which collapses both development time and cost for internal business applications significantly.
For a B2B business, Airtable can run your entire operations. CRM, project management, client onboarding, task management, invoicing, performance tracking, all connected, all in one place. Building that well requires real expertise though. You need a solid grasp of database design principles to structure Airtable correctly from the start. That is not a barrier to say do not use it. It is a reason why having someone with database experience build it for you produces a fundamentally better outcome than figuring it out yourself.
"That combination usually requires three separate systems. Airtable puts them together in one platform, which collapses both development time and cost for internal business applications significantly."
If you're evaluating whether you need this kind of expertise, our guide on what an AI automation consultant actually does is a good place to start.
The Mistake Most Businesses Make
Using Airtable as a spreadsheet.
This sounds obvious given what we just said, but it happens constantly. The tell: team members are directly editing rows in the base view. No forms. No interfaces. No automations. Everyone has access to the raw database and makes changes there directly.
You would not expose a raw SQL database to your employees or customers. You would build an interface that lets them interact with the data safely. Airtable is no different. The base view is for the person who designed the system. End users should interact through forms and interfaces that validate inputs, enforce logic, and present data cleanly.
"You would not expose a raw SQL database to your employees or customers. You would build an interface that lets them interact with the data safely. Airtable is no different."
When you use Airtable like a spreadsheet, you also tend not to design the data model properly. Tables proliferate without relationships. Data gets duplicated across multiple records instead of being linked. The base grows into something that cannot be cleanly automated or extended later.
Getting Airtable right from the start means understanding how to normalise tables, define relationships between them, and separate the concerns of data storage, data processing, and data presentation. That is where PhotonMan comes in. We have built production Airtable systems for businesses across industries, and the database design work that underpins those systems is what makes them maintainable and extensible over time.
What Airtable Can Actually Replace
We have built full enterprise resource planning systems on Airtable for businesses that would otherwise have purchased expensive SaaS products or commissioned custom software.
For a design and branding agency: the complete project management system, employee performance management, client delivery tracking, task creation and closure, all running on Airtable. One tool replaced several disconnected systems.
For a financial services firm: the complete client lifecycle from onboarding through ongoing service delivery. Automatic task creation when a new client was onboarded. Automatic task closure with audit trails. NPS survey collection and follow-up. Renewal reminders triggered at the right time. All handled by Airtable automations, no external tools required. If you want to see exactly how a workflow like this is designed end-to-end, read our detailed breakdown of how to automate client onboarding.
PhotonMan itself runs entirely on Airtable. Client management, project tracking, content pipeline, invoicing workflow, team task management. Single source of truth, everything connected. We use Airtable's native automations alongside custom Lambda functions via the Airtable API. We do not use Zapier or n8n for our own operations because Airtable's native integrations cover 80 to 90 percent of what we need, and AWS Lambda handles the rest.
The reason we keep the stack tight: every tool you add is another point of failure, another subscription to manage, another system to debug when something breaks. Fewer tools, built deeper, is almost always the right answer.
"Every tool you add is another point of failure, another subscription to manage, another system to debug when something breaks. Fewer tools, built deeper, is almost always the right answer."
How Airtable Fits Into a Larger Automation Stack
Airtable integrates natively with hundreds of tools. For most B2B businesses, those native integrations cover the majority of automation needs. Gmail, Google Calendar, Slack, and most common SaaS tools connect directly.
When you need more complex integrations, Airtable's API is clean and well-documented. You can connect Zapier, n8n, or Make for more complex orchestration. Or, as we do at PhotonMan, write custom Lambda functions that interact with Airtable via API, giving you precise control over logic and cost without adding another automation platform.
Airtable has also added native AI integration. You can build automations that include an AI reasoning step using Claude or GPT directly within Airtable, without separate API setup. For lighter AI use cases, classifying incoming data, generating summaries, drafting responses, this is powerful and cost-effective.
For a B2B business, Airtable can genuinely be the one platform that runs everything. Our AI automation consulting services are built around helping businesses design and deploy exactly this kind of consolidated stack.
When Airtable Is Not the Right Choice
Two main situations.
First: B2C businesses with large user bases. Airtable has rate limits on API calls and record counts depending on your plan. For a B2B business with hundreds of clients, you will never hit those limits. For a B2C application with tens of thousands of users, you will. Airtable is not a production database for consumer applications. Use a proper database for that.
"Airtable is not a production database for consumer applications."
Second: regulatory requirements around data geography. Airtable is US-based infrastructure. If you operate in a jurisdiction that requires data to be stored in a specific geographic region, Airtable may not meet your compliance requirements. Verify against your specific obligations before committing.
If you're still figuring out which tools are right for your business, our small business AI automation guide walks through how to think about the decision.
