Airtable

What it is

Airtable is what a spreadsheet becomes when the cells have types. A field can be a date, a person, an attachment, a link to a record in another table, and because the structure is real, the same data can be shown as a grid, a calendar, a kanban or a gallery without duplicating it.

On top of that sit interfaces, which turn a base into something a colleague can use without seeing the underlying tables, automations that run when a record changes, and an AI layer with app building and agents. Integrations include Slack, Google Drive, Salesforce, Jira and Zendesk, with more through the marketplace.

Who it's for (and who it isn't)

It fits teams whose shared spreadsheet has become load-bearing: a content calendar, an inventory list, an applicant tracker, a client roster. The moment several people edit it and one accidental sort ruins a week, you have outgrown a spreadsheet and Airtable is the natural next step.

It is a weaker fit for documents and knowledge, where Notion is stronger because it starts from the page rather than the table. It is also not a replacement for a real application when you need proper user accounts, permissions per customer and a public interface: at that point you are building software, and a no-code database is scaffolding rather than a foundation.

Pricing

Airtable is freemium. A free plan is available, aimed at individuals, very small teams and light needs. Team is $20 per user per month billed annually, and Business is $45 per user per month billed annually. Enterprise Scale is quoted on request. The pricing page does not state monthly rates or the exact free plan limits, so check the current limits in their billing documentation before you plan around them.

The variable that decides your bill is seats, and the trap is that collaborators who only need to read still count in most setups. Decide who needs to edit before you invite the department.

Set it up

Official guide: Importing third-party data into Airtable

1. Create an Airtable account on the Free plan, in a web browser. Import does not work in the mobile app. Have the spreadsheet you rely on ready, as a Google Sheet, an Excel file or a CSV file (a plain spreadsheet file). You now see your Airtable home screen.
2. Create a new base, which is one project folder that holds your tables. Click "+ Add or import" and choose "Microsoft Excel" or "CSV file", then click "Upload file". For a Google Sheet, choose "Google Sheets" and connect your Google account when asked. Keep "Auto-select field types" and "Use the first row as headers" switched on, then click "Import". You now see your spreadsheet as a table.
3. Check the field types. A field is a column, and its type is the kind of data it holds. Click the dropdown arrow next to a column name, click "Edit field", choose a type such as "Date" for dates or "Single select" for a status you pick from a list, and click "Save". The column now has the new type, so check that its values still look right.
4. Make a view for one job, such as "my tasks this week". A view is a saved way to look at the same table. Click "+ Create new…" in the left sidebar (open it with the three horizontal bars icon). Pick the grid type, name the view, choose "Collaborative", click "Create new view" and add a filter for the rows you want. The view now lists only those rows.
5. Set up the message you now send by hand. An automation is a rule that runs by itself. Open the base, click "Automations", then "Create new …" and "Create automation". Click "+ Add trigger" (the event that starts the rule) and choose "When a record is created". Pick your table and click "Use suggested record". You now see the values of a test row.
6. Click "+ Add advanced logic or action", choose "Send an email", and fill in the recipient, subject and message. On the Free plan the email can only go to collaborators on the base. Test the step, then switch the toggle next to the automation name from OFF to ON. Existing rows do not trigger it, only new ones. The toggle now shows green ON.

When this works, adding a new row to your table sends your email by itself, and your view shows only the rows you picked.

Strengths and limitations

The strength is the distance between a spreadsheet and a working internal tool. Non-technical people can build something genuinely useful in an afternoon, and interfaces mean the rest of the team gets a clean surface rather than a grid.

The limitations are cost and ceiling. Per-seat pricing at $20 and $45 per user per month adds up quickly for a team, and the free plan's exact limits are not published on the pricing page, which makes planning harder than it should be. Complex bases become hard to maintain, and performance drops as records grow. See Notion vs Airtable if you are choosing between the two.