Lesson 3. Airtable: Database with Superpowers

Lesson 3. Airtable: Database with Superpowers#

Goal: understand when to switch to Airtable and how to use it for agents.

What Is Airtable#

Airtable is a hybrid of a spreadsheet and a database. It looks like Google Sheets but works like a real database with:

• links between tables (one customer → many orders)
• different views (table, calendar, kanban, gallery)
• input forms (customers fill a form → data goes into the base)
• automations (when status changes → send email)

When to Switch to Airtable#

Switch to Airtable when:

• you have a complex structure (customers → orders → products)
• you need links between tables (one customer can have many orders)
• you need different views (list, calendar, kanban)
• you need input forms (customers fill a form, data goes into the base)
• you need in-base automations (when status changes → send notification)

Example Airtable Structure#

Table 1: Customers

Table 2: Orders

What links give you:

• in "Customers" you can click "Orders" and see all orders for that customer
• in "Orders" you can click "Customer" and see full customer info
• when you change a customer's name — it updates in all linked orders

How to Connect Airtable to an Agent#

Step 1. Create a base

• go to airtable.com
• create a new base
• create tables and fields
• set up links between tables (field type "Link to another record")

Step 2. Get an API key

• go to account settings → API
• create a Personal Access Token (PAT)
• copy the token (you'll need it for the connection)

Step 3. Connect via integration

• in Zapier / Make / n8n select the "Airtable" module
• enter the API key
• choose base and table
• configure action: "Read records," "Create record," "Update record"

Step 4. Test

• run a test
• confirm data is read and written correctly
• verify links between tables work

Airtable Views#

Airtable lets you create different views of the same data:

• Grid (table) — classic view
• Calendar — when you have a date field
• Kanban — when you have a status field (columns = statuses)
• Gallery — when you have images
• Form — for customer input

Example: the agent writes meetings to Airtable → you view them in the Calendar view.

Airtable Free Tier Limits (2026)#

• up to 1,200 records per base
• up to 2 GB file storage
• up to 1,000 API requests per month
• up to 50 automations per month

Enough for small projects. For larger ones — paid plan (from $20/month per user).

Practical Example: Freelancer CRM#

Task: a freelancer manages clients and projects in Airtable; the agent helps qualify leads and schedule meetings.

Structure:

• "Customers" table: name, email, phone, status (lead / customer / inactive)
• "Projects" table: name, customer (link), status, deadline, amount
• "Meetings" table: customer (link), date, topic, status (scheduled / completed / cancelled)

Agent logic:

1. Lead writes to Telegram bot → agent asks questions (name, email, task)
2. Agent creates a record in "Customers" with status "lead"
3. If lead is interested → agent offers a meeting
4. Lead picks a date → agent creates a record in "Meetings"
5. Freelancer sees the new meeting in Airtable's calendar view

Tools: Zapier (for chatbot) + Airtable (for CRM) + integration via API or Zapier.

---