Airtable - the practical guide.

Airtable fundamentally organises data into “bases”, which are collections of tables. Each table works like a spreadsheet, but with richer field types such as attachments, checkboxes, dropdowns, and even linked records. This linking capability is crucial – it allows you to create relational databases without writing a single line of code. For example, a marketing team might have one table for campaigns, another for content assets, and then link them together to see which assets belong to which campaigns, and their respective statuses.

Day-to-day, marketing teams use Airtable for everything from editorial calendars and content planning to campaign tracking and lead management. You can create custom views like Kanban boards for visual project management, gallery views for asset libraries, or calendar views for deadlines. Its automation features, called Automations, let you set up triggers and actions – for instance, automatically assigning a task when a record status changes, or sending an email notification when a deadline is approaching. These automations remove manual busywork and streamline repetitive processes.

Airtable sits as a central hub for operational data, often integrating with other tools via its API or built-in connectors. It can pull data from forms, push updates to Slack, or connect with email marketing platforms. It's not a CRM like Salesforce, nor a dedicated project management suite like Asana, but rather a flexible layer that can mimic aspects of both. Its strength lies in its adaptability, allowing teams to build bespoke solutions tailored precisely to their unique workflows, without needing developer support for every tweak.

Airtable is perfect for small to medium-sized marketing teams, creative agencies, and operations teams within larger organisations who need a flexible solution to manage diverse data and workflows. It particularly shines for those who have outgrown basic spreadsheets but find traditional database systems too complex or rigid. Common jobs-to-be-done include managing content pipelines, tracking influencer collaborations, organising event logistics, or building custom CRMs for niche sales processes. It’s also often adopted by individual marketers or project managers looking to bring order to their own varied tasks.

Airtable offers four main pricing tiers: Free, Team, Business, and Enterprise. The Free plan is quite generous, offering unlimited bases, 1,200 records per base, and 2GB of attachments. The Team plan starts at $20 per user per month (billed annually at $240) and boosts limits to 50,000 records, 10GB attachments, and more automation runs. Business, at $45 per user per month (billed annually at $540), scales further with more records, attachments, and advanced features like SAML SSO. Enterprise pricing is custom, driven by features like dedicated account management and advanced security. The bill primarily scales with the number of users and the data storage/automation usage.

Airtable is the right choice when you need a highly customisable system to manage structured data and workflows, especially if your data isn't easily categorised into off-the-shelf software. It's excellent for creating bespoke solutions for niche marketing operations, such as managing a complex influencer programme or tracking a multi-channel content strategy with many moving parts. It's not a good fit if you just need a simple task list - Trello or Asana would be overkill for that. Nor is it suited for heavy-duty analytics or complex financial modelling; for that, stick with Excel or specialised BI tools like Tableau. If you need robust CRM functionalities straight out of the box, Salesforce or HubSpot are better choices.

While flexible, Airtable can become unwieldy if not properly structured from the start. Over-reliance on linked records without clear relationships can lead to a "spaghetti database". The cost can also add up quickly, especially for larger teams who exceed the generous but finite record and automation limits on the lower tiers. While automations are powerful, they can be tricky to debug. Finally, report building and advanced analytics are not Airtable's strong suit; you’ll likely need to export data to other tools for deeper insights.