How to use AI in Airtable: automate your database, generate records, and build dashboards without coding

1. Go to https://airtable.com and create a free account.
2. In the main panel, click “Add a base”.
3. You can start from a template or from scratch. For this guide, pick “Start from scratch”.
4. Give your base a name (for example, “Clients” or “Content Projects”).

A base in Airtable is like an Excel file, but with superpowers: it can have multiple sheets (tables), different field types, and built-in automations.

Each row is a record. Each column is a field. Fields can be text, numbers, dates, dropdown lists, attachments, and more.

Before asking AI for help, you need a table with data. Let’s create a sample table: Potential Clients (it can be anything: inventory, tasks, content).

1. Airtable already creates an empty table. Click the column name (field) to rename it.
2. Create these fields:
   • Name (type: Single line text)
   • Company (type: Single line text)
   • Industry (type: Single select): add options like “Marketing”, “Technology”, “Health”, “Education”
   • Notes (type: Long text): for a summary of the first conversation
   • Priority (type: Single select): “High”, “Medium”, “Low”
3. Add a few example records (5 to 10 rows with real or made-up data). You need data for AI to work with.

Tip: the “Name” field is always first and is what Airtable uses as the record identifier.

AI fields are special columns that auto-generate their content using artificial intelligence. Here’s how to enable them:

1. Click the ”+” button at the end of your columns to add a new field.
2. In the field type menu, look for the “AI” section or type “AI” in the search box. You’ll see options like:
   • AI text: generates free text based on other fields.
   • AI classification: classifies the record into one of the categories you define.
   • AI summary: summarizes the content of a long field.
3. Choose AI text and name it “Auto summary”.
4. In the “Prompt” field, write something like:

   Based on the company "{Company}", the industry "{Industry}", and the notes "{Notes}", write a 2-sentence summary about this potential client and why they might be interested in our services.

   (Fields in curly braces {} are replaced with the actual value from each record.)
5. Save the field. Airtable asks if you want to generate values for all existing records. Accept.

In seconds, every row will have its own AI-generated summary. You just saved yourself hours of manual work.

Let’s say you want AI to automatically decide whether a client is “High”, “Medium”, or “Low” priority based on their notes:

1. Add another field of type AI classification.
2. In “Categories”, type your options: High, Medium, Low.
3. In the prompt, write:

   Based on the notes "{Notes}" and industry "{Industry}", classify this client as High priority (ready to buy soon), Medium priority (interested but no urgency), or Low priority (just exploring).

4. Save and generate values.

Airtable will use AI to assign a category to each record. You can use this to:

• Sort the table by priority automatically.
• Filter to see only “High” priority clients.
• Trigger an automation when a client becomes “High”.

This same system works for classifying support tickets, rating content by tone, categorizing products, or detecting sentiment in survey responses.

A dashboard in Airtable is a special view called “Dashboard” that groups charts, counts, and summaries from your base:

1. In the left sidebar, click ”+ Add a view” (or the grid symbol).
2. Choose “Dashboard” (may be called “Summary” in some versions).
3. Click “Add a widget” to add blocks:
   • Summary: shows a count, sum, average, or max of a numeric field.
   • Bar chart / Pie chart: charts records grouped by a field (for example, how many clients per industry).
   • Record list: a filtered list of records based on criteria.
4. Add a bar chart to see the distribution by “Priority” or “Industry”.
5. Add a Summary block that counts total “High” priority records.

The dashboard updates itself every time you change the data. No need to export to Excel or do manual calculations.

For a more advanced dashboard connected to multiple data sources, see the tutorial How to create a business metrics dashboard with AI.

Airtable’s automations let things happen without you doing anything: send an email when a field changes, create a record in another table, notify Slack, and more.

To create a simple automation:

1. In the sidebar, click “Automations” (the lightning icon).
2. Click ”+ Create automation”.
3. Define the trigger: for example, “When a record enters a view” (when a record enters a specific view, like a “High priority” filter).
4. Define the action: “Send email” to notify yourself, or “Create record” to log it in another table.
5. You can add an AI step inside the automation: select “Generate with AI” as the action type, write the prompt, and use the result in the next step (for example, to auto-generate the email body).
6. Activate the automation with the toggle in the top-right corner.

To connect Airtable with other apps like Gmail, Slack, Notion, or Google Calendar, use Make or Zapier. The tutorial How to automate tasks with Make and AI explains how to connect everything without code.

Problem	Fix
I don’t see the “AI” option when adding a field	Make sure you’re on a plan that includes AI. The Free plan only has 500 credits, but they do exist.
It says AI credits are used up	Credits reset monthly. In the meantime, limit generations to the most important records.
AI generates incorrect text	Refine the prompt to be more specific. Include instructions about tone and expected length.
The automation doesn’t trigger	Check that it’s enabled (green toggle) and that the trigger matches a real event in your table.