Airtable

Sync your Airtable tables into AI SmartTalk's knowledge base. Turn your structured data into AI-queryable knowledge—perfect for product catalogs, FAQs, team directories, and more.

---

Overview

The Airtable integration enables you to:

• Connect your Airtable base via API key
• Sync table data as knowledge base entries
• Query your data conversationally through the AI
• Keep data fresh with manual or scheduled syncs

---

Prerequisites

Before you begin, ensure you have:

• An active AI SmartTalk account
• An Airtable account with at least one base
• An Airtable API key (Personal Access Token)

---

Step-by-Step Setup

Step 1: Generate Your Airtable API Key

1. Log into your Airtable account
2. Go to Account Settings → Developer hub
3. Click Create new token
4. Configure your token:
   • Name: AI SmartTalk Integration
   • Scopes: Select data.records:read and schema.bases:read
   • Access: Choose the specific bases you want to connect
5. Click Create token and copy it immediately

Important: Save your token securely—Airtable only shows it once!

Step 2: Connect to AI SmartTalk

1. Log into your AI SmartTalk account
2. Navigate to Settings → Integrations
3. Find Airtable and click Connect
4. Paste your API key in the Personal Access Token field
5. Click Validate

Step 3: Select Tables to Sync

After validation, you'll see your available bases and tables:

1. Browse bases: Click to expand each base
2. Select tables: Check the tables you want to sync
3. Configure fields: Choose which columns to include
4. Click Start Sync

Step 4: Verify the Import

1. Go to Knowledge in AI SmartTalk
2. Your Airtable records appear as individual knowledge entries
3. Test your AI by asking questions about your data

---

What Gets Synced

Data Type	How It's Processed
Text fields	Synced as searchable content
Number fields	Included in record context
Select/Multi-select	Treated as categories/tags
Linked records	References included
Attachments	URLs referenced (files not downloaded)
Formulas	Computed values synced

Example: Product Catalog

If you have a "Products" table:

Name	Description	Price	Category
Widget Pro	Professional-grade widget...	$99	Tools
Widget Lite	Entry-level widget...	$49	Tools

Your AI can answer:

• "What products do you have?"
• "Tell me about Widget Pro"
• "What's your cheapest tool?"

---

Sync Configuration

Field Selection

For each table, you can configure:

• Primary field: Main identifier for each record
• Content fields: Fields to include in knowledge base
• Exclude fields: Internal fields to skip (IDs, timestamps, etc.)

Sync Frequency

Option	Description
Manual	Click "Sync Now" when needed
On import	Syncs when you trigger an import
Scheduled	Set up via SmartFlow (see below)

Scheduling with SmartFlow

To automatically sync your Airtable data:

1. Create a new SmartFlow
2. Add a Scheduled trigger (daily, weekly, etc.)
3. Add the Sync action → Select Airtable
4. Save and activate the workflow

---

Use Cases

Product/Service Catalog

Sync your product database so customers can ask:

• "What products do you have under $100?"
• "Compare Widget Pro and Widget Lite"
• "Do you have anything in the Tools category?"

FAQ / Knowledge Base

Store FAQs in Airtable with Question/Answer columns:

• "How do I reset my password?"
• "What's your refund policy?"
• "Where can I find my invoice?"

Team Directory

Sync team member data for internal queries:

• "Who handles customer support?"
• "What's Sarah's role?"
• "List everyone in the Engineering team"

Event/Schedule Data

Sync event tables for scheduling queries:

• "What events are coming up?"
• "When is the next webinar?"
• "What happened at last month's meetup?"

---

Troubleshooting

Connection Issues

Issue	Solution
"Invalid API key"	Regenerate token in Airtable Developer hub
"Base not found"	Ensure token has access to that base
"Permission denied"	Add data.records:read scope to your token

Sync Issues

Issue	Solution
Missing records	Check that records aren't filtered/hidden in view
Stale data	Click Sync Now to refresh
Wrong fields syncing	Review field selection in integration settings

AI Can't Find Data

Issue	Solution
No results for queries	Wait for sync to complete and AI to process
Partial answers	Ensure all relevant fields are included in sync

---

Managing the Connection

Action	How
Update API key	Settings → Integrations → Airtable → Update Token
Add tables	Edit connection → Select additional tables
Remove tables	Uncheck tables you no longer want synced
Disconnect	Settings → Integrations → Airtable → Disconnect

---

Best Practices

1. Structure for AI: Use clear, descriptive field names
2. Deduplicate data: Remove duplicate records before syncing
3. Use primary fields wisely: Choose unique, descriptive identifiers
4. Regular syncs: Keep data fresh, especially for changing content
5. Limit scope: Only sync tables your AI needs to answer questions

---

Related Documentation

• Integrations Overview
• Knowledge Base Management
• CSV URL Import — Alternative for static data
• SmartFlow Scheduled Triggers — Automate syncs